[MDEV-3516] LP:798576 - Assertion `!table || (!table->write_set || bitmap_is_set(table->write_set, field_index) || bitmap_is_set(table->vcol_set, field_index))' failed with views in maria-5.3 Created: 2011-06-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: | Philip Stoev (Inactive) | Assignee: | Igor Babaev |
| Resolution: | Fixed | Votes: | 0 |
| Labels: | Launchpad | ||
| Attachments: |
|
| Description |
|
Not repeatable with maria-5.2, mysql-5.1 . Seems to require views and non-integer field types. Further simplification of the query was not successful. backtrace: mysqld: field.cc:3747: virtual int Field_longlong::store(longlong, bool): Assertion `!table || (!table->write_set || bitmap_is_set(table->write_set, field_index) || bitmap_is_set(table->vcol_set, field_index))' failed. #6 0x00000033b58296e6 in __assert_fail () from /lib64/libc.so.6 explain: id select_type table type possible_keys key key_len ref rows Extra test case: SET SESSION join_cache_level=0; # to avoid JKL references in stack trace CREATE TABLE t1 ( f1 int NOT NULL , f10 varchar(32)) ; CREATE TABLE t2 ( f1 int NOT NULL , f3 int, f6 time, f7 time, f8 datetime, f9 datetime, f10 varchar(1) COLLATE latin1_swedish_ci, f11 varchar(1) COLLATE latin1_swedish_ci) ; CREATE OR REPLACE VIEW v1 AS SELECT * FROM t1; EXPLAIN SELECT COUNT( alias2.f10 ) , alias1.f11 AS field13 , alias2.f1 AS field14 , alias1.f10 AS field16 , alias2.f10 AS field17 , alias1.f3 AS field18 , alias1.f10 AS field19 , alias1.f6 AS field20 , alias1.f3 AS field21 , alias2.f6 AS field22 FROM t2 AS alias1 RIGHT JOIN v2 AS alias2 RIGHT JOIN v1 AS alias3 ON alias3.f1 ON alias3.f10 > alias2.f10 WHERE alias1.f1 GROUP BY field13 , field14 , field16 , field17 , field18 , field19 , field20 , field21 , field22; |
| Comments |
| Comment by Philip Stoev (Inactive) [ 2011-06-19 ] |
|
Re: Assertion `!table || (!table->write_set || bitmap_is_set(table->write_set, field_index) || bitmap_is_set(table->vcol_set, field_index))' failed with views in maria-5.3 CREATE TABLE t1 ( f1 int NOT NULL , f2 int NOT NULL ) ; CREATE TABLE t2 ( f2 int) ; CREATE ALGORITHM=MERGE VIEW v2 AS SELECT t1.f1, t2.f2 FROM (t2 LEFT JOIN t1 ON (t2.f2 <> t1.f1)) WHERE (t1.f2 <= 'up') ; backtrace: #8 0x006b0d98 in __assert_fail () from /lib/libc.so.6 |
| Comment by Rasmus Johansson (Inactive) [ 2011-12-13 ] |
|
Launchpad bug id: 798576 |