SET sql_mode=STRICT_TRANS_TABLES;

CREATE TABLE t0 (i INT) ENGINE=MyISAM;

CREATE VIEW v1 AS SELECT * FROM t0;

CREATE VIEW v2 AS SELECT * FROM v1;

DROP VIEW IF EXISTS v1;

CREATE TABLE t1 (i INT) ENGINE=MyISAM;

INSERT INTO t1 SELECT TABLE_ROWS FROM information_schema.tables ORDER BY TABLE_ROWS;

5.5/sql/filesort.cc:335: ha_rows filesort(THD*, TABLE*, SORT_FIELD*, uint, SQL_SELECT*, ha_rows, bool, ha_rows*): Assertion `thd->is_error() || kill_errno || thd->killed == ABORT_QUERY' failed.

150214  0:42:17 [ERROR] mysqld got signal 6 ;

#6  0x00007f502895d311 in *__GI___assert_fail (assertion=0xe06a78 "thd->is_error() || kill_errno || thd->killed == ABORT_QUERY", file=<optimized out>, line=335, function=0xe075c0 "ha_rows filesort(THD*, TABLE*, SORT_FIELD*, uint, SQL_SELECT*, ha_rows, bool, ha_rows*)") at assert.c:81

#7  0x00000000007e3874 in filesort (thd=0x7f5024550060, table=0x7f5023569078, sortorder=0x7f502377ee68, s_length=1, select=0x7f502354e078, max_rows=18446744073709551615, sort_positions=false, examined_rows=0x7f5023fb49d8) at 5.5/sql/filesort.cc:335

#8  0x0000000000694ace in create_sort_index (thd=0x7f5024550060, join=0x7f5023534a58, order=0x7f5023688008, filesort_limit=18446744073709551615, select_limit=18446744073709551615, is_order_by=false) at 5.5/sql/sql_select.cc:19859

#9  0x000000000066ba7e in JOIN::exec (this=0x7f5023534a58) at 5.5/sql/sql_select.cc:2843

#10 0x000000000066c499 in mysql_select (thd=0x7f5024550060, rref_pointer_array=0x7f5024553cd0, tables=0x7f5023687918, wild_num=0, fields=..., conds=0x0, og_num=1, order=0x7f5023688008, group=0x0, having=0x0, proc_param=0x0, select_options=4026796800, result=0x7f5023688fa8, unit=0x7f5024553380, select_lex=0x7f5024553a60) at 5.5/sql/sql_select.cc:3094

#11 0x0000000000662f69 in handle_select (thd=0x7f5024550060, lex=0x7f50245532d0, result=0x7f5023688fa8, setup_tables_done_option=1073741824) at 5.5/sql/sql_select.cc:319

#12 0x000000000063735d in mysql_execute_command (thd=0x7f5024550060) at 5.5/sql/sql_parse.cc:3060

#13 0x000000000063ec8e in mysql_parse (thd=0x7f5024550060, rawbuf=0x7f5023687078 "INSERT INTO t1 SELECT TABLE_ROWS FROM information_schema.tables ORDER BY TABLE_ROWS", length=83, parser_state=0x7f5023fb5620) at 5.5/sql/sql_parse.cc:5909

#14 0x00000000006328d1 in dispatch_command (command=COM_QUERY, thd=0x7f5024550060, packet=0x7f5024607061 "INSERT INTO t1 SELECT TABLE_ROWS FROM information_schema.tables ORDER BY TABLE_ROWS", packet_length=83) at 5.5/sql/sql_parse.cc:1079

#15 0x0000000000631a5d in do_command (thd=0x7f5024550060) at 5.5/sql/sql_parse.cc:793

#16 0x00000000007340ea in do_handle_one_connection (thd_arg=0x7f5024550060) at 5.5/sql/sql_connect.cc:1266

#17 0x0000000000733ba9 in handle_one_connection (arg=0x7f5024550060) at 5.5/sql/sql_connect.cc:1181

#18 0x0000000000b6c2cd in pfs_spawn_thread (arg=0x7f5024571ca0) at 5.5/storage/perfschema/pfs.cc:1015

#19 0x00007f502a758b50 in start_thread (arg=<optimized out>) at pthread_create.c:304

#20 0x00007f5028a0e70d in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:112

Query (0x7f5023687078): INSERT INTO t1 SELECT TABLE_ROWS FROM information_schema.tables ORDER BY TABLE_ROWS

Connection ID (thread ID): 2

Status: KILL_BAD_DATA