From 20c4dfd4a9e7c5f2f570488a7ead0b7c74e61817 Mon Sep 17 00:00:00 2001 From: Sergei Golubchik Date: Mon, 22 Feb 2016 19:55:43 +0100 Subject: MDEV-9576 syntax error on view with nullif and count don't transform Item_func_nullif if it's context_analysis_only --- mysql-test/r/null.result | 7 +++++++ 1 file changed, 7 insertions(+) (limited to 'mysql-test/r') 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((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 # -- cgit v1.2.1