diff options
| author | unknown <Sinisa@sinisa.nasamreza.org> | 2003-09-13 19:56:58 +0300 |
|---|---|---|
| committer | unknown <Sinisa@sinisa.nasamreza.org> | 2003-09-13 19:56:58 +0300 |
| commit | aedc0ab09836923bebb35146f640e90e72dec8b9 (patch) | |
| tree | b2ab877657ef6e06964de1b23fbbba07cdb9645a /mysql-test/r/union.result | |
| parent | 61663eaa1882d2cdaab6dcd75e6515646adc500b (diff) | |
| download | mariadb-git-aedc0ab09836923bebb35146f640e90e72dec8b9.tar.gz | |
Fixes for OPTION_FOUND_ROWS in UNION's
mysql-test/r/subselect.result:
A warning added to subselect test due to the recent changes.
UNION in sub-select returns the empty set, which is why this warning is
a mistery to me.
mysql-test/r/union.result:
two changes.
First one is due to the proper handling of LIMIT offset, limit in
UNION without all.
Second is a change in behaviour due to the fact that ORDER by in a
UNION without braces is not now applicable to the last SELECT node.
It can not be applied until one bug is fixed (after my vacation).
Should be documented.
Diffstat (limited to 'mysql-test/r/union.result')
| -rw-r--r-- | mysql-test/r/union.result | 4 |
1 files changed, 2 insertions, 2 deletions
diff --git a/mysql-test/r/union.result b/mysql-test/r/union.result index 952ed566132..2e962190762 100644 --- a/mysql-test/r/union.result +++ b/mysql-test/r/union.result @@ -409,7 +409,7 @@ found_rows() SELECT SQL_CALC_FOUND_ROWS * FROM t1 UNION SELECT * FROM t2 LIMIT 2,2; a 3 -4 +5 select found_rows(); found_rows() 6 @@ -423,7 +423,7 @@ found_rows() 5 SELECT * FROM t1 UNION SELECT * FROM t2 ORDER BY a desc LIMIT 1; a -5 +3 (SELECT * FROM t1 ORDER by a) UNION ALL (SELECT * FROM t2 ORDER BY a) ORDER BY A desc LIMIT 4; a 5 |