Details
-
Bug
-
Status: Closed (View Workflow)
-
Critical
-
Resolution: Fixed
-
None
-
None
-
None
Description
Not repeatable with maria-5.2. Not repeatable with maria-5.3 before WL#106.
backtrace:
#3 <signal handler called>
#4 0x000000000059d382 in Item_field::Item_field (this=0xe4e8bc0, f=0x8f8f8f8f8f8f8f8f) at item.cc:2025
#5 0x00000000007422c5 in add_ref_to_table_cond (thd=0xe414ed8, join_tab=0xe492da8) at sql_select.cc:19658
#6 0x000000000074bceb in JOIN::optimize (this=0xe4969e0) at sql_select.cc:1528
#7 0x000000000074db97 in mysql_select (thd=0xe414ed8, rref_pointer_array=0xe417a28, tables=0xe45bbb8, wild_num=1, fields=..., conds=0x0, og_num=1,
order=0xe45c9a0, group=0x0, having=0x0, proc_param=0x0, select_options=2147764736, result=0xe45d700, unit=0xe417320, select_lex=0xe417808)
at sql_select.cc:2871
#8 0x0000000000754016 in handle_select (thd=0xe414ed8, lex=0xe417280, result=0xe45d700, setup_tables_done_option=0) at sql_select.cc:283
#9 0x00000000006a14e8 in execute_sqlcom_select (thd=0xe414ed8, all_tables=0xe45bbb8) at sql_parse.cc:5082
#10 0x00000000006a319b in mysql_execute_command (thd=0xe414ed8) at sql_parse.cc:2227
#11 0x00000000006abf33 in mysql_parse (thd=0xe414ed8, rawbuf=0xe45b990 "SELECT * FROM v1 JOIN t1 USING ( f2 ) ORDER BY v1.f1", length=52,
found_semicolon=0x4264cf08) at sql_parse.cc:6083
#12 0x00000000006acdcb in dispatch_command (command=COM_QUERY, thd=0xe414ed8, packet=0xe452619 "SELECT * FROM v1 JOIN t1 USING ( f2 ) ORDER BY v1.f1",
packet_length=52) at sql_parse.cc:1206
#13 0x00000000006ae3dd in do_command (thd=0xe414ed8) at sql_parse.cc:904
#14 0x0000000000698e8f in handle_one_connection (arg=0xe414ed8) at sql_connect.cc:1177
#15 0x00000033b600673d in start_thread () from /lib64/libpthread.so.0
#16 0x00000033b58d40cd in clone () from /lib64/libc.so.6
test case:
CREATE TABLE t1 ( f2 int NOT NULL ) ;
INSERT INTO t1 VALUES (0);
CREATE TABLE t2 ( f1 int NOT NULL , f2 int) ;
INSERT INTO t2 VALUES (262,NULL),(253,190),(260,NULL),(250,163),(188,8),(257,200),(256,NULL),(255,NULL),(249,NULL),(259,7);
CREATE VIEW v1 AS SELECT f1, min(f2) AS f2 from t2 group by f1;
SELECT * FROM v1 JOIN t1 USING ( f2 ) ORDER BY v1.f1;
bzr version-info:
revision-id: <email address hidden>
date: 2011-06-17 23:00:26 +0200
build-date: 2011-06-19 21:20:47 +0300
revno: 3051
branch-nick: maria-5.3