diff options
| author | unknown <sasha@mysql.sashanet.com> | 2001-10-03 15:19:58 -0600 |
|---|---|---|
| committer | unknown <sasha@mysql.sashanet.com> | 2001-10-03 15:19:58 -0600 |
| commit | 6dcd03d76c5eb67a4d6ef8d01393789e45ab1864 (patch) | |
| tree | 8565f1027a2bc60cd641c7447414822be4d1ba6b /mysql-test/r/bigint.result | |
| parent | 7968bc7f66bf7a641fdda4493252bc8e7c571374 (diff) | |
| download | mariadb-git-6dcd03d76c5eb67a4d6ef8d01393789e45ab1864.tar.gz | |
post-merge fixes
mysql-test/fix-result:
version update
mysql-test/r/bigint.result:
post-merge fix
mysql-test/r/join.result:
post-merge fix
mysql-test/r/merge.result:
post-merge fix
mysql-test/r/null_key.result:
post-merge fix
mysql-test/r/rpl000002.result:
post-merge fix
mysql-test/r/rpl000015.result:
post-merge fix
mysql-test/r/rpl000016.result:
post-merge fix
mysql-test/r/rpl_log.result:
post-merge fix
mysql-test/r/show_check.result:
post-merge fix
mysql-test/t/rpl000002.test:
post-merge fix
mysql-test/t/rpl000015.test:
post-merge fix
mysql-test/t/rpl000016.test:
post-merge fix
Diffstat (limited to 'mysql-test/r/bigint.result')
| -rw-r--r-- | mysql-test/r/bigint.result | 30 |
1 files changed, 30 insertions, 0 deletions
diff --git a/mysql-test/r/bigint.result b/mysql-test/r/bigint.result index 1a1748155ce..1c4a94ef1ee 100644 --- a/mysql-test/r/bigint.result +++ b/mysql-test/r/bigint.result @@ -25,3 +25,33 @@ select * from t1; a 18446744073709551614 drop table t1; +create table t1 ( a int not null default 1, big bigint ); +insert into t1 (big) values (-1),(12345678901234567),(9223372036854775807),(18446744073709551615); +select min(big),max(big),max(big)-1 from t1; +min(big) max(big) max(big)-1 +-1 9223372036854775807 9223372036854775806 +select min(big),max(big),max(big)-1 from t1 group by a; +min(big) max(big) max(big)-1 +-1 9223372036854775807 9223372036854775806 +alter table t1 modify big bigint unsigned not null; +select min(big),max(big),max(big)-1 from t1; +min(big) max(big) max(big)-1 +12345678901234567 18446744073709551615 18446744073709551614 +select min(big),max(big),max(big)-1 from t1 group by a; +min(big) max(big) max(big)-1 +12345678901234567 18446744073709551615 18446744073709551614 +alter table t1 add key (big); +select min(big),max(big),max(big)-1 from t1; +min(big) max(big) max(big)-1 +12345678901234567 18446744073709551615 18446744073709551614 +select min(big),max(big),max(big)-1 from t1 group by a; +min(big) max(big) max(big)-1 +12345678901234567 18446744073709551615 18446744073709551614 +alter table t1 modify big bigint not null; +select min(big),max(big),max(big)-1 from t1; +min(big) max(big) max(big)-1 +-1 9223372036854775807 9223372036854775806 +select min(big),max(big),max(big)-1 from t1 group by a; +min(big) max(big) max(big)-1 +-1 9223372036854775807 9223372036854775806 +drop table t1; |