Details
-
Bug
-
Status: Confirmed (View Workflow)
-
Major
-
Resolution: Unresolved
-
10.5, 10.6, 10.4(EOL), 10.7(EOL), 10.8(EOL), 10.9(EOL)
-
None
Description
--source include/have_innodb.inc
|
|
CREATE TABLE t1 (a varchar(10) CHARACTER SET utf8mb4, key(a)) engine=innodb; |
INSERT INTO t1 VALUES (0xEFBFBF),(0xF0908080),(0xF48FBFBF); |
ALTER TABLE t1 MODIFY a varchar(10) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin; |
|
SELECT count(DISTINCT a) FROM t1; |
10.4 49e3bd2cbcb12ed45908 |
Version: '10.4.23-MariaDB-debug-log'
|
mysqld: /10.4/sql/opt_range.cc:14994: virtual int QUICK_GROUP_MIN_MAX_SELECT::get_next(): Assertion `is_last_prefix <= 0' failed.
|
220124 15:44:34 [ERROR] mysqld got signal 6 ;
|
|
|
/lib/x86_64-linux-gnu/libc.so.6(+0x30102)[0x7f9bc173f102]
|
sql/opt_range.cc:14998(QUICK_GROUP_MIN_MAX_SELECT::get_next())[0x555f3caed9b2]
|
sql/records.cc:369(rr_quick(READ_RECORD*))[0x555f3cb0f526]
|
sql/records.h:70(READ_RECORD::read_record())[0x555f3bdc3c52]
|
sql/sql_select.cc:21552(join_init_read_record(st_join_table*))[0x555f3c0b480e]
|
sql/sql_select.cc:20600(sub_select(JOIN*, st_join_table*, bool))[0x555f3c0ada62]
|
sql/sql_select.cc:20139(do_select(JOIN*, Procedure*))[0x555f3c0abc67]
|
sql/sql_select.cc:4534(JOIN::exec_inner())[0x555f3c03bf1e]
|
sql/sql_select.cc:4317(JOIN::exec())[0x555f3c03956a]
|
sql/sql_select.cc:4757(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*))[0x555f3c03d5c9]
|
sql/sql_select.cc:436(handle_select(THD*, LEX*, select_result*, unsigned long))[0x555f3c00ee98]
|
sql/sql_parse.cc:6449(execute_sqlcom_select(THD*, TABLE_LIST*))[0x555f3bf80dd6]
|
sql/sql_parse.cc:3963(mysql_execute_command(THD*))[0x555f3bf6e697]
|
sql/sql_parse.cc:7995(mysql_parse(THD*, char*, unsigned int, Parser_state*, bool, bool))[0x555f3bf89f21]
|
sql/sql_parse.cc:1860(dispatch_command(enum_server_command, THD*, char*, unsigned int, bool, bool))[0x555f3bf60d06]
|
sql/sql_parse.cc:1373(do_command(THD*))[0x555f3bf5d777]
|
sql/sql_connect.cc:1420(do_handle_one_connection(CONNECT*))[0x555f3c345f5d]
|
sql/sql_connect.cc:1317(handle_one_connection)[0x555f3c3456ba]
|
perfschema/pfs.cc:1871(pfs_spawn_thread)[0x555f3cffd7ef]
|
nptl/pthread_create.c:487(start_thread)[0x7f9bc1bfdfa3]
|
x86_64/clone.S:97(clone)[0x7f9bc18084cf]
|
|
Query (0x62b0000a1290): SELECT count(DISTINCT a) FROM t1
|
Attachments
Issue Links
- relates to
-
MDEV-15656 Assertion `is_last_prefix <= 0' failed in QUICK_GROUP_MIN_MAX_SELECT::get_next
- Closed