Details
-
Bug
-
Status: Open (View Workflow)
-
Major
-
Resolution: Unresolved
-
10.5, 10.6, 10.11, 11.2(EOL), 11.4, 11.6(EOL)
-
None
-
None
Description
|
CREATE TABLE t1 ( d int, id int NOT NULL auto_increment, s geometry, b int, a int, p1 point NOT NULL DEFAULT st_geometryfromtext('Point(1 1)'), PRIMARY KEY (a,d,id)); |
|
SET SQL_MODE= 'SIMULTANEOUS_ASSIGNMENT' ; |
INSERT IGNORE INTO t1 ( a, b ) VALUES ( 1,2 ); |
--error 1416
|
UPDATE IGNORE t1 SET id = a, s = 1 WHERE p1 IS NOT NULL; |
ALTER TABLE t1 FORCE; |
|
mariadbd: /10.5/src/sql/field.h:1178: const uchar* Field::ptr_in_record(const uchar*) const: Assertion `l_offset >= 0 && table->s->rec_buff_length - l_offset > 0' failed.
|
241113 16:17:02 [ERROR] mysqld got signal 6 ;
|
|
Server version: 10.5.28-MariaDB-debug-log source revision: cad881ab104ac54f5e4c4ddffc3470346f98c38f
|
|
/lib/x86_64-linux-gnu/libc.so.6(+0x33fd6)[0x7f9d0b24afd6]
|
sql/field.h:1179(Field::ptr_in_record(unsigned char const*) const)[0x562605d9be0d]
|
sql/field.cc:10932(Column_definition::Column_definition(THD*, Field*, Field*))[0x562606237d40]
|
sql/field.h:5683(Create_field::Create_field(THD*, Field*, Field*))[0x56260594af14]
|
sql/sql_table.cc:8801(mysql_prepare_alter_table(THD*, TABLE*, HA_CREATE_INFO*, Alter_info*, Alter_table_ctx*))[0x562605cabe5a]
|
sql/sql_table.cc:10832(mysql_alter_table(THD*, st_mysql_const_lex_string const*, st_mysql_const_lex_string const*, HA_CREATE_INFO*, TABLE_LIST*, Recreate_info*, Alter_info*, unsigned int, st_order*, bool, bool))[0x562605cbbf97]
|
sql/sql_alter.cc:601(Sql_cmd_alter_table::execute(THD*))[0x562605e6df3f]
|
sql/sql_parse.cc:6179(mysql_execute_command(THD*))[0x5626059ff17f]
|
sql/sql_parse.cc:8237(mysql_parse(THD*, char*, unsigned int, Parser_state*, bool, bool))[0x562605a0cb93]
|
sql/sql_parse.cc:1894(dispatch_command(enum_server_command, THD*, char*, unsigned int, bool, bool))[0x5626059e1506]
|
sql/sql_parse.cc:1375(do_command(THD*))[0x5626059ddde0]
|
sql/sql_connect.cc:1407(do_handle_one_connection(CONNECT*, bool))[0x562605e50c9c]
|
sql/sql_connect.cc:1321(handle_one_connection)[0x562605e507f6]
|
perfschema/pfs.cc:2203(pfs_spawn_thread)[0x562606b0e9b4]
|
nptl/pthread_create.c:478(start_thread)[0x7f9d0b7fb609]
|
|
Query (0x62b0000852a8): ALTER TABLE t1 FORCE
|
Attachments
Issue Links
- relates to
-
MDEV-27769 Assertion `l_offset >= 0 && table->s->rec_buff_length - l_offset > 0' failed in Field::ptr_in_record
- Confirmed