Details
-
Bug
-
Status: Closed (View Workflow)
-
Major
-
Resolution: Fixed
-
N/A
-
None
Description
Hopefully it is related to MDEV-25142 and will be fixed by the same patch.
CREATE VIEW v AS SELECT * FROM JSON_TABLE('[]', '$' COLUMNS (f INT EXISTS PATH '$')) a; |
SELECT * FROM INFORMATION_SCHEMA.GEOMETRY_COLUMNS; |
bb-10.6-mdev17399-psergey2 8b533cc1d5 |
mysqld: /data/src/bb-10.6-mdev17399-psergey2/sql/sql_error.cc:994: void convert_error_to_warning(THD*): Assertion `thd->is_error()' failed.
|
210315 17:31:39 [ERROR] mysqld got signal 6 ;
|
 |
#7 0x00007f1afcb43f36 in __GI___assert_fail (assertion=0x5563cfca619e "thd->is_error()", file=0x5563cfca5b38 "/data/src/bb-10.6-mdev17399-psergey2/sql/sql_error.cc", line=994, function=0x5563cfca61b0 "void convert_error_to_warning(THD*)") at assert.c:101
|
#8 0x00005563ceeab37d in convert_error_to_warning (thd=0x7f1aa4000db8) at /data/src/bb-10.6-mdev17399-psergey2/sql/sql_error.cc:994
|
#9 0x00005563cfc2b0d1 in Show::get_geometry_column_record (thd=0x7f1aa4000db8, tables=0x7f1aa4027f70, table=0x7f1aa401f1b0, res=true, db_name=0x7f1aa4019650, table_name=0x7f1aa4019680) at /data/src/bb-10.6-mdev17399-psergey2/plugin/type_geom/plugin.cc:168
|
#10 0x00005563cefba175 in fill_schema_table_by_open (thd=0x7f1aa4000db8, mem_root=0x7f1afc071e80, is_show_fields_or_keys=false, table=0x7f1aa401f1b0, schema_table=0x5563d17687e8, orig_db_name=0x7f1aa4019650, orig_table_name=0x7f1aa4019680, open_tables_state_backup=0x7f1afc071ec0, can_deadlock=false) at /data/src/bb-10.6-mdev17399-psergey2/sql/sql_show.cc:4652
|
#11 0x00005563cefbbb7a in get_all_tables (thd=0x7f1aa4000db8, tables=0x7f1aa4014470, cond=0x0) at /data/src/bb-10.6-mdev17399-psergey2/sql/sql_show.cc:5260
|
#12 0x00005563cefcce7b in get_schema_tables_result (join=0x7f1aa4015b20, executed_place=PROCESSED_BY_JOIN_EXEC) at /data/src/bb-10.6-mdev17399-psergey2/sql/sql_show.cc:8731
|
#13 0x00005563cef59d5f in JOIN::exec_inner (this=0x7f1aa4015b20) at /data/src/bb-10.6-mdev17399-psergey2/sql/sql_select.cc:4445
|
#14 0x00005563cef59161 in JOIN::exec (this=0x7f1aa4015b20) at /data/src/bb-10.6-mdev17399-psergey2/sql/sql_select.cc:4268
|
#15 0x00005563cef5a9ad in mysql_select (thd=0x7f1aa4000db8, tables=0x7f1aa4014470, fields=..., conds=0x0, og_num=0, order=0x0, group=0x0, having=0x0, proc_param=0x0, select_options=2684619520, result=0x7f1aa4015af8, unit=0x7f1aa4004f90, select_lex=0x7f1aa4013e20) at /data/src/bb-10.6-mdev17399-psergey2/sql/sql_select.cc:4744
|
#16 0x00005563cef4a2db in handle_select (thd=0x7f1aa4000db8, lex=0x7f1aa4004ec8, result=0x7f1aa4015af8, setup_tables_done_option=0) at /data/src/bb-10.6-mdev17399-psergey2/sql/sql_select.cc:417
|
#17 0x00005563cef0cdd7 in execute_sqlcom_select (thd=0x7f1aa4000db8, all_tables=0x7f1aa4014470) at /data/src/bb-10.6-mdev17399-psergey2/sql/sql_parse.cc:6230
|
#18 0x00005563cef04037 in mysql_execute_command (thd=0x7f1aa4000db8) at /data/src/bb-10.6-mdev17399-psergey2/sql/sql_parse.cc:3926
|
#19 0x00005563cef11c24 in mysql_parse (thd=0x7f1aa4000db8, rawbuf=0x7f1aa4013d60 "SELECT * FROM INFORMATION_SCHEMA.GEOMETRY_COLUMNS", length=49, parser_state=0x7f1afc073510) at /data/src/bb-10.6-mdev17399-psergey2/sql/sql_parse.cc:8001
|
#20 0x00005563ceefe042 in dispatch_command (command=COM_QUERY, thd=0x7f1aa4000db8, packet=0x7f1aa400b379 "SELECT * FROM INFORMATION_SCHEMA.GEOMETRY_COLUMNS", packet_length=49, blocking=true) at /data/src/bb-10.6-mdev17399-psergey2/sql/sql_parse.cc:1886
|
#21 0x00005563ceefc9e9 in do_command (thd=0x7f1aa4000db8, blocking=true) at /data/src/bb-10.6-mdev17399-psergey2/sql/sql_parse.cc:1397
|
#22 0x00005563cf0aaf98 in do_handle_one_connection (connect=0x5563d1d5aea8, put_in_cache=true) at /data/src/bb-10.6-mdev17399-psergey2/sql/sql_connect.cc:1410
|
#23 0x00005563cf0aacf4 in handle_one_connection (arg=0x5563d1cf6138) at /data/src/bb-10.6-mdev17399-psergey2/sql/sql_connect.cc:1312
|
#24 0x00005563cf60d987 in pfs_spawn_thread (arg=0x5563d1c3f678) at /data/src/bb-10.6-mdev17399-psergey2/storage/perfschema/pfs.cc:2201
|
#25 0x00007f1afd05b609 in start_thread (arg=<optimized out>) at pthread_create.c:477
|
#26 0x00007f1afcc2f293 in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:95
|
Attachments
Issue Links
- relates to
-
MDEV-17399 Add support for JSON_TABLE
-
- Closed
-
-
MDEV-25142 JSON_TABLE: CREATE VIEW involving EXISTS PATH ends up with invalid frm
-
- Closed
-