diff options
| author | Alexander Barkov <bar@mariadb.org> | 2017-09-13 12:12:05 +0400 |
|---|---|---|
| committer | Alexander Barkov <bar@mariadb.org> | 2017-09-13 12:12:05 +0400 |
| commit | 178540b904f3eca70488a3d1a0a55f5676087c04 (patch) | |
| tree | c6b011a292ea8a3510dae01aa3ea43e87cf3662f /mysql-test/r/view.result | |
| parent | 3a9ee22ba924160cbc5a4dd3fd047d62f11dabd2 (diff) | |
| parent | a237a920991f417e9a4567957f4fc7aa5b538270 (diff) | |
| download | mariadb-git-178540b904f3eca70488a3d1a0a55f5676087c04.tar.gz | |
Merge remote-tracking branch 'origin/10.2' into bb-10.2-ext
Diffstat (limited to 'mysql-test/r/view.result')
| -rw-r--r-- | mysql-test/r/view.result | 23 |
1 files changed, 23 insertions, 0 deletions
diff --git a/mysql-test/r/view.result b/mysql-test/r/view.result index 8767b737ca7..36abece7743 100644 --- a/mysql-test/r/view.result +++ b/mysql-test/r/view.result @@ -6638,6 +6638,29 @@ drop table procViewTable; use test; drop database bugTest; # +# MDEV-13436: PREPARE doesn't work as expected & throws errors but +# MySQL is working fine +# +create table t1 (a int); +insert into t1 values (1),(2); +SET @sql_query = " + CREATE VIEW v1 AS + SELECT * FROM ( + SELECT CASE WHEN 1 IN (SELECT a from t1 where a < 2) THEN TRUE END AS testcase + ) testalias +"; +PREPARE stmt FROM @sql_query; +EXECUTE stmt; +DEALLOCATE PREPARE stmt; +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 `testalias`.`testcase` AS `testcase` from (select case when 1 in (select `test`.`t1`.`a` from `test`.`t1` where `test`.`t1`.`a` < 2) then 1 end AS `testcase`) `testalias` latin1 latin1_swedish_ci +SELECT * FROM v1; +testcase +1 +drop view v1; +drop table t1; +# # End of 10.2 tests # # |