diff options
| author | unknown <igor@rurik.mysql.com> | 2005-07-17 09:46:14 -0700 |
|---|---|---|
| committer | unknown <igor@rurik.mysql.com> | 2005-07-17 09:46:14 -0700 |
| commit | 6a88fa48ae2568aadf8513060a88c88b65c3f7cc (patch) | |
| tree | 1e07c203ef28201cbcf2715f936d037466b46e03 /mysql-test/r/select.result | |
| parent | 89519b677e5fb9082e388515def51e47ae899f0b (diff) | |
| download | mariadb-git-6a88fa48ae2568aadf8513060a88c88b65c3f7cc.tar.gz | |
select.result, select.test:
Added a test case for bug #11745.
sql_select.cc:
Fixed bug # 11745.
Added support of where clause for queries with FROM DUAL.
sql_yacc.yy:
Fixed bug # 11745.
Added optional where clause for queries with FROM DUAL.
sql/sql_yacc.yy:
Fixed bug # 11745.
Added optional where clause for queries with FROM DUAL.
sql/sql_select.cc:
Fixed bug # 11745.
Added support of where clause for queries with FROM DUAL.
mysql-test/t/select.test:
Added a test case for bug #11745.
mysql-test/r/select.result:
Added a test case for bug #11745.
Diffstat (limited to 'mysql-test/r/select.result')
| -rw-r--r-- | mysql-test/r/select.result | 16 |
1 files changed, 16 insertions, 0 deletions
diff --git a/mysql-test/r/select.result b/mysql-test/r/select.result index 6c9ec9d8297..2df60944999 100644 --- a/mysql-test/r/select.result +++ b/mysql-test/r/select.result @@ -2582,3 +2582,19 @@ a 254 255 drop table t2; +CREATE TABLE t1 (a int, b int, c int); +INSERT INTO t1 +SELECT 50, 3, 3 FROM DUAL +WHERE NOT EXISTS +(SELECT * FROM t1 WHERE a = 50 AND b = 3); +SELECT * FROM t1; +a b c +50 3 3 +INSERT INTO t1 +SELECT 50, 3, 3 FROM DUAL +WHERE NOT EXISTS +(SELECT * FROM t1 WHERE a = 50 AND b = 3); +SELECT * FROM t1; +a b c +50 3 3 +DROP TABLE t1; |