diff options
| author | unknown <anozdrin/alik@alik.> | 2006-12-19 15:32:02 +0300 |
|---|---|---|
| committer | unknown <anozdrin/alik@alik.> | 2006-12-19 15:32:02 +0300 |
| commit | b66ab7f80b629c6d33d7e4ac01002cbb7676df18 (patch) | |
| tree | aceea9637cb5d76fdf857a8c509a47c3c949fb15 /mysql-test/r/view.result | |
| parent | d501b2dd3966d4f236b46a3b3bb7b89929e25716 (diff) | |
| download | mariadb-git-b66ab7f80b629c6d33d7e4ac01002cbb7676df18.tar.gz | |
Fix for BUG#24293: '\Z' token is not handled correctly in views.
If SELECT-part of CREATE VIEW statement contains '\Z',
it is not handled correctly.
The problem was in String::print().
Symbol with code 032 (26) is replaced with '\z',
which is not supported by the lexer.
The fix is to replace the symbol with '\Z'.
mysql-test/r/view.result:
Update result file.
mysql-test/t/view.test:
Add test case for BUG#24293.
sql/sql_string.cc:
We should replace 032 with \Z, since lexer does not understand \z.
Diffstat (limited to 'mysql-test/r/view.result')
| -rw-r--r-- | mysql-test/r/view.result | 9 |
1 files changed, 9 insertions, 0 deletions
diff --git a/mysql-test/r/view.result b/mysql-test/r/view.result index 81711f95ae6..caa494c26b3 100644 --- a/mysql-test/r/view.result +++ b/mysql-test/r/view.result @@ -3014,4 +3014,13 @@ i j 6 3 DROP VIEW v1, v2; DROP TABLE t1; +DROP VIEW IF EXISTS v1; +CREATE VIEW v1 AS SELECT 'The\ZEnd'; +SELECT * FROM v1; +TheEnd +TheEnd +SHOW CREATE VIEW v1; +View Create View +v1 CREATE ALGORITHM=UNDEFINED DEFINER=`root`@`localhost` SQL SECURITY DEFINER VIEW `v1` AS select _latin1'The\ZEnd' AS `TheEnd` +DROP VIEW v1; End of 5.0 tests. |