summaryrefslogtreecommitdiff
path: root/mysql-test/r/select.result
diff options
context:
space:
mode:
authorAlexey Kopytov <Alexey.Kopytov@sun.com>2009-02-10 16:27:35 +0300
committerAlexey Kopytov <Alexey.Kopytov@sun.com>2009-02-10 16:27:35 +0300
commit1571f06196072930b6bcf3d77eeae3cbe4a3611b (patch)
treebdffa8e5d8194b81855bad072fe9eb7827c64d02 /mysql-test/r/select.result
parent0888d7c0a8fdc72563d710cc3affa61ad2262c5c (diff)
parenta01946373d5752c921c4daddfec5c6cdfdbfa627 (diff)
downloadmariadb-git-1571f06196072930b6bcf3d77eeae3cbe4a3611b.tar.gz
Merge into dev tree.
Diffstat (limited to 'mysql-test/r/select.result')
-rw-r--r--mysql-test/r/select.result14
1 files changed, 7 insertions, 7 deletions
diff --git a/mysql-test/r/select.result b/mysql-test/r/select.result
index 0519489b715..621c11906cb 100644
--- a/mysql-test/r/select.result
+++ b/mysql-test/r/select.result
@@ -2784,26 +2784,26 @@ id select_type table type possible_keys key key_len ref rows Extra
1 SIMPLE NULL NULL NULL NULL NULL NULL NULL Select tables optimized away
select max(key1) from t1 where key1 <= 0.6158;
max(key1)
-0.61580002307892
+0.615800023078918
select max(key2) from t2 where key2 <= 1.6158;
max(key2)
-1.6158000230789
+1.61580002307892
select min(key1) from t1 where key1 >= 0.3762;
min(key1)
-0.37619999051094
+0.376199990510941
select min(key2) from t2 where key2 >= 1.3762;
min(key2)
-1.3761999607086
+1.37619996070862
select max(key1), min(key2) from t1, t2
where key1 <= 0.6158 and key2 >= 1.3762;
max(key1) min(key2)
-0.61580002307892 1.3761999607086
+0.615800023078918 1.37619996070862
select max(key1) from t1 where key1 <= 0.6158 and rand() + 0.5 >= 0.5;
max(key1)
-0.61580002307892
+0.615800023078918
select min(key1) from t1 where key1 >= 0.3762 and rand() + 0.5 >= 0.5;
min(key1)
-0.37619999051094
+0.376199990510941
DROP TABLE t1,t2;
CREATE TABLE t1 (i BIGINT UNSIGNED NOT NULL);
INSERT INTO t1 VALUES (10);