Comment 7 for bug 595305

Will do. I am in training this week so please expect a two to three
day turnaround. Thanks for the patch!
Sent from my iPod

On Jul 13, 2010, at 11:44 AM, Prafulla Tekawade <<email address hidden>
 > wrote:

> Hi Patrick,
> Can you take a look at the fix ?
>
> --
> Assertion failed - exec_method != MATERIALIZATION || (exec_method ==
> MATERIALIZATION && engine->engine_type() ==
> subselect_engine::HASH_SJ_ENGINE)", file=<value optimized out>,
> line=318, function=0x84fae0 "virtual bool
> drizzled::Item_in_subselect::exec()
> https://bugs.launchpad.net/bugs/595305
> You received this bug notification because you are a direct subscriber
> of the bug.
>
> Status in A Lightweight SQL Database for Cloud and Web: In Progress
>
> Bug description:
> This is the same failing assertion from https://bugs.launchpad.net/drizzle/+bug/588408
> However, the test case for that bug no longer hits the assertion.
> Creating a new bug with new test case.
>
> Test case to be posted shortly.
>
> Backtrace:
>
> #0 0x00007f28ff4f8a75 in *__GI_raise (sig=<value optimized out>)
> at ../nptl/sysdeps/unix/sysv/linux/raise.c:64
> #1 0x00007f28ff4fc5c0 in *__GI_abort () at abort.c:92
> #2 0x00007f28ff4f1941 in *__GI___assert_fail (
> assertion=0x84d500 "exec_method != MATERIALIZATION ||
> (exec_method == MATERIALIZATION && engine->engine_type() ==
> subselect_engine::HASH_SJ_ENGINE)",
> file=<value optimized out>, line=318, function=0x84fae0 "virtual
> bool drizzled::Item_in_subselect::exec()") at assert.c:81
> #3 0x0000000000575b9e in drizzled::Item_in_subselect::exec
> (this=0x28c5128) at drizzled/item/subselect.cc:318
> #4 0x0000000000572f77 in drizzled::Item_in_subselect::val_bool
> (this=0x28c5128) at drizzled/item/subselect.cc:907
> #5 0x0000000000550c2c in drizzled::Item_in_optimizer::val_int
> (this=0x7f28e002d680) at drizzled/item/cmpfunc.cc:1597
> #6 0x00000000005bbafc in get_mm_tree (param=0x7f28e8dd55a0,
> cond=0x7f28e002d680) at drizzled/optimizer/range.cc:2654
> #7 0x00000000005bbc58 in get_mm_tree (param=0x7f28e8dd55a0,
> cond=<value optimized out>) at drizzled/optimizer/range.cc:2614
> #8 0x00000000005bc667 in
> drizzled::optimizer::SqlSelect::test_quick_select
> (this=0x7f28e002de90, session=0x7f28e43f9a30, keys_to_use=...,
> prev_tables=<value optimized out>, limit=<value optimized out>,
> force_quick_range=false, ordered_output=false) at drizzled/optimizer/
> range.cc:751
> #9 0x0000000000611108 in drizzled::get_quick_record_count
> (session=0x7f28e43f9a30, select=0x7f28e002de90,
> table=0x7f28e43f22b0, keys=0x7f28e0025850,
> limit=18446744073709551615) at drizzled/sql_select.cc:476
> #10 0x00000000005902fa in make_join_statistics (join=0x7f28dc000db8,
> tables=<value optimized out>, conds=<value optimized out>,
> keyuse_array=<value optimized out>) at drizzled/join.cc:5826
> #11 0x0000000000591c39 in drizzled::Join::optimize
> (this=0x7f28dc000db8) at drizzled/join.cc:559
> #12 0x00000000006111e5 in drizzled::mysql_select
> (session=0x7f28e43f9a30, rref_pointer_array=<value optimized out>,
> tables=0x28c3868, wild_num=0,
> fields=..., conds=0x7f28ff60c3d1, og_num=2, order=0x7f28dc000b70,
> group=0x0, having=0x0, select_options=2147500033,
> result=0x7f28dc000d98,
> unit=0x7f28e43fa4a0, select_lex=0x7f28e43fa6b0) at drizzled/
> sql_select.cc:412
> #13 0x0000000000611b60 in drizzled::handle_select
> (session=0x7f28e43f9a30, lex=0x7f28e43fa480, result=0x7f28dc000d98,
> setup_tables_done_option=0)
> at drizzled/sql_select.cc:146
> #14 0x000000000060b895 in drizzled::execute_sqlcom_select
> (session=0x7f28e43f9a30, all_tables=0x28c3868) at drizzled/
> sql_parse.cc:543
> #15 0x000000000060b4fe in mysql_execute_command
> (session=0x7f28e43f9a30, inBuf=<value optimized out>, length=<value
> optimized out>)
> at drizzled/sql_parse.cc:478
> #16 drizzled::mysql_parse (session=0x7f28e43f9a30, inBuf=<value
> optimized out>, length=<value optimized out>) at drizzled/
> sql_parse.cc:734
> #17 0x000000000060d6d2 in drizzled::dispatch_command
> (command=drizzled::COM_QUERY, session=0x7f28e43f9a30,
> packet=0x7f28e43ea221 "SELECT DISTINCT OUTR . `col_text` AS X
> FROM BB AS OUTR2 LEFT JOIN BB AS OUTR ON ( OUTR2 . `col_char` <>
> OUTR . `col_text` ) WHERE OUTR . `col_bigint_key` IN ( SELECT
> INNR . `pk` AS Y FROM BB AS INNR "..., packet_length=<value
> optimized out>) at drizzled/sql_parse.cc:223
> #18 0x00000000005dd92f in drizzled::Session::executeStatement
> (this=0x7f28e43f9a30) at drizzled/session.cc:646
> #19 0x00000000005dfcd2 in drizzled::Session::run
> (this=0x7f28e43f9a30) at drizzled/session.cc:505
> #20 0x00007f28fba8d083 in MultiThreadScheduler::runSession
> (arg=<value optimized out>) at ./plugin/multi_thread/multi_thread.h:67
> #21 session_thread (arg=<value optimized out>) at plugin/
> multi_thread/multi_thread.cc:43
> #22 0x00007f28ff84d9ca in start_thread (arg=<value optimized out>)
> at pthread_create.c:300
> #23 0x00007f28ff5ab6cd in clone () at ../sysdeps/unix/sysv/linux/
> x86_64/clone.S:112
> #24 0x0000000000000000 in ?? ()
>
> To unsubscribe from this bug, go to:
> https://bugs.launchpad.net/drizzle/+bug/595305/+subscribe