diff options
| author | Oleksandr Byelkin <sanja@mariadb.com> | 2015-04-14 23:18:54 +0200 |
|---|---|---|
| committer | Oleksandr Byelkin <sanja@mariadb.com> | 2015-04-23 15:56:10 +0200 |
| commit | 20109712aeb3d23e5e975780897ad236cbcd2ddc (patch) | |
| tree | 1d6e7509cce9617bb40c8dcffc34b6cc810e1eb3 /mysql-test/r/derived.result | |
| parent | 8cbaafd22b145512cc91f7b512290320849e77bd (diff) | |
| download | mariadb-git-20109712aeb3d23e5e975780897ad236cbcd2ddc.tar.gz | |
MDEV-6892: WHERE does not apply
Taking into account implicit dependence of constant view field from nullable table of left join added.
Fixed finding real table to check if it turned to NULL (materialized view & derived taken into account)
Removed incorrect uninitialization.
Diffstat (limited to 'mysql-test/r/derived.result')
| -rw-r--r-- | mysql-test/r/derived.result | 12 |
1 files changed, 12 insertions, 0 deletions
diff --git a/mysql-test/r/derived.result b/mysql-test/r/derived.result index d0f42c3d3ec..7c44466ae92 100644 --- a/mysql-test/r/derived.result +++ b/mysql-test/r/derived.result @@ -568,3 +568,15 @@ update t1 set balance=(select sum(balance) from (SELECT balance FROM t1 where ac set optimizer_switch=@save_derived_optimizer_switch_bug; drop table t1; set optimizer_switch=@save_derived_optimizer_switch; +# +# MDEV-6892: WHERE does not apply +# +create table t1 (id int); +create table t2 (id int); +insert into t1 values(1),(2),(3); +insert into t2 values(4),(5),(6); +select x.id, message from (select id from t1) x left join +(select id, 1 as message from t2) y on x.id=y.id +where coalesce(message,0) <> 0; +id message +drop table t1,t2; |