← Back to branch summary

~jlukas79/+junk/mysql-server

« back to all changes in this revision

Viewing changes to mysql-test/r/type_newdecimal.result

manual merge 6.0-main --> 6.0-bka-review

Show diffs side-by-side

added added

removed removed

Lines of Context:
mysql-test/r/type_newdecimal.result
838
838
x
839
839
99999999999999999999999999999999999999999999999999999999999999999
840
840
Warnings:
841
 
Error   1292    Truncated incorrect DECIMAL value: ''
 
841
Warning 1292    Truncated incorrect DECIMAL value: ''
842
842
select 9999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999 + 1 as x;
843
843
x
844
844
100000000000000000000000000000000000000000000000000000000000000000
845
845
Warnings:
846
 
Error   1292    Truncated incorrect DECIMAL value: ''
 
846
Warning 1292    Truncated incorrect DECIMAL value: ''
847
847
select 0.190287977636363637 + 0.040372670 * 0 -  0;
848
848
0.190287977636363637 + 0.040372670 * 0 -  0
849
849
0.190287977636363637
1380
1380
insert into t1 values(
1381
1381
89000000000000000000000000000000000000000000000000000000000000000000000000000000000000000);
1382
1382
Warnings:
1383
 
Error   1292    Truncated incorrect DECIMAL value: ''
 
1383
Warning 1292    Truncated incorrect DECIMAL value: ''
1384
1384
Warning 1264    Out of range value for column 'c1' at row 1
1385
1385
insert into t1 values(
1386
1386
99999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999 *
1387
1387
99999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999);
1388
1388
Warnings:
1389
 
Error   1292    Truncated incorrect DECIMAL value: ''
1390
 
Error   1292    Truncated incorrect DECIMAL value: ''
1391
 
Error   1292    Truncated incorrect DECIMAL value: ''
 
1389
Warning 1292    Truncated incorrect DECIMAL value: ''
 
1390
Warning 1292    Truncated incorrect DECIMAL value: ''
 
1391
Warning 1292    Truncated incorrect DECIMAL value: ''
1392
1392
Warning 1264    Out of range value for column 'c1' at row 1
1393
1393
insert into t1 values(1e100);
1394
1394
Warnings:
1432
1432
cast(19999999999999999999 as unsigned)
1433
1433
18446744073709551615
1434
1434
Warnings:
1435
 
Error   1292    Truncated incorrect DECIMAL value: ''
 
1435
Warning 1292    Truncated incorrect DECIMAL value: ''
1436
1436
create table t1(a decimal(18));
1437
1437
insert into t1 values(123456789012345678);
1438
1438
alter table t1 modify column a decimal(19);