diff options
| author | unknown <gshchepa/uchum@host.loc> | 2008-03-27 20:05:51 +0400 |
|---|---|---|
| committer | unknown <gshchepa/uchum@host.loc> | 2008-03-27 20:05:51 +0400 |
| commit | 8e473edd486e35cd80617db5220c89e933995a56 (patch) | |
| tree | 00822f3ce8fa3bc1d7558dba317e47e06b0a8636 /mysql-test/t/view.test | |
| parent | 4eaa7303fc56a0a9c0d2b3e27b17436cea5f47a8 (diff) | |
| parent | 1207c8664452405748a1e02cd80644540e225ee2 (diff) | |
| download | mariadb-git-8e473edd486e35cd80617db5220c89e933995a56.tar.gz | |
Merge host.loc:/home/uchum/work/mysql-5.0
into host.loc:/home/uchum/work/5.0-opt
configure.in:
Auto merged
sql/item.cc:
Auto merged
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 23e64b0546f..9fa981ccb9a 100644 --- a/mysql-test/t/view.test +++ b/mysql-test/t/view.test @@ -3538,5 +3538,28 @@ 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 # ----------------------------------------------------------------- |