Details
-
Bug
-
Status: Closed (View Workflow)
-
Critical
-
Resolution: Fixed
-
10.3(EOL)
Description
Reproducible on 10.3 with UNION, INTERSECT, EXCEPT.
Not reproducible with UNION on 10.2.
CREATE TABLE t1 (c1 CHAR(8)); |
INSERT INTO t1 VALUES ('10'),('-10'); |
|
CREATE TABLE t2 (c2 CHAR); |
SET @a= CAST('10' AS CHAR); |
|
SELECT c1 FROM t1 UNION SELECT - @a FROM t2; |
10.3 176000a54ceb8dabe8f8b985aff565dfae6fb0df |
2017-07-02 20:48:12 139766304167680 [ERROR] mysqld: Table '/data/bld/10.3/mysql-test/var/tmp/mysqld.1/#sql_1f02_0' is marked as crashed and should be repaired
|
mysqld: /data/src/10.3/storage/maria/ma_open.c:1369: _ma_state_info_write: Assertion `(&(&share->intern_lock)->m_mutex)->count > 0 && pthread_equal(pthread_self(), (&(&share->intern_lock)->m_mutex)->thread)' failed.
|
170702 20:48:12 [ERROR] mysqld got signal 6 ;
|
|
#7 0x00007f1de6bfdee2 in __assert_fail () from /lib/x86_64-linux-gnu/libc.so.6
|
#8 0x0000563e55783d47 in _ma_state_info_write (share=0x7f1dd0062650, pWrite=1) at /data/src/10.3/storage/maria/ma_open.c:1369
|
#9 0x0000563e557c5b6c in maria_close (info=0x7f1dd00636b0) at /data/src/10.3/storage/maria/ma_close.c:146
|
#10 0x0000563e5574221a in ha_maria::close (this=0x7f1dd0041d78) at /data/src/10.3/storage/maria/ha_maria.cc:1274
|
#11 0x0000563e5553e293 in handler::ha_close (this=0x7f1dd0041d78) at /data/src/10.3/sql/handler.cc:2544
|
#12 0x0000563e55746754 in ha_maria::drop_table (this=0x7f1dd0041d78, name=0x7f1dd007f0c8 "/data/bld/10.3/mysql-test/var/tmp/mysqld.1/#sql_1f02_0") at /data/src/10.3/storage/maria/ha_maria.cc:2680
|
#13 0x0000563e55542b68 in handler::ha_drop_table (this=0x7f1dd0041d78, name=0x7f1dd007f0c8 "/data/bld/10.3/mysql-test/var/tmp/mysqld.1/#sql_1f02_0") at /data/src/10.3/sql/handler.cc:4325
|
#14 0x0000563e552f7415 in free_tmp_table (thd=0x7f1dd0000b00, entry=0x7f1dd007de08) at /data/src/10.3/sql/sql_select.cc:17779
|
#15 0x0000563e55371a2f in st_select_lex_unit::cleanup (this=0x7f1dd0004698) at /data/src/10.3/sql/sql_union.cc:1760
|
#16 0x0000563e5536bf8b in mysql_union (thd=0x7f1dd0000b00, lex=0x7f1dd00045d0, result=0x7f1dd0016218, unit=0x7f1dd0004698, setup_tables_done_option=0) at /data/src/10.3/sql/sql_union.cc:42
|
#17 0x0000563e552c76b0 in handle_select (thd=0x7f1dd0000b00, lex=0x7f1dd00045d0, result=0x7f1dd0016218, setup_tables_done_option=0) at /data/src/10.3/sql/sql_select.cc:351
|
#18 0x0000563e552938b5 in execute_sqlcom_select (thd=0x7f1dd0000b00, all_tables=0x7f1dd0014b10) at /data/src/10.3/sql/sql_parse.cc:6476
|
#19 0x0000563e55289c43 in mysql_execute_command (thd=0x7f1dd0000b00) at /data/src/10.3/sql/sql_parse.cc:3590
|
#20 0x0000563e55297306 in mysql_parse (thd=0x7f1dd0000b00, rawbuf=0x7f1dd00148e8 "SELECT c1 FROM t1 UNION SELECT - @a FROM t2", length=43, parser_state=0x7f1de0e94200, is_com_multi=false, is_next_command=false) at /data/src/10.3/sql/sql_parse.cc:7932
|
#21 0x0000563e55284f93 in dispatch_command (command=COM_QUERY, thd=0x7f1dd0000b00, packet=0x7f1dd0088521 "", packet_length=43, is_com_multi=false, is_next_command=false) at /data/src/10.3/sql/sql_parse.cc:1822
|
#22 0x0000563e5528390d in do_command (thd=0x7f1dd0000b00) at /data/src/10.3/sql/sql_parse.cc:1380
|
#23 0x0000563e553d17e4 in do_handle_one_connection (connect=0x563e58852bb0) at /data/src/10.3/sql/sql_connect.cc:1354
|
#24 0x0000563e553d1571 in handle_one_connection (arg=0x563e58852bb0) at /data/src/10.3/sql/sql_connect.cc:1260
|
#25 0x0000563e5582eb2f in pfs_spawn_thread (arg=0x563e587ada60) at /data/src/10.3/storage/perfschema/pfs.cc:1862
|
#26 0x00007f1de8b42494 in start_thread (arg=0x7f1de0e95700) at pthread_create.c:333
|
#27 0x00007f1de6cba93f in clone () from /lib/x86_64-linux-gnu/libc.so.6
|
Attachments
Issue Links
- relates to
-
MDEV-15901 CREATE..SELECT with DIV creates columns of a wrong data type
- Open
-
MDEV-15924 Wrong field type for CAST(temporal_column AS [UN]SIGNED)
- Open
-
MDEV-15926 MEDIUMINT returns wrong I_S attributes
- Closed
-
MDEV-15927 MEDIUMINT returns a wrong length on conversion to string
- Open
-
MDEV-15930 Wrong field type for CAST(decimal_column AS [UN]SIGNED)
- Open
-
MDEV-15946 MEDIUMINT(N<8) creates a wrong data type on conversion to string
- Closed
-
MDEV-15957 Unexpected "Data too long" when doing CREATE..SELECT with stored functions
- Closed
-
MDEV-15960 Wrong data type on CREATE..SELECT char_or_enum_or_text_spvar
- Closed
-
MDEV-15971 Split the code for CHARACTER_OCTET_LENGTH and CHARACTER_MAXIMUM_LENGTH into methods in Field
- Closed
probably arithmetic operations should not let super-long maximum length path throug, because it will be error (or truncation with warning) or it will be converted and then length will not be more then max length for int/double/decimal