SEND-PR: -*- send-pr -*- SEND-PR: Lines starting with `SEND-PR' will be removed automatically, as SEND-PR: will all comments (text enclosed in `<' and `>'). SEND-PR: From: root To: mysql@lists.mysql.com Subject: 5.0.4 (and 5.0.3) segfault when presented with a specific query containing a subquery of the form <> ANY( inner query )
>Description: 0x8097e13 init_signals__Fv + 327 0x833c348 __md5_crypt_r + 312 0x82d729f uf_space_prespace_selected + 219 0x82d3410 _mi_calc_var_pack_key_length + 1044 0x8126676 innobase_mysql_prepare_print_arbitrary_thd + 10 0x8123574 repair__9ha_myisamP3THDR17st_mi_check_paramb + 196 0x81233d1 repair__9ha_myisamP3THDP15st_ha_check_opt + 389 0x81194cd cost_group_min_max__FP8st_tableP6st_keyUiUiP8SEL_TREEP7SEL_ARGUlbT7PdPUl + 489 0x811db78 merge_buffers__FP13st_sort_paramP11st_io_cacheT1PUcP10st_buffpekN24i + 760 0x80e3754 make_cond_for_table__FP4ItemUxUx + 680 0x80e2839 end_send__FP4JOINP13st_join_tableb + 173 0x80e3754 make_cond_for_table__FP4ItemUxUx + 680 0x80e2839 end_send__FP4JOINP13st_join_tableb + 173 0x80e2584 join_read_last__FP13st_join_table + 128 0x80d3d6f exec__4JOIN + 2591 0x807eb7b exec__30subselect_single_select_engine + 379 0x807bc9e cleanup__21Item_maxmin_subselect + 18 0x807ca39 single_value_transformer__17Item_in_subselectP4JOINP12Comp_creator + 121 0x83aec41 transform__18Item_default_valuePM4ItemFP4ItemPc_P4ItemPc + 81 0x8064eb8 cleanup__17Item_in_optimizer + 0 0x80639c5 convert_constant_item__FP3THDP5FieldPP4Item + 1 0x804c44d val_bool__4Item + 33 0x8068ae4 val_int__12Item_cond_or + 32 0x80e28e5 end_send__FP4JOINP13st_join_tableb + 345 0x80e29a1 end_send_group__FP4JOINP13st_join_tableb + 37 0x80e29a1 end_send_group__FP4JOINP13st_join_tableb + 37 0x80e29a1 end_send_group__FP4JOINP13st_join_tableb + 37 0x80e29a1 end_send_group__FP4JOINP13st_join_tableb + 37 0x80e2584 join_read_last__FP13st_join_table + 128 0x80d3d6f exec__4JOIN + 2591 0x80d55b6 make_join_statistics__FP4JOINP13st_table_listP4ItemP16st_dynamic_array + 1262 0x80d1c8f prepare__4JOINPPP4ItemP13st_table_listUiP4ItemUiP8st_orderT6T4T6P13st_select_lexP18st_select_lex_unit + 1159 0x80a8a79 mysql_execute_command__FP3THD + 1813 0x80ae6db add_field_to_list__FP3THDPc16enum_field_typesT1T1UiP4ItemT6P13st_lex_stringT1Pt4List1Z6StringP15charset_info_stUi + 435 0x80a7164 dispatch_command__F19enum_server_commandP3THDPcUi + 2216 0x80a6acf dispatch_command__F19enum_server_commandP3THDPcUi + 531 0x80a6084 handle_bootstrap + 180 0x8339afc __pthread_lock + 28 0x836350a _svcauth_des + 730 >How-To-Repeat: Unfortunately this NDA'd so I cannot provide the table structure, query, etc. If the stack trace is unhelpful I will happily spend the time to try to create a test case. >Fix: unknown >Submitter-Id: <submitter ID> >Originator: root >Organization: <organization of PR author (multiple lines)> >MySQL support: none >Synopsis: Segfault with subquery >Severity: critical >Priority: high >Category: mysql >Class: sw-bug sw-bug >Release: mysql-5.0.4-beta-standard (MySQL Community Edition - Standard (GPL)) >Server: /usr/local/bin/mysqladmin Ver 8.41 Distrib 5.0.4-beta, for pc-linux-gnu on i686 Copyright (C) 2000 MySQL AB & MySQL Finland AB & TCX DataKonsult AB This software comes with ABSOLUTELY NO WARRANTY. This is free software, and you are welcome to modify and redistribute it under the GPL license Server version 5.0.4-beta-standard-log Protocol version 10 Connection Localhost via UNIX socket UNIX socket /tmp/mysql.sock Uptime: 5 min 59 sec Threads: 1 Questions: 2 Slow queries: 0 Opens: 0 Flush tables: 1 Open tables: 0 Queries per second avg: 0.006 >C compiler: 2.95.3 >C++ compiler: 2.95.3 >Environment: <machine, os, target, libraries (multiple lines)> System: Linux dev2 2.4.29-vs1.2.10 #1 Thu Mar 24 23:28:44 CST 2005 i686 unknown Architecture: i686 Some paths: /usr/bin/perl /usr/bin/make /usr/bin/gcc /usr/bin/cc GCC: Reading specs from /usr/lib/gcc-lib/i386-linux/2.95.4/specs gcc version 2.95.4 20011002 (Debian prerelease) Compilation info: CC='gcc' CFLAGS='-O2 -mcpu=pentiumpro' CXX='gcc' CXXFLAGS='-O2 -mcpu=pentiumpro -felide-constructors' LDFLAGS='' ASFLAGS='' LIBC: lrwxrwxrwx 1 root root 13 Apr 14 14:06 /lib/libc.so.6 -> libc-2.2.5.so -rwxr-xr-x 1 root root 1153784 Jan 7 06:05 /lib/libc-2.2.5.so Configure command: ./configure '--prefix=/usr/local/mysql' '--localstatedir=/usr/local/mysql/data' '--libexecdir=/usr/local/mysql/bin' '--with-comment=MySQL Community Edition - Standard (GPL)' '--with-extra-charsets=complex' '--with-server-suffix=-standard' '--enable-thread-safe-client' '--enable-local-infile' '--enable-assembler' '--disable-shared' '--with-client-ldflags=-all-static' '--with-big-tables' '--with-mysqld-ldflags=-all-static' '--with-readline' '--with-embedded-server' '--with-archive-storage-engine' '--with-innodb' 'CFLAGS=-O2 -mcpu=pentiumpro' 'CPPFLAGS=-DDEFAULT_THREAD_STACK=126976' 'CXXFLAGS=-O2 -mcpu=pentiumpro -felide-constructors' 'CXX=gcc' Also, it should be noted in 4.1.x there is no segfault. James Nobis Web Developer Academic Superstore 223 W. Anderson Ln. Suite A110, Austin, TX 78752 Voice: (512) 450-1199 x453 Fax: (512) 450-0263 http://www.academicsuperstore.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]