[MDEV-16048] crashing with virtual columns Created: 2018-04-27  Updated: 2019-09-12  Resolved: 2019-09-09

Status: Closed
Project: MariaDB Server
Component/s: Virtual Columns
Affects Version/s: 10.3.6, 10.2, 10.3
Fix Version/s: N/A

Type: Bug Priority: Major
Reporter: sbester1 Assignee: Nikita Malyavin
Resolution: Duplicate Votes: 0
Labels: None
Environment:

Win x64


Issue Links:
Duplicate
duplicates MDEV-19249 Slave MariaDB 10.2.23 crashing when r... Closed

 Description   

Version: '*10.3.6-MariaDB*'  socket: ''  port: 3306  mariadb.org binary distribution
180427 18:20:05 [ERROR] mysqld got exception 0xc0000005 ;
mysqld.exe!Item_func_or_sum::walk()[item.h:4617]
mysqld.exe!fix_session_vcol_expr()[table.cc:2879]
mysqld.exe!fix_all_session_vcol_exprs()[sql_base.cc:5090]
mysqld.exe!lock_tables()[sql_base.cc:5274]
mysqld.exe!open_and_lock_tables()[sql_base.cc:4917]
mysqld.exe!mysql_insert()[sql_insert.cc:766]
mysqld.exe!mysql_execute_command()[sql_parse.cc:4722]
mysqld.exe!mysql_parse()[sql_parse.cc:8006]
mysqld.exe!dispatch_command()[sql_parse.cc:1848]
mysqld.exe!do_command()[sql_parse.cc:1390]
mysqld.exe!threadpool_process_request()[threadpool_common.cc:358]
mysqld.exe!tp_callback()[threadpool_common.cc:186]
ntdll.dll!RtlDllShutdownInProgress()
ntdll.dll!DbgUiRemoteBreakin()
kernel32.dll!BaseThreadInitThunk()
ntdll.dll!RtlUserThreadStart()

How to Repeat

set sql_mode='';
drop table if exists t;
create table t (
  a int generated always as (updatexml((@@global.date_format),1,substring_index(1,2,3))) virtual
) engine=innodb;
insert into t values();
insert ignore into t values();



 Comments   
Comment by Elena Stepanova [ 2018-04-27 ]

Thanks for the report and test case.

Comment by Nikita Malyavin [ 2019-09-09 ]

another duplicate of MDEV-16039

Generated at Thu Feb 08 08:25:58 UTC 2024 using Jira 8.20.16#820016-sha1:9d11dbea5f4be3d4cc21f03a88dd11d8c8687422.