[MDEV-2604] LP:784281 - Wrong result from view containing outer reference in simijoin subquery Created: 2011-05-17 Updated: 2015-02-02 Resolved: 2012-10-04 |
|
| Status: | Closed |
| Project: | MariaDB Server |
| Component/s: | None |
| Affects Version/s: | None |
| Fix Version/s: | None |
| Type: | Bug | Priority: | Critical |
| Reporter: | Igor Babaev | Assignee: | Igor Babaev |
| Resolution: | Fixed | Votes: | 0 |
| Labels: | Launchpad | ||
| Attachments: |
|
| Description |
|
A wrong result is returned by the query below for the test case of bug #33389 from mysql-test/t/view.test. To reproduce the problem first execute the following statements: create table t1 (a int, key(a)); create view v1 as select a b from t1; insert into t1 values (1), (1); Then run the query You'll get: MariaDB [test]> select * from v2; The expected result is:
---
--- |
| Comments |
| Comment by Igor Babaev [ 2011-05-17 ] |
|
Re: Wrong result from view containing outer reference in simijoin subquery |
| Comment by Rasmus Johansson (Inactive) [ 2011-12-13 ] |
|
Launchpad bug id: 784281 |