mirror of
https://github.com/MariaDB/server.git
synced 2025-02-19 03:45:35 +01:00
32 lines
955 B
Text
32 lines
955 B
Text
#Bug #20746926: GENERATED COLUMNS: INVALID READ OF THD WHEN WARNINGS
|
|
#
|
|
# Testing cmp_item_datetime
|
|
connect con1,localhost,root,,;
|
|
set sql_mode='';
|
|
create table t1 (
|
|
a date not null,
|
|
b mediumtext generated always as ((a not in (a,a))) virtual,
|
|
c timestamp generated always as ((a not in (b,b))) stored
|
|
);
|
|
insert t1(a) values(7777777777);
|
|
Warnings:
|
|
Warning 1265 Data truncated for column 'a' at row 1
|
|
Warning 1292 Incorrect datetime value: '0'
|
|
show warnings;
|
|
Level Code Message
|
|
Warning 1265 Data truncated for column 'a' at row 1
|
|
Warning 1292 Incorrect datetime value: '0'
|
|
disconnect con1;
|
|
connect con2,localhost,root,,;
|
|
set sql_mode='';
|
|
insert t1(a) values(6666666666);
|
|
Warnings:
|
|
Warning 1265 Data truncated for column 'a' at row 1
|
|
Warning 1292 Incorrect datetime value: '0'
|
|
show warnings;
|
|
Level Code Message
|
|
Warning 1265 Data truncated for column 'a' at row 1
|
|
Warning 1292 Incorrect datetime value: '0'
|
|
drop table t1;
|
|
disconnect con2;
|
|
connection default;
|