Details
-
Bug
-
Status: Closed (View Workflow)
-
Major
-
Resolution: Fixed
-
10.4(EOL)
-
None
Description
Reproducible on 10.4 with Innodb, not with MyIsam.
--source include/have_innodb.inc
|
CREATE TABLE t1 ( pk int NOT NULL PRIMARY KEY, v1 varchar(1)) ENGINE=InnoDB; |
CREATE TABLE t2 ( pk int NOT NULL PRIMARY KEY, v1 varchar(1)) ENGINE=InnoDB; |
|
SELECT t2.v1 FROM t2 JOIN t1 ON (t1.pk = t2.pk) |
WHERE t2.v1 = 'n' |
GROUP BY t2.v1 |
HAVING (t2.v1 = 'd' OR t2.v1 > 's'); |
10.4 9bd47835d0fcdcf2f041da39 |
/10.4/sql/item_cmpfunc.cc:5291: virtual longlong Item_cond_or::val_int(): Assertion `fixed == 1' failed.
|
|
assert/assert.c:92(__assert_fail_base)[0x7f3044fd7bd7]
|
/lib/x86_64-linux-gnu/libc.so.6(+0x2dc82)[0x7f3044fd7c82]
|
/10.4/sql/mysqld(_ZN12Item_cond_or7val_intEv+0x13c)[0x559a76703634]
|
sql/item_cmpfunc.cc:5292(Item_cond_or::val_int())[0x559a75c6d390]
|
/10.4/sql/mysqld(_ZN14Item_cache_int11cache_valueEv+0x11b)[0x559a766b89e3]
|
/10.4/sql/mysqld(_ZN10Item_cache9has_valueEv+0xaa)[0x559a763970ee]
|
sql/item.h:1499(Item::val_int_result())[0x559a766b8d2e]
|
sql/item.cc:9700(Item_cache_int::cache_value())[0x559a75fb43cb]
|
sql/item.h:6520(Item_cache::has_value())[0x559a75f745bd]
|
sql/item.cc:9733(Item_cache_int::val_int())[0x559a75f71cd0]
|
sql/sql_select.cc:11030(make_join_select(JOIN*, SQL_SELECT*, Item*))[0x559a75f6bc2f]
|
sql/sql_select.cc:2441(JOIN::optimize_stage2())[0x559a75f88ca1]
|
sql/sql_select.cc:2193(JOIN::optimize_inner())[0x559a75f5fdc0]
|
sql/sql_select.cc:1551(JOIN::optimize())[0x559a75ee485d]
|
sql/sql_select.cc:4564(mysql_select(THD*, TABLE_LIST*, unsigned int, List<Item>&, Item*, unsigned int, st_order*, st_order*, Item*, st_order*, unsigned long long, select_result*, st_select_lex_unit*, st_select_lex*))[0x559a75ed160f]
|
sql/sql_select.cc:424(handle_select(THD*, LEX*, select_result*, unsigned long))[0x559a75eecd3b]
|
sql/sql_parse.cc:6604(execute_sqlcom_select(THD*, TABLE_LIST*))[0x559a75ec57e8]
|
sql/sql_parse.cc:3841(mysql_execute_command(THD*))[0x559a75ec26e3]
|
sql/sql_parse.cc:8157(mysql_parse(THD*, char*, unsigned int, Parser_state*, bool, bool))[0x559a76236abe]
|
sql/sql_parse.cc:1831(dispatch_command(enum_server_command, THD*, char*, unsigned int, bool, bool))[0x559a76236488]
|
sql/sql_parse.cc:1358(do_command(THD*))[0x559a775f3151]
|
/lib/x86_64-linux-gnu/libpthread.so.0(+0x76ba)[0x7f3045e206ba]
|
x86_64/clone.S:111(clone)[0x7f30450b141d]
|
|
Query (0x62b00007e288): SELECT t2.v1 FROM t2 JOIN t1 ON (t1.pk = t2.pk) WHERE t2.v1 = 'n' GROUP BY t2.v1 HAVING (t2.v1 = 'd' OR t2.v1 > 's')
|
Attachments
Issue Links
- causes
-
MDEV-32395 update_depend_map_for_order: SEGV at /mariadb-11.3.0/sql/sql_select.cc:16583
- In Review
- includes
-
MDEV-18675 Server crashes in COND_EQUAL::copy
- Closed
-
MDEV-18937 Wrong result caused by equality pushdown from HAVING
- Closed
-
MDEV-19025 No 'Impossible WHERE' message after pushdown when OR cond is used
- Closed
-
MDEV-19048 Assertion `ctx.compare_type_handler()->cmp_type() != STRING_RESULT' failed in Field_num::get_equal_zerofill_const_item
- Closed
- relates to
-
MDEV-19012 Server crashes in st_select_lex_unit::optimize
- Closed