• Monty's avatar
    MDEV-24929 Server crash in thr_multi_unlock or in get_schema_tables_result · 640f4231
    Monty authored
    This was caused by two different bugs:
    1) Information_schema tables where not locked by lock_tables, but
       get_lock_data() was not filtering these out. This caused a crash when
       mysql_unlock_some_tables() tried to unlock tables early, including
       not locked information schema tables.
    
    Fixed by not locking SYSTEM_TMP_TABLES
    
    2) In some cases the optimizer will notice that we do not need to read
       the information_schema tables at all. In this case
       join_tab->read_record is not set, which caused a crash in
       get_schema_tables_result()
    
    Fixed by ignoring const tables in get_schema_tables_result()
    640f4231
information_schema.test 62.2 KB