diff options
| author | igor@rurik.mysql.com <> | 2005-01-22 02:42:54 -0800 |
|---|---|---|
| committer | igor@rurik.mysql.com <> | 2005-01-22 02:42:54 -0800 |
| commit | 0b61a16fd215a21dead590a66ee88f858b8eb9e3 (patch) | |
| tree | 8af432a50c14f0944f9bc73bab399c79cfce652f /mysql-test/r/select_found.result | |
| parent | e30b5f86e513de6e464a3ca489f8733e2c2ff881 (diff) | |
| parent | 8527f256c0688a4ecbd79b60534184a92b5d755f (diff) | |
| download | mariadb-git-0b61a16fd215a21dead590a66ee88f858b8eb9e3.tar.gz | |
Merge rurik.mysql.com:/home/igor/dev/mysql-4.0-0
into rurik.mysql.com:/home/igor/dev/mysql-4.1-0
Diffstat (limited to 'mysql-test/r/select_found.result')
| -rw-r--r-- | mysql-test/r/select_found.result | 8 |
1 files changed, 8 insertions, 0 deletions
diff --git a/mysql-test/r/select_found.result b/mysql-test/r/select_found.result index 00dbcb54d93..665277f68f2 100644 --- a/mysql-test/r/select_found.result +++ b/mysql-test/r/select_found.result @@ -246,3 +246,11 @@ SELECT FOUND_ROWS(); FOUND_ROWS() 0 DROP TABLE t1; +CREATE TABLE t1 (a int, b int); +INSERT INTO t1 VALUES (1,2), (1,3), (1,4), (1,5); +SELECT SQL_CALC_FOUND_ROWS DISTINCT 'a' FROM t1 GROUP BY b LIMIT 2; +a +a +SELECT FOUND_ROWS(); +FOUND_ROWS() +1 |