|
Setting it to minor because queries are weird, and the problem is only reproducible on 5.5.
It is likely to be related to MDEV-11664
DROP TABLE IF EXISTS t1;
|
CREATE TABLE t1 (i INT) ENGINE=MyISAM;
|
INSERT INTO t1 VALUES
|
(2),(8),(1),(NULL),(3),(2),(NULL),(4),(60),(0),(8),(5),(4),(207),(183),
|
(7),(1),(17),(4),(0),(1),(5),(NULL),(7),(5),(160),(215),(7),(1),(8),
|
(4),(1),(2),(7),(2),(0),(2),(4),(NULL),(6),(4),(3),(9),(7),(3),(9),(8),
|
(4),(4),(9),(8),(2),(8),(0),(1),(5),(4),(1),(0),(NULL),(7),(3),(9),
|
(225),(2),(8),(9),(2),(4),(4),(6),(7),(2),(2),(9),(198),(9),(7),(99);
|
|
SELECT ( SELECT DISTINCT i FROM t1 GROUP BY @a := 1 WITH ROLLUP ) AS s1;
|
SELECT NULL FROM t1 GROUP BY COLLATION(0), LAST_DAY(1) WITH ROLLUP;
|
SHOW WARNINGS;
|
|
5.5 ec6d8dadc01269451332e5b24b12a5350a2a4896
|
#3 <signal handler called>
|
#4 0x00000000005e125c in MYSQL_ERROR::get_level (this=0x2000200020002000) at /data/src/5.5/sql/sql_error.h:192
|
#5 0x00000000005e0c10 in mysqld_show_warnings (thd=0x7f8f81274060, levels_to_show=7) at /data/src/5.5/sql/sql_error.cc:699
|
#6 0x0000000000603555 in mysql_execute_command (thd=0x7f8f81274060) at /data/src/5.5/sql/sql_parse.cc:2303
|
#7 0x000000000060cab6 in mysql_parse (thd=0x7f8f81274060, rawbuf=0x7f8f80148078 "SHOW WARNINGS", length=13, parser_state=0x7f8f87688650) at /data/src/5.5/sql/sql_parse.cc:5931
|
#8 0x00000000006007ed in dispatch_command (command=COM_QUERY, thd=0x7f8f81274060, packet=0x7f8f81f4e061 "", packet_length=13) at /data/src/5.5/sql/sql_parse.cc:1079
|
#9 0x00000000005ff9a7 in do_command (thd=0x7f8f81274060) at /data/src/5.5/sql/sql_parse.cc:793
|
#10 0x0000000000701c6d in do_handle_one_connection (thd_arg=0x7f8f81274060) at /data/src/5.5/sql/sql_connect.cc:1268
|
#11 0x00000000007019fa in handle_one_connection (arg=0x7f8f81274060) at /data/src/5.5/sql/sql_connect.cc:1184
|
#12 0x0000000000944721 in pfs_spawn_thread (arg=0x7f8f81f7a3a0) at /data/src/5.5/storage/perfschema/pfs.cc:1015
|
#13 0x00007f8f872c50a4 in start_thread (arg=0x7f8f87689700) at pthread_create.c:309
|
#14 0x00007f8f856eb87d in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:111
|
|