summaryrefslogtreecommitdiff
path: root/mysql-test/r/bigint.result
diff options
context:
space:
mode:
authorunknown <gshchepa/uchum@gleb.loc>2007-06-16 22:40:25 +0500
committerunknown <gshchepa/uchum@gleb.loc>2007-06-16 22:40:25 +0500
commit200c69e3e6dd7a59796f1fd1ac78f90ec402a6c3 (patch)
tree210b1122be877ed2b2834f7ee6aeb6fd33668092 /mysql-test/r/bigint.result
parentf6a7490c387c5752df6b10007efe19f993f64e43 (diff)
parent67988a75fc3030462d43c9625caa924bfc8c443d (diff)
downloadmariadb-git-200c69e3e6dd7a59796f1fd1ac78f90ec402a6c3.tar.gz
Merge gleb.loc:/home/uchum/work/bk/5.0-opt
into gleb.loc:/home/uchum/work/bk/5.1-opt mysql-test/r/func_str.result: Auto merged mysql-test/t/func_str.test: Auto merged mysql-test/r/bigint.result: Merge with 5.0-opt. mysql-test/t/bigint.test: Merge with 5.0-opt. sql/item_func.cc: Merge with 5.0-opt.
Diffstat (limited to 'mysql-test/r/bigint.result')
-rw-r--r--mysql-test/r/bigint.result26
1 files changed, 26 insertions, 0 deletions
diff --git a/mysql-test/r/bigint.result b/mysql-test/r/bigint.result
index 8d831ba800b..0d6cf8e7d30 100644
--- a/mysql-test/r/bigint.result
+++ b/mysql-test/r/bigint.result
@@ -362,6 +362,32 @@ cast(-19999999999999999999 as signed)
-9223372036854775808
Warnings:
Error 1292 Truncated incorrect DECIMAL value: ''
+select -9223372036854775808;
+Catalog Database Table Table_alias Column Column_alias Type Length Max length Is_null Flags Decimals Charsetnr
+def -9223372036854775808 8 20 20 N 32897 0 63
+-9223372036854775808
+-9223372036854775808
+select -(9223372036854775808);
+Catalog Database Table Table_alias Column Column_alias Type Length Max length Is_null Flags Decimals Charsetnr
+def -(9223372036854775808) 8 20 20 N 32897 0 63
+-(9223372036854775808)
+-9223372036854775808
+select -((9223372036854775808));
+Catalog Database Table Table_alias Column Column_alias Type Length Max length Is_null Flags Decimals Charsetnr
+def -((9223372036854775808)) 8 20 20 N 32897 0 63
+-((9223372036854775808))
+-9223372036854775808
+select -(-(9223372036854775808));
+Catalog Database Table Table_alias Column Column_alias Type Length Max length Is_null Flags Decimals Charsetnr
+def -(-(9223372036854775808)) 246 21 19 N 129 0 63
+-(-(9223372036854775808))
+9223372036854775808
+select --9223372036854775808, ---9223372036854775808, ----9223372036854775808;
+--9223372036854775808 ---9223372036854775808 ----9223372036854775808
+9223372036854775808 -9223372036854775808 9223372036854775808
+select -(-9223372036854775808), -(-(-9223372036854775808));
+-(-9223372036854775808) -(-(-9223372036854775808))
+9223372036854775808 -9223372036854775808
create table t1 select -9223372036854775808 bi;
describe t1;
Field Type Null Key Default Extra