diff options
| author | Sergei Golubchik <serg@mariadb.org> | 2016-02-22 19:55:43 +0100 |
|---|---|---|
| committer | Sergei Golubchik <serg@mariadb.org> | 2016-02-23 10:54:36 +0100 |
| commit | 20c4dfd4a9e7c5f2f570488a7ead0b7c74e61817 (patch) | |
| tree | 33e73afca64b9a387bf77a7ac5d5ad57b146b0da /mysql-test/r | |
| parent | 216b5cc9b6434d501f9aaee9716f5b2983ba38c8 (diff) | |
| download | mariadb-git-20c4dfd4a9e7c5f2f570488a7ead0b7c74e61817.tar.gz | |
MDEV-9576 syntax error on view with nullif and count
don't transform Item_func_nullif if it's context_analysis_only
Diffstat (limited to 'mysql-test/r')
| -rw-r--r-- | mysql-test/r/null.result | 7 |
1 files changed, 7 insertions, 0 deletions
diff --git a/mysql-test/r/null.result b/mysql-test/r/null.result index af24ad428ff..cd4fa259b3f 100644 --- a/mysql-test/r/null.result +++ b/mysql-test/r/null.result @@ -1524,6 +1524,13 @@ id select_type table type possible_keys key key_len ref rows filtered Extra Warnings: Note 1003 select nullif(<cache>(avg(`test`.`t1`.`a`)),0) AS `NULLIF(AVG(a),0)` from `test`.`t1` DROP TABLE t1; +create table t1 (col1 varchar(50)); +create view v1 AS select nullif(count(distinct col1),0) from t1; +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 nullif(count(distinct `t1`.`col1`),0) AS `nullif(count(distinct col1),0)` from `t1` latin1 latin1_swedish_ci +drop view v1; +drop table t1; # # End of 10.1 tests # |