diff options
Diffstat (limited to 'mysql-test/r/type_decimal.result')
-rw-r--r-- | mysql-test/r/type_decimal.result | 109 |
1 files changed, 56 insertions, 53 deletions
diff --git a/mysql-test/r/type_decimal.result b/mysql-test/r/type_decimal.result index b31ef73742d..da25394eb08 100644 --- a/mysql-test/r/type_decimal.result +++ b/mysql-test/r/type_decimal.result @@ -1,4 +1,5 @@ DROP TABLE IF EXISTS t1; +SET SQL_WARNINGS=1; CREATE TABLE t1 ( id int(11) NOT NULL auto_increment, datatype_id int(11) DEFAULT '0' NOT NULL, @@ -157,17 +158,17 @@ insert into t1 values ("00000000000001"),("+0000000000001"),("-0000000000001"); insert into t1 values ("+111111111.11"),("111111111.11"),("-11111111.11"); insert into t1 values ("-111111111.11"),("+1111111111.11"),("1111111111.11"); Warnings: -Warning 1262 Data truncated, out of range for column 'a' at row 1 -Warning 1262 Data truncated, out of range for column 'a' at row 2 -Warning 1262 Data truncated, out of range for column 'a' at row 3 +Warning 1263 Data truncated, out of range for column 'a' at row 1 +Warning 1263 Data truncated, out of range for column 'a' at row 2 +Warning 1263 Data truncated, out of range for column 'a' at row 3 insert into t1 values ("1e+1000"),("1e-1000"),("-1e+1000"); Warnings: -Warning 1262 Data truncated, out of range for column 'a' at row 1 -Warning 1263 Data truncated for column 'a' at row 2 -Warning 1262 Data truncated, out of range for column 'a' at row 3 +Warning 1263 Data truncated, out of range for column 'a' at row 1 +Warning 1264 Data truncated for column 'a' at row 2 +Warning 1263 Data truncated, out of range for column 'a' at row 3 insert into t1 values ("123.4e"),("123.4e+2"),("123.4e-2"),("123e1"),("123e+0"); Warnings: -Warning 1263 Data truncated for column 'a' at row 3 +Warning 1264 Data truncated for column 'a' at row 3 select * from t1; a 0.00 @@ -200,32 +201,32 @@ drop table t1; create table t1 (a decimal(10,2) unsigned); insert into t1 values ("0.0"),("-0.0"),("+0.0"),("01.0"),("+01.0"),("-01.0"); Warnings: -Warning 1262 Data truncated, out of range for column 'a' at row 2 -Warning 1262 Data truncated, out of range for column 'a' at row 6 +Warning 1263 Data truncated, out of range for column 'a' at row 2 +Warning 1263 Data truncated, out of range for column 'a' at row 6 insert into t1 values ("-.1"),("+.1"),(".1"); Warnings: -Warning 1262 Data truncated, out of range for column 'a' at row 1 +Warning 1263 Data truncated, out of range for column 'a' at row 1 insert into t1 values ("00000000000001"),("+0000000000001"),("-0000000000001"); Warnings: -Warning 1262 Data truncated, out of range for column 'a' at row 3 +Warning 1263 Data truncated, out of range for column 'a' at row 3 insert into t1 values ("+111111111.11"),("111111111.11"),("-11111111.11"); Warnings: -Warning 1262 Data truncated, out of range for column 'a' at row 1 -Warning 1262 Data truncated, out of range for column 'a' at row 2 -Warning 1262 Data truncated, out of range for column 'a' at row 3 +Warning 1263 Data truncated, out of range for column 'a' at row 1 +Warning 1263 Data truncated, out of range for column 'a' at row 2 +Warning 1263 Data truncated, out of range for column 'a' at row 3 insert into t1 values ("-111111111.11"),("+1111111111.11"),("1111111111.11"); Warnings: -Warning 1262 Data truncated, out of range for column 'a' at row 1 -Warning 1262 Data truncated, out of range for column 'a' at row 2 -Warning 1262 Data truncated, out of range for column 'a' at row 3 +Warning 1263 Data truncated, out of range for column 'a' at row 1 +Warning 1263 Data truncated, out of range for column 'a' at row 2 +Warning 1263 Data truncated, out of range for column 'a' at row 3 insert into t1 values ("1e+1000"),("1e-1000"),("-1e+1000"); Warnings: -Warning 1262 Data truncated, out of range for column 'a' at row 1 -Warning 1263 Data truncated for column 'a' at row 2 -Warning 1262 Data truncated, out of range for column 'a' at row 3 +Warning 1263 Data truncated, out of range for column 'a' at row 1 +Warning 1264 Data truncated for column 'a' at row 2 +Warning 1263 Data truncated, out of range for column 'a' at row 3 insert into t1 values ("123.4e"),("123.4e+2"),("123.4e-2"),("123e1"),("123e+0"); Warnings: -Warning 1263 Data truncated for column 'a' at row 3 +Warning 1264 Data truncated for column 'a' at row 3 select * from t1; a 0.00 @@ -258,32 +259,32 @@ drop table t1; create table t1 (a decimal(10,2) zerofill); insert into t1 values ("0.0"),("-0.0"),("+0.0"),("01.0"),("+01.0"),("-01.0"); Warnings: -Warning 1262 Data truncated, out of range for column 'a' at row 2 -Warning 1262 Data truncated, out of range for column 'a' at row 6 +Warning 1263 Data truncated, out of range for column 'a' at row 2 +Warning 1263 Data truncated, out of range for column 'a' at row 6 insert into t1 values ("-.1"),("+.1"),(".1"); Warnings: -Warning 1262 Data truncated, out of range for column 'a' at row 1 +Warning 1263 Data truncated, out of range for column 'a' at row 1 insert into t1 values ("00000000000001"),("+0000000000001"),("-0000000000001"); Warnings: -Warning 1262 Data truncated, out of range for column 'a' at row 3 +Warning 1263 Data truncated, out of range for column 'a' at row 3 insert into t1 values ("+111111111.11"),("111111111.11"),("-11111111.11"); Warnings: -Warning 1262 Data truncated, out of range for column 'a' at row 1 -Warning 1262 Data truncated, out of range for column 'a' at row 2 -Warning 1262 Data truncated, out of range for column 'a' at row 3 +Warning 1263 Data truncated, out of range for column 'a' at row 1 +Warning 1263 Data truncated, out of range for column 'a' at row 2 +Warning 1263 Data truncated, out of range for column 'a' at row 3 insert into t1 values ("-111111111.11"),("+1111111111.11"),("1111111111.11"); Warnings: -Warning 1262 Data truncated, out of range for column 'a' at row 1 -Warning 1262 Data truncated, out of range for column 'a' at row 2 -Warning 1262 Data truncated, out of range for column 'a' at row 3 +Warning 1263 Data truncated, out of range for column 'a' at row 1 +Warning 1263 Data truncated, out of range for column 'a' at row 2 +Warning 1263 Data truncated, out of range for column 'a' at row 3 insert into t1 values ("1e+1000"),("1e-1000"),("-1e+1000"); Warnings: -Warning 1262 Data truncated, out of range for column 'a' at row 1 -Warning 1263 Data truncated for column 'a' at row 2 -Warning 1262 Data truncated, out of range for column 'a' at row 3 +Warning 1263 Data truncated, out of range for column 'a' at row 1 +Warning 1264 Data truncated for column 'a' at row 2 +Warning 1263 Data truncated, out of range for column 'a' at row 3 insert into t1 values ("123.4e"),("123.4e+2"),("123.4e-2"),("123e1"),("123e+0"); Warnings: -Warning 1263 Data truncated for column 'a' at row 3 +Warning 1264 Data truncated for column 'a' at row 3 select * from t1; a 00000000.00 @@ -320,13 +321,13 @@ insert into t1 values (00000000000001),(+0000000000001),(-0000000000001); insert into t1 values (+111111111.11),(111111111.11),(-11111111.11); insert into t1 values (-111111111.11),(+1111111111.11),(1111111111.11); Warnings: -Warning 1262 Data truncated, out of range for column 'a' at row 1 -Warning 1262 Data truncated, out of range for column 'a' at row 2 -Warning 1262 Data truncated, out of range for column 'a' at row 3 +Warning 1263 Data truncated, out of range for column 'a' at row 1 +Warning 1263 Data truncated, out of range for column 'a' at row 2 +Warning 1263 Data truncated, out of range for column 'a' at row 3 insert into t1 values (1e+100),(1e-100),(-1e+100); Warnings: -Warning 1262 Data truncated, out of range for column 'a' at row 1 -Warning 1262 Data truncated, out of range for column 'a' at row 3 +Warning 1263 Data truncated, out of range for column 'a' at row 1 +Warning 1263 Data truncated, out of range for column 'a' at row 3 insert into t1 values (123.4e0),(123.4e+2),(123.4e-2),(123e1),(123e+0); select * from t1; a @@ -360,8 +361,8 @@ drop table t1; create table t1 (a decimal); insert into t1 values (-99999999999999),(-1),('+1'),('01'),('+00000000000001'),('+12345678901'),(99999999999999); Warnings: -Warning 1262 Data truncated, out of range for column 'a' at row 1 -Warning 1262 Data truncated, out of range for column 'a' at row 7 +Warning 1263 Data truncated, out of range for column 'a' at row 1 +Warning 1263 Data truncated, out of range for column 'a' at row 7 select * from t1; a -9999999999 @@ -375,9 +376,9 @@ drop table t1; create table t1 (a decimal unsigned); insert into t1 values (-99999999999999),(-1),('+1'),('01'),('+00000000000001'),('+1234567890'),(99999999999999); Warnings: -Warning 1262 Data truncated, out of range for column 'a' at row 1 -Warning 1262 Data truncated, out of range for column 'a' at row 2 -Warning 1262 Data truncated, out of range for column 'a' at row 7 +Warning 1263 Data truncated, out of range for column 'a' at row 1 +Warning 1263 Data truncated, out of range for column 'a' at row 2 +Warning 1263 Data truncated, out of range for column 'a' at row 7 select * from t1; a 0 @@ -391,9 +392,9 @@ drop table t1; create table t1 (a decimal zerofill); insert into t1 values (-99999999999999),(-1),('+1'),('01'),('+00000000000001'),('+1234567890'),(99999999999999); Warnings: -Warning 1262 Data truncated, out of range for column 'a' at row 1 -Warning 1262 Data truncated, out of range for column 'a' at row 2 -Warning 1262 Data truncated, out of range for column 'a' at row 7 +Warning 1263 Data truncated, out of range for column 'a' at row 1 +Warning 1263 Data truncated, out of range for column 'a' at row 2 +Warning 1263 Data truncated, out of range for column 'a' at row 7 select * from t1; a 0000000000 @@ -407,9 +408,9 @@ drop table t1; create table t1 (a decimal unsigned zerofill); insert into t1 values (-99999999999999),(-1),('+1'),('01'),('+00000000000001'),('+1234567890'),(99999999999999); Warnings: -Warning 1262 Data truncated, out of range for column 'a' at row 1 -Warning 1262 Data truncated, out of range for column 'a' at row 2 -Warning 1262 Data truncated, out of range for column 'a' at row 7 +Warning 1263 Data truncated, out of range for column 'a' at row 1 +Warning 1263 Data truncated, out of range for column 'a' at row 2 +Warning 1263 Data truncated, out of range for column 'a' at row 7 select * from t1; a 0000000000 @@ -423,14 +424,16 @@ drop table t1; create table t1(a decimal(10,0)); insert into t1 values ("1e4294967295"); Warnings: -Warning 1262 Data truncated, out of range for column 'a' at row 1 +Warning 1264 Data truncated for column 'a' at row 1 +Warning 1263 Data truncated, out of range for column 'a' at row 1 select * from t1; a 99999999999 delete from t1; insert into t1 values("1e4294967297"); Warnings: -Warning 1262 Data truncated, out of range for column 'a' at row 1 +Warning 1264 Data truncated for column 'a' at row 1 +Warning 1263 Data truncated, out of range for column 'a' at row 1 select * from t1; a 99999999999 |