Uploaded image for project: 'MariaDB Server'
  1. MariaDB Server
  2. MDEV-21406

Wrong result or Assertion `tmp != ((long long) 0x8000000000000000LL)' failed in TIME_from_longlong_datetime_packed

Details

    • Bug
    • Status: Closed (View Workflow)
    • Major
    • Resolution: Cannot Reproduce
    • 10.1(EOL), 10.2(EOL), 10.3(EOL), 10.4(EOL), 10.5, 10.6, 10.7(EOL), 10.8(EOL), 10.9(EOL), 10.10(EOL), 10.11
    • N/A
    • Temporal Types

    Description

      CREATE TABLE t1 (a DATETIME DEFAULT CURRENT_TIMESTAMP, b INT);
      INSERT INTO t1 () VALUES (),();
      SELECT * FROM t1 WHERE IFNULL(b, DEFAULT(a)) IS NOT NULL;
       
      # Cleanup
      DROP TABLE t1;
      

      On a debug build with ASAN (on some reason only with ASAN) the test case causes an assertion failure:

      10.4 071feae3 debug ASAN

      mysqld: /data/src/10.4/sql/compat56.cc:271: void TIME_from_longlong_datetime_packed(MYSQL_TIME*, longlong): Assertion `tmp != ((long long) 0x8000000000000000LL)' failed.
      191230  2:14:18 [ERROR] mysqld got signal 6 ;
       
      #6  0x00007fc1221c3e67 in __assert_fail_base (fmt=<optimized out>, assertion=assertion@entry=0x556a7c450540 "tmp != ((long long) 0x8", '0' <repeats 15 times>, "LL)", file=file@entry=0x556a7c4502a0 "/data/src/10.4/sql/compat56.cc", line=line@entry=271, function=function@entry=0x556a7c4508e0 <TIME_from_longlong_datetime_packed(st_mysql_time*, long long)::__PRETTY_FUNCTION__> "void TIME_from_longlong_datetime_packed(MYSQL_TIME*, longlong)") at assert.c:92
      #7  0x00007fc1221c3f12 in __GI___assert_fail (assertion=0x556a7c450540 "tmp != ((long long) 0x8", '0' <repeats 15 times>, "LL)", file=0x556a7c4502a0 "/data/src/10.4/sql/compat56.cc", line=271, function=0x556a7c4508e0 <TIME_from_longlong_datetime_packed(st_mysql_time*, long long)::__PRETTY_FUNCTION__> "void TIME_from_longlong_datetime_packed(MYSQL_TIME*, longlong)") at assert.c:101
      #8  0x0000556a7acda9b4 in TIME_from_longlong_datetime_packed (ltime=0x7fc119518900, tmp=-9223372036854775808) at /data/src/10.4/sql/compat56.cc:271
      #9  0x0000556a7ad17374 in Field_datetimef::get_TIME (this=0x62b0000648d8, ltime=0x7fc119518900, pos=0x62b0000649b9 "", fuzzydate=...) at /data/src/10.4/sql/field.cc:6971
      #10 0x0000556a7ad46985 in Field_datetimef::get_date (this=0x62b0000648d8, ltime=0x7fc119518900, fuzzydate=...) at /data/src/10.4/sql/field.h:3467
      #11 0x0000556a7adc999d in Item_field::get_date_result (this=0x62b0000632f8, thd=0x62b000046270, ltime=0x7fc119518900, fuzzydate=...) at /data/src/10.4/sql/item.cc:3229
      #12 0x0000556a7adaf83f in Item::val_datetime_packed_result (this=0x62b0000632f8, thd=0x62b000046270) at /data/src/10.4/sql/item.cc:121
      #13 0x0000556a7adfe484 in Item_cache_temporal::cache_value (this=0x62b0000666f0) at /data/src/10.4/sql/item.cc:9820
      #14 0x0000556a7aaf1080 in Item_cache::has_value (this=0x62b0000666f0) at /data/src/10.4/sql/item.h:6573
      #15 0x0000556a7ae0da9b in Item_cache_datetime::val_str (this=0x62b0000666f0, to=0x62b000063488) at /data/src/10.4/sql/item.h:6746
      #16 0x0000556a7ae31f87 in Item_func_ifnull::str_op (this=0x62b000063458, str=0x62b000063488) at /data/src/10.4/sql/item_cmpfunc.cc:2389
      #17 0x0000556a7aaebdb1 in Item_func_hybrid_field_type::str_op_with_null_check (this=0x62b000063458, str=0x62b000063488) at /data/src/10.4/sql/item_func.h:688
      #18 0x0000556a7aaebee9 in Item_func_hybrid_field_type::val_str_from_str_op (this=0x62b000063458, str=0x7fc119518bb0) at /data/src/10.4/sql/item_func.h:697
      #19 0x0000556a7aac90c7 in Type_handler_string_result::Item_func_hybrid_field_type_val_str (this=0x556a7d334ec0 <type_handler_varchar>, item=0x62b000063458, str=0x7fc119518bb0) at /data/src/10.4/sql/sql_type.cc:4930
      #20 0x0000556a7a5d5380 in Item_func_hybrid_field_type::val_str (this=0x62b000063458, str=0x7fc119518bb0) at /data/src/10.4/sql/item_func.h:769
      #21 0x0000556a7aac3f3a in Type_handler_string_result::Item_update_null_value (this=0x556a7d334ec0 <type_handler_varchar>, item=0x62b000063458) at /data/src/10.4/sql/sql_type.cc:3590
      #22 0x0000556a7a39b574 in Item::update_null_value (this=0x62b000063458) at /data/src/10.4/sql/item.h:1783
      #23 0x0000556a7a52bd74 in Item_func::is_null (this=0x62b000063458) at /data/src/10.4/sql/item_func.h:184
      #24 0x0000556a7ae4b388 in Item_func_isnotnull::val_int (this=0x62b000063530) at /data/src/10.4/sql/item_cmpfunc.cc:5435
      #25 0x0000556a7a72ddf1 in evaluate_join_record (join=0x62b000063f50, join_tab=0x62b000065d90, error=0) at /data/src/10.4/sql/sql_select.cc:20350
      #26 0x0000556a7a72d254 in sub_select (join=0x62b000063f50, join_tab=0x62b000065d90, end_of_records=false) at /data/src/10.4/sql/sql_select.cc:20255
      #27 0x0000556a7a72b63d in do_select (join=0x62b000063f50, procedure=0x0) at /data/src/10.4/sql/sql_select.cc:19793
      #28 0x0000556a7a6c4a44 in JOIN::exec_inner (this=0x62b000063f50) at /data/src/10.4/sql/sql_select.cc:4452
      #29 0x0000556a7a6c2350 in JOIN::exec (this=0x62b000063f50) at /data/src/10.4/sql/sql_select.cc:4234
      #30 0x0000556a7a6c5e02 in mysql_select (thd=0x62b000046270, tables=0x62b000062970, wild_num=1, fields=..., conds=0x62b000063530, og_num=0, order=0x0, group=0x0, having=0x0, proc_param=0x0, select_options=2147748608, result=0x62b000063f20, unit=0x62b00004a198, select_lex=0x62b000062378) at /data/src/10.4/sql/sql_select.cc:4666
      #31 0x0000556a7a69b649 in handle_select (thd=0x62b000046270, lex=0x62b00004a0d8, result=0x62b000063f20, setup_tables_done_option=0) at /data/src/10.4/sql/sql_select.cc:420
      #32 0x0000556a7a61dc83 in execute_sqlcom_select (thd=0x62b000046270, all_tables=0x62b000062970) at /data/src/10.4/sql/sql_parse.cc:6360
      #33 0x0000556a7a60ba27 in mysql_execute_command (thd=0x62b000046270) at /data/src/10.4/sql/sql_parse.cc:3899
      #34 0x0000556a7a6262a2 in mysql_parse (thd=0x62b000046270, rawbuf=0x62b000062290 "SELECT * FROM t1 WHERE IFNULL(b, DEFAULT(a)) IS NOT NULL", length=56, parser_state=0x7fc11951b290, is_com_multi=false, is_next_command=false) at /data/src/10.4/sql/sql_parse.cc:7901
      #35 0x0000556a7a5ff555 in dispatch_command (command=COM_QUERY, thd=0x62b000046270, packet=0x629000221271 "", packet_length=56, is_com_multi=false, is_next_command=false) at /data/src/10.4/sql/sql_parse.cc:1842
      #36 0x0000556a7a5fc455 in do_command (thd=0x62b000046270) at /data/src/10.4/sql/sql_parse.cc:1360
      #37 0x0000556a7a9830b1 in do_handle_one_connection (connect=0x611000002630) at /data/src/10.4/sql/sql_connect.cc:1412
      #38 0x0000556a7a982a65 in handle_one_connection (arg=0x611000002630) at /data/src/10.4/sql/sql_connect.cc:1316
      #39 0x0000556a7bde6dfe in pfs_spawn_thread (arg=0x6160000033f0) at /data/src/10.4/storage/perfschema/pfs.cc:1862
      #40 0x00007fc12414c4a4 in start_thread (arg=0x7fc11951d300) at pthread_create.c:456
      #41 0x00007fc122280d0f in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:97
      

      Reproducible on 10.3-10.5.

      Non-ASAN builds of 10.3-10.5 and any builds of 10.1-10.2, as well as MySQL 5.6/5.7/8.0, don't crash, but they return the empty result set:

      SELECT * FROM t1 WHERE IFNULL(b, DEFAULT(a)) IS NOT NULL;
      a	b
      DROP TABLE t1;
      

      This seems to be wrong, because IFNULL(b, DEFAULT(a)) IS NOT NULL is clearly true:

      SELECT IFNULL(b, DEFAULT(a)) IS NOT NULL FROM t1;
      IFNULL(b, DEFAULT(a)) IS NOT NULL
      1
      1
      

      Also, if DATETIME is replaced with TIMESTAMP in the same case, then the result set is returned:

      CREATE TABLE t1 (a TIMESTAMP DEFAULT CURRENT_TIMESTAMP, b INT);
      INSERT INTO t1 () VALUES (),();
      SELECT * FROM t1 WHERE IFNULL(b, DEFAULT(a)) IS NOT NULL;
      a	b
      2019-12-30 02:23:13	NULL
      2019-12-30 02:23:13	NULL
      DROP TABLE t1;
      

      Finally, here is a variation of the test case which causes the same assertion failure on 10.3 and 10.5 ASAN builds, but a different one on 10.4 ASAN build. The change in the test case is the absence of IS NOT NULL in the WHERE clause:

      CREATE TABLE t1 (a DATETIME DEFAULT CURRENT_TIMESTAMP, b INT);
      INSERT INTO t1 () VALUES (),();
      SELECT * FROM t1 WHERE IFNULL(b, DEFAULT(a));
       
      # Cleanup
      DROP TABLE t1;
      

      10.4 071feae3 debug ASAN

      mysqld: /data/src/10.4/sql/sql_type.h:2064: Datetime::Datetime(THD*, Item*, date_mode_t): Assertion `is_valid_value_slow()' failed.
      191230  2:26:42 [ERROR] mysqld got signal 6 ;
       
      #7  0x00007fbb7fd4ff12 in __GI___assert_fail (assertion=0x556fa264dea0 "is_valid_value_slow()", file=0x556fa264de00 "/data/src/10.4/sql/sql_type.h", line=2064, function=0x556fa264ecc0 <Datetime::Datetime(THD*, Item*, date_mode_t)::__PRETTY_FUNCTION__> "Datetime::Datetime(THD*, Item*, date_mode_t)") at assert.c:101
      #8  0x0000556fa08f961f in Datetime::Datetime (this=0x7fbb770a1df0, thd=0x62b000046270, item=0x62b000066590, fuzzydate=...) at /data/src/10.4/sql/sql_type.h:2064
      #9  0x0000556fa1041438 in Datetime::Datetime (this=0x7fbb770a1e60, thd=0x62b000046270, item=0x62b000066590) at /data/src/10.4/sql/sql_type.h:2067
      #10 0x0000556fa10414f5 in Datetime::Datetime (this=0x7fbb770a1e60, item=0x62b000066590) at /data/src/10.4/sql/sql_type.h:2070
      #11 0x0000556fa136daf2 in Item_cache_datetime::val_str (this=0x62b000066590, to=0x62b000063470) at /data/src/10.4/sql/item.h:6746
      #12 0x0000556fa1391f87 in Item_func_ifnull::str_op (this=0x62b000063440, str=0x62b000063470) at /data/src/10.4/sql/item_cmpfunc.cc:2389
      #13 0x0000556fa104bdb1 in Item_func_hybrid_field_type::str_op_with_null_check (this=0x62b000063440, str=0x62b000063470) at /data/src/10.4/sql/item_func.h:688
      #14 0x0000556fa1407059 in Item_func_hybrid_field_type::val_int_from_str_op (this=0x62b000063440) at /data/src/10.4/sql/item_func.cc:943
      #15 0x0000556fa1029112 in Type_handler_string_result::Item_func_hybrid_field_type_val_int (this=0x556fa3894ec0 <type_handler_varchar>, item=0x62b000063440) at /data/src/10.4/sql/sql_type.cc:4948
      #16 0x0000556fa0b350cf in Item_func_hybrid_field_type::val_int (this=0x62b000063440) at /data/src/10.4/sql/item_func.h:757
      #17 0x0000556fa0c8ddf1 in evaluate_join_record (join=0x62b000063e60, join_tab=0x62b000065c30, error=0) at /data/src/10.4/sql/sql_select.cc:20350
      #18 0x0000556fa0c8d254 in sub_select (join=0x62b000063e60, join_tab=0x62b000065c30, end_of_records=false) at /data/src/10.4/sql/sql_select.cc:20255
      #19 0x0000556fa0c8b63d in do_select (join=0x62b000063e60, procedure=0x0) at /data/src/10.4/sql/sql_select.cc:19793
      #20 0x0000556fa0c24a44 in JOIN::exec_inner (this=0x62b000063e60) at /data/src/10.4/sql/sql_select.cc:4452
      #21 0x0000556fa0c22350 in JOIN::exec (this=0x62b000063e60) at /data/src/10.4/sql/sql_select.cc:4234
      #22 0x0000556fa0c25e02 in mysql_select (thd=0x62b000046270, tables=0x62b000062958, wild_num=1, fields=..., conds=0x62b000063440, og_num=0, order=0x0, group=0x0, having=0x0, proc_param=0x0, select_options=2147748608, result=0x62b000063e30, unit=0x62b00004a198, select_lex=0x62b000062360) at /data/src/10.4/sql/sql_select.cc:4666
      #23 0x0000556fa0bfb649 in handle_select (thd=0x62b000046270, lex=0x62b00004a0d8, result=0x62b000063e30, setup_tables_done_option=0) at /data/src/10.4/sql/sql_select.cc:420
      #24 0x0000556fa0b7dc83 in execute_sqlcom_select (thd=0x62b000046270, all_tables=0x62b000062958) at /data/src/10.4/sql/sql_parse.cc:6360
      #25 0x0000556fa0b6ba27 in mysql_execute_command (thd=0x62b000046270) at /data/src/10.4/sql/sql_parse.cc:3899
      #26 0x0000556fa0b862a2 in mysql_parse (thd=0x62b000046270, rawbuf=0x62b000062290 "SELECT * FROM t1 WHERE IFNULL(b, DEFAULT(a))", length=44, parser_state=0x7fbb770a4290, is_com_multi=false, is_next_command=false) at /data/src/10.4/sql/sql_parse.cc:7901
      #27 0x0000556fa0b5f555 in dispatch_command (command=COM_QUERY, thd=0x62b000046270, packet=0x629000221271 "", packet_length=44, is_com_multi=false, is_next_command=false) at /data/src/10.4/sql/sql_parse.cc:1842
      #28 0x0000556fa0b5c455 in do_command (thd=0x62b000046270) at /data/src/10.4/sql/sql_parse.cc:1360
      #29 0x0000556fa0ee30b1 in do_handle_one_connection (connect=0x611000002630) at /data/src/10.4/sql/sql_connect.cc:1412
      #30 0x0000556fa0ee2a65 in handle_one_connection (arg=0x611000002630) at /data/src/10.4/sql/sql_connect.cc:1316
      #31 0x0000556fa2346dfe in pfs_spawn_thread (arg=0x6160000033f0) at /data/src/10.4/storage/perfschema/pfs.cc:1862
      #32 0x00007fbb81cd84a4 in start_thread (arg=0x7fbb770a6300) at pthread_create.c:456
      #33 0x00007fbb7fe0cd0f in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:97
      

      Attachments

        Issue Links

          Activity

            Without IFNULL. Also only reproducible on an ASAN build (10.5 debug ASAN).

            CREATE TABLE t1 (a DATETIME DEFAULT CURRENT_TIMESTAMP);
            SELECT * FROM t1 WHERE DEFAULT(a) < 0 ORDER BY BINARY(DES_ENCRYPT('bar' >= 'foo'));
             
            # Cleanup
            DROP TABLE t1;
            

            10.5 9930cb22 ASAN

            mariadbd: /data/src/10.5/sql/compat56.cc:271: void TIME_from_longlong_datetime_packed(MYSQL_TIME*, longlong): Assertion `tmp != ((long long) 0x8000000000000000LL)' failed.
            210120 21:04:46 [ERROR] mysqld got signal 6 ;
             
            #7  0x00007ff2adbb1f36 in __GI___assert_fail (assertion=0x560d64010ae0 "tmp != ((long long) 0x8", '0' <repeats 15 times>, "LL)", file=0x560d64010640 "/data/src/10.5/sql/compat56.cc", line=271, function=0x560d64010a80 "void TIME_from_longlong_datetime_packed(MYSQL_TIME*, longlong)") at assert.c:101
            #8  0x0000560d62240fc4 in TIME_from_longlong_datetime_packed (ltime=0x7ff2a49f29f0, tmp=-9223372036854775808) at /data/src/10.5/sql/compat56.cc:271
            #9  0x0000560d62286407 in Field_datetimef::val_datetime_packed (this=0x62b00003aff8, thd=0x62b000069288) at /data/src/10.5/sql/field.cc:7115
            #10 0x0000560d62354ff1 in Item_field::val_datetime_packed (this=0x62b000039240, thd=0x62b000069288) at /data/src/10.5/sql/item.cc:3322
            #11 0x0000560d623b2a97 in Arg_comparator::compare_datetime (this=0x62b000039518) at /data/src/10.5/sql/item_cmpfunc.cc:741
            #12 0x0000560d623f9962 in Arg_comparator::compare (this=0x62b000039518) at /data/src/10.5/sql/item_cmpfunc.h:102
            #13 0x0000560d623c043b in Item_func_lt::val_int (this=0x62b000039448) at /data/src/10.5/sql/item_cmpfunc.cc:1829
            #14 0x0000560d6209c2b6 in Type_handler_int_result::Item_val_bool (this=0x560d65efb260 <type_handler_bool>, item=0x62b000039448) at /data/src/10.5/sql/sql_type.cc:4998
            #15 0x0000560d6181d590 in Item::val_bool (this=0x62b000039448) at /data/src/10.5/sql/item.h:1489
            #16 0x0000560d61c79f12 in Item::eval_const_cond (this=0x62b000039448) at /data/src/10.5/sql/item.h:1496
            #17 0x0000560d61c163f6 in Item_bool_func2::remove_eq_conds (this=0x62b000039448, thd=0x62b000069288, cond_value=0x62b00003aac8, top_level_arg=true) at /data/src/10.5/sql/sql_select.cc:17504
            #18 0x0000560d61c136c0 in optimize_cond (join=0x62b00003a7b0, conds=0x62b000039448, join_list=0x62b000038588, ignore_on_conds=false, cond_value=0x62b00003aac8, cond_equal=0x62b00003abf0, flags=1) at /data/src/10.5/sql/sql_select.cc:17040
            #19 0x0000560d61ba1318 in JOIN::optimize_inner (this=0x62b00003a7b0) at /data/src/10.5/sql/sql_select.cc:1995
            #20 0x0000560d61b9d242 in JOIN::optimize (this=0x62b00003a7b0) at /data/src/10.5/sql/sql_select.cc:1627
            #21 0x0000560d61bbd4f3 in mysql_select (thd=0x62b000069288, tables=0x62b0000389e8, fields=..., conds=0x62b000039448, og_num=1, order=0x62b00003a550, group=0x0, having=0x0, proc_param=0x0, select_options=2147748608, result=0x62b00003a780, unit=0x62b00006d428, select_lex=0x62b0000383c0) at /data/src/10.5/sql/sql_select.cc:4644
            #22 0x0000560d61b8f46c in handle_select (thd=0x62b000069288, lex=0x62b00006d360, result=0x62b00003a780, setup_tables_done_option=0) at /data/src/10.5/sql/sql_select.cc:417
            #23 0x0000560d61af8a68 in execute_sqlcom_select (thd=0x62b000069288, all_tables=0x62b0000389e8) at /data/src/10.5/sql/sql_parse.cc:6281
            #24 0x0000560d61ae7969 in mysql_execute_command (thd=0x62b000069288) at /data/src/10.5/sql/sql_parse.cc:3977
            #25 0x0000560d61b03d62 in mysql_parse (thd=0x62b000069288, rawbuf=0x62b0000382a8 "SELECT * FROM t1 WHERE DEFAULT(a) < 0 ORDER BY BINARY(DES_ENCRYPT('bar' >= 'foo'))", length=82, parser_state=0x7ff2a49f47c0, is_com_multi=false, is_next_command=false) at /data/src/10.5/sql/sql_parse.cc:8062
            #26 0x0000560d61ada05b in dispatch_command (command=COM_QUERY, thd=0x62b000069288, packet=0x62900024e289 "SELECT * FROM t1 WHERE DEFAULT(a) < 0 ORDER BY BINARY(DES_ENCRYPT('bar' >= 'foo'))", packet_length=82, is_com_multi=false, is_next_command=false) at /data/src/10.5/sql/sql_parse.cc:1889
            #27 0x0000560d61ad6984 in do_command (thd=0x62b000069288) at /data/src/10.5/sql/sql_parse.cc:1370
            #28 0x0000560d61f18bea in do_handle_one_connection (connect=0x61100000b888, put_in_cache=true) at /data/src/10.5/sql/sql_connect.cc:1410
            #29 0x0000560d61f1854e in handle_one_connection (arg=0x61100000b748) at /data/src/10.5/sql/sql_connect.cc:1312
            #30 0x0000560d62c23e99 in pfs_spawn_thread (arg=0x6160000eb308) at /data/src/10.5/storage/perfschema/pfs.cc:2201
            #31 0x00007ff2ae0c7609 in start_thread (arg=<optimized out>) at pthread_create.c:477
            #32 0x00007ff2adc9d293 in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:95
            

            elenst Elena Stepanova added a comment - Without IFNULL. Also only reproducible on an ASAN build (10.5 debug ASAN). CREATE TABLE t1 (a DATETIME DEFAULT CURRENT_TIMESTAMP ); SELECT * FROM t1 WHERE DEFAULT (a) < 0 ORDER BY BINARY (DES_ENCRYPT( 'bar' >= 'foo' ));   # Cleanup DROP TABLE t1; 10.5 9930cb22 ASAN mariadbd: /data/src/10.5/sql/compat56.cc:271: void TIME_from_longlong_datetime_packed(MYSQL_TIME*, longlong): Assertion `tmp != ((long long) 0x8000000000000000LL)' failed. 210120 21:04:46 [ERROR] mysqld got signal 6 ;   #7 0x00007ff2adbb1f36 in __GI___assert_fail (assertion=0x560d64010ae0 "tmp != ((long long) 0x8", '0' <repeats 15 times>, "LL)", file=0x560d64010640 "/data/src/10.5/sql/compat56.cc", line=271, function=0x560d64010a80 "void TIME_from_longlong_datetime_packed(MYSQL_TIME*, longlong)") at assert.c:101 #8 0x0000560d62240fc4 in TIME_from_longlong_datetime_packed (ltime=0x7ff2a49f29f0, tmp=-9223372036854775808) at /data/src/10.5/sql/compat56.cc:271 #9 0x0000560d62286407 in Field_datetimef::val_datetime_packed (this=0x62b00003aff8, thd=0x62b000069288) at /data/src/10.5/sql/field.cc:7115 #10 0x0000560d62354ff1 in Item_field::val_datetime_packed (this=0x62b000039240, thd=0x62b000069288) at /data/src/10.5/sql/item.cc:3322 #11 0x0000560d623b2a97 in Arg_comparator::compare_datetime (this=0x62b000039518) at /data/src/10.5/sql/item_cmpfunc.cc:741 #12 0x0000560d623f9962 in Arg_comparator::compare (this=0x62b000039518) at /data/src/10.5/sql/item_cmpfunc.h:102 #13 0x0000560d623c043b in Item_func_lt::val_int (this=0x62b000039448) at /data/src/10.5/sql/item_cmpfunc.cc:1829 #14 0x0000560d6209c2b6 in Type_handler_int_result::Item_val_bool (this=0x560d65efb260 <type_handler_bool>, item=0x62b000039448) at /data/src/10.5/sql/sql_type.cc:4998 #15 0x0000560d6181d590 in Item::val_bool (this=0x62b000039448) at /data/src/10.5/sql/item.h:1489 #16 0x0000560d61c79f12 in Item::eval_const_cond (this=0x62b000039448) at /data/src/10.5/sql/item.h:1496 #17 0x0000560d61c163f6 in Item_bool_func2::remove_eq_conds (this=0x62b000039448, thd=0x62b000069288, cond_value=0x62b00003aac8, top_level_arg=true) at /data/src/10.5/sql/sql_select.cc:17504 #18 0x0000560d61c136c0 in optimize_cond (join=0x62b00003a7b0, conds=0x62b000039448, join_list=0x62b000038588, ignore_on_conds=false, cond_value=0x62b00003aac8, cond_equal=0x62b00003abf0, flags=1) at /data/src/10.5/sql/sql_select.cc:17040 #19 0x0000560d61ba1318 in JOIN::optimize_inner (this=0x62b00003a7b0) at /data/src/10.5/sql/sql_select.cc:1995 #20 0x0000560d61b9d242 in JOIN::optimize (this=0x62b00003a7b0) at /data/src/10.5/sql/sql_select.cc:1627 #21 0x0000560d61bbd4f3 in mysql_select (thd=0x62b000069288, tables=0x62b0000389e8, fields=..., conds=0x62b000039448, og_num=1, order=0x62b00003a550, group=0x0, having=0x0, proc_param=0x0, select_options=2147748608, result=0x62b00003a780, unit=0x62b00006d428, select_lex=0x62b0000383c0) at /data/src/10.5/sql/sql_select.cc:4644 #22 0x0000560d61b8f46c in handle_select (thd=0x62b000069288, lex=0x62b00006d360, result=0x62b00003a780, setup_tables_done_option=0) at /data/src/10.5/sql/sql_select.cc:417 #23 0x0000560d61af8a68 in execute_sqlcom_select (thd=0x62b000069288, all_tables=0x62b0000389e8) at /data/src/10.5/sql/sql_parse.cc:6281 #24 0x0000560d61ae7969 in mysql_execute_command (thd=0x62b000069288) at /data/src/10.5/sql/sql_parse.cc:3977 #25 0x0000560d61b03d62 in mysql_parse (thd=0x62b000069288, rawbuf=0x62b0000382a8 "SELECT * FROM t1 WHERE DEFAULT(a) < 0 ORDER BY BINARY(DES_ENCRYPT('bar' >= 'foo'))", length=82, parser_state=0x7ff2a49f47c0, is_com_multi=false, is_next_command=false) at /data/src/10.5/sql/sql_parse.cc:8062 #26 0x0000560d61ada05b in dispatch_command (command=COM_QUERY, thd=0x62b000069288, packet=0x62900024e289 "SELECT * FROM t1 WHERE DEFAULT(a) < 0 ORDER BY BINARY(DES_ENCRYPT('bar' >= 'foo'))", packet_length=82, is_com_multi=false, is_next_command=false) at /data/src/10.5/sql/sql_parse.cc:1889 #27 0x0000560d61ad6984 in do_command (thd=0x62b000069288) at /data/src/10.5/sql/sql_parse.cc:1370 #28 0x0000560d61f18bea in do_handle_one_connection (connect=0x61100000b888, put_in_cache=true) at /data/src/10.5/sql/sql_connect.cc:1410 #29 0x0000560d61f1854e in handle_one_connection (arg=0x61100000b748) at /data/src/10.5/sql/sql_connect.cc:1312 #30 0x0000560d62c23e99 in pfs_spawn_thread (arg=0x6160000eb308) at /data/src/10.5/storage/perfschema/pfs.cc:2201 #31 0x00007ff2ae0c7609 in start_thread (arg=<optimized out>) at pthread_create.c:477 #32 0x00007ff2adc9d293 in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:95
            alice Alice Sherepa added a comment -

            also on 10.5

            create table t1 (d1 datetime not null);
            insert into t1 values ('0000-00-00 00:00:00'), ('0000-00-00 00:00:00');
             
            select avg(d1) over () from t1 group by uuid()  with rollup;
            

            10.5 1f1f61a9de0c85

            Version: '10.5.10-MariaDB-debug-log' 
            /10.5/sql/compat56.cc:271: void TIME_from_longlong_datetime_packed(MYSQL_TIME*, longlong): Assertion `tmp != ((long long) 0x8000000000000000LL)' failed.
            210304 16:29:22 [ERROR] mysqld got signal 6 ;
             
            linux/raise.c:51(__GI_raise)[0x7f615d72b18b]
            stdlib/abort.c:81(__GI_abort)[0x7f615d70a859]
            intl/loadmsgcat.c:509(get_sysdep_segment_value)[0x7f615d70a729]
            :0(__GI___assert_fail)[0x7f615d71bf36]
            sql/compat56.cc:273(TIME_from_longlong_datetime_packed(st_mysql_time*, long long))[0x561b8258a054]
            sql/field.cc:7103(Field_datetimef::get_TIME(st_mysql_time*, unsigned char const*, date_mode_t) const)[0x561b825cf13b]
            sql/field.h:3923(Field_datetimef::get_date(st_mysql_time*, date_mode_t))[0x561b825fdf99]
            sql/field.cc:5854(Field_temporal::val_decimal(my_decimal*))[0x561b825bffcf]
            sql/item.cc:3360(Item_field::val_decimal_result(my_decimal*))[0x561b8269e7b4]
            sql/item.cc:8363(Item_ref::val_decimal(my_decimal*))[0x561b826c8a80]
            sql/item_sum.cc:1807(Aggregator_simple::arg_val_decimal(my_decimal*))[0x561b828b2eaa]
            sql/item_sum.cc:1629(Item_sum_sum::add_helper(bool))[0x561b828b113a]
            sql/item_sum.cc:1602(Item_sum_sum::add())[0x561b828b0b8b]
            sql/item_sum.cc:2025(Item_sum_avg::add())[0x561b828b626c]
            sql/sql_window.cc:1102(Frame_cursor::add_value_to_items())[0x561b82441c03]
            sql/sql_window.cc:1515(Frame_range_current_row_bottom::pre_next_partition(unsigned long long))[0x561b824442c1]
            sql/sql_window.cc:1162(Cursor_manager::notify_cursors_partition_changed(unsigned long long))[0x561b82442355]
            sql/sql_window.cc:2845(compute_window_func(THD*, List<Item_window_func>&, List<Cursor_manager>&, TABLE*, SORT_INFO*))[0x561b8243d34f]
            sql/sql_window.cc:2976(Window_func_runner::exec(THD*, TABLE*, SORT_INFO*))[0x561b8243db58]
            sql/sql_window.cc:3004(Window_funcs_sort::exec(JOIN*, bool))[0x561b8243dda6]
            sql/sql_window.cc:3131(Window_funcs_computation::exec(JOIN*, bool))[0x561b8243ebae]
            sql/sql_select.cc:28962(AGGR_OP::end_send())[0x561b81fb93f0]
            sql/sql_select.cc:20397(sub_select_postjoin_aggr(JOIN*, st_join_table*, bool))[0x561b81f78b13]
            sql/sql_select.cc:20632(sub_select(JOIN*, st_join_table*, bool))[0x561b81f794c6]
            sql/sql_select.cc:20223(do_select(JOIN*, Procedure*))[0x561b81f77f08]
            sql/sql_select.cc:4467(JOIN::exec_inner())[0x561b81f046b9]
            sql/sql_select.cc:4248(JOIN::exec())[0x561b81f01ca4]
            sql/sql_select.cc:4722(mysql_select(THD*, TABLE_LIST*, List<Item>&, Item*, unsigned int, st_order*, st_order*, Item*, st_order*, unsigned long long, select_result*, st_select_lex_unit*, st_select_lex*))[0x561b81f06078]
            sql/sql_select.cc:417(handle_select(THD*, LEX*, select_result*, unsigned long))[0x561b81ed78b6]
            sql/sql_parse.cc:6282(execute_sqlcom_select(THD*, TABLE_LIST*))[0x561b81e41024]
            sql/sql_parse.cc:3978(mysql_execute_command(THD*))[0x561b81e2ff1f]
            sql/sql_parse.cc:8063(mysql_parse(THD*, char*, unsigned int, Parser_state*, bool, bool))[0x561b81e4c31e]
            sql/sql_parse.cc:1892(dispatch_command(enum_server_command, THD*, char*, unsigned int, bool, bool))[0x561b81e22517]
            sql/sql_parse.cc:1370(do_command(THD*))[0x561b81e1ee40]
            sql/sql_connect.cc:1410(do_handle_one_connection(CONNECT*, bool))[0x561b822616dc]
            sql/sql_connect.cc:1314(handle_one_connection)[0x561b82261040]
            perfschema/pfs.cc:2203(pfs_spawn_thread)[0x561b82f70bf7]
            nptl/pthread_create.c:478(start_thread)[0x7f615dc33609]
            x86_64/clone.S:97(__GI___clone)[0x7f615d807293]
             
            Query (0x62b0000852a8): select avg(d1) over () from t1 group by uuid()  with rollup
            
            

            alice Alice Sherepa added a comment - also on 10.5 create table t1 (d1 datetime not null ); insert into t1 values ( '0000-00-00 00:00:00' ), ( '0000-00-00 00:00:00' );   select avg (d1) over () from t1 group by uuid() with rollup ; 10.5 1f1f61a9de0c85 Version: '10.5.10-MariaDB-debug-log' /10.5/sql/compat56.cc:271: void TIME_from_longlong_datetime_packed(MYSQL_TIME*, longlong): Assertion `tmp != ((long long) 0x8000000000000000LL)' failed. 210304 16:29:22 [ERROR] mysqld got signal 6 ;   linux/raise.c:51(__GI_raise)[0x7f615d72b18b] stdlib/abort.c:81(__GI_abort)[0x7f615d70a859] intl/loadmsgcat.c:509(get_sysdep_segment_value)[0x7f615d70a729] :0(__GI___assert_fail)[0x7f615d71bf36] sql/compat56.cc:273(TIME_from_longlong_datetime_packed(st_mysql_time*, long long))[0x561b8258a054] sql/field.cc:7103(Field_datetimef::get_TIME(st_mysql_time*, unsigned char const*, date_mode_t) const)[0x561b825cf13b] sql/field.h:3923(Field_datetimef::get_date(st_mysql_time*, date_mode_t))[0x561b825fdf99] sql/field.cc:5854(Field_temporal::val_decimal(my_decimal*))[0x561b825bffcf] sql/item.cc:3360(Item_field::val_decimal_result(my_decimal*))[0x561b8269e7b4] sql/item.cc:8363(Item_ref::val_decimal(my_decimal*))[0x561b826c8a80] sql/item_sum.cc:1807(Aggregator_simple::arg_val_decimal(my_decimal*))[0x561b828b2eaa] sql/item_sum.cc:1629(Item_sum_sum::add_helper(bool))[0x561b828b113a] sql/item_sum.cc:1602(Item_sum_sum::add())[0x561b828b0b8b] sql/item_sum.cc:2025(Item_sum_avg::add())[0x561b828b626c] sql/sql_window.cc:1102(Frame_cursor::add_value_to_items())[0x561b82441c03] sql/sql_window.cc:1515(Frame_range_current_row_bottom::pre_next_partition(unsigned long long))[0x561b824442c1] sql/sql_window.cc:1162(Cursor_manager::notify_cursors_partition_changed(unsigned long long))[0x561b82442355] sql/sql_window.cc:2845(compute_window_func(THD*, List<Item_window_func>&, List<Cursor_manager>&, TABLE*, SORT_INFO*))[0x561b8243d34f] sql/sql_window.cc:2976(Window_func_runner::exec(THD*, TABLE*, SORT_INFO*))[0x561b8243db58] sql/sql_window.cc:3004(Window_funcs_sort::exec(JOIN*, bool))[0x561b8243dda6] sql/sql_window.cc:3131(Window_funcs_computation::exec(JOIN*, bool))[0x561b8243ebae] sql/sql_select.cc:28962(AGGR_OP::end_send())[0x561b81fb93f0] sql/sql_select.cc:20397(sub_select_postjoin_aggr(JOIN*, st_join_table*, bool))[0x561b81f78b13] sql/sql_select.cc:20632(sub_select(JOIN*, st_join_table*, bool))[0x561b81f794c6] sql/sql_select.cc:20223(do_select(JOIN*, Procedure*))[0x561b81f77f08] sql/sql_select.cc:4467(JOIN::exec_inner())[0x561b81f046b9] sql/sql_select.cc:4248(JOIN::exec())[0x561b81f01ca4] sql/sql_select.cc:4722(mysql_select(THD*, TABLE_LIST*, List<Item>&, Item*, unsigned int, st_order*, st_order*, Item*, st_order*, unsigned long long, select_result*, st_select_lex_unit*, st_select_lex*))[0x561b81f06078] sql/sql_select.cc:417(handle_select(THD*, LEX*, select_result*, unsigned long))[0x561b81ed78b6] sql/sql_parse.cc:6282(execute_sqlcom_select(THD*, TABLE_LIST*))[0x561b81e41024] sql/sql_parse.cc:3978(mysql_execute_command(THD*))[0x561b81e2ff1f] sql/sql_parse.cc:8063(mysql_parse(THD*, char*, unsigned int, Parser_state*, bool, bool))[0x561b81e4c31e] sql/sql_parse.cc:1892(dispatch_command(enum_server_command, THD*, char*, unsigned int, bool, bool))[0x561b81e22517] sql/sql_parse.cc:1370(do_command(THD*))[0x561b81e1ee40] sql/sql_connect.cc:1410(do_handle_one_connection(CONNECT*, bool))[0x561b822616dc] sql/sql_connect.cc:1314(handle_one_connection)[0x561b82261040] perfschema/pfs.cc:2203(pfs_spawn_thread)[0x561b82f70bf7] nptl/pthread_create.c:478(start_thread)[0x7f615dc33609] x86_64/clone.S:97(__GI___clone)[0x7f615d807293]   Query (0x62b0000852a8): select avg(d1) over () from t1 group by uuid() with rollup
            bar Alexander Barkov added a comment - - edited

            Also repeatable with RAND() instead if UUID() with a 10.3 ASAN build:

            create or replace table t1 (d1 datetime not null);
            insert into t1 values ('0000-00-00 00:00:00'), ('0000-00-00 00:00:00');
            select avg(d1) over () from t1 group by rand()  with rollup;
            

            No crash in a DEBUG build (without ASAN).

            bar Alexander Barkov added a comment - - edited Also repeatable with RAND() instead if UUID() with a 10.3 ASAN build: create or replace table t1 (d1 datetime not null ); insert into t1 values ( '0000-00-00 00:00:00' ), ( '0000-00-00 00:00:00' ); select avg (d1) over () from t1 group by rand() with rollup ; No crash in a DEBUG build (without ASAN).
            Roel Roel Van de Paar added a comment - - edited

            (Crashes without ASAN)

            INSTALL PLUGIN Spider SONAME 'ha_spider.so';
            CREATE USER Spider@localhost IDENTIFIED BY 'PWD123';
            CREATE SERVER srv FOREIGN DATA WRAPPER MYSQL OPTIONS (SOCKET '../socket.sock',DATABASE 'test',user 'Spider',PASSWORD 'PWD123');
            CREATE TABLE t (c INT) ENGINE=InnoDB;
            CREATE TABLE t2 (DATE DATETIME,KEY DATE (DATE)) ENGINE=Spider COMMENT='WRAPPER "mysql",srv "srv",TABLE "t"';
            EXPLAIN SELECT 1 FROM DUAL WHERE (0) IN (SELECT * FROM t2);
            

            Leads to:

            10.11.0 6ebdd3013a18b01dbecec76b870810329eb76586 (Debug)

            mysqld: /test/10.11_dbg/sql/compat56.cc:271: void TIME_from_longlong_datetime_packed(MYSQL_TIME*, longlong): Assertion `tmp != ((long long) 0x8000000000000000LL)' failed.
            

            10.11.0 6ebdd3013a18b01dbecec76b870810329eb76586 (Debug)

            Core was generated by `/test/MD190922-mariadb-10.11.0-linux-x86_64-dbg/bin/mysqld --no-defaults --core'.
            Program terminated with signal SIGABRT, Aborted.
            #0  __GI_raise (sig=sig@entry=6) at ../sysdeps/unix/sysv/linux/raise.c:50
            [Current thread is 1 (Thread 0x14ea28096700 (LWP 4033029))]
            (gdb) bt
            #0  __GI_raise (sig=sig@entry=6) at ../sysdeps/unix/sysv/linux/raise.c:50
            #1  0x000014ea3f407859 in __GI_abort () at abort.c:79
            #2  0x000014ea3f407729 in __assert_fail_base (fmt=0x14ea3f59d588 "%s%s%s:%u: %s%sAssertion `%s' failed.\n%n", assertion=0x55fa1c5e4ba8 "tmp != ((long long) 0x8", '0' <repeats 15 times>, "LL)", file=0x55fa1c5e4998 "/test/10.11_dbg/sql/compat56.cc", line=271, function=<optimized out>) at assert.c:92
            #3  0x000014ea3f418fd6 in __GI___assert_fail (assertion=assertion@entry=0x55fa1c5e4ba8 "tmp != ((long long) 0x8", '0' <repeats 15 times>, "LL)", file=file@entry=0x55fa1c5e4998 "/test/10.11_dbg/sql/compat56.cc", line=line@entry=271, function=function@entry=0x55fa1c5e4b68 "void TIME_from_longlong_datetime_packed(MYSQL_TIME*, longlong)") at assert.c:101
            #4  0x000055fa1bb32a56 in TIME_from_longlong_datetime_packed (ltime=ltime@entry=0x14ea28093990, tmp=tmp@entry=-9223372036854775808) at /test/10.11_dbg/sql/compat56.cc:271
            #5  0x000055fa1bb419fd in Field_datetimef::get_TIME (this=<optimized out>, ltime=0x14ea28093990, pos=0x14e9e40171a9 "", fuzzydate={m_mode = date_mode_t::CONV_NONE}) at /test/10.11_dbg/sql/field.cc:7197
            #6  0x000055fa1bb61b2b in Field_datetimef::get_date (this=<optimized out>, ltime=<optimized out>, fuzzydate=<optimized out>) at /test/10.11_dbg/sql/field.h:3961
            #7  0x000055fa1bb394af in Field_datetime_with_dec::val_str (this=0x14e9e404ff80, str=0x14ea28093a38, unused=<optimized out>) at /test/10.11_dbg/sql/sql_basic_types.h:204
            #8  0x000014ea223a7e54 in Field::val_str (str=0x14ea28093a38, this=0x14e9e404ff80) at /test/10.11_dbg/sql/field.h:1604
            #9  Field::val_str (new_ptr=0x14e9e40171a9 "", str=0x14ea28093a38, this=0x14e9e404ff80) at /test/10.11_dbg/sql/field.h:1604
            #10 spider_db_mysql_util::append_column_value (this=0x14ea22414150 <spider_db_mysql_utility>, spider=<optimized out>, str=0x14e9e4084ae0, field=0x14e9e404ff80, new_ptr=0x14e9e40171a9 "", is_like=<optimized out>, access_charset=0x55fa1cd9e120 <my_charset_latin1>) at /test/10.11_dbg/storage/spider/spd_db_mysql.cc:4206
            #11 0x000014ea2230f1a5 in spider_db_append_key_where_internal (str=0x14e9e4084ae0, str_part=str_part@entry=0x0, str_part2=str_part2@entry=0x0, start_key=0x14ea28094340, end_key=0x0, spider=0x14e9e4078600, set_order=false, sql_type=1, dbton_id=0) at /test/10.11_dbg/storage/spider/spd_db_conn.cc:1737
            #12 0x000014ea223bd4b9 in spider_mbase_handler::append_key_where (this=<optimized out>, str=<optimized out>, str_part=str_part@entry=0x0, str_part2=str_part2@entry=0x0, start_key=<optimized out>, end_key=<optimized out>, sql_type=1, set_order=false) at /test/10.11_dbg/storage/spider/spd_db_mysql.cc:10659
            #13 0x000014ea223bd4f7 in spider_mbase_handler::append_key_where_part (this=<optimized out>, start_key=<optimized out>, end_key=<optimized out>, sql_type=<optimized out>) at /test/10.11_dbg/storage/spider/spd_db_mysql.cc:10643
            #14 0x000014ea223810db in ha_spider::append_key_where_sql_part (this=this@entry=0x14e9e4078600, start_key=start_key@entry=0x14ea28094340, end_key=end_key@entry=0x0, sql_type=sql_type@entry=1) at /test/10.11_dbg/storage/spider/ha_spider.cc:10933
            #15 0x000014ea223102f8 in spider_db_append_key_where (start_key=start_key@entry=0x14ea28094340, end_key=end_key@entry=0x0, spider=spider@entry=0x14e9e4078600) at /test/10.11_dbg/storage/spider/spd_db_conn.cc:2052
            #16 0x000014ea22381e57 in ha_spider::index_read_map_internal (this=this@entry=0x14e9e4078600, buf=buf@entry=0x14e9e404ff38 "\377\200", key=key@entry=0x14e9e40171a8 "", keypart_map=keypart_map@entry=1, find_flag=find_flag@entry=HA_READ_KEY_EXACT) at /test/10.11_dbg/storage/spider/ha_spider.cc:1348
            #17 0x000014ea22382d87 in ha_spider::index_read_map (this=0x14e9e4078600, buf=0x14e9e404ff38 "\377\200", key=0x14e9e40171a8 "", keypart_map=1, find_flag=HA_READ_KEY_EXACT) at /test/10.11_dbg/storage/spider/ha_spider.cc:1632
            #18 0x000055fa1bb74e41 in handler::ha_index_read_map (this=0x14e9e4078600, buf=0x14e9e404ff38 "\377\200", key=0x14e9e40171a8 "", keypart_map=1, find_flag=find_flag@entry=HA_READ_KEY_EXACT) at /test/10.11_dbg/sql/handler.cc:3472
            #19 0x000055fa1bc8807a in subselect_indexsubquery_engine::exec (this=0x14e9e40cca78) at /test/10.11_dbg/sql/item_subselect.cc:4523
            #20 0x000055fa1bc7e13a in Item_subselect::exec (this=this@entry=0x14e9e4014d48) at /test/10.11_dbg/sql/item_subselect.cc:855
            #21 0x000055fa1bc833e9 in Item_in_subselect::exec (this=0x14e9e4014d48) at /test/10.11_dbg/sql/item_subselect.cc:1037
            #22 0x000055fa1bc7d2db in Item_in_subselect::val_bool (this=0x14e9e4014d48) at /test/10.11_dbg/sql/item_subselect.cc:1990
            #23 0x000055fa1b754f49 in Item::val_bool_result (this=<optimized out>) at /test/10.11_dbg/sql/item.h:1783
            #24 0x000055fa1bbc5b58 in Item_in_optimizer::val_int (this=0x14e9e4016e48) at /test/10.11_dbg/sql/item_cmpfunc.cc:1650
            #25 0x000055fa1ba7ceb0 in Type_handler_int_result::Item_val_bool (this=<optimized out>, item=<optimized out>) at /test/10.11_dbg/sql/sql_type.cc:5091
            #26 0x000055fa1b754e7a in Item::val_bool (this=0x14e9e4016e48) at /test/10.11_dbg/sql/item.h:1687
            #27 0x000055fa1b8c4592 in Item::eval_const_cond (this=0x14e9e4016e48) at /test/10.11_dbg/sql/item.h:1694
            #28 Item::remove_eq_conds (this=0x14e9e4016e48, thd=<optimized out>, cond_value=0x14e9e4016388, top_level_arg=<optimized out>) at /test/10.11_dbg/sql/sql_select.cc:18612
            #29 0x000055fa1b8c9240 in optimize_cond (join=join@entry=0x14e9e4016000, conds=0x14e9e4016e48, join_list=0x14e9e4013490, ignore_on_conds=ignore_on_conds@entry=false, cond_value=cond_value@entry=0x14e9e4016388, cond_equal=cond_equal@entry=0x14e9e40164b0, flags=1) at /test/10.11_dbg/sql/sql_select.cc:18162
            #30 0x000055fa1b90f5ff in JOIN::optimize_inner (this=this@entry=0x14e9e4016000) at /test/10.11_dbg/sql/sql_select.cc:2252
            #31 0x000055fa1b910464 in JOIN::optimize (this=this@entry=0x14e9e4016000) at /test/10.11_dbg/sql/sql_select.cc:1864
            #32 0x000055fa1b910557 in mysql_select (thd=thd@entry=0x14e9e4000d48, tables=0x0, fields=@0x14e9e4013578: {<base_list> = {<Sql_alloc> = {<No data fields>}, first = 0x14e9e40137d0, last = 0x14e9e40137d0, elements = 1}, <No data fields>}, conds=0x14e9e4014d48, og_num=0, order=0x0, group=0x0, having=0x0, proc_param=0x0, select_options=2164525828, result=0x14e9e40159b0, unit=0x14e9e4004f80, select_lex=0x14e9e40132d8) at /test/10.11_dbg/sql/sql_select.cc:5057
            #33 0x000055fa1b9110c9 in mysql_explain_union (thd=thd@entry=0x14e9e4000d48, unit=unit@entry=0x14e9e4004f80, result=result@entry=0x14e9e40159b0) at /test/10.11_dbg/sql/sql_select.cc:28494
            #34 0x000055fa1b87aaac in execute_sqlcom_select (thd=thd@entry=0x14e9e4000d48, all_tables=0x14e9e4013e38) at /test/10.11_dbg/sql/sql_parse.cc:6199
            #35 0x000055fa1b887109 in mysql_execute_command (thd=thd@entry=0x14e9e4000d48, is_called_from_prepared_stmt=is_called_from_prepared_stmt@entry=false) at /test/10.11_dbg/sql/sql_parse.cc:3945
            #36 0x000055fa1b87503c in mysql_parse (thd=thd@entry=0x14e9e4000d48, rawbuf=<optimized out>, length=<optimized out>, parser_state=parser_state@entry=0x14ea28095330) at /test/10.11_dbg/sql/sql_parse.cc:8037
            #37 0x000055fa1b88266d in dispatch_command (command=command@entry=COM_QUERY, thd=thd@entry=0x14e9e4000d48, packet=packet@entry=0x14e9e400aed9 "", packet_length=packet_length@entry=58, blocking=blocking@entry=true) at /test/10.11_dbg/sql/sql_class.h:1345
            #38 0x000055fa1b884d97 in do_command (thd=0x14e9e4000d48, blocking=blocking@entry=true) at /test/10.11_dbg/sql/sql_parse.cc:1407
            #39 0x000055fa1b9e8fb9 in do_handle_one_connection (connect=<optimized out>, connect@entry=0x55fa1e267608, put_in_cache=put_in_cache@entry=true) at /test/10.11_dbg/sql/sql_connect.cc:1416
            #40 0x000055fa1b9e94c3 in handle_one_connection (arg=0x55fa1e267608) at /test/10.11_dbg/sql/sql_connect.cc:1318
            #41 0x000014ea3f918609 in start_thread (arg=<optimized out>) at pthread_create.c:477
            #42 0x000014ea3f504133 in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:95
            

            Bug confirmed present in:
            MariaDB: 10.4.27 (dbg), 10.5.18 (dbg), 10.6.10 (dbg), 10.7.6 (dbg), 10.8.5 (dbg), 10.9.3 (dbg), 10.10.0 (dbg), 10.10.2 (dbg), 10.11.0 (dbg)

            Bug (or feature/syntax) confirmed not present in:
            MariaDB: 10.3.37 (dbg), 10.3.37 (opt), 10.4.27 (opt), 10.5.18 (opt), 10.6.10 (opt), 10.7.6 (opt), 10.8.5 (opt), 10.9.3 (opt), 10.10.0 (opt), 10.10.2 (opt), 10.11.0 (opt)
            MySQL: 5.5.62 (dbg), 5.5.62 (opt), 5.6.51 (dbg), 5.6.51 (opt), 5.7.38 (dbg), 5.7.38 (opt), 8.0.29 (dbg), 8.0.29 (opt)

            Roel Roel Van de Paar added a comment - - edited (Crashes without ASAN) INSTALL PLUGIN Spider SONAME 'ha_spider.so' ; CREATE USER Spider@localhost IDENTIFIED BY 'PWD123' ; CREATE SERVER srv FOREIGN DATA WRAPPER MYSQL OPTIONS (SOCKET '../socket.sock' , DATABASE 'test' , user 'Spider' , PASSWORD 'PWD123' ); CREATE TABLE t (c INT ) ENGINE=InnoDB; CREATE TABLE t2 ( DATE DATETIME, KEY DATE ( DATE )) ENGINE=Spider COMMENT= 'WRAPPER "mysql",srv "srv",TABLE "t"' ; EXPLAIN SELECT 1 FROM DUAL WHERE (0) IN ( SELECT * FROM t2); Leads to: 10.11.0 6ebdd3013a18b01dbecec76b870810329eb76586 (Debug) mysqld: /test/10.11_dbg/sql/compat56.cc:271: void TIME_from_longlong_datetime_packed(MYSQL_TIME*, longlong): Assertion `tmp != ((long long) 0x8000000000000000LL)' failed. 10.11.0 6ebdd3013a18b01dbecec76b870810329eb76586 (Debug) Core was generated by `/test/MD190922-mariadb-10.11.0-linux-x86_64-dbg/bin/mysqld --no-defaults --core'. Program terminated with signal SIGABRT, Aborted. #0 __GI_raise (sig=sig@entry=6) at ../sysdeps/unix/sysv/linux/raise.c:50 [Current thread is 1 (Thread 0x14ea28096700 (LWP 4033029))] (gdb) bt #0 __GI_raise (sig=sig@entry=6) at ../sysdeps/unix/sysv/linux/raise.c:50 #1 0x000014ea3f407859 in __GI_abort () at abort.c:79 #2 0x000014ea3f407729 in __assert_fail_base (fmt=0x14ea3f59d588 "%s%s%s:%u: %s%sAssertion `%s' failed.\n%n", assertion=0x55fa1c5e4ba8 "tmp != ((long long) 0x8", '0' <repeats 15 times>, "LL)", file=0x55fa1c5e4998 "/test/10.11_dbg/sql/compat56.cc", line=271, function=<optimized out>) at assert.c:92 #3 0x000014ea3f418fd6 in __GI___assert_fail (assertion=assertion@entry=0x55fa1c5e4ba8 "tmp != ((long long) 0x8", '0' <repeats 15 times>, "LL)", file=file@entry=0x55fa1c5e4998 "/test/10.11_dbg/sql/compat56.cc", line=line@entry=271, function=function@entry=0x55fa1c5e4b68 "void TIME_from_longlong_datetime_packed(MYSQL_TIME*, longlong)") at assert.c:101 #4 0x000055fa1bb32a56 in TIME_from_longlong_datetime_packed (ltime=ltime@entry=0x14ea28093990, tmp=tmp@entry=-9223372036854775808) at /test/10.11_dbg/sql/compat56.cc:271 #5 0x000055fa1bb419fd in Field_datetimef::get_TIME (this=<optimized out>, ltime=0x14ea28093990, pos=0x14e9e40171a9 "", fuzzydate={m_mode = date_mode_t::CONV_NONE}) at /test/10.11_dbg/sql/field.cc:7197 #6 0x000055fa1bb61b2b in Field_datetimef::get_date (this=<optimized out>, ltime=<optimized out>, fuzzydate=<optimized out>) at /test/10.11_dbg/sql/field.h:3961 #7 0x000055fa1bb394af in Field_datetime_with_dec::val_str (this=0x14e9e404ff80, str=0x14ea28093a38, unused=<optimized out>) at /test/10.11_dbg/sql/sql_basic_types.h:204 #8 0x000014ea223a7e54 in Field::val_str (str=0x14ea28093a38, this=0x14e9e404ff80) at /test/10.11_dbg/sql/field.h:1604 #9 Field::val_str (new_ptr=0x14e9e40171a9 "", str=0x14ea28093a38, this=0x14e9e404ff80) at /test/10.11_dbg/sql/field.h:1604 #10 spider_db_mysql_util::append_column_value (this=0x14ea22414150 <spider_db_mysql_utility>, spider=<optimized out>, str=0x14e9e4084ae0, field=0x14e9e404ff80, new_ptr=0x14e9e40171a9 "", is_like=<optimized out>, access_charset=0x55fa1cd9e120 <my_charset_latin1>) at /test/10.11_dbg/storage/spider/spd_db_mysql.cc:4206 #11 0x000014ea2230f1a5 in spider_db_append_key_where_internal (str=0x14e9e4084ae0, str_part=str_part@entry=0x0, str_part2=str_part2@entry=0x0, start_key=0x14ea28094340, end_key=0x0, spider=0x14e9e4078600, set_order=false, sql_type=1, dbton_id=0) at /test/10.11_dbg/storage/spider/spd_db_conn.cc:1737 #12 0x000014ea223bd4b9 in spider_mbase_handler::append_key_where (this=<optimized out>, str=<optimized out>, str_part=str_part@entry=0x0, str_part2=str_part2@entry=0x0, start_key=<optimized out>, end_key=<optimized out>, sql_type=1, set_order=false) at /test/10.11_dbg/storage/spider/spd_db_mysql.cc:10659 #13 0x000014ea223bd4f7 in spider_mbase_handler::append_key_where_part (this=<optimized out>, start_key=<optimized out>, end_key=<optimized out>, sql_type=<optimized out>) at /test/10.11_dbg/storage/spider/spd_db_mysql.cc:10643 #14 0x000014ea223810db in ha_spider::append_key_where_sql_part (this=this@entry=0x14e9e4078600, start_key=start_key@entry=0x14ea28094340, end_key=end_key@entry=0x0, sql_type=sql_type@entry=1) at /test/10.11_dbg/storage/spider/ha_spider.cc:10933 #15 0x000014ea223102f8 in spider_db_append_key_where (start_key=start_key@entry=0x14ea28094340, end_key=end_key@entry=0x0, spider=spider@entry=0x14e9e4078600) at /test/10.11_dbg/storage/spider/spd_db_conn.cc:2052 #16 0x000014ea22381e57 in ha_spider::index_read_map_internal (this=this@entry=0x14e9e4078600, buf=buf@entry=0x14e9e404ff38 "\377\200", key=key@entry=0x14e9e40171a8 "", keypart_map=keypart_map@entry=1, find_flag=find_flag@entry=HA_READ_KEY_EXACT) at /test/10.11_dbg/storage/spider/ha_spider.cc:1348 #17 0x000014ea22382d87 in ha_spider::index_read_map (this=0x14e9e4078600, buf=0x14e9e404ff38 "\377\200", key=0x14e9e40171a8 "", keypart_map=1, find_flag=HA_READ_KEY_EXACT) at /test/10.11_dbg/storage/spider/ha_spider.cc:1632 #18 0x000055fa1bb74e41 in handler::ha_index_read_map (this=0x14e9e4078600, buf=0x14e9e404ff38 "\377\200", key=0x14e9e40171a8 "", keypart_map=1, find_flag=find_flag@entry=HA_READ_KEY_EXACT) at /test/10.11_dbg/sql/handler.cc:3472 #19 0x000055fa1bc8807a in subselect_indexsubquery_engine::exec (this=0x14e9e40cca78) at /test/10.11_dbg/sql/item_subselect.cc:4523 #20 0x000055fa1bc7e13a in Item_subselect::exec (this=this@entry=0x14e9e4014d48) at /test/10.11_dbg/sql/item_subselect.cc:855 #21 0x000055fa1bc833e9 in Item_in_subselect::exec (this=0x14e9e4014d48) at /test/10.11_dbg/sql/item_subselect.cc:1037 #22 0x000055fa1bc7d2db in Item_in_subselect::val_bool (this=0x14e9e4014d48) at /test/10.11_dbg/sql/item_subselect.cc:1990 #23 0x000055fa1b754f49 in Item::val_bool_result (this=<optimized out>) at /test/10.11_dbg/sql/item.h:1783 #24 0x000055fa1bbc5b58 in Item_in_optimizer::val_int (this=0x14e9e4016e48) at /test/10.11_dbg/sql/item_cmpfunc.cc:1650 #25 0x000055fa1ba7ceb0 in Type_handler_int_result::Item_val_bool (this=<optimized out>, item=<optimized out>) at /test/10.11_dbg/sql/sql_type.cc:5091 #26 0x000055fa1b754e7a in Item::val_bool (this=0x14e9e4016e48) at /test/10.11_dbg/sql/item.h:1687 #27 0x000055fa1b8c4592 in Item::eval_const_cond (this=0x14e9e4016e48) at /test/10.11_dbg/sql/item.h:1694 #28 Item::remove_eq_conds (this=0x14e9e4016e48, thd=<optimized out>, cond_value=0x14e9e4016388, top_level_arg=<optimized out>) at /test/10.11_dbg/sql/sql_select.cc:18612 #29 0x000055fa1b8c9240 in optimize_cond (join=join@entry=0x14e9e4016000, conds=0x14e9e4016e48, join_list=0x14e9e4013490, ignore_on_conds=ignore_on_conds@entry=false, cond_value=cond_value@entry=0x14e9e4016388, cond_equal=cond_equal@entry=0x14e9e40164b0, flags=1) at /test/10.11_dbg/sql/sql_select.cc:18162 #30 0x000055fa1b90f5ff in JOIN::optimize_inner (this=this@entry=0x14e9e4016000) at /test/10.11_dbg/sql/sql_select.cc:2252 #31 0x000055fa1b910464 in JOIN::optimize (this=this@entry=0x14e9e4016000) at /test/10.11_dbg/sql/sql_select.cc:1864 #32 0x000055fa1b910557 in mysql_select (thd=thd@entry=0x14e9e4000d48, tables=0x0, fields=@0x14e9e4013578: {<base_list> = {<Sql_alloc> = {<No data fields>}, first = 0x14e9e40137d0, last = 0x14e9e40137d0, elements = 1}, <No data fields>}, conds=0x14e9e4014d48, og_num=0, order=0x0, group=0x0, having=0x0, proc_param=0x0, select_options=2164525828, result=0x14e9e40159b0, unit=0x14e9e4004f80, select_lex=0x14e9e40132d8) at /test/10.11_dbg/sql/sql_select.cc:5057 #33 0x000055fa1b9110c9 in mysql_explain_union (thd=thd@entry=0x14e9e4000d48, unit=unit@entry=0x14e9e4004f80, result=result@entry=0x14e9e40159b0) at /test/10.11_dbg/sql/sql_select.cc:28494 #34 0x000055fa1b87aaac in execute_sqlcom_select (thd=thd@entry=0x14e9e4000d48, all_tables=0x14e9e4013e38) at /test/10.11_dbg/sql/sql_parse.cc:6199 #35 0x000055fa1b887109 in mysql_execute_command (thd=thd@entry=0x14e9e4000d48, is_called_from_prepared_stmt=is_called_from_prepared_stmt@entry=false) at /test/10.11_dbg/sql/sql_parse.cc:3945 #36 0x000055fa1b87503c in mysql_parse (thd=thd@entry=0x14e9e4000d48, rawbuf=<optimized out>, length=<optimized out>, parser_state=parser_state@entry=0x14ea28095330) at /test/10.11_dbg/sql/sql_parse.cc:8037 #37 0x000055fa1b88266d in dispatch_command (command=command@entry=COM_QUERY, thd=thd@entry=0x14e9e4000d48, packet=packet@entry=0x14e9e400aed9 "", packet_length=packet_length@entry=58, blocking=blocking@entry=true) at /test/10.11_dbg/sql/sql_class.h:1345 #38 0x000055fa1b884d97 in do_command (thd=0x14e9e4000d48, blocking=blocking@entry=true) at /test/10.11_dbg/sql/sql_parse.cc:1407 #39 0x000055fa1b9e8fb9 in do_handle_one_connection (connect=<optimized out>, connect@entry=0x55fa1e267608, put_in_cache=put_in_cache@entry=true) at /test/10.11_dbg/sql/sql_connect.cc:1416 #40 0x000055fa1b9e94c3 in handle_one_connection (arg=0x55fa1e267608) at /test/10.11_dbg/sql/sql_connect.cc:1318 #41 0x000014ea3f918609 in start_thread (arg=<optimized out>) at pthread_create.c:477 #42 0x000014ea3f504133 in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:95 Bug confirmed present in: MariaDB: 10.4.27 (dbg), 10.5.18 (dbg), 10.6.10 (dbg), 10.7.6 (dbg), 10.8.5 (dbg), 10.9.3 (dbg), 10.10.0 (dbg), 10.10.2 (dbg), 10.11.0 (dbg) Bug (or feature/syntax) confirmed not present in: MariaDB: 10.3.37 (dbg), 10.3.37 (opt), 10.4.27 (opt), 10.5.18 (opt), 10.6.10 (opt), 10.7.6 (opt), 10.8.5 (opt), 10.9.3 (opt), 10.10.0 (opt), 10.10.2 (opt), 10.11.0 (opt) MySQL: 5.5.62 (dbg), 5.5.62 (opt), 5.6.51 (dbg), 5.6.51 (opt), 5.7.38 (dbg), 5.7.38 (opt), 8.0.29 (dbg), 8.0.29 (opt)
            alice Alice Sherepa added a comment -

            nor reproducible on current 10.5 9b3413c71f16a3d738af358e288a0168f4c15827 -11.6.
            but test cases about Spider are still repeatable, maybe it is better to report them separately

            Version: '10.11.10-MariaDB-debug'
            mysqld: /10.11/src/sql/compat56.cc:271: void TIME_from_longlong_datetime_packed(MYSQL_TIME*, longlong): Assertion `tmp != ((long long) 0x8000000000000000LL)' failed.
            241022 18:01:27 [ERROR] mysqld got signal 6 ;
             
            Server version: 10.11.10-MariaDB-debug source revision: abc46259c6e6fc0fdf8144ad4be551495d88d22a
             
            /lib/x86_64-linux-gnu/libc.so.6(+0x33fd6)[0x7f8b9c56afd6]
            sql/compat56.cc:273(TIME_from_longlong_datetime_packed(st_mysql_time*, long long))[0x55a111cd8633]
            sql/field.cc:7255(Field_datetimef::get_TIME(st_mysql_time*, unsigned char const*, date_mode_t) const)[0x55a111d1e6fc]
            sql/field.h:3997(Field_datetimef::get_date(st_mysql_time*, date_mode_t))[0x55a111d4e9a5]
            sql/field.cc:7200(Field_datetime_with_dec::val_str(String*, String*))[0x55a111d1de0b]
            sql/field.h:1057(Field::val_str(String*))[0x55a11110b0ee]
            sql/field.h:1618(Field::val_str(String*, unsigned char const*))[0x55a111a90590]
            spider/spd_db_mysql.cc:3526(spider_db_mysql_util::append_column_value(ha_spider*, spider_string*, Field*, unsigned char const*, bool, charset_info_st const*))[0x7f8b7088711a]
            spider/spd_db_conn.cc:1681(spider_db_append_key_where_internal(spider_string*, spider_string*, spider_string*, st_key_range const*, st_key_range const*, ha_spider*, bool, unsigned long, unsigned int))[0x7f8b706711cd]
            spider/spd_db_mysql.cc:9653(spider_mbase_handler::append_key_where(spider_string*, spider_string*, spider_string*, st_key_range const*, st_key_range const*, unsigned long, bool))[0x7f8b708c3188]
            spider/spd_db_mysql.cc:9637(spider_mbase_handler::append_key_where_part(st_key_range const*, st_key_range const*, unsigned long))[0x7f8b708c2edf]
            spider/ha_spider.cc:9116(ha_spider::append_key_where_sql_part(st_key_range const*, st_key_range const*, unsigned long))[0x7f8b70845d84]
            spider/spd_db_conn.cc:1996(spider_db_append_key_where(st_key_range const*, st_key_range const*, ha_spider*))[0x7f8b7067476a]
            spider/ha_spider.cc:1500(ha_spider::index_read_map_internal(unsigned char*, unsigned char const*, unsigned long, ha_rkey_function))[0x7f8b707ea2c6]
            spider/ha_spider.cc:1604(ha_spider::index_read_map(unsigned char*, unsigned char const*, unsigned long, ha_rkey_function))[0x7f8b707eb798]
            sql/handler.cc:3588(handler::ha_index_read_map(unsigned char*, unsigned char const*, unsigned long, ha_rkey_function))[0x55a111d9a4b0]
            sql/item_subselect.cc:4525(subselect_indexsubquery_engine::exec())[0x55a112063864]
            sql/item_subselect.cc:816(Item_subselect::exec())[0x55a11203af20]
            sql/item_subselect.cc:998(Item_in_subselect::exec())[0x55a11203c575]
            sql/item_subselect.cc:1970(Item_in_subselect::val_bool())[0x55a1120479a1]
            sql/item.h:1817(Item::val_bool_result())[0x55a11106abb8]
            sql/item_cmpfunc.cc:1735(Item_in_optimizer::val_int())[0x55a111e61131]
            sql/sql_type.cc:5227(Type_handler_int_result::Item_val_bool(Item*) const)[0x55a111b1c818]
            sql/item.h:1722(Item::val_bool())[0x55a11106a6ce]
            sql/item.h:1729(Item::eval_const_cond())[0x55a11163a942]
            sql/sql_select.cc:19618(Item::remove_eq_conds(THD*, Item::cond_result*, bool))[0x55a1115cfa7b]
            sql/sql_select.cc:19162(optimize_cond(JOIN*, Item*, List<TABLE_LIST>*, bool, Item::cond_result*, COND_EQUAL**, int))[0x55a1115ccff1]
            sql/sql_select.cc:2357(JOIN::optimize_inner())[0x55a11154ed7f]
            sql/sql_select.cc:1954(JOIN::optimize())[0x55a11154a897]
            sql/sql_select.cc:5206(mysql_select(THD*, TABLE_LIST*, List<Item>&, Item*, unsigned int, st_order*, st_order*, Item*, st_order*, unsigned long long, select_result*, st_select_lex_unit*, st_select_lex*))[0x55a11156d399]
            sql/sql_select.cc:29957(mysql_explain_union(THD*, st_select_lex_unit*, select_result*))[0x55a111622fa2]
            sql/sql_parse.cc:6340(execute_sqlcom_select(THD*, TABLE_LIST*))[0x55a1114583cd]
            sql/sql_parse.cc:3988(mysql_execute_command(THD*, bool))[0x55a111446c20]
            sql/sql_parse.cc:8161(mysql_parse(THD*, char*, unsigned int, Parser_state*))[0x55a111463be2]
            sql/sql_parse.cc:1897(dispatch_command(enum_server_command, THD*, char*, unsigned int, bool))[0x55a1114389bc]
            sql/sql_parse.cc:1408(do_command(THD*, bool))[0x55a111435678]
            sql/sql_connect.cc:1417(do_handle_one_connection(CONNECT*, bool))[0x55a111917fba]
            sql/sql_connect.cc:1321(handle_one_connection)[0x55a111917940]
            perfschema/pfs.cc:2203(pfs_spawn_thread)[0x55a1125a829e]
            nptl/pthread_create.c:478(start_thread)[0x7f8b9cb1b609]
             
            Query (0x6290000e62a8): EXPLAIN SELECT 1 FROM DUAL WHERE (0) IN (SELECT * FROM t2)
            

            alice Alice Sherepa added a comment - nor reproducible on current 10.5 9b3413c71f16a3d738af358e288a0168f4c15827 -11.6. but test cases about Spider are still repeatable, maybe it is better to report them separately Version: '10.11.10-MariaDB-debug' mysqld: /10.11/src/sql/compat56.cc:271: void TIME_from_longlong_datetime_packed(MYSQL_TIME*, longlong): Assertion `tmp != ((long long) 0x8000000000000000LL)' failed. 241022 18:01:27 [ERROR] mysqld got signal 6 ;   Server version: 10.11.10-MariaDB-debug source revision: abc46259c6e6fc0fdf8144ad4be551495d88d22a   /lib/x86_64-linux-gnu/libc.so.6(+0x33fd6)[0x7f8b9c56afd6] sql/compat56.cc:273(TIME_from_longlong_datetime_packed(st_mysql_time*, long long))[0x55a111cd8633] sql/field.cc:7255(Field_datetimef::get_TIME(st_mysql_time*, unsigned char const*, date_mode_t) const)[0x55a111d1e6fc] sql/field.h:3997(Field_datetimef::get_date(st_mysql_time*, date_mode_t))[0x55a111d4e9a5] sql/field.cc:7200(Field_datetime_with_dec::val_str(String*, String*))[0x55a111d1de0b] sql/field.h:1057(Field::val_str(String*))[0x55a11110b0ee] sql/field.h:1618(Field::val_str(String*, unsigned char const*))[0x55a111a90590] spider/spd_db_mysql.cc:3526(spider_db_mysql_util::append_column_value(ha_spider*, spider_string*, Field*, unsigned char const*, bool, charset_info_st const*))[0x7f8b7088711a] spider/spd_db_conn.cc:1681(spider_db_append_key_where_internal(spider_string*, spider_string*, spider_string*, st_key_range const*, st_key_range const*, ha_spider*, bool, unsigned long, unsigned int))[0x7f8b706711cd] spider/spd_db_mysql.cc:9653(spider_mbase_handler::append_key_where(spider_string*, spider_string*, spider_string*, st_key_range const*, st_key_range const*, unsigned long, bool))[0x7f8b708c3188] spider/spd_db_mysql.cc:9637(spider_mbase_handler::append_key_where_part(st_key_range const*, st_key_range const*, unsigned long))[0x7f8b708c2edf] spider/ha_spider.cc:9116(ha_spider::append_key_where_sql_part(st_key_range const*, st_key_range const*, unsigned long))[0x7f8b70845d84] spider/spd_db_conn.cc:1996(spider_db_append_key_where(st_key_range const*, st_key_range const*, ha_spider*))[0x7f8b7067476a] spider/ha_spider.cc:1500(ha_spider::index_read_map_internal(unsigned char*, unsigned char const*, unsigned long, ha_rkey_function))[0x7f8b707ea2c6] spider/ha_spider.cc:1604(ha_spider::index_read_map(unsigned char*, unsigned char const*, unsigned long, ha_rkey_function))[0x7f8b707eb798] sql/handler.cc:3588(handler::ha_index_read_map(unsigned char*, unsigned char const*, unsigned long, ha_rkey_function))[0x55a111d9a4b0] sql/item_subselect.cc:4525(subselect_indexsubquery_engine::exec())[0x55a112063864] sql/item_subselect.cc:816(Item_subselect::exec())[0x55a11203af20] sql/item_subselect.cc:998(Item_in_subselect::exec())[0x55a11203c575] sql/item_subselect.cc:1970(Item_in_subselect::val_bool())[0x55a1120479a1] sql/item.h:1817(Item::val_bool_result())[0x55a11106abb8] sql/item_cmpfunc.cc:1735(Item_in_optimizer::val_int())[0x55a111e61131] sql/sql_type.cc:5227(Type_handler_int_result::Item_val_bool(Item*) const)[0x55a111b1c818] sql/item.h:1722(Item::val_bool())[0x55a11106a6ce] sql/item.h:1729(Item::eval_const_cond())[0x55a11163a942] sql/sql_select.cc:19618(Item::remove_eq_conds(THD*, Item::cond_result*, bool))[0x55a1115cfa7b] sql/sql_select.cc:19162(optimize_cond(JOIN*, Item*, List<TABLE_LIST>*, bool, Item::cond_result*, COND_EQUAL**, int))[0x55a1115ccff1] sql/sql_select.cc:2357(JOIN::optimize_inner())[0x55a11154ed7f] sql/sql_select.cc:1954(JOIN::optimize())[0x55a11154a897] sql/sql_select.cc:5206(mysql_select(THD*, TABLE_LIST*, List<Item>&, Item*, unsigned int, st_order*, st_order*, Item*, st_order*, unsigned long long, select_result*, st_select_lex_unit*, st_select_lex*))[0x55a11156d399] sql/sql_select.cc:29957(mysql_explain_union(THD*, st_select_lex_unit*, select_result*))[0x55a111622fa2] sql/sql_parse.cc:6340(execute_sqlcom_select(THD*, TABLE_LIST*))[0x55a1114583cd] sql/sql_parse.cc:3988(mysql_execute_command(THD*, bool))[0x55a111446c20] sql/sql_parse.cc:8161(mysql_parse(THD*, char*, unsigned int, Parser_state*))[0x55a111463be2] sql/sql_parse.cc:1897(dispatch_command(enum_server_command, THD*, char*, unsigned int, bool))[0x55a1114389bc] sql/sql_parse.cc:1408(do_command(THD*, bool))[0x55a111435678] sql/sql_connect.cc:1417(do_handle_one_connection(CONNECT*, bool))[0x55a111917fba] sql/sql_connect.cc:1321(handle_one_connection)[0x55a111917940] perfschema/pfs.cc:2203(pfs_spawn_thread)[0x55a1125a829e] nptl/pthread_create.c:478(start_thread)[0x7f8b9cb1b609]   Query (0x6290000e62a8): EXPLAIN SELECT 1 FROM DUAL WHERE (0) IN (SELECT * FROM t2)
            Roel Roel Van de Paar added a comment - - edited

            Agreed. Created MDEV-35252 for the spider issue, and closing this as "(now) can't repeat", though perhaps it is fixed in the meantime elsewhere.

            bar FYI, in case you know of any patches that may have resolved this.

            Roel Roel Van de Paar added a comment - - edited Agreed. Created MDEV-35252 for the spider issue, and closing this as "(now) can't repeat", though perhaps it is fixed in the meantime elsewhere. bar FYI, in case you know of any patches that may have resolved this.

            Roel, sorry I don't know.

            bar Alexander Barkov added a comment - Roel , sorry I don't know.

            People

              bar Alexander Barkov
              elenst Elena Stepanova
              Votes:
              0 Vote for this issue
              Watchers:
              5 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved:

                Git Integration

                  Error rendering 'com.xiplink.jira.git.jira_git_plugin:git-issue-webpanel'. Please contact your Jira administrators.