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

replace into generated columns is unstable

    XMLWordPrintable

    Details

    • Type: Bug
    • Status: Closed (View Workflow)
    • Priority: Major
    • Resolution: Duplicate
    • Affects Version/s: 10.3.10
    • Fix Version/s: N/A
    • Component/s: Virtual Columns
    • Labels:
      None
    • Environment:
      Win64

      Description

      Version: '10.3.10-MariaDB'  socket: ''  port: 3306  mariadb.org binary distribution
      [ERROR] mysqld got exception 0xc0000005 ;
      terribly wrong...
      mysqld.exe!Field::load_data_set_null()[field.cc:1297]
      mysqld.exe!Item_func::print_args()[item_func.cc:611]
      mysqld.exe!Item_func::print()[item_func.cc:601]
      mysqld.exe!Item::print_parenthesised()[item.cc:585]
      mysqld.exe!Item_func::print_op()[item_func.cc:621]
      mysqld.exe!Item::print_parenthesised()[item.cc:585]
      mysqld.exe!fix_vcol_expr()[table.cc:2868]
      mysqld.exe!fix_all_session_vcol_exprs()[sql_base.cc:5177]
      mysqld.exe!lock_tables()[sql_base.cc:5361]
      mysqld.exe!open_and_lock_tables()[sql_base.cc:5004]
      mysqld.exe!mysql_insert()[sql_insert.cc:760]
      mysqld.exe!mysql_execute_command()[sql_parse.cc:4725]
      mysqld.exe!mysql_parse()[sql_parse.cc:8096]
      mysqld.exe!dispatch_command()[sql_parse.cc:1852]
      mysqld.exe!do_command()[sql_parse.cc:1394]
      mysqld.exe!threadpool_process_request()[threadpool_common.cc:358]
      mysqld.exe!tp_callback()[threadpool_common.cc:186]
      

      How to Repeat (non-simplified test)

      set sql_mode='';
      drop table if exists t;
      create table t (
        `c0000` timestamp not null default current_timestamp() on update current_timestamp(),
        `c0001` decimal(27,25) generated always as (dayofmonth(( @@global.secure_file_priv))) virtual,
        `c0002` datetime(1) not null,
        `c0003` date not null,
        `c0004` time not null,
        `c0005` date not null,
        `c0006` smallint(6) not null,
        `c0007` timestamp generated always as (-2147483649) virtual,
        `c0008` smallint(6) generated always as (concat_ws(convert(`c0001` using cp932),get_format(datetime, 'iso'),( @@global.flush_time)) <> (`c0004` = 1)) virtual,
        `c0009` double not null,
        primary key (`c0004`),
        unique key `i0002` (`c0007`),
        key `i0001` (`c0003`) using btree,
        key `i0003` (`c0003`)
      ) engine=innodb default charset=latin1 row_format=compressed key_block_size=2;
       
      replace into t set `c0000` = '2018-06-03 10:31:43',`c0002` = '2019-08-07 10:54:42',`c0003` = '2019-10-15',`c0004` = '02:58:55',`c0005` = '2018-04-28',`c0006` = 0,`c0009` = 4294967294;
      replace into t set `c0000` = '2018-06-03 10:31:43',`c0002` = '2019-08-07 10:54:42',`c0003` = '2019-10-15',`c0004` = '02:58:55',`c0005` = '2018-04-28',`c0006` = 0,`c0009` = 4294967294;
      replace into t set `c0000` = '2018-06-03 10:31:43',`c0002` = '2019-08-07 10:54:42',`c0003` = '2019-10-15',`c0004` = '02:58:55',`c0005` = '2018-04-28',`c0006` = 0,`c0009` = 4294967294;
      

        Attachments

          Issue Links

            Activity

              People

              Assignee:
              Unassigned Unassigned
              Reporter:
              sbester1 sbester1
              Votes:
              1 Vote for this issue
              Watchers:
              5 Start watching this issue

                Dates

                Created:
                Updated:
                Resolved:

                  Git Integration