summaryrefslogtreecommitdiff
path: root/mysql-test/r/func_math.result
diff options
context:
space:
mode:
authorunknown <gkodinov/kgeorge@magare.gmz>2007-10-01 12:56:25 +0300
committerunknown <gkodinov/kgeorge@magare.gmz>2007-10-01 12:56:25 +0300
commit163ba66c3f965ff4b0091628156e337058fc28a0 (patch)
tree0959af4265f279d4c92fbc5a3c4bc06483bd9ce6 /mysql-test/r/func_math.result
parent82c059cf2fc5939f1b2fa904f14d1d5431973ee8 (diff)
parent0ad23eb8a5f377e94d4b4ae83f39555dbe75c3b0 (diff)
downloadmariadb-git-163ba66c3f965ff4b0091628156e337058fc28a0.tar.gz
merge 5.0-opt -> 5.1-opt
mysql-test/r/func_math.result: Auto merged mysql-test/t/func_math.test: Auto merged mysql-test/t/view_grant.test: Auto merged sql/item_func.cc: Auto merged sql/sql_select.cc: Auto merged sql/sql_view.cc: Auto merged
Diffstat (limited to 'mysql-test/r/func_math.result')
-rw-r--r--mysql-test/r/func_math.result8
1 files changed, 0 insertions, 8 deletions
diff --git a/mysql-test/r/func_math.result b/mysql-test/r/func_math.result
index 186c67876b2..6a476d12896 100644
--- a/mysql-test/r/func_math.result
+++ b/mysql-test/r/func_math.result
@@ -372,25 +372,17 @@ pow(cast(-2 as unsigned), 5) pow(18446744073709551614, 5) pow(-2, 5)
CREATE TABLE t1 (a timestamp, b varchar(20), c bit(1));
INSERT INTO t1 VALUES('1998-09-23', 'str1', 1), ('2003-03-25', 'str2', 0);
SELECT a DIV 900 y FROM t1 GROUP BY y;
-Catalog Database Table Table_alias Column Column_alias Type Length Max length Is_null Flags Decimals Charsetnr
-def y y 8 19 11 Y 32800 0 63
y
22201025555
22255916666
SELECT DISTINCT a DIV 900 y FROM t1;
-Catalog Database Table Table_alias Column Column_alias Type Length Max length Is_null Flags Decimals Charsetnr
-def y y 8 19 11 Y 32800 0 63
y
22201025555
22255916666
SELECT b DIV 900 y FROM t1 GROUP BY y;
-Catalog Database Table Table_alias Column Column_alias Type Length Max length Is_null Flags Decimals Charsetnr
-def y y 8 20 1 Y 32768 0 63
y
0
SELECT c DIV 900 y FROM t1 GROUP BY y;
-Catalog Database Table Table_alias Column Column_alias Type Length Max length Is_null Flags Decimals Charsetnr
-def y y 3 1 1 Y 32800 0 63
y
0
DROP TABLE t1;