[MDEV-2686] LP:675981 - Assertion `cache != __null' failed in sub_select_cache() on EXPLAIN in maria-5.3-mwl89 Created: 2010-11-16 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 | ||
| Reporter: | Philip Stoev (Inactive) | Assignee: | Timour Katchaounov (Inactive) |
| Resolution: | Fixed | Votes: | 0 |
| Labels: | Launchpad | ||
| Attachments: |
|
| Description |
|
The following query: EXPLAIN asserts in maria-5.3-mwl89 with the following backtrace: #8 0x00a72d98 in __assert_fail () from /lib/libc.so.6 Working EXPLAIN is vitally important for automatic testing, so this bug needs to be fixed before testing on mwl-89 can continue. Test case: CREATE TABLE t2 (f1 int, f5 int) ; CREATE TABLE t3 (f4 int) ; EXPLAIN EXPLAIN from 5.3: id select_type table type possible_keys key key_len ref rows Extra |
| Comments |
| Comment by Timour Katchaounov (Inactive) [ 2010-11-19 ] |
|
Re: Assertion `cache != __null' failed in sub_select_cache() on EXPLAIN in maria-5.3-mwl89 set @@optimizer_switch='semijoin=off'; |
| Comment by Philip Stoev (Inactive) [ 2010-11-22 ] |
|
Re: Assertion `cache != __null' failed in sub_select_cache() on EXPLAIN in maria-5.3-mwl89 CREATE TABLE t1 (f1 int,f2 int,f4 int,f6 int,KEY (f4)) ; CREATE TABLE t3 (f3 int) ; CREATE TABLE t2 (f3 int) ; EXPLAIN |
| Comment by Philip Stoev (Inactive) [ 2010-11-22 ] |
|
Re: Assertion `cache != __null' failed in sub_select_cache() on EXPLAIN in maria-5.3-mwl89 |
| Comment by Rasmus Johansson (Inactive) [ 2010-11-22 ] |
|
Launchpad bug id: 675981 |