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]
