Details
-
Bug
-
Status: Closed (View Workflow)
-
Major
-
Resolution: Duplicate
-
10.3.10
-
None
-
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
- duplicates
-
MDEV-16039 Crash when selecting virtual columns generated using functions with DAYNAME()
- Closed