drop database if exists db_018;
create database db_019;
use db_019;
create table tt1 (c1 decimal(64));
... WRONG: inserted as 0
insert into tt1 values( 89000000000000000000000000000000000000000000000000000000000000000000000000000000000000000 );
Warnings:
Error	1292	Truncated incorrect DECIMAL value: ''
insert into tt1 values( 83000000000000000000000000000000000000000000000000000000000000000000000000000000000 );
Warnings:
Error	1292	Truncated incorrect DECIMAL value: ''
... next 2 rows inserted as *MAX_VALUE*, BOTH WARNING and ERROR shown
insert into tt1 values( 89123456789012345678901234567890123456789012345678901234567890123456789012345678900000000 );
Warnings:
Error	1292	Truncated incorrect DECIMAL value: ''
Warning	1264	Out of range value adjusted for column 'c1' at row 1
insert into tt1 values( 8200000000000000000000000000000000000000000000000000000000000000000000000000000000 );
Warnings:
Error	1292	Truncated incorrect DECIMAL value: ''
Warning	1264	Out of range value adjusted for column 'c1' at row 1
... OK: next 4 rows inserted as *MAX_VALUE*, only WARNING shown
insert into tt1 values( 65000000000000000000000000000000000000000000000000000000000000000 );
Warnings:
Warning	1264	Out of range value adjusted for column 'c1' at row 1
insert into tt1 values( 65123456789012345678901234567890123456789012345678901234567890000 );
Warnings:
Warning	1264	Out of range value adjusted for column 'c1' at row 1
... CORRECT: inserted value as wanted.
insert into tt1 values( 6412345678901234567890123456789012345678901234567890123456789000 );
select * from tt1;
c1
0
0
9999999999999999999999999999999999999999999999999999999999999999
9999999999999999999999999999999999999999999999999999999999999999
9999999999999999999999999999999999999999999999999999999999999999
9999999999999999999999999999999999999999999999999999999999999999
6412345678901234567890123456789012345678901234567890123456789000
... inserted as *MAX_VALUE*, only WARNING shown
insert into tt1 values( 6.1234E+89 );
Warnings:
Warning	1264	Out of range value adjusted for column 'c1' at row 1
insert into tt1 values( 6.1234E+83 );
Warnings:
Warning	1264	Out of range value adjusted for column 'c1' at row 1
insert into tt1 values( 6.1234E+65 );
Warnings:
Warning	1264	Out of range value adjusted for column 'c1' at row 1
... STRANGE: value inserted AND WARNING shown
insert into tt1 values( 0.64123456E64 );
Warnings:
Note	1265	Data truncated for column 'c1' at row 1
insert into tt1 values(  6.4123456E63 );
Warnings:
Note	1265	Data truncated for column 'c1' at row 1
insert into tt1 values(  64.123456E62 );
Warnings:
Note	1265	Data truncated for column 'c1' at row 1
insert into tt1 values(  641.23456E61 );
Warnings:
Note	1265	Data truncated for column 'c1' at row 1
insert into tt1 values(  6412.3456E60 );
Warnings:
Note	1265	Data truncated for column 'c1' at row 1
insert into tt1 values(  64123.456E59 );
Warnings:
Note	1265	Data truncated for column 'c1' at row 1
select * from tt1;
c1
0
0
9999999999999999999999999999999999999999999999999999999999999999
9999999999999999999999999999999999999999999999999999999999999999
9999999999999999999999999999999999999999999999999999999999999999
9999999999999999999999999999999999999999999999999999999999999999
6412345678901234567890123456789012345678901234567890123456789000
9999999999999999999999999999999999999999999999999999999999999999
9999999999999999999999999999999999999999999999999999999999999999
9999999999999999999999999999999999999999999999999999999999999999
6412345600000000899492411331745085252813067451936489276033728512
6412345600000000899492411331745085252813067451936489276033728512
6412345600000000899492411331745085252813067451936489276033728512
6412345600000000899492411331745085252813067451936489276033728512
6412345600000000899492411331745085252813067451936489276033728512
6412345600000000899492411331745085252813067451936489276033728512
drop database if exists db_019;