diff options
| author | unknown <gshchepa/uchum@host.loc> | 2008-03-27 00:51:29 +0400 |
|---|---|---|
| committer | unknown <gshchepa/uchum@host.loc> | 2008-03-27 00:51:29 +0400 |
| commit | 9179e20a3424ba3ee1d036d6da3970f98d018619 (patch) | |
| tree | f71ad97f94a2e4cabd939b64532d9124f40d753b /mysql-test/t/view.test | |
| parent | 3ca4bb96a41eb24be4aa5ca497e916b3c16de713 (diff) | |
| parent | c3f2e30320f31d654fecb0bf2eabf66e64685b89 (diff) | |
| download | mariadb-git-9179e20a3424ba3ee1d036d6da3970f98d018619.tar.gz | |
Merge host.loc:/home/uchum/work/5.0-opt
into host.loc:/home/uchum/work/5.1-opt
mysql-test/r/view.result:
Merge with 5.0-opt (bug#35193).
mysql-test/t/view.test:
Merge with 5.0-opt (bug#35193).
sql/sql_select.cc:
Merge with 5.0-opt (bug#35193).
Diffstat (limited to 'mysql-test/t/view.test')
| -rw-r--r-- | mysql-test/t/view.test | 23 |
1 files changed, 23 insertions, 0 deletions
diff --git a/mysql-test/t/view.test b/mysql-test/t/view.test index 43f7d4a6f68..7db1a693a93 100644 --- a/mysql-test/t/view.test +++ b/mysql-test/t/view.test @@ -3534,6 +3534,29 @@ DROP TABLE t1; ########################################################################### --echo # ----------------------------------------------------------------- +--echo # -- Bug#35193: VIEW query is rewritten without "FROM DUAL", +--echo # -- causing syntax error +--echo # ----------------------------------------------------------------- +--echo + +CREATE VIEW v1 AS SELECT 1 FROM DUAL WHERE 1; + +--echo + +SELECT * FROM v1; +SHOW CREATE TABLE v1; + +--echo + +DROP VIEW v1; + +--echo +--echo # -- End of test case for Bug#35193. +--echo + +########################################################################### + +--echo # ----------------------------------------------------------------- --echo # -- End of 5.0 tests. --echo # ----------------------------------------------------------------- |