Sure thing.  I'll have the bug updated sometime this weekend.

Many thanks for your help on these bugs!

On Sat, Jul 3, 2010 at 3:59 AM, Prafulla Tekawade <
<email address hidden>> wrote:

> Hi Patrick,
> I have pushed fix for this bug at
> https://code.launchpad.net/~prafulla-tekawade/drizzle/dr-bug-600664
>
> Can you please take a look at it?
>
>
> ** Changed in: drizzle
>     Assignee: (unassigned) => Prafulla Tekawade (prafulla-tekawade)
>
> ** Branch linked: lp:~prafulla-tekawade/drizzle/dr-bug-600664
>
> ** Changed in: drizzle
>       Status: Confirmed => In Progress
>
> --
> Crash / segfault in drizzled::optimizer::add_key_part (keyuse_array=<value
> optimized out>, key_field=0x2d0dc28) at drizzled/optimizer/key_field.cc:63
> https://bugs.launchpad.net/bugs/600664
> 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:
> Crashing bug / segfault:
> in drizzled::optimizer::add_key_part (keyuse_array=<value optimized out>,
> key_field=0x2d0dc28) at drizzled/optimizer/key_field.cc:63
>
> Test case on the way
>
> Backtrace:
> #0  0x0000000000000000 in ?? ()
> #1  0x00000000005aeb7c in drizzled::optimizer::add_key_part
> (keyuse_array=<value optimized out>, key_field=0x2d0dc28) at
> drizzled/optimizer/key_field.cc:63
> #2  0x0000000000617781 in drizzled::update_ref_and_keys (session=<value
> optimized out>, keyuse=0x2d0ae18, join_tab=0x2d48738, tables=<value
> optimized out>,
>    cond=<value optimized out>, normal_tables=18446744073709551615,
> select_lex=0x2c54940, sargables=...) at drizzled/sql_select.cc:596
> #3  0x0000000000594eed in make_join_statistics (join=0x2d09858, tables=0x0,
> conds=<value optimized out>, keyuse_array=<value optimized out>) at
> drizzled/join.cc:5610
> #4  0x00000000005964f1 in drizzled::Join::optimize (this=0x2d09858) at
> drizzled/join.cc:565
> #5  0x0000000000577ca2 in drizzled::subselect_single_select_engine::exec
> (this=0x2c55490) at drizzled/item/subselect.cc:2148
> #6  0x000000000057a128 in drizzled::Item_subselect::exec (this=0x2c55350)
> at drizzled/item/subselect.cc:299
> #7  drizzled::Item_in_subselect::exec (this=0x2c55350) at
> drizzled/item/subselect.cc:348
> #8  0x0000000000577547 in drizzled::Item_in_subselect::val_bool
> (this=0x2c55350) at drizzled/item/subselect.cc:907
> #9  0x000000000055550c in drizzled::Item_in_optimizer::val_int
> (this=0x2c87480) at drizzled/item/cmpfunc.cc:1597
> #10 0x000000000054d6bc in drizzled::Item::val_bool (this=0x2c87480) at
> drizzled/item.cc:94
> #11 0x0000000000554a79 in drizzled::Item_cond_and::val_int (this=0x2d0c7b8)
> at drizzled/item/cmpfunc.cc:4203
> #12 0x000000000054d6bc in drizzled::Item::val_bool (this=0x2d0c7b8) at
> drizzled/item.cc:94
> #13 0x00000000005549e9 in drizzled::Item_cond_or::val_int (this=0x2d0c6d0)
> at drizzled/item/cmpfunc.cc:4221
> #14 0x00000000005b6df8 in drizzled::optimizer::SqlSelect::skip_record
> (this=<value optimized out>) at drizzled/optimizer/range.cc:423
> #15 0x000000000058d349 in drizzled::flush_cached_records (join=0x2d07878,
> join_tab=0x2d0b220, skip_last=<value optimized out>) at
> drizzled/join.cc:2698
> #16 0x00000000006133f7 in drizzled::sub_select_cache (join=0x2d07878,
> join_tab=0x2d0b220, end_of_records=<value optimized out>) at
> drizzled/sql_select.cc:3384
> #17 0x0000000000617e70 in drizzled::do_select (join=0x2d07878, fields=0x0,
> table=0x2d30bb8) at drizzled/sql_select.cc:3335
> #18 0x0000000000592a97 in drizzled::Join::exec (this=0x2d07878) at
> drizzled/join.cc:1349
> #19 0x00000000006145f2 in drizzled::mysql_select (session=0x7fe4183a36c0,
> rref_pointer_array=<value optimized out>, tables=0x2c53e20, wild_num=0,
> fields=<value optimized out>,
>    conds=<value optimized out>, og_num=2, order=0x2c86518, group=0x0,
> having=0x0, select_options=2147500033, result=0x2c870a0,
> unit=0x7fe4183a4130, select_lex=0x7fe4183a4330)
>    at drizzled/sql_select.cc:427
> #20 0x0000000000614ef0 in drizzled::handle_select (session=0x7fe4183a36c0,
> lex=0x7fe4183a4110, result=0x2c870a0, setup_tables_done_option=0) at
> drizzled/sql_select.cc:146
> #21 0x000000000060ea65 in drizzled::execute_sqlcom_select
> (session=0x7fe4183a36c0, all_tables=0x2c53e20) at drizzled/sql_parse.cc:543
> #22 0x000000000060e6ce in mysql_execute_command (session=0x7fe4183a36c0,
> inBuf=<value optimized out>, length=<value optimized out>) at
> drizzled/sql_parse.cc:478
> #23 drizzled::mysql_parse (session=0x7fe4183a36c0, inBuf=<value optimized
> out>, length=<value optimized out>) at drizzled/sql_parse.cc:736
> #24 0x00000000006108c2 in drizzled::dispatch_command
> (command=drizzled::COM_QUERY, session=0x7fe4183a36c0,
>    packet=0x7fe41839d391 "SELECT DISTINCT AVG(DISTINCT OUTR .
> `col_int_not_null` ) AS X FROM BB AS OUTR2 LEFT JOIN BB AS OUTR ON ( OUTR2 .
> `col_text` <= OUTR . `col_text_key` ) WHERE ( OUTR . `col_text_not_null` ,
> OUTR . `col_"..., packet_length=<value optimized out>) at
> drizzled/sql_parse.cc:223
> #25 0x00000000005e18df in drizzled::Session::executeStatement
> (this=0x7fe4183a36c0) at drizzled/session.cc:646
> ---Type <return> to continue, or q <return> to quit---
> #26 0x00000000005e3e12 in drizzled::Session::run (this=0x7fe4183a36c0) at
> drizzled/session.cc:505
> #27 0x00007fe431586083 in MultiThreadScheduler::runSession (arg=<value
> optimized out>) at ./plugin/multi_thread/multi_thread.h:67
> #28 session_thread (arg=<value optimized out>) at
> plugin/multi_thread/multi_thread.cc:43
> #29 0x00007fe4353549ca in start_thread (arg=<value optimized out>) at
> pthread_create.c:300
> #30 0x00007fe4350b26cd in clone () at
> ../sysdeps/unix/sysv/linux/x86_64/clone.S:112
> #31 0x0000000000000000 in ?? ()
>
> To unsubscribe from this bug, go to:
> https://bugs.launchpad.net/drizzle/+bug/600664/+subscribe
>