diff options
| author | unknown <timour@askmonty.org> | 2011-02-14 16:50:10 +0200 |
|---|---|---|
| committer | unknown <timour@askmonty.org> | 2011-02-14 16:50:10 +0200 |
| commit | 6c45d903f009c600ca5df628000eefed0762916b (patch) | |
| tree | b2ab3029d9ad7f0fb186ab09458c37a04ffc49c4 /mysql-test/r/subselect_mat_cost.result | |
| parent | 1be11803c762d0251d10ae423899f807de5c999a (diff) | |
| download | mariadb-git-6c45d903f009c600ca5df628000eefed0762916b.tar.gz | |
Fix LP BUG#718578
This bug extends the fix for LP BUG#715027 to cover one
more case of an Item being transformed, and its property
Item::with_subselect not being updated because
quick_fix_fields doesn't recalculate any properties.
Diffstat (limited to 'mysql-test/r/subselect_mat_cost.result')
| -rw-r--r-- | mysql-test/r/subselect_mat_cost.result | 16 |
1 files changed, 16 insertions, 0 deletions
diff --git a/mysql-test/r/subselect_mat_cost.result b/mysql-test/r/subselect_mat_cost.result index 914a308602d..58c9fbd24bf 100644 --- a/mysql-test/r/subselect_mat_cost.result +++ b/mysql-test/r/subselect_mat_cost.result @@ -3969,3 +3969,19 @@ WHERE t1.f1 AND alias2.f10 ORDER BY field1 ; field1 drop table t1,t2; +# +# LP BUG#718578 Yet another Assertion `!table || +# (!table->read_set || bitmap_is_set(table->read_set, field_index))' +CREATE TABLE t1 ( f1 int(11), f2 int(11), f3 int(11)) ; +INSERT IGNORE INTO t1 VALUES (28,5,6),(29,NULL,4); +CREATE TABLE t2 ( f10 varchar(1) ); +INSERT IGNORE INTO t2 VALUES (NULL); +SELECT f1 AS field1 +FROM ( SELECT * FROM t1 ) AS alias1 +WHERE (SELECT t1.f1 +FROM t2 JOIN t1 ON t1.f2 +WHERE alias1.f3 AND t1.f3) AND f2 +ORDER BY field1; +field1 +28 +drop table t1,t2; |