diff options
| author | Sergei Golubchik <serg@mariadb.org> | 2016-11-03 22:40:19 +0100 |
|---|---|---|
| committer | Sergei Golubchik <serg@mariadb.org> | 2016-12-12 20:27:22 +0100 |
| commit | 232dc91bc957bfc3e08d08cec940d5fc8021799e (patch) | |
| tree | b0a8e3e744a8f9d4c1ee6f3fbfb3def90591b5ba /mysql-test/r/func_like.result | |
| parent | 660355c1acf70cc30e6a69000a1c5357a84fdc60 (diff) | |
| download | mariadb-git-232dc91bc957bfc3e08d08cec940d5fc8021799e.tar.gz | |
bugfix: Item_func_like::print() was losing ESCAPE clause
Diffstat (limited to 'mysql-test/r/func_like.result')
| -rw-r--r-- | mysql-test/r/func_like.result | 8 |
1 files changed, 8 insertions, 0 deletions
diff --git a/mysql-test/r/func_like.result b/mysql-test/r/func_like.result index 9c8e9727d16..0740e89f8df 100644 --- a/mysql-test/r/func_like.result +++ b/mysql-test/r/func_like.result @@ -254,3 +254,11 @@ DROP TABLE t1; # # End of 10.1 tests # +create view v1 as select 'foo!' like 'foo!!', 'foo!' like 'foo!!' escape '!'; +show create view v1; +View Create View character_set_client collation_connection +v1 CREATE ALGORITHM=UNDEFINED DEFINER=`root`@`localhost` SQL SECURITY DEFINER VIEW `v1` AS select ('foo!' like 'foo!!') AS `'foo!' like 'foo!!'`,('foo!' like 'foo!!' escape '!') AS `'foo!' like 'foo!!' escape '!'` koi8r koi8r_general_ci +select * from v1; +'foo!' like 'foo!!' 'foo!' like 'foo!!' escape '!' +0 1 +drop view v1; |