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

ASSERT_COLUMN_MARKED_FOR_READ failed on tables with vcols

    XMLWordPrintable

    Details

      Description

      IMPORTANT: Some of the test cases below fail on all of 10.2-10.6, and some only on 10.4-10.6. Please pay attention to the inline notes before declaring something as "not reproducible", and make sure all variations are fixed before closing the issue.

      Test case 1, only fails on 10.4-10.6

      CREATE TABLE t1 (d DATETIME(3), v DATETIME(2) AS (d));
      CREATE VIEW v1 AS SELECT * FROM t1;
       
      INSERT INTO t1 (d) VALUES ('2004-04-19 15:37:39.123'),('1985-12-24 10:15:08.456') ;
      DELETE FROM v1 ORDER BY v LIMIT 4;
       
      # Cleanup
      DROP VIEW v1;
      DROP TABLE t1;
      

      10.4 30da40bb8c3

      mysqld: /data/src/10.4/sql/field.cc:6889: virtual bool Field_datetimef::get_TIME(MYSQL_TIME*, const uchar*, date_mode_t) const: Assertion `!table || (!table->read_set || bitmap_is_set(table->read_set, field_index) || (!(ptr >= table->record[0] && ptr < table->record[0] + table->s->reclength)))' failed.
      190108 14:10:23 [ERROR] mysqld got signal 6 ;
       
      #7  0x00007fc39319cee2 in __assert_fail () from /lib/x86_64-linux-gnu/libc.so.6
      #8  0x0000557ec9ec85ed in Field_datetimef::get_TIME (this=0x7fc37c124110, ltime=0x7fc38d32d1b0, pos=0x7fc37c1376ae "\231r&\371g", fuzzydate=...) at /data/src/10.4/sql/field.cc:6889
      #9  0x0000557ec9ede076 in Field_datetimef::get_date (this=0x7fc37c124110, ltime=0x7fc38d32d1b0, fuzzydate=...) at /data/src/10.4/sql/field.h:3410
      #10 0x0000557ec9edcd1c in Field_temporal::save_in_field (this=0x7fc37c124110, to=0x7fc37c13a0e8) at /data/src/10.4/sql/field.h:2664
      #11 0x0000557ec9ed9c0e in Field::store_field (this=0x7fc37c13a0e8, from=0x7fc37c124110) at /data/src/10.4/sql/field.h:770
      #12 0x0000557ec9ee3816 in field_conv_incompatible (to=0x7fc37c13a0e8, from=0x7fc37c124110) at /data/src/10.4/sql/field_conv.cc:851
      #13 0x0000557ec9ee3872 in field_conv (to=0x7fc37c13a0e8, from=0x7fc37c124110) at /data/src/10.4/sql/field_conv.cc:864
      #14 0x0000557ec9f174e3 in save_field_in_field (from=0x7fc37c124110, null_value=0x7fc37c16fbbe, to=0x7fc37c13a0e8, no_conversions=false) at /data/src/10.4/sql/item.cc:6352
      #15 0x0000557ec9f17724 in Item_field::save_in_field (this=0x7fc37c16fb48, to=0x7fc37c13a0e8, no_conversions=false) at /data/src/10.4/sql/item.cc:6403
      #16 0x0000557ec9cff23c in TABLE::update_virtual_fields (this=0x7fc37c123340, h=0x7fc37c136f18, update_mode=VCOL_UPDATE_FOR_DELETE) at /data/src/10.4/sql/table.cc:7798
      #17 0x0000557eca09891f in record_should_be_deleted (thd=0x7fc37c000b00, table=0x7fc37c123340, sel=0x0, explain=0x7fc37c07f278, truncate_history=false) at /data/src/10.4/sql/sql_delete.cc:239
      #18 0x0000557eca09a620 in mysql_delete (thd=0x7fc37c000b00, table_list=0x7fc37c0152f8, conds=0x7fc37c015bb0, order_list=0x7fc37c0053a8, limit=4, options=0, result=0x0) at /data/src/10.4/sql/sql_delete.cc:736
      #19 0x0000557ec9be02a6 in mysql_execute_command (thd=0x7fc37c000b00) at /data/src/10.4/sql/sql_parse.cc:4928
      #20 0x0000557ec9bea2c4 in mysql_parse (thd=0x7fc37c000b00, rawbuf=0x7fc37c014f98 "DELETE LOW_PRIORITY IGNORE FROM `view_t8` WHERE `col_timestamp` BETWEEN 1 AND 7 ORDER BY `col_bit`,`col_blob`,`col_char`,`col_date`,`col_enum`,`col_int`,`col_time`,`col_timestamp`,`col_varchar`,`col_y"..., length=330, parser_state=0x7fc38d32e600, is_com_multi=false, is_next_command=false) at /data/src/10.4/sql/sql_parse.cc:8104
      #21 0x0000557ec9bd74ee in dispatch_command (command=COM_QUERY, thd=0x7fc37c000b00, packet=0x7fc37c00b421 "DELETE LOW_PRIORITY IGNORE FROM `view_t8` WHERE `col_timestamp` BETWEEN 1 AND 7 ORDER BY `col_bit`,`col_blob`,`col_char`,`col_date`,`col_enum`,`col_int`,`col_time`,`col_timestamp`,`col_varchar`,`col_y"..., packet_length=331, is_com_multi=false, is_next_command=false) at /data/src/10.4/sql/sql_parse.cc:1851
      #22 0x0000557ec9bd5f12 in do_command (thd=0x7fc37c000b00) at /data/src/10.4/sql/sql_parse.cc:1396
      #23 0x0000557ec9d42140 in do_handle_one_connection (connect=0x557ecde7c320) at /data/src/10.4/sql/sql_connect.cc:1402
      #24 0x0000557ec9d41ec4 in handle_one_connection (arg=0x557ecde7c320) at /data/src/10.4/sql/sql_connect.cc:1308
      #25 0x0000557eca201308 in pfs_spawn_thread (arg=0x557ecdd8d140) at /data/src/10.4/storage/perfschema/pfs.cc:1862
      #26 0x00007fc394c58494 in start_thread (arg=0x7fc38d32f700) at pthread_create.c:333
      #27 0x00007fc39325993f in clone () from /lib/x86_64-linux-gnu/libc.so.6
      

      10.5.10 dd07cfcecd4aabb0aeae9c4f5087f82b4080c1bd (Debug)

      mysqld: /test/10.5_dbg/sql/field.cc:7100: virtual bool Field_datetimef::get_TIME(MYSQL_TIME*, const uchar*, date_mode_t) const: Assertion `marked_for_read()' failed.
      

      10.5.10 dd07cfcecd4aabb0aeae9c4f5087f82b4080c1bd (Debug)

      Core was generated by `/test/MD270421-mariadb-10.5.10-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 0x14e2f011f700 (LWP 643960))]
      (gdb) bt
      #0  __GI_raise (sig=sig@entry=6) at ../sysdeps/unix/sysv/linux/raise.c:50
      #1  0x000014e2f26db859 in __GI_abort () at abort.c:79
      #2  0x000014e2f26db729 in __assert_fail_base (fmt=0x14e2f2871588 "%s%s%s:%u: %s%sAssertion `%s' failed.\n%n", assertion=0x55cdcf6200bc "marked_for_read()", file=0x55cdcf61fea3 "/test/10.5_dbg/sql/field.cc", line=7100, function=<optimized out>) at assert.c:92
      #3  0x000014e2f26ecf36 in __GI___assert_fail (assertion=assertion@entry=0x55cdcf6200bc "marked_for_read()", file=file@entry=0x55cdcf61fea3 "/test/10.5_dbg/sql/field.cc", line=line@entry=7100, function=function@entry=0x55cdcf621d70 "virtual bool Field_datetimef::get_TIME(MYSQL_TIME*, const uchar*, date_mode_t) const") at assert.c:101
      #4  0x000055cdcea505cf in Field_datetimef::get_TIME (this=0x14e288024b50, ltime=0x14e2f011d1f0, pos=0x14e288024b19 "\231\066p\243\310\021Ѐ", fuzzydate={m_mode = date_mode_t::CONV_NONE}) at /test/10.5_dbg/sql/field.cc:7100
      #5  0x000055cdcea70a65 in Field_datetimef::get_date (this=<optimized out>, ltime=<optimized out>, fuzzydate=<optimized out>) at /test/10.5_dbg/sql/field.h:3923
      #6  0x000055cdcea6b0f2 in Field_temporal::save_in_field (this=0x14e288024b50, to=0x14e288024c28) at /test/10.5_dbg/sql/sql_basic_types.h:279
      #7  0x000055cdce8f49bf in Field::store_field (this=<optimized out>, from=<optimized out>) at /test/10.5_dbg/sql/field.h:907
      #8  0x000055cdcea7125d in field_conv_incompatible (to=to@entry=0x14e288024c28, from=from@entry=0x14e288024b50) at /test/10.5_dbg/sql/field_conv.cc:850
      #9  0x000055cdcea72859 in field_conv (to=to@entry=0x14e288024c28, from=from@entry=0x14e288024b50) at /test/10.5_dbg/sql/field_conv.cc:861
      #10 0x000055cdcea9f001 in save_field_in_field (from=0x14e288024b50, null_value=0x14e288025fde, to=0x14e288024c28, no_conversions=<optimized out>) at /test/10.5_dbg/sql/item.cc:6521
      #11 0x000055cdcea9f0e5 in Item_field::save_in_field (this=<optimized out>, to=<optimized out>, no_conversions=<optimized out>) at /test/10.5_dbg/sql/item.cc:6572
      #12 0x000055cdce8c9ea3 in TABLE::update_virtual_fields (this=0x14e28801e998, h=h@entry=0x14e288024f80, update_mode=update_mode@entry=VCOL_UPDATE_FOR_READ) at /test/10.5_dbg/sql/table.cc:8619
      #13 0x000055cdcea840ee in handler::ha_rnd_pos (this=0x14e288024f80, buf=0x14e288024b18 "\371\231\066p\243\310\021Ѐ", pos=<optimized out>) at /test/10.5_dbg/sql/handler.cc:3107
      #14 0x000055cdcec59310 in rr_from_pointers (info=0x14e2f011d620) at /test/10.5_dbg/sql/records.h:81
      #15 0x000055cdcec7704f in READ_RECORD::read_record (this=0x14e2f011d620) at /test/10.5_dbg/sql/records.h:80
      #16 mysql_delete (thd=thd@entry=0x14e288000db8, table_list=0x14e288013dc8, conds=<optimized out>, order_list=order_list@entry=0x14e288005a08, limit=4, options=<optimized out>, result=0x0) at /test/10.5_dbg/sql/sql_delete.cc:772
      #17 0x000055cdce7b6fb7 in mysql_execute_command (thd=thd@entry=0x14e288000db8) at /test/10.5_dbg/sql/sql_limit.h:67
      #18 0x000055cdce7a034f in mysql_parse (thd=thd@entry=0x14e288000db8, rawbuf=<optimized out>, length=<optimized out>, parser_state=parser_state@entry=0x14e2f011e3d0, is_com_multi=is_com_multi@entry=false, is_next_command=is_next_command@entry=false) at /test/10.5_dbg/sql/sql_parse.cc:8099
      #19 0x000055cdce7af565 in dispatch_command (command=command@entry=COM_QUERY, thd=thd@entry=0x14e288000db8, packet=packet@entry=0x14e28800b499 "DELETE FROM v1 ORDER BY v LIMIT 4", packet_length=packet_length@entry=33, is_com_multi=is_com_multi@entry=false, is_next_command=is_next_command@entry=false) at /test/10.5_dbg/sql/sql_class.h:1270
      #20 0x000055cdce7b2dea in do_command (thd=0x14e288000db8) at /test/10.5_dbg/sql/sql_parse.cc:1370
      #21 0x000055cdce90f379 in do_handle_one_connection (connect=<optimized out>, connect@entry=0x55cdd22c72d8, put_in_cache=put_in_cache@entry=true) at /test/10.5_dbg/sql/sql_connect.cc:1410
      #22 0x000055cdce90fa7d in handle_one_connection (arg=arg@entry=0x55cdd22c72d8) at /test/10.5_dbg/sql/sql_connect.cc:1312
      #23 0x000055cdcedc8885 in pfs_spawn_thread (arg=0x55cdd21fa038) at /test/10.5_dbg/storage/perfschema/pfs.cc:2201
      #24 0x000014e2f2be9609 in start_thread (arg=<optimized out>) at pthread_create.c:477
      #25 0x000014e2f27d8293 in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:95
      

      10.6.1 f8665314d4ba190679001b81bb7d9fd7a38fc0f6 (Debug)

      mysqld: /test/10.6_dbg/sql/field.cc:7112: virtual bool Field_datetimef::get_TIME(MYSQL_TIME*, const uchar*, date_mode_t) const: Assertion `marked_for_read()' failed.
      

      10.6.1 f8665314d4ba190679001b81bb7d9fd7a38fc0f6 (Debug)

      Core was generated by `/test/MD100521-mariadb-10.6.1-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 0x148e1c803700 (LWP 3944549))]
      (gdb) bt
      #0  __GI_raise (sig=sig@entry=6) at ../sysdeps/unix/sysv/linux/raise.c:50
      #1  0x0000148e1f3c1859 in __GI_abort () at abort.c:79
      #2  0x0000148e1f3c1729 in __assert_fail_base (fmt=0x148e1f557588 "%s%s%s:%u: %s%sAssertion `%s' failed.\n%n", assertion=0x55e850f406e4 "marked_for_read()", file=0x55e850f404cb "/test/10.6_dbg/sql/field.cc", line=7112, function=<optimized out>) at assert.c:92
      #3  0x0000148e1f3d2f36 in __GI___assert_fail (assertion=assertion@entry=0x55e850f406e4 "marked_for_read()", file=file@entry=0x55e850f404cb "/test/10.6_dbg/sql/field.cc", line=line@entry=7112, function=function@entry=0x55e850f42398 "virtual bool Field_datetimef::get_TIME(MYSQL_TIME*, const uchar*, date_mode_t) const") at assert.c:101
      #4  0x000055e8503b8c5d in Field_datetimef::get_TIME (this=0x148dc4025290, ltime=0x148e1c801250, pos=0x148dc4025259 "\231\066p\243\310\021Ѐ", fuzzydate={m_mode = date_mode_t::CONV_NONE}) at /test/10.6_dbg/sql/field.cc:7112
      #5  0x000055e8503d9127 in Field_datetimef::get_date (this=<optimized out>, ltime=<optimized out>, fuzzydate=<optimized out>) at /test/10.6_dbg/sql/field.h:3926
      #6  0x000055e8503d37b4 in Field_temporal::save_in_field (this=0x148dc4025290, to=0x148dc4025368) at /test/10.6_dbg/sql/sql_basic_types.h:279
      #7  0x000055e85025b203 in Field::store_field (this=<optimized out>, from=<optimized out>) at /test/10.6_dbg/sql/field.h:907
      #8  0x000055e8503d991f in field_conv_incompatible (to=to@entry=0x148dc4025368, from=from@entry=0x148dc4025290) at /test/10.6_dbg/sql/field_conv.cc:850
      #9  0x000055e8503daf1b in field_conv (to=to@entry=0x148dc4025368, from=from@entry=0x148dc4025290) at /test/10.6_dbg/sql/field_conv.cc:861
      #10 0x000055e85040603d in save_field_in_field (from=0x148dc4025290, null_value=0x148dc402672e, to=0x148dc4025368, no_conversions=<optimized out>) at /test/10.6_dbg/sql/item.cc:6525
      #11 0x000055e850406121 in Item_field::save_in_field (this=<optimized out>, to=<optimized out>, no_conversions=<optimized out>) at /test/10.6_dbg/sql/item.cc:6576
      #12 0x000055e850230743 in TABLE::update_virtual_fields (this=0x148dc401f008, h=h@entry=0x148dc40256c0, update_mode=update_mode@entry=VCOL_UPDATE_FOR_READ) at /test/10.6_dbg/sql/table.cc:8707
      #13 0x000055e8503ec610 in handler::ha_rnd_pos (this=0x148dc40256c0, buf=0x148dc4025258 "\371\231\066p\243\310\021Ѐ", pos=<optimized out>) at /test/10.6_dbg/sql/handler.cc:3109
      #14 0x000055e8505be8fa in rr_from_pointers (info=0x148e1c8016a0) at /test/10.6_dbg/sql/records.h:82
      #15 0x000055e8505dc6af in READ_RECORD::read_record (this=0x148e1c8016a0) at /test/10.6_dbg/sql/records.h:81
      #16 mysql_delete (thd=thd@entry=0x148dc4000db8, table_list=0x148dc40140c8, conds=<optimized out>, order_list=order_list@entry=0x148dc4005bd8, limit=4, options=<optimized out>, result=0x0) at /test/10.6_dbg/sql/sql_delete.cc:782
      #17 0x000055e85011e398 in mysql_execute_command (thd=thd@entry=0x148dc4000db8) at /test/10.6_dbg/sql/sql_limit.h:83
      #18 0x000055e85010802b in mysql_parse (thd=thd@entry=0x148dc4000db8, rawbuf=<optimized out>, length=<optimized out>, parser_state=parser_state@entry=0x148e1c802410) at /test/10.6_dbg/sql/sql_parse.cc:8018
      #19 0x000055e850116e5d in dispatch_command (command=command@entry=COM_QUERY, thd=thd@entry=0x148dc4000db8, packet=packet@entry=0x148dc400b799 "DELETE FROM v1 ORDER BY v LIMIT 4", packet_length=packet_length@entry=33, blocking=blocking@entry=true) at /test/10.6_dbg/sql/sql_class.h:1333
      #20 0x000055e85011a250 in do_command (thd=0x148dc4000db8, blocking=blocking@entry=true) at /test/10.6_dbg/sql/sql_parse.cc:1406
      #21 0x000055e850274dec in do_handle_one_connection (connect=<optimized out>, connect@entry=0x55e8542da9b8, put_in_cache=put_in_cache@entry=true) at /test/10.6_dbg/sql/sql_connect.cc:1410
      #22 0x000055e8502753f1 in handle_one_connection (arg=arg@entry=0x55e8542da9b8) at /test/10.6_dbg/sql/sql_connect.cc:1312
      #23 0x000055e850727cee in pfs_spawn_thread (arg=0x55e8541c42a8) at /test/10.6_dbg/storage/perfschema/pfs.cc:2201
      #24 0x0000148e1f8cf609 in start_thread (arg=<optimized out>) at pthread_create.c:477
      #25 0x0000148e1f4be293 in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:95
      

      Reproducible with at least MyISAM and InnoDB.
      Not reproducible on 10.3.
      No visible effect on a non-debug build.

      Test case 2, from MDEV-18167, only fails on 10.4-10.6

      CREATE TABLE t1 ( 
        id INT NOT NULL AUTO_INCREMENT,
        f ENUM('a','b','c'),
        v ENUM('a','b','c') AS (f),
        KEY(v,id)
      ) ENGINE=MyISAM;
      INSERT INTO t1 (f) VALUES ('a'),('b');
      INSERT IGNORE INTO t1 SELECT * FROM t1;
       
      # Cleanup
      DROP TABLE t1;
      

      10.4 30da40bb8c

      mysqld: /data/src/10.4/sql/field.cc:9118: virtual longlong Field_enum::val_int(): Assertion `!table || (!table->read_set || bitmap_is_set(table->read_set, field_index) || (!(ptr >= table->record[0] && ptr < table->record[0] + table->s->reclength)))' failed.
      190108 15:32:35 [ERROR] mysqld got signal 6 ;
       
      #7  0x00007f37f7c0eee2 in __assert_fail () from /lib/x86_64-linux-gnu/libc.so.6
      #8  0x000055fa5f90e33c in Field_enum::val_int (this=0x7f37e000aab0) at /data/src/10.4/sql/field.cc:9118
      #9  0x000055fa5f91bf77 in Field_enum::store_field (this=0x7f37e000aba8, from=0x7f37e000aab0) at /data/src/10.4/sql/field.h:4146
      #10 0x000055fa5f920816 in field_conv_incompatible (to=0x7f37e000aba8, from=0x7f37e000aab0) at /data/src/10.4/sql/field_conv.cc:851
      #11 0x000055fa5f920872 in field_conv (to=0x7f37e000aba8, from=0x7f37e000aab0) at /data/src/10.4/sql/field_conv.cc:864
      #12 0x000055fa5f9544e3 in save_field_in_field (from=0x7f37e000aab0, null_value=0x7f37e0123ff6, to=0x7f37e000aba8, no_conversions=false) at /data/src/10.4/sql/item.cc:6352
      #13 0x000055fa5f954724 in Item_field::save_in_field (this=0x7f37e0123f80, to=0x7f37e000aba8, no_conversions=false) at /data/src/10.4/sql/item.cc:6403
      #14 0x000055fa5f73c23c in TABLE::update_virtual_fields (this=0x7f37e0122ac0, h=0x7f37e01236f8, update_mode=VCOL_UPDATE_FOR_WRITE) at /data/src/10.4/sql/table.cc:7798
      #15 0x000055fa5f5913ce in fill_record (thd=0x7f37e0000b00, table_arg=0x7f37e0122ac0, fields=..., values=..., ignore_errors=false, update=false) at /data/src/10.4/sql/sql_base.cc:8431
      #16 0x000055fa5f59188a in fill_record_n_invoke_before_triggers (thd=0x7f37e0000b00, table=0x7f37e0122ac0, fields=..., values=..., ignore_errors=false, event=TRG_EVENT_INSERT) at /data/src/10.4/sql/sql_base.cc:8562
      #17 0x000055fa5f5d5b4f in mysql_insert (thd=0x7f37e0000b00, table_list=0x7f37e0015090, fields=..., values_list=..., update_fields=..., update_values=..., duplic=DUP_ERROR, ignore=false) at /data/src/10.4/sql/sql_insert.cc:960
      #18 0x000055fa5f61c639 in mysql_execute_command (thd=0x7f37e0000b00) at /data/src/10.4/sql/sql_parse.cc:4730
      #19 0x000055fa5f6272c4 in mysql_parse (thd=0x7f37e0000b00, rawbuf=0x7f37e0014f98 "INSERT INTO t1 (f) VALUES ('a'),('b')", length=37, parser_state=0x7f37f1da0600, is_com_multi=false, is_next_command=false) at /data/src/10.4/sql/sql_parse.cc:8104
      #20 0x000055fa5f6144ee in dispatch_command (command=COM_QUERY, thd=0x7f37e0000b00, packet=0x7f37e000b421 "INSERT INTO t1 (f) VALUES ('a'),('b')", packet_length=37, is_com_multi=false, is_next_command=false) at /data/src/10.4/sql/sql_parse.cc:1851
      #21 0x000055fa5f612f12 in do_command (thd=0x7f37e0000b00) at /data/src/10.4/sql/sql_parse.cc:1396
      #22 0x000055fa5f77f140 in do_handle_one_connection (connect=0x55fa622bd320) at /data/src/10.4/sql/sql_connect.cc:1402
      #23 0x000055fa5f77eec4 in handle_one_connection (arg=0x55fa622bd320) at /data/src/10.4/sql/sql_connect.cc:1308
      #24 0x000055fa5fc3e308 in pfs_spawn_thread (arg=0x55fa621ce140) at /data/src/10.4/storage/perfschema/pfs.cc:1862
      #25 0x00007f37f96ca494 in start_thread (arg=0x7f37f1da1700) at pthread_create.c:333
      #26 0x00007f37f7ccb93f in clone () from /lib/x86_64-linux-gnu/libc.so.6
      

      Not reproducible with InnoDB (the test case is not applicable due to the order of columns in the key).
      Not reproducible on 10.3.
      No visible effect on a non-debug build.

      Test case 3, fails on 10.2, 10.3, 10.5 and 10.6 but not 10.4

      --source include/have_partition.inc
       
      CREATE TABLE t1 ( 
          a INT,
          b INT,
          c BIT(4) NOT NULL DEFAULT b'0',
          pk INTEGER AUTO_INCREMENT,
          d BIT(4) AS (c) VIRTUAL,
          PRIMARY KEY(pk),
          KEY (b,d)
      ) PARTITION BY HASH(pk);
      INSERT INTO t1 () VALUES (),();
      UPDATE t1 SET a = 0 WHERE b IS NULL ORDER BY pk;
       
      # Cleanup
      DROP TABLE t1;
      

      10.2 b8b74e14

      mysqld: /data/src/10.2/sql/field.cc:9532: virtual longlong Field_bit::val_int(): Assertion `!table || (!table->read_set || bitmap_is_set(table->read_set, field_index) || (!(ptr >= table->record[0] && ptr < table->record[0] + table->s->reclength)))' failed.
      190530  3:55:17 [ERROR] mysqld got signal 6 ;
       
      #7  0x00007fc44db56f12 in __GI___assert_fail (assertion=0x55a3e60f7e78 "!table || (!table->read_set || bitmap_is_set(table->read_set, field_index) || (!(ptr >= table->record[0] && ptr < table->record[0] + table->s->reclength)))", file=0x55a3e60f7c18 "/data/src/10.2/sql/field.cc", line=9532, function=0x55a3e60fc3e0 <Field_bit::val_int()::__PRETTY_FUNCTION__> "virtual longlong Field_bit::val_int()") at assert.c:101
      #8  0x000055a3e580fe0c in Field_bit::val_int (this=0x7fc42c0312a0) at /data/src/10.2/sql/field.cc:9532
      #9  0x000055a3e5818bea in Field_bit::save_in_field (this=0x7fc42c0312a0, to=0x7fc42c091d88) at /data/src/10.2/sql/field.h:3746
      #10 0x000055a3e562f89a in Field::store_field (this=0x7fc42c091d88, from=0x7fc42c0312a0) at /data/src/10.2/sql/field.h:829
      #11 0x000055a3e581ca31 in field_conv_incompatible (to=0x7fc42c091d88, from=0x7fc42c0312a0) at /data/src/10.2/sql/field_conv.cc:831
      #12 0x000055a3e581ca8d in field_conv (to=0x7fc42c091d88, from=0x7fc42c0312a0) at /data/src/10.2/sql/field_conv.cc:842
      #13 0x000055a3e5849f12 in save_field_in_field (from=0x7fc42c0312a0, null_value=0x7fc42c06b85a, to=0x7fc42c091d88, no_conversions=false) at /data/src/10.2/sql/item.cc:6274
      #14 0x000055a3e584a11a in Item_field::save_in_field (this=0x7fc42c06b7e8, to=0x7fc42c091d88, no_conversions=false) at /data/src/10.2/sql/item.cc:6320
      #15 0x000055a3e56baff6 in TABLE::update_virtual_fields (this=0x7fc42c069e50, h=0x7fc42c06aa58, update_mode=VCOL_UPDATE_FOR_READ) at /data/src/10.2/sql/table.cc:7642
      #16 0x000055a3e582b0d4 in handler::ha_index_read_map (this=0x7fc42c06aa58, buf=0x7fc42c0310b0 "\a\360", key=0x7fc42c081258 "\001", keypart_map=1, find_flag=HA_READ_KEY_EXACT) at /data/src/10.2/sql/handler.cc:2684
      #17 0x000055a3e5831c00 in handler::read_range_first (this=0x7fc42c06aa58, start_key=0x7fc42c00c6e0, end_key=0x7fc42c00c2c0, eq_range_arg=true, sorted=false) at /data/src/10.2/sql/handler.cc:5424
      #18 0x000055a3e5f461b6 in ha_partition::handle_unordered_scan_next_partition (this=0x7fc42c00c188, buf=0x7fc42c0310b0 "\a\360") at /data/src/10.2/sql/ha_partition.cc:6037
      #19 0x000055a3e5f451e4 in ha_partition::common_index_read (this=0x7fc42c00c188, buf=0x7fc42c0310b0 "\a\360", have_start_key=true) at /data/src/10.2/sql/ha_partition.cc:5519
      #20 0x000055a3e5f45a7c in ha_partition::read_range_first (this=0x7fc42c00c188, start_key=0x7fc42c00c270, end_key=0x7fc42c00c290, eq_range_arg=true, sorted=true) at /data/src/10.2/sql/ha_partition.cc:5810
      #21 0x000055a3e5742c50 in handler::multi_range_read_next (this=0x7fc42c00c188, range_info=0x7fc448689ac0) at /data/src/10.2/sql/multi_range_read.cc:298
      #22 0x000055a3e598280c in QUICK_RANGE_SELECT::get_next (this=0x7fc42c080ff0) at /data/src/10.2/sql/opt_range.cc:11452
      #23 0x000055a3e581f4a0 in find_all_keys (thd=0x7fc42c000b00, param=0x7fc448689d80, select=0x7fc42c013328, fs_info=0x7fc42c07ff90, buffpek_pointers=0x7fc448689f80, tempfile=0x7fc448689e10, pq=0x0, found_rows=0x7fc42c080170) at /data/src/10.2/sql/filesort.cc:781
      #24 0x000055a3e581db22 in filesort (thd=0x7fc42c000b00, table=0x7fc42c069e50, filesort=0x7fc44868a250, tracker=0x7fc42c013790, join=0x0, first_table_bit=0) at /data/src/10.2/sql/filesort.cc:274
      #25 0x000055a3e5697f7b in mysql_update (thd=0x7fc42c000b00, table_list=0x7fc42c012560, fields=..., values=..., conds=0x7fc42c012e50, order_num=1, order=0x7fc42c013018, limit=18446744073709551615, handle_duplicates=DUP_ERROR, ignore=false, found_return=0x7fc44868a870, updated_return=0x7fc44868a920) at /data/src/10.2/sql/sql_update.cc:562
      #26 0x000055a3e55abe78 in mysql_execute_command (thd=0x7fc42c000b00) at /data/src/10.2/sql/sql_parse.cc:4290
      #27 0x000055a3e55b7cba in mysql_parse (thd=0x7fc42c000b00, rawbuf=0x7fc42c012458 "UPDATE t1 SET a = 0 WHERE b IS NULL ORDER BY pk", length=47, parser_state=0x7fc44868b200, is_com_multi=false, is_next_command=false) at /data/src/10.2/sql/sql_parse.cc:8020
      #28 0x000055a3e55a550e in dispatch_command (command=COM_QUERY, thd=0x7fc42c000b00, packet=0x7fc42c08d531 "UPDATE t1 SET a = 0 WHERE b IS NULL ORDER BY pk", packet_length=47, is_com_multi=false, is_next_command=false) at /data/src/10.2/sql/sql_parse.cc:1833
      #29 0x000055a3e55a3e62 in do_command (thd=0x7fc42c000b00) at /data/src/10.2/sql/sql_parse.cc:1386
      #30 0x000055a3e56f6b38 in do_handle_one_connection (connect=0x55a3e7efc700) at /data/src/10.2/sql/sql_connect.cc:1335
      #31 0x000055a3e56f68b8 in handle_one_connection (arg=0x55a3e7efc700) at /data/src/10.2/sql/sql_connect.cc:1241
      #32 0x000055a3e5f23032 in pfs_spawn_thread (arg=0x55a3e7f1f9b0) at /data/src/10.2/storage/perfschema/pfs.cc:1862
      #33 0x00007fc44f6cb4a4 in start_thread (arg=0x7fc44868c700) at pthread_create.c:456
      #34 0x00007fc44dc13d0f in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:97
      

      10.3.29 4d412e9854ccb3676a9a51a002fbcc6b44a26294 (Debug)

      mysqld: /test/10.3_dbg/sql/field.cc:9902: virtual longlong Field_bit::val_int(): Assertion `!table || (!table->read_set || bitmap_is_set(table->read_set, field_index) || (!(ptr >= table->record[0] && ptr < table->record[0] + table->s->reclength)))' failed.
      

      10.3.29 4d412e9854ccb3676a9a51a002fbcc6b44a26294 (Debug)

      Core was generated by `/test/MD270421-mariadb-10.3.29-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 0x14c5ac057700 (LWP 1263192))]
      (gdb) bt
      #0  __GI_raise (sig=sig@entry=6) at ../sysdeps/unix/sysv/linux/raise.c:50
      #1  0x000014c5aff9f859 in __GI_abort () at abort.c:79
      #2  0x000014c5aff9f729 in __assert_fail_base (fmt=0x14c5b0135588 "%s%s%s:%u: %s%sAssertion `%s' failed.\n%n", assertion=0x55959a861788 "!table || (!table->read_set || bitmap_is_set(table->read_set, field_index) || (!(ptr >= table->record[0] && ptr < table->record[0] + table->s->reclength)))", file=0x55959a860837 "/test/10.3_dbg/sql/field.cc", line=9902, function=<optimized out>) at assert.c:92
      #3  0x000014c5affb0f36 in __GI___assert_fail (assertion=assertion@entry=0x55959a861788 "!table || (!table->read_set || bitmap_is_set(table->read_set, field_index) || (!(ptr >= table->record[0] && ptr < table->record[0] + table->s->reclength)))", file=file@entry=0x55959a860837 "/test/10.3_dbg/sql/field.cc", line=line@entry=9902, function=function@entry=0x55959a862418 "virtual longlong Field_bit::val_int()") at assert.c:101
      #4  0x0000559599dea051 in Field_bit::val_int (this=0x14c54400c860) at /test/10.3_dbg/sql/field.cc:9902
      #5  0x0000559599e07d4e in Field_bit::save_in_field (this=<optimized out>, to=0x14c544029b80) at /test/10.3_dbg/sql/field.h:4146
      #6  0x0000559599e0636d in Field::store_field (this=<optimized out>, from=<optimized out>) at /test/10.3_dbg/sql/field.h:791
      #7  0x0000559599e0bd8f in field_conv_incompatible (to=to@entry=0x14c544029b80, from=from@entry=0x14c54400c860) at /test/10.3_dbg/sql/field_conv.cc:836
      #8  0x0000559599e0d2d8 in field_conv (to=to@entry=0x14c544029b80, from=from@entry=0x14c54400c860) at /test/10.3_dbg/sql/field_conv.cc:847
      #9  0x0000559599e314cb in save_field_in_field (from=0x14c54400c860, null_value=0x14c54402b036, to=0x14c544029b80, no_conversions=<optimized out>) at /test/10.3_dbg/sql/item.cc:6742
      #10 0x0000559599e315af in Item_field::save_in_field (this=<optimized out>, to=<optimized out>, no_conversions=<optimized out>) at /test/10.3_dbg/sql/item.cc:6793
      #11 0x0000559599c810c6 in TABLE::update_virtual_fields (this=0x14c544020440, h=h@entry=0x14c5440218d8, update_mode=update_mode@entry=VCOL_UPDATE_FOR_READ) at /test/10.3_dbg/sql/table.cc:7978
      #12 0x0000559599e1bae2 in handler::ha_index_read_map (this=this@entry=0x14c5440218d8, buf=0x14c54400c660 <incomplete sequence \367>, key=0x14c544006f00 "\001", keypart_map=<optimized out>, find_flag=<optimized out>) at /test/10.3_dbg/sql/handler.cc:2913
      #13 0x0000559599e23233 in handler::read_range_first (this=0x14c5440218d8, start_key=0x14c5440219c8, end_key=0x14c5440219e8, eq_range_arg=<optimized out>, sorted=<optimized out>) at /test/10.3_dbg/sql/handler.cc:5844
      #14 0x0000559599cfde5e in handler::multi_range_read_next (this=0x14c5440218d8, range_info=range_info@entry=0x14c544025860) at /test/10.3_dbg/sql/multi_range_read.cc:299
      #15 0x0000559599cfdef0 in Mrr_simple_index_reader::get_next (this=0x14c544021e68, range_info=0x14c544025860) at /test/10.3_dbg/sql/multi_range_read.cc:336
      #16 0x0000559599cffc64 in DsMrr_impl::dsmrr_next (this=0x14c544021d28, range_info=0x14c544025860) at /test/10.3_dbg/sql/multi_range_read.cc:1406
      #17 0x000055959a030fe4 in ha_innobase::multi_range_read_next (this=<optimized out>, range_info=<optimized out>) at /test/10.3_dbg/storage/innobase/handler/ha_innodb.cc:20735
      #18 0x000055959a5f38ba in ha_partition::handle_ordered_index_scan (this=this@entry=0x14c544021088, buf=0x14c54400c660 <incomplete sequence \367>, reverse_order=reverse_order@entry=false) at /test/10.3_dbg/sql/ha_partition.cc:7575
      #19 0x000055959a5f5719 in ha_partition::multi_range_read_next (this=0x14c544021088, range_info=0x14c5ac053ee8) at /test/10.3_dbg/sql/ha_partition.cc:6517
      #20 0x0000559599f8e898 in QUICK_RANGE_SELECT::get_next (this=0x14c544031350) at /test/10.3_dbg/sql/opt_range.cc:11552
      #21 0x0000559599e11fe2 in find_all_keys (found_rows=0x14c5440301e0, pq=0x0, tempfile=0x14c5ac054130, buffpek_pointers=0x14c5ac0542a0, fs_info=0x14c544030000, select=0x14c5440124b0, param=0x14c5ac0540a0, thd=0x14c544000d90) at /test/10.3_dbg/sql/filesort.cc:780
      #22 filesort (thd=thd@entry=0x14c544000d90, table=table@entry=0x14c544020440, filesort=filesort@entry=0x14c5ac054950, tracker=0x14c544012918, join=join@entry=0x0, first_table_bit=first_table_bit@entry=0) at /test/10.3_dbg/sql/filesort.cc:269
      #23 0x0000559599c643f6 in mysql_update (thd=thd@entry=0x14c544000d90, table_list=<optimized out>, fields=@0x14c544005508: {<base_list> = {<Sql_alloc> = {<No data fields>}, first = 0x14c544011e98, last = 0x14c544011e98, elements = 1}, <No data fields>}, values=@0x14c544005a38: {<base_list> = {<Sql_alloc> = {<No data fields>}, first = 0x14c544011ea8, last = 0x14c544011ea8, elements = 1}, <No data fields>}, conds=<optimized out>, order_num=<optimized out>, order=0x14c5440121a8, limit=18446744073709551615, ignore=false, found_return=0x14c5ac054db0, updated_return=0x14c5ac054e70) at /test/10.3_dbg/sql/sql_update.cc:691
      #24 0x0000559599b86af8 in mysql_execute_command (thd=thd@entry=0x14c544000d90) at /test/10.3_dbg/sql/sql_parse.cc:4346
      #25 0x0000559599b8e3ec in mysql_parse (thd=thd@entry=0x14c544000d90, rawbuf=<optimized out>, length=<optimized out>, parser_state=parser_state@entry=0x14c5ac056540, is_com_multi=is_com_multi@entry=false, is_next_command=is_next_command@entry=false) at /test/10.3_dbg/sql/sql_parse.cc:7873
      #26 0x0000559599b90b5d in dispatch_command (command=command@entry=COM_QUERY, thd=thd@entry=0x14c544000d90, packet=packet@entry=0x14c5440198f1 "UPDATE t1 SET a = 0 WHERE b IS NULL ORDER BY pk", packet_length=packet_length@entry=47, is_com_multi=is_com_multi@entry=false, is_next_command=is_next_command@entry=false) at /test/10.3_dbg/sql/sql_class.h:1152
      #27 0x0000559599b93cfd in do_command (thd=0x14c544000d90) at /test/10.3_dbg/sql/sql_parse.cc:1398
      #28 0x0000559599cbab11 in do_handle_one_connection (connect=connect@entry=0x55959c745490) at /test/10.3_dbg/sql/sql_connect.cc:1403
      #29 0x0000559599cbad48 in handle_one_connection (arg=0x55959c745490) at /test/10.3_dbg/sql/sql_connect.cc:1308
      #30 0x000014c5b0175609 in start_thread (arg=<optimized out>) at pthread_create.c:477
      #31 0x000014c5b009c293 in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:95
      

      10.6.1 f8665314d4ba190679001b81bb7d9fd7a38fc0f6 (Debug)

      mysqld: /test/10.6_dbg/sql/field.cc:9848: virtual longlong Field_bit::val_int(): Assertion `marked_for_read()' failed.
      

      10.6.1 f8665314d4ba190679001b81bb7d9fd7a38fc0f6 (Debug)

      Core was generated by `/test/MD100521-mariadb-10.6.1-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 0x1497c80a0700 (LWP 990566))]
      (gdb) bt
      #0  __GI_raise (sig=sig@entry=6) at ../sysdeps/unix/sysv/linux/raise.c:50
      #1  0x00001497d1304859 in __GI_abort () at abort.c:79
      #2  0x00001497d1304729 in __assert_fail_base (fmt=0x1497d149a588 "%s%s%s:%u: %s%sAssertion `%s' failed.\n%n", assertion=0x55999db326e4 "marked_for_read()", file=0x55999db324cb "/test/10.6_dbg/sql/field.cc", line=9848, function=<optimized out>) at assert.c:92
      #3  0x00001497d1315f36 in __GI___assert_fail (assertion=assertion@entry=0x55999db326e4 "marked_for_read()", file=file@entry=0x55999db324cb "/test/10.6_dbg/sql/field.cc", line=line@entry=9848, function=function@entry=0x55999db344a8 "virtual longlong Field_bit::val_int()") at assert.c:101
      #4  0x000055999cfab08d in Field_bit::val_int (this=0x14977c022d48) at /test/10.6_dbg/sql/field.cc:9848
      #5  0x000055999ce4e247 in Field_bit::save_in_field (this=<optimized out>, to=0x14977c029df8) at /test/10.6_dbg/sql/field.h:4899
      #6  0x000055999ce4d203 in Field::store_field (this=<optimized out>, from=<optimized out>) at /test/10.6_dbg/sql/field.h:907
      #7  0x000055999cfcb91f in field_conv_incompatible (to=to@entry=0x14977c029df8, from=from@entry=0x14977c022d48) at /test/10.6_dbg/sql/field_conv.cc:850
      #8  0x000055999cfccf1b in field_conv (to=to@entry=0x14977c029df8, from=from@entry=0x14977c022d48) at /test/10.6_dbg/sql/field_conv.cc:861
      #9  0x000055999cff803d in save_field_in_field (from=0x14977c022d48, null_value=0x14977c02aa5e, to=0x14977c029df8, no_conversions=<optimized out>) at /test/10.6_dbg/sql/item.cc:6525
      #10 0x000055999cff8121 in Item_field::save_in_field (this=<optimized out>, to=<optimized out>, no_conversions=<optimized out>) at /test/10.6_dbg/sql/item.cc:6576
      #11 0x000055999ce22743 in TABLE::update_virtual_fields (this=0x14977c01e088, h=h@entry=0x14977c0294c0, update_mode=update_mode@entry=VCOL_UPDATE_FOR_READ) at /test/10.6_dbg/sql/table.cc:8707
      #12 0x000055999cfdeb05 in handler::ha_index_read_map (this=this@entry=0x14977c0294c0, buf=0x14977c022af8 <incomplete sequence \367>, key=<optimized out>, keypart_map=<optimized out>, find_flag=<optimized out>) at /test/10.6_dbg/sql/handler.cc:3132
      #13 0x000055999cfe6c1e in handler::read_range_first (this=0x14977c0294c0, start_key=0x14977c0295c0, end_key=0x14977c0295e0, eq_range_arg=<optimized out>, sorted=<optimized out>) at /test/10.6_dbg/sql/handler.cc:6208
      #14 0x000055999ceb3efc in handler::multi_range_read_next (this=0x14977c0294c0, range_info=range_info@entry=0x14977c02c408) at /test/10.6_dbg/sql/multi_range_read.cc:516
      #15 0x000055999ceb3f8e in Mrr_simple_index_reader::get_next (this=0x14977c029ae8, range_info=0x14977c02c408) at /test/10.6_dbg/sql/multi_range_read.cc:553
      #16 0x000055999ceb5db0 in DsMrr_impl::dsmrr_next (this=0x14977c029998, range_info=0x14977c02c408) at /test/10.6_dbg/sql/multi_range_read.cc:1653
      #17 0x000055999d3bdab0 in ha_innobase::multi_range_read_next (this=<optimized out>, range_info=<optimized out>) at /test/10.6_dbg/storage/innobase/handler/ha_innodb.cc:19482
      #18 0x000055999d30884f in ha_partition::handle_ordered_index_scan (this=this@entry=0x14977c028bd0, buf=0x14977c022af8 <incomplete sequence \367>, reverse_order=reverse_order@entry=false) at /test/10.6_dbg/sql/ha_partition.cc:7717
      #19 0x000055999d30a6c7 in ha_partition::multi_range_read_next (this=0x14977c028bd0, range_info=0x1497c809dff8) at /test/10.6_dbg/sql/ha_partition.cc:6665
      #20 0x000055999d182574 in QUICK_RANGE_SELECT::get_next (this=0x14977c076810) at /test/10.6_dbg/sql/opt_range.cc:12647
      #21 0x000055999cfd3e1a in find_all_keys (found_rows=0x14977c075820, pq=0x0, tempfile=0x1497c809e250, buffpek_pointers=0x1497c809e3c0, fs_info=0x14977c075630, select=0x14977c015068, param=0x1497c809e190, thd=0x14977c000db8) at /test/10.6_dbg/sql/filesort.cc:898
      #22 filesort (thd=thd@entry=0x14977c000db8, table=table@entry=0x14977c01e088, filesort=filesort@entry=0x1497c809eab0, tracker=0x14977c0154f8, join=join@entry=0x0, first_table_bit=first_table_bit@entry=0) at /test/10.6_dbg/sql/filesort.cc:355
      #23 0x000055999ce09a22 in mysql_update (thd=thd@entry=0x14977c000db8, table_list=<optimized out>, fields=@0x14977c005a88: {<base_list> = {<Sql_alloc> = {<No data fields>}, first = 0x14977c0149b8, last = 0x14977c0149b8, elements = 1}, <No data fields>}, values=@0x14977c006020: {<base_list> = {<Sql_alloc> = {<No data fields>}, first = 0x14977c0149c8, last = 0x14977c0149c8, elements = 1}, <No data fields>}, conds=<optimized out>, order_num=<optimized out>, order=0x14977c014d50, limit=18446744073709551615, ignore=false, found_return=0x1497c809ef10, updated_return=0x1497c809f000) at /test/10.6_dbg/sql/sql_update.cc:794
      #24 0x000055999cd0f2b7 in mysql_execute_command (thd=thd@entry=0x14977c000db8) at /test/10.6_dbg/sql/sql_limit.h:83
      #25 0x000055999ccfa02b in mysql_parse (thd=thd@entry=0x14977c000db8, rawbuf=<optimized out>, length=<optimized out>, parser_state=parser_state@entry=0x1497c809f410) at /test/10.6_dbg/sql/sql_parse.cc:8018
      #26 0x000055999cd08e5d in dispatch_command (command=command@entry=COM_QUERY, thd=thd@entry=0x14977c000db8, packet=packet@entry=0x14977c00b799 "UPDATE t1 SET a = 0 WHERE b IS NULL ORDER BY pk", packet_length=packet_length@entry=47, blocking=blocking@entry=true) at /test/10.6_dbg/sql/sql_class.h:1333
      #27 0x000055999cd0c250 in do_command (thd=0x14977c000db8, blocking=blocking@entry=true) at /test/10.6_dbg/sql/sql_parse.cc:1406
      #28 0x000055999ce66dec in do_handle_one_connection (connect=<optimized out>, connect@entry=0x5599a107c9d8, put_in_cache=put_in_cache@entry=true) at /test/10.6_dbg/sql/sql_connect.cc:1410
      #29 0x000055999ce673f1 in handle_one_connection (arg=arg@entry=0x5599a107c9d8) at /test/10.6_dbg/sql/sql_connect.cc:1312
      #30 0x000055999d319cee in pfs_spawn_thread (arg=0x5599a0f662c8) at /test/10.6_dbg/storage/perfschema/pfs.cc:2201
      #31 0x00001497d1812609 in start_thread (arg=<optimized out>) at pthread_create.c:477
      #32 0x00001497d1401293 in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:95
      

      10.4.19 9e6310e323a3abd411f852ff57fe41c9f149ff3a (Debug)

      10.4.19-dbg>CREATE TABLE t1 (a INT, b INT, c BIT(4) NOT NULL DEFAULT b'0', pk INTEGER AUTO_INCREMENT, d BIT(4) AS (c) VIRTUAL, PRIMARY KEY(pk), KEY (b,d)) PARTITION BY HASH(pk);
      Query OK, 0 rows affected (0.027 sec)
      10.4.19-dbg>INSERT INTO t1 () VALUES (),();
      Query OK, 2 rows affected (0.010 sec)
      Records: 2  Duplicates: 0  Warnings: 0
      10.4.19-dbg>UPDATE t1 SET a = 0 WHERE b IS NULL ORDER BY pk;
      Query OK, 2 rows affected (0.008 sec)
      Rows matched: 2  Changed: 2  Warnings: 0
      10.4.19-dbg>
      

      Not applicable to 10.1. Fails with at least MyISAM and InnoDB.
      No obvious problem on a non-debug build.

        Attachments

          Issue Links

            Activity

              People

              Assignee:
              nikitamalyavin Nikita Malyavin
              Reporter:
              elenst Elena Stepanova
              Votes:
              0 Vote for this issue
              Watchers:
              6 Start watching this issue

                Dates

                Created:
                Updated:
                Resolved:

                  Git Integration