summaryrefslogtreecommitdiff
path: root/mysql-test/r/select_found.result
diff options
context:
space:
mode:
authorunknown <serg@serg.mysql.com>2003-01-28 00:55:41 +0100
committerunknown <serg@serg.mysql.com>2003-01-28 00:55:41 +0100
commit0d470b8d7723629776609892e4fc400b17ad8359 (patch)
tree15a7b5601b010be414ee68b5a604b38637aeb057 /mysql-test/r/select_found.result
parent48f587a8836bd0b4a8e98bc87a9b98133b58fef5 (diff)
downloadmariadb-git-0d470b8d7723629776609892e4fc400b17ad8359.tar.gz
do not force CONNECTION_ID(), FOUND_ROWS(), PI(), CURRENT_USER(),
and VERSION() to be uppercase in e.g. "select pi()" mysql-test/r/func_math.result: result updated mysql-test/r/select_found.result: result updated mysql-test/r/union.result: result updated
Diffstat (limited to 'mysql-test/r/select_found.result')
-rw-r--r--mysql-test/r/select_found.result14
1 files changed, 7 insertions, 7 deletions
diff --git a/mysql-test/r/select_found.result b/mysql-test/r/select_found.result
index 1c2cd7da894..0a7f464cf7b 100644
--- a/mysql-test/r/select_found.result
+++ b/mysql-test/r/select_found.result
@@ -12,43 +12,43 @@ a b
7 7
8 9
select found_rows();
-FOUND_ROWS()
+found_rows()
8
select SQL_CALC_FOUND_ROWS * from t1 limit 1;
a b
1 2
select found_rows();
-FOUND_ROWS()
+found_rows()
8
select SQL_BUFFER_RESULT SQL_CALC_FOUND_ROWS * from t1 limit 1;
a b
1 2
select found_rows();
-FOUND_ROWS()
+found_rows()
8
select SQL_CALC_FOUND_ROWS * from t1 order by b desc limit 1;
a b
8 9
select found_rows();
-FOUND_ROWS()
+found_rows()
8
select SQL_CALC_FOUND_ROWS distinct b from t1 limit 1;
b
2
select found_rows();
-FOUND_ROWS()
+found_rows()
6
select SQL_CALC_FOUND_ROWS b,count(*) as c from t1 group by b order by c desc limit 1;
b c
5 3
select found_rows();
-FOUND_ROWS()
+found_rows()
6
select SQL_CALC_FOUND_ROWS * from t1 left join t1 as t2 on (t1.b=t2.a) limit 2,1;
a b a b
3 5 5 5
select found_rows();
-FOUND_ROWS()
+found_rows()
8
drop table t1;
create table t1 (a int not null primary key);