diff options
| author | unknown <acurtis@xiphis.org> | 2005-08-11 12:18:53 +0100 |
|---|---|---|
| committer | unknown <acurtis@xiphis.org> | 2005-08-11 12:18:53 +0100 |
| commit | de00ff7626c85cd8809daa85c840f0f6736c6099 (patch) | |
| tree | 7e424eae0123e35fa5eec3670a550a310c6e1916 /mysql-test/t/bigint.test | |
| parent | 98da6d5ffbaf00dfc9f2b3d18bbda665cf3fd67e (diff) | |
| parent | bf07693148f916b27e8a520965fdd556ad054806 (diff) | |
| download | mariadb-git-de00ff7626c85cd8809daa85c840f0f6736c6099.tar.gz | |
Merge xiphis.org:/usr/home/antony/work2/mysql-4.1
into xiphis.org:/usr/home/antony/work2/merge-5.0
client/mysql.cc:
Auto merged
client/mysqldump.c:
Auto merged
client/mysqltest.c:
Auto merged
myisam/ft_boolean_search.c:
Auto merged
myisammrg/myrg_static.c:
Auto merged
mysql-test/r/func_str.result:
Auto merged
mysql-test/r/rpl_drop_temp.result:
Auto merged
mysql-test/r/type_datetime.result:
Auto merged
mysql-test/t/bigint.test:
Auto merged
mysql-test/t/func_str.test:
Auto merged
mysql-test/t/rpl_drop_temp.test:
Auto merged
sql/field.cc:
Auto merged
sql/item_cmpfunc.cc:
Auto merged
sql/slave.cc:
Auto merged
sql/sql_cache.cc:
Auto merged
sql/sql_parse.cc:
Auto merged
sql-common/my_time.c:
Auto merged
include/my_sys.h:
manual merge 4.1->5.0
mysql-test/r/bigint.result:
manual merge 4.1->5.0
mysql-test/r/subselect.result:
manual merge 4.1->5.0
mysql-test/t/subselect.test:
manual merge 4.1->5.0
mysys/charset.c:
manual merge 4.1->5.0
sql/ha_ndbcluster.cc:
manual merge 4.1->5.0
sql/item_strfunc.cc:
manual merge 4.1->5.0
sql/sql_base.cc:
manual merge 4.1->5.0
sql/sql_select.cc:
manual merge 4.1->5.0
sql/sql_union.cc:
manual merge 4.1->5.0
strings/Makefile.am:
manual merge 4.1->5.0
tests/mysql_client_test.c:
manual merge 4.1->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 |