diff options
| author | acurtis@xiphis.org <> | 2005-08-11 12:18:53 +0100 |
|---|---|---|
| committer | acurtis@xiphis.org <> | 2005-08-11 12:18:53 +0100 |
| commit | b9476f7d50e9911ea83f304351e5cab7a3880089 (patch) | |
| tree | 7e424eae0123e35fa5eec3670a550a310c6e1916 /mysql-test/t/bigint.test | |
| parent | 0f75d647349694d820923342325440e9abdd49a6 (diff) | |
| parent | 3b64651683a6f8d9276fd49843832f672312f880 (diff) | |
| download | mariadb-git-b9476f7d50e9911ea83f304351e5cab7a3880089.tar.gz | |
Merge xiphis.org:/usr/home/antony/work2/mysql-4.1
into xiphis.org:/usr/home/antony/work2/merge-5.0
Diffstat (limited to 'mysql-test/t/bigint.test')
| -rw-r--r-- | mysql-test/t/bigint.test | 3 |
1 files changed, 3 insertions, 0 deletions
diff --git a/mysql-test/t/bigint.test b/mysql-test/t/bigint.test index 5c06ef89676..5f21d2b5813 100644 --- a/mysql-test/t/bigint.test +++ b/mysql-test/t/bigint.test @@ -14,6 +14,9 @@ select +9999999999999999999,-9999999999999999999; select cast(9223372036854775808 as unsigned)+1; select 9223372036854775808+1; select -(0-3),round(-(0-3)), round(9999999999999999999); +select 1,11,101,1001,10001,100001,1000001,10000001,100000001,1000000001,10000000001,100000000001,1000000000001,10000000000001,100000000000001,1000000000000001,10000000000000001,100000000000000001,1000000000000000001,10000000000000000001; +select -1,-11,-101,-1001,-10001,-100001,-1000001,-10000001,-100000001,-1000000001,-10000000001,-100000000001,-1000000000001,-10000000000001,-100000000000001,-1000000000000001,-10000000000000001,-100000000000000001,-1000000000000000001,-10000000000000000001; +select conv(1,10,16),conv((1<<2)-1,10,16),conv((1<<10)-2,10,16),conv((1<<16)-3,10,16),conv((1<<25)-4,10,16),conv((1<<31)-5,10,16),conv((1<<36)-6,10,16),conv((1<<47)-7,10,16),conv((1<<48)-8,10,16),conv((1<<55)-9,10,16),conv((1<<56)-10,10,16),conv((1<<63)-11,10,16); # # In 3.23 we have to disable the test of column to bigint as |