CREATE DATABASE IF NOT EXISTS db;

USE db;

CREATE TABLE t (a INT);

SHOW TABLES WHERE `Tables_in_db` IN ('f38_users', 'f38_usermeta', 'f38_blogs', 'f38_blogmeta', 'f38_signups', 'f38_site', 'f38_sitemeta', 'f38_registration_log', 'f38_posts', 'f38_comments', 'f38_links', 'f38_options', 'f38_postmeta', 'f38_terms', 'f38_term_taxonomy', 'f38_term_relationships', 'f38_termmeta', 'f38_commentmeta', 'f38_4_posts', 'f38_4_comments', 'f38_4_links', 'f38_4_options', 'f38_4_postmeta', 'f38_4_terms', 'f38_4_term_taxonomy', 'f38_4_term_relationships', 'f38_4_termmeta', 'f38_4_commentmeta', 'f38_13_posts', 'f38_13_comments', 'f38_13_links', 'f38_13_options', 'f38_13_postmeta', 'f38_13_terms', 'f38_13_term_taxonomy', 'f38_13_term_relationships', 'f38_13_termmeta', 'f38_13_commentmeta', 'f38_12_posts', 'f38_12_comments', 'f38_12_links', 'f38_12_options', 'f38_12_postmeta', 'f38_12_terms', 'f38_12_term_taxonomy', 'f38_12_term_relationships', 'f38_12_termmeta', 'f38_12_commentmeta', 'f38_16_posts', 'f38_16_comments', 'f38_16_links', 'f38_16_options', 'f38_16_postmeta', 'f38_16_terms', 'f38_16_term_taxonomy', 'f38_16_term_relationships', 'f38_16_termmeta', 'f38_16_commentmeta', 'f38_15_posts', 'f38_15_comments', 'f38_15_links', 'f38_15_options', 'f38_15_postmeta', 'f38_15_terms', 'f38_15_term_taxonomy', 'f38_15_term_relationships', 'f38_15_termmeta', 'f38_15_commentmeta', 'f38_19_posts', 'f38_19_comments', 'f38_19_links', 'f38_19_options', 'f38_19_postmeta', 'f38_19_terms', 'f38_19_term_taxonomy', 'f38_19_term_relationships', 'f38_19_termmeta', 'f38_19_commentmeta', 'f38_20_posts', 'f38_20_comments', 'f38_20_links', 'f38_20_options', 'f38_20_postmeta', 'f38_20_terms', 'f38_20_term_taxonomy', 'f38_20_term_relationships', 'f38_20_termmeta', 'f38_20_commentmeta', 'f38_21_posts', 'f38_21_comments', 'f38_21_links', 'f38_21_options', 'f38_21_postmeta', 'f38_21_terms', 'f38_21_term_taxonomy', 'f38_21_term_relationships', 'f38_21_termmeta', 'f38_21_commentmeta', 'f38_22_posts', 'f38_22_comments', 'f38_22_links', 'f38_22_options', 'f38_22_postmeta', 'f38_22_terms', 'f38_22_term_taxonomy', 'f38_22_term_relationships', 'f38_22_termmeta', 'f38_22_commentmeta', 'f38_23_posts', 'f38_23_comments', 'f38_23_links', 'f38_23_options', 'f38_23_postmeta', 'f38_23_terms', 'f38_23_term_taxonomy', 'f38_23_term_relationships', 'f38_23_termmeta', 'f38_23_commentmeta', 'f38_45_posts', 'f38_45_comments', 'f38_45_links', 'f38_45_options', 'f38_45_postmeta', 'f38_45_terms', 'f38_45_term_taxonomy', 'f38_45_term_relationships', 'f38_45_termmeta', 'f38_45_commentmeta', 'f38_75_posts', 'f38_75_comments', 'f38_75_links', 'f38_75_options', 'f38_75_postmeta', 'f38_75_terms', 'f38_75_term_taxonomy', 'f38_75_term_relationships', 'f38_75_termmeta', 'f38_75_commentmeta', 'f38_78_posts', 'f38_78_comments', 'f38_78_links', 'f38_78_options', 'f38_78_postmeta', 'f38_78_terms', 'f38_78_term_taxonomy', 'f38_78_term_relationships', 'f38_78_termmeta', 'f38_78_commentmeta', 'f38_28_posts', 'f38_28_comments', 'f38_28_links', 'f38_28_options', 'f38_28_postmeta', 'f38_28_terms', 'f38_28_term_taxonomy', 'f38_28_term_relationships', 'f38_28_termmeta', 'f38_28_commentmeta', 'f38_31_posts', 'f38_31_comments', 'f38_31_links', 'f38_31_options', 'f38_31_postmeta', 'f38_31_terms', 'f38_31_term_taxonomy', 'f38_31_term_relationships', 'f38_31_termmeta', 'f38_31_commentmeta', 'f38_30_posts', 'f38_30_comments', 'f38_30_links', 'f38_30_options', 'f38_30_postmeta', 'f38_30_terms', 'f38_30_term_taxonomy', 'f38_30_term_relationships', 'f38_30_termmeta', 'f38_30_commentmeta', 'f38_32_posts', 'f38_32_comments', 'f38_32_links', 'f38_32_options', 'f38_32_postmeta', 'f38_32_terms', 'f38_32_term_taxonomy', 'f38_32_term_relationships', 'f38_32_termmeta', 'f38_32_commentmeta', 'f38_34_posts', 'f38_34_comments', 'f38_34_links', 'f38_34_options', 'f38_34_postmeta', 'f38_34_terms', 'f38_34_term_taxonomy', 'f38_34_term_relationships', 'f38_34_termmeta', 'f38_34_commentmeta', 'f38_35_posts', 'f38_35_comments', 'f38_35_links', 'f38_35_options', 'f38_35_postmeta', 'f38_35_terms', 'f38_35_term_taxonomy', 'f38_35_term_relationships', 'f38_35_termmeta', 'f38_35_commentmeta', 'f38_36_posts', 'f38_36_comments', 'f38_36_links', 'f38_36_options', 'f38_36_postmeta', 'f38_36_terms', 'f38_36_term_taxonomy', 'f38_36_term_relationships', 'f38_36_termmeta', 'f38_36_commentmeta', 'f38_38_posts', 'f38_38_comments', 'f38_38_links', 'f38_38_options', 'f38_38_postmeta', 'f38_38_terms', 'f38_38_term_taxonomy', 'f38_38_term_relationships', 'f38_38_termmeta', 'f38_38_commentmeta', 'f38_39_posts', 'f38_39_comments', 'f38_39_links', 'f38_39_options', 'f38_39_postmeta', 'f38_39_terms', 'f38_39_term_taxonomy', 'f38_39_term_relationships', 'f38_39_termmeta', 'f38_39_commentmeta', 'f38_46_posts', 'f38_46_comments', 'f38_46_links', 'f38_46_options', 'f38_46_postmeta', 'f38_46_terms', 'f38_46_term_taxonomy', 'f38_46_term_relationships', 'f38_46_termmeta', 'f38_46_commentmeta', 'f38_51_posts', 'f38_51_comments', 'f38_51_links', 'f38_51_options', 'f38_51_postmeta', 'f38_51_terms', 'f38_51_term_taxonomy', 'f38_51_term_relationships', 'f38_51_termmeta', 'f38_51_commentmeta', 'f38_70_posts', 'f38_70_comments', 'f38_70_links', 'f38_70_options', 'f38_70_postmeta', 'f38_70_terms', 'f38_70_term_taxonomy', 'f38_70_term_relationships', 'f38_70_termmeta', 'f38_70_commentmeta', 'f38_48_posts', 'f38_48_comments', 'f38_48_links', 'f38_48_options', 'f38_48_postmeta', 'f38_48_terms', 'f38_48_term_taxonomy', 'f38_48_term_relationships', 'f38_48_termmeta', 'f38_48_commentmeta', 'f38_49_posts', 'f38_49_comments', 'f38_49_links', 'f38_49_options', 'f38_49_postmeta', 'f38_49_terms', 'f38_49_term_taxonomy', 'f38_49_term_relationships', 'f38_49_termmeta', 'f38_49_commentmeta', 'f38_190_posts', 'f38_190_comments', 'f38_190_links', 'f38_190_options', 'f38_190_postmeta', 'f38_190_terms', 'f38_190_term_taxonomy', 'f38_190_term_relationships', 'f38_190_termmeta', 'f38_190_commentmeta', 'f38_52_posts', 'f38_52_comments', 'f38_52_links', 'f38_52_options', 'f38_52_postmeta', 'f38_52_terms', 'f38_52_term_taxonomy', 'f38_52_term_relationships', 'f38_52_termmeta', 'f38_52_commentmeta', 'f38_166_posts', 'f38_166_comments', 'f38_166_links', 'f38_166_options', 'f38_166_postmeta', 'f38_166_terms', 'f38_166_term_taxonomy', 'f38_166_term_relationships', 'f38_166_termmeta', 'f38_166_commentmeta', 'f38_54_posts', 'f38_54_comments', 'f38_54_links', 'f38_54_options', 'f38_54_postmeta', 'f38_54_terms', 'f38_54_term_taxonomy', 'f38_54_term_relationships', 'f38_54_termmeta', 'f38_54_commentmeta', 'f38_55_posts', 'f38_55_comments', 'f38_55_links', 'f38_55_options', 'f38_55_postmeta', 'f38_55_terms', 'f38_55_term_taxonomy', 'f38_55_term_relationships', 'f38_55_termmeta', 'f38_55_commentmeta', 'f38_124_posts', 'f38_124_comments', 'f38_124_links', 'f38_124_options', 'f38_124_postmeta', 'f38_124_terms', 'f38_124_term_taxonomy', 'f38_124_term_relationships', 'f38_124_termmeta', 'f38_124_commentmeta', 'f38_60_posts', 'f38_60_comments', 'f38_60_links', 'f38_60_options', 'f38_60_postmeta', 'f38_60_terms', 'f38_60_term_taxonomy', 'f38_60_term_relationships', 'f38_60_termmeta', 'f38_60_commentmeta', 'f38_61_posts', 'f38_61_comments', 'f38_61_links', 'f38_61_options', 'f38_61_postmeta', 'f38_61_terms', 'f38_61_term_taxonomy', 'f38_61_term_relationships', 'f38_61_termmeta', 'f38_61_commentmeta', 'f38_63_posts', 'f38_63_comments', 'f38_63_links', 'f38_63_options', 'f38_63_postmeta', 'f38_63_terms', 'f38_63_term_taxonomy', 'f38_63_term_relationships', 'f38_63_termmeta', 'f38_63_commentmeta', 'f38_114_posts', 'f38_114_comments', 'f38_114_links', 'f38_114_options', 'f38_114_postmeta', 'f38_114_terms', 'f38_114_term_taxonomy', 'f38_114_term_relationships', 'f38_114_termmeta', 'f38_114_commentmeta', 'f38_65_posts', 'f38_65_comments', 'f38_65_links', 'f38_65_options', 'f38_65_postmeta', 'f38_65_terms', 'f38_65_term_taxonomy', 'f38_65_term_relationships', 'f38_65_termmeta', 'f38_65_commentmeta', 'f38_113_posts', 'f38_113_comments', 'f38_113_links', 'f38_113_options', 'f38_113_postmeta', 'f38_113_terms', 'f38_113_term_taxonomy', 'f38_113_term_relationships', 'f38_113_termmeta', 'f38_113_commentmeta', 'f38_67_posts', 'f38_67_comments', 'f38_67_links', 'f38_67_options', 'f38_67_postmeta', 'f38_67_terms', 'f38_67_term_taxonomy', 'f38_67_term_relationships', 'f38_67_termmeta', 'f38_67_commentmeta', 'f38_69_posts', 'f38_69_comments', 'f38_69_links', 'f38_69_options', 'f38_69_postmeta', 'f38_69_terms', 'f38_69_term_taxonomy', 'f38_69_term_relationships', 'f38_69_termmeta', 'f38_69_commentmeta', 'f38_72_posts', 'f38_72_comments', 'f38_72_links', 'f38_72_options', 'f38_72_postmeta', 'f38_72_terms', 'f38_72_term_taxonomy', 'f38_72_term_relationships', 'f38_72_termmeta', 'f38_72_commentmeta', 'f38_122_posts', 'f38_122_comments', 'f38_122_links', 'f38_122_options', 'f38_122_postmeta', 'f38_122_terms', 'f38_122_term_taxonomy', 'f38_122_term_relationships', 'f38_122_termmeta', 'f38_122_commentmeta', 'f38_82_posts', 'f38_82_comments', 'f38_82_links', 'f38_82_options', 'f38_82_postmeta', 'f38_82_terms', 'f38_82_term_taxonomy', 'f38_82_term_relationships', 'f38_82_termmeta', 'f38_82_commentmeta', 'f38_83_posts', 'f38_83_comments', 'f38_83_links', 'f38_83_options', 'f38_83_postmeta', 'f38_83_terms', 'f38_83_term_taxonomy', 'f38_83_term_relationships', 'f38_83_termmeta', 'f38_83_commentmeta', 'f38_120_posts', 'f38_120_comments', 'f38_120_links', 'f38_120_options', 'f38_120_postmeta', 'f38_120_terms', 'f38_120_term_taxonomy', 'f38_120_term_relationships', 'f38_120_termmeta', 'f38_120_commentmeta', 'f38_85_posts', 'f38_85_comments', 'f38_85_links', 'f38_85_options', 'f38_85_postmeta', 'f38_85_terms', 'f38_85_term_taxonomy', 'f38_85_term_relationships', 'f38_85_termmeta', 'f38_85_commentmeta', 'f38_119_posts', 'f38_119_comments', 'f38_119_links', 'f38_119_options', 'f38_119_postmeta', 'f38_119_terms', 'f38_119_term_taxonomy', 'f38_119_term_relationships', 'f38_119_termmeta', 'f38_119_commentmeta', 'f38_121_posts', 'f38_121_comments', 'f38_121_links', 'f38_121_options', 'f38_121_postmeta', 'f38_121_terms', 'f38_121_term_taxonomy', 'f38_121_term_relationships', 'f38_121_termmeta', 'f38_121_commentmeta', 'f38_116_posts', 'f38_116_comments', 'f38_116_links', 'f38_116_options', 'f38_116_postmeta', 'f38_116_terms', 'f38_116_term_taxonomy', 'f38_116_term_relationships', 'f38_116_termmeta', 'f38_116_commentmeta', 'f38_90_posts', 'f38_90_comments', 'f38_90_links', 'f38_90_options', 'f38_90_postmeta', 'f38_90_terms', 'f38_90_term_taxonomy', 'f38_90_term_relationships', 'f38_90_termmeta', 'f38_90_commentmeta', 'f38_91_posts', 'f38_91_comments', 'f38_91_links', 'f38_91_options', 'f38_91_postmeta', 'f38_91_terms', 'f38_91_term_taxonomy', 'f38_91_term_relationships', 'f38_91_termmeta', 'f38_91_commentmeta', 'f38_94_posts', 'f38_94_comments', 'f38_94_links', 'f38_94_options', 'f38_94_postmeta', 'f38_94_terms', 'f38_94_term_taxonomy', 'f38_94_term_relationships', 'f38_94_termmeta', 'f38_94_commentmeta', 'f38_171_posts', 'f38_171_comments', 'f38_171_links', 'f38_171_options', 'f38_171_postmeta', 'f38_171_terms', 'f38_171_term_taxonomy', 'f38_171_term_relationships', 'f38_171_termmeta', 'f38_171_commentmeta', 'f38_96_posts', 'f38_96_comments', 'f38_96_links', 'f38_96_options', 'f38_96_postmeta', 'f38_96_terms', 'f38_96_term_taxonomy', 'f38_96_term_relationships', 'f38_96_termmeta', 'f38_96_commentmeta', 'f38_98_posts', 'f38_98_comments', 'f38_98_links', 'f38_98_options', 'f38_98_postmeta', 'f38_98_terms', 'f38_98_term_taxonomy', 'f38_98_term_relationships', 'f38_98_termmeta', 'f38_98_commentmeta', 'f38_99_posts', 'f38_99_comments', 'f38_99_links', 'f38_99_options', 'f38_99_postmeta', 'f38_99_terms', 'f38_99_term_taxonomy', 'f38_99_term_relationships', 'f38_99_termmeta', 'f38_99_commentmeta', 'f38_100_posts', 'f38_100_comments', 'f38_100_links', 'f38_100_options', 'f38_100_postmeta', 'f38_100_terms', 'f38_100_term_taxonomy', 'f38_100_term_relationships', 'f38_100_termmeta', 'f38_100_commentmeta', 'f38_103_posts', 'f38_103_comments', 'f38_103_links', 'f38_103_options', 'f38_103_postmeta', 'f38_103_terms', 'f38_103_term_taxonomy', 'f38_103_term_relationships', 'f38_103_termmeta', 'f38_103_commentmeta', 'f38_104_posts', 'f38_104_comments', 'f38_104_links', 'f38_104_options', 'f38_104_postmeta', 'f38_104_terms', 'f38_104_term_taxonomy', 'f38_104_term_relationships', 'f38_104_termmeta', 'f38_104_commentmeta', 'f38_105_posts', 'f38_105_comments', 'f38_105_links', 'f38_105_options', 'f38_105_postmeta', 'f38_105_terms', 'f38_105_term_taxonomy', 'f38_105_term_relationships', 'f38_105_termmeta', 'f38_105_commentmeta', 'f38_106_posts', 'f38_106_comments', 'f38_106_links', 'f38_106_options', 'f38_106_postmeta', 'f38_106_terms', 'f38_106_term_taxonomy', 'f38_106_term_relationships', 'f38_106_termmeta', 'f38_106_commentmeta', 'f38_107_posts', 'f38_107_comments', 'f38_107_links', 'f38_107_options', 'f38_107_postmeta', 'f38_107_terms', 'f38_107_term_taxonomy', 'f38_107_term_relationships', 'f38_107_termmeta', 'f38_107_commentmeta', 'f38_108_posts', 'f38_108_comments', 'f38_108_links', 'f38_108_options', 'f38_108_postmeta', 'f38_108_terms', 'f38_108_term_taxonomy', 'f38_108_term_relationships', 'f38_108_termmeta', 'f38_108_commentmeta', 'f38_123_posts', 'f38_123_comments', 'f38_123_links', 'f38_123_options', 'f38_123_postmeta', 'f38_123_terms', 'f38_123_term_taxonomy', 'f38_123_term_relationships', 'f38_123_termmeta', 'f38_123_commentmeta', 'f38_117_posts', 'f38_117_comments', 'f38_117_links', 'f38_117_options', 'f38_117_postmeta', 'f38_117_terms', 'f38_117_term_taxonomy', 'f38_117_term_relationships', 'f38_117_termmeta', 'f38_117_commentmeta', 'f38_118_posts', 'f38_118_comments', 'f38_118_links', 'f38_118_options', 'f38_118_postmeta', 'f38_118_terms', 'f38_118_term_taxonomy', 'f38_118_term_relationships', 'f38_118_termmeta', 'f38_118_commentmeta', 'f38_125_posts', 'f38_125_comments', 'f38_125_links', 'f38_125_options', 'f38_125_postmeta', 'f38_125_terms', 'f38_125_term_taxonomy', 'f38_125_term_relationships', 'f38_125_termmeta', 'f38_125_commentmeta', 'f38_126_posts', 'f38_126_comments', 'f38_126_links', 'f38_126_options', 'f38_126_postmeta', 'f38_126_terms', 'f38_126_term_taxonomy', 'f38_126_term_relationships', 'f38_126_termmeta', 'f38_126_commentmeta', 'f38_127_posts', 'f38_127_comments', 'f38_127_links', 'f38_127_options', 'f38_127_postmeta', 'f38_127_terms', 'f38_127_term_taxonomy', 'f38_127_term_relationships', 'f38_127_termmeta', 'f38_127_commentmeta', 'f38_128_posts', 'f38_128_comments', 'f38_128_links', 'f38_128_options', 'f38_128_postmeta', 'f38_128_terms', 'f38_128_term_taxonomy', 'f38_128_term_relationships', 'f38_128_termmeta', 'f38_128_commentmeta', 'f38_129_posts', 'f38_129_comments', 'f38_129_links', 'f38_129_options', 'f38_129_postmeta', 'f38_129_terms', 'f38_129_term_taxonomy', 'f38_129_term_relationships', 'f38_129_termmeta', 'f38_129_commentmeta', 'f38_130_posts', 'f38_130_comments', 'f38_130_links', 'f38_130_options', 'f38_130_postmeta', 'f38_130_terms', 'f38_130_term_taxonomy', 'f38_130_term_relationships', 'f38_130_termmeta', 'f38_130_commentmeta', 'f38_131_posts', 'f38_131_comments', 'f38_131_links', 'f38_131_options', 'f38_131_postmeta', 'f38_131_terms', 'f38_131_term_taxonomy', 'f38_131_term_relationships', 'f38_131_termmeta', 'f38_131_commentmeta', 'f38_132_posts', 'f38_132_comments', 'f38_132_links', 'f38_132_options', 'f38_132_postmeta', 'f38_132_terms', 'f38_132_term_taxonomy', 'f38_132_term_relationships', 'f38_132_termmeta', 'f38_132_commentmeta', 'f38_133_posts', 'f38_133_comments', 'f38_133_links', 'f38_133_options', 'f38_133_postmeta', 'f38_133_terms', 'f38_133_term_taxonomy', 'f38_133_term_relationships', 'f38_133_termmeta', 'f38_133_commentmeta', 'f38_134_posts', 'f38_134_comments', 'f38_134_links', 'f38_134_options', 'f38_134_postmeta', 'f38_134_terms', 'f38_134_term_taxonomy', 'f38_134_term_relationships', 'f38_134_termmeta', 'f38_134_commentmeta', 'f38_135_posts', 'f38_135_comments', 'f38_135_links', 'f38_135_options', 'f38_135_postmeta', 'f38_135_terms', 'f38_135_term_taxonomy', 'f38_135_term_relationships', 'f38_135_termmeta', 'f38_135_commentmeta', 'f38_136_posts', 'f38_136_comments', 'f38_136_links', 'f38_136_options', 'f38_136_postmeta', 'f38_136_terms', 'f38_136_term_taxonomy', 'f38_136_term_relationships', 'f38_136_termmeta', 'f38_136_commentmeta', 'f38_137_posts', 'f38_137_comments', 'f38_137_links', 'f38_137_options', 'f38_137_postmeta', 'f38_137_terms', 'f38_137_term_taxonomy', 'f38_137_term_relationships', 'f38_137_termmeta', 'f38_137_commentmeta', 'f38_138_posts', 'f38_138_comments', 'f38_138_links', 'f38_138_options', 'f38_138_postmeta', 'f38_138_terms', 'f38_138_term_taxonomy', 'f38_138_term_relationships', 'f38_138_termmeta', 'f38_138_commentmeta', 'f38_139_posts', 'f38_139_comments', 'f38_139_links', 'f38_139_options', 'f38_139_postmeta', 'f38_139_terms', 'f38_139_term_taxonomy', 'f38_139_term_relationships', 'f38_139_termmeta', 'f38_139_commentmeta', 'f38_140_posts', 'f38_140_comments', 'f38_140_links', 'f38_140_options', 'f38_140_postmeta', 'f38_140_terms', 'f38_140_term_taxonomy', 'f38_140_term_relationships', 'f38_140_termmeta', 'f38_140_commentmeta', 'f38_141_posts', 'f38_141_comments', 'f38_141_links', 'f38_141_options', 'f38_141_postmeta', 'f38_141_terms', 'f38_141_term_taxonomy', 'f38_141_term_relationships', 'f38_141_termmeta', 'f38_141_commentmeta', 'f38_142_posts', 'f38_142_comments', 'f38_142_links', 'f38_142_options', 'f38_142_postmeta', 'f38_142_terms', 'f38_142_term_taxonomy', 'f38_142_term_relationships', 'f38_142_termmeta', 'f38_142_commentmeta', 'f38_143_posts', 'f38_143_comments', 'f38_143_links', 'f38_143_options', 'f38_143_postmeta', 'f38_143_terms', 'f38_143_term_taxonomy', 'f38_143_term_relationships', 'f38_143_termmeta', 'f38_143_commentmeta', 'f38_144_posts', 'f38_144_comments', 'f38_144_links', 'f38_144_options', 'f38_144_postmeta', 'f38_144_terms', 'f38_144_term_taxonomy', 'f38_144_term_relationships', 'f38_144_termmeta', 'f38_144_commentmeta', 'f38_145_posts', 'f38_145_comments', 'f38_145_links', 'f38_145_options', 'f38_145_postmeta', 'f38_145_terms', 'f38_145_term_taxonomy', 'f38_145_term_relationships', 'f38_145_termmeta', 'f38_145_commentmeta', 'f38_146_posts', 'f38_146_comments', 'f38_146_links', 'f38_146_options', 'f38_146_postmeta', 'f38_146_terms', 'f38_146_term_taxonomy', 'f38_146_term_relationships', 'f38_146_termmeta', 'f38_146_commentmeta', 'f38_147_posts', 'f38_147_comments', 'f38_147_links', 'f38_147_options', 'f38_147_postmeta', 'f38_147_terms', 'f38_147_term_taxonomy', 'f38_147_term_relationships', 'f38_147_termmeta', 'f38_147_commentmeta', 'f38_148_posts', 'f38_148_comments', 'f38_148_links', 'f38_148_options', 'f38_148_postmeta', 'f38_148_terms', 'f38_148_term_taxonomy', 'f38_148_term_relationships', 'f38_148_termmeta', 'f38_148_commentmeta', 'f38_149_posts', 'f38_149_comments', 'f38_149_links', 'f38_149_options', 'f38_149_postmeta', 'f38_149_terms', 'f38_149_term_taxonomy', 'f38_149_term_relationships', 'f38_149_termmeta', 'f38_149_commentmeta', 'f38_150_posts', 'f38_150_comments', 'f38_150_links', 'f38_150_options', 'f38_150_postmeta', 'f38_150_terms', 'f38_150_term_taxonomy', 'f38_150_term_relationships', 'f38_150_termmeta', 'f38_150_commentmeta', 'f38_151_posts', 'f38_151_comments', 'f38_151_links', 'f38_151_options', 'f38_151_postmeta', 'f38_151_terms', 'f38_151_term_taxonomy', 'f38_151_term_relationships', 'f38_151_termmeta', 'f38_151_commentmeta', 'f38_182_posts', 'f38_182_comments', 'f38_182_links', 'f38_182_options', 'f38_182_postmeta', 'f38_182_terms', 'f38_182_term_taxonomy', 'f38_182_term_relationships', 'f38_182_termmeta', 'f38_182_commentmeta', 'f38_181_posts', 'f38_181_comments', 'f38_181_links', 'f38_181_options', 'f38_181_postmeta', 'f38_181_terms', 'f38_181_term_taxonomy', 'f38_181_term_relationships', 'f38_181_termmeta', 'f38_181_commentmeta', 'f38_180_posts', 'f38_180_comments', 'f38_180_links', 'f38_180_options', 'f38_180_postmeta', 'f38_180_terms', 'f38_180_term_taxonomy', 'f38_180_term_relationships', 'f38_180_termmeta', 'f38_180_commentmeta', 'f38_178_posts', 'f38_178_comments', 'f38_178_links', 'f38_178_options', 'f38_178_postmeta', 'f38_178_terms', 'f38_178_term_taxonomy', 'f38_178_term_relationships', 'f38_178_termmeta', 'f38_178_commentmeta', 'f38_177_posts', 'f38_177_comments');

==14352==ERROR: AddressSanitizer: SEGV on unknown address 0x000000000000 (pc 0x5630c4eab756 bp 0x7fbe6d304ad0 sp 0x7fbe6d304a90 T31)

    #0 0x5630c4eab755 in calculate_key_len(TABLE*, unsigned int, unsigned char const*, unsigned long) /data/src/10.3/sql/table.cc:4082

    #1 0x5630c5320509 in handler::prepare_index_key_scan_map(unsigned char const*, unsigned long) /data/src/10.3/sql/handler.h:3086

    #2 0x5630c4d19420 in join_read_always_key /data/src/10.3/sql/sql_select.cc:20419

    #3 0x5630c4d13e31 in sub_select(JOIN*, st_join_table*, bool) /data/src/10.3/sql/sql_select.cc:19665

    #4 0x5630c4d15410 in evaluate_join_record /data/src/10.3/sql/sql_select.cc:19888

    #5 0x5630c4d13fea in sub_select(JOIN*, st_join_table*, bool) /data/src/10.3/sql/sql_select.cc:19668

    #6 0x5630c4d12334 in do_select /data/src/10.3/sql/sql_select.cc:19208

    #7 0x5630c4cad9c0 in JOIN::exec_inner() /data/src/10.3/sql/sql_select.cc:4098

    #8 0x5630c4cab5f3 in JOIN::exec() /data/src/10.3/sql/sql_select.cc:3892

    #9 0x5630c4caead2 in 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*) /data/src/10.3/sql/sql_select.cc:4297

    #10 0x5630c4c88b09 in handle_select(THD*, LEX*, select_result*, unsigned long) /data/src/10.3/sql/sql_select.cc:370

    #11 0x5630c4c0a880 in execute_sqlcom_select /data/src/10.3/sql/sql_parse.cc:6293

    #12 0x5630c4bfa0ed in mysql_execute_command(THD*) /data/src/10.3/sql/sql_parse.cc:3820

    #13 0x5630c4c138bc in mysql_parse(THD*, char*, unsigned int, Parser_state*, bool, bool) /data/src/10.3/sql/sql_parse.cc:7817

    #14 0x5630c4bee628 in dispatch_command(enum_server_command, THD*, char*, unsigned int, bool, bool) /data/src/10.3/sql/sql_parse.cc:1856

    #15 0x5630c4beb507 in do_command(THD*) /data/src/10.3/sql/sql_parse.cc:1401

    #16 0x5630c4f61912 in do_handle_one_connection(CONNECT*) /data/src/10.3/sql/sql_connect.cc:1403

    #17 0x5630c4f612d9 in handle_one_connection /data/src/10.3/sql/sql_connect.cc:1308

    #18 0x7fbe9c9ea4a3 in start_thread (/lib/x86_64-linux-gnu/libpthread.so.0+0x74a3)

    #19 0x7fbe9ab1ed0e in __clone (/lib/x86_64-linux-gnu/libc.so.6+0xe8d0e)

AddressSanitizer can not provide additional info.

SUMMARY: AddressSanitizer: SEGV /data/src/10.3/sql/table.cc:4082 in calculate_key_len(TABLE*, unsigned int, unsigned char const*, unsigned long)

Thread T31 created by T0 here:

    #0 0x7fbe9cc30f59 in __interceptor_pthread_create (/usr/lib/x86_64-linux-gnu/libasan.so.3+0x30f59)

    #1 0x5630c6525b8f in spawn_thread_noop /data/src/10.3/mysys/psi_noop.c:187

    #2 0x5630c49588c0 in inline_mysql_thread_create /data/src/10.3/include/mysql/psi/mysql_thread.h:1275

    #3 0x5630c496de31 in create_thread_to_handle_connection(CONNECT*) /data/src/10.3/sql/mysqld.cc:6608

    #4 0x5630c496e514 in create_new_thread /data/src/10.3/sql/mysqld.cc:6678

    #5 0x5630c496f52c in handle_connections_sockets() /data/src/10.3/sql/mysqld.cc:6953

    #6 0x5630c496d301 in mysqld_main(int, char**) /data/src/10.3/sql/mysqld.cc:6230

    #7 0x5630c4956fdf in main /data/src/10.3/sql/main.cc:25

    #8 0x7fbe9aa562e0 in __libc_start_main (/lib/x86_64-linux-gnu/libc.so.6+0x202e0)

==14352==ABORTING

set @@in_predicate_conversion_threshold=10;

use mysql;

show tables where tables_in_mysql in ('1','2','3','4','5','6','7','8','9');

show tables where tables_in_mysql in ('1','2','3','4','5','6','7','8','9','boom');

(gdb) wher

  #0  THD::fill_derived_tables (this=0x7fffac00bdc8) at /home/psergey/dev-git2/10.5-look/sql/sql_class.h:3804

  #1  0x0000555555e044e7 in mysql_handle_single_derived (lex=0x7fffac00feb0, derived=0x7fffac025d28, phases=96) at /home/psergey/dev-git2/10.5-look/sql/sql_derived.cc:203

  #2  0x0000555555ed2e64 in st_join_table::preread_init (this=0x7fffac074528) at /home/psergey/dev-git2/10.5-look/sql/sql_select.cc:13679

  #3  0x0000555555ee5ff4 in sub_select (join=0x7fffac022f30, join_tab=0x7fffac074528, end_of_records=false) at /home/psergey/dev-git2/10.5-look/sql/sql_select.cc:20774

  #4  0x0000555555ee690c in evaluate_join_record (join=0x7fffac022f30, join_tab=0x7fffac074180, error=0) at /home/psergey/dev-git2/10.5-look/sql/sql_select.cc:21035

  #5  0x0000555555ee61cd in sub_select (join=0x7fffac022f30, join_tab=0x7fffac074180, end_of_records=false) at /home/psergey/dev-git2/10.5-look/sql/sql_select.cc:20812

  #6  0x0000555555ee5686 in do_select (join=0x7fffac022f30, procedure=0x0) at /home/psergey/dev-git2/10.5-look/sql/sql_select.cc:20346

  #7  0x0000555555eb8fa1 in JOIN::exec_inner (this=0x7fffac022f30) at /home/psergey/dev-git2/10.5-look/sql/sql_select.cc:4494

  #8  0x0000555555eb80cd in JOIN::exec (this=0x7fffac022f30) at /home/psergey/dev-git2/10.5-look/sql/sql_select.cc:4274

  #9  0x0000555555eb9909 in mysql_select (thd=0x7fffac00bdc8, tables=0x7fffac0213a8, fields=..., conds=0x7fffac0222e0, og_num=0, order=0x0, group=0x0, having=0x0, proc_param=0x0, select_options=2147748608, result=0x7fffac022f08, unit=0x7fffac00ff78, select_lex=0x7fffac020d98) at /home/psergey/dev-git2/10.5-look/sql/sql_select.cc:4750

  #10 0x0000555555ea9316 in handle_select (thd=0x7fffac00bdc8, lex=0x7fffac00feb0, result=0x7fffac022f08, setup_tables_done_option=0) at /home/psergey/dev-git2/10.5-look/sql/sql_select.cc:443

  #11 0x0000555555e6c510 in execute_sqlcom_select (thd=0x7fffac00bdc8, all_tables=0x7fffac0213a8) at /home/psergey/dev-git2/10.5-look/sql/sql_parse.cc:6313

  #12 0x0000555555e6375e in mysql_execute_command (thd=0x7fffac00bdc8) at /home/psergey/dev-git2/10.5-look/sql/sql_parse.cc:4009

  #13 0x0000555555e7133f in mysql_parse (thd=0x7fffac00bdc8, rawbuf=0x7fffac020ca0 "select * from t10 where a in ('1','2','3','4','5','6','7','8','9','boom')", length=73, parser_state=0x7ffff4134510, is_com_multi=false, is_next_command=false) at /home/psergey/dev-git2/10.5-look/sql/sql_parse.cc:8101

bool LEX::only_view_structure()

{

  switch (sql_command) {

  case SQLCOM_SHOW_CREATE:

  case SQLCOM_CHECKSUM:

  case SQLCOM_SHOW_TABLES:

  case SQLCOM_SHOW_FIELDS:

  case SQLCOM_REVOKE_ALL:

  case SQLCOM_REVOKE:

  case SQLCOM_GRANT:

  case SQLCOM_CREATE_VIEW:

    return TRUE;

  case SQLCOM_CREATE_TABLE:

    return create_info.like();

  default:

    return FALSE;

  }

}

  inline bool fill_derived_tables()

  {

    return !stmt_arena->is_stmt_prepare() && !lex->only_view_structure();

  }

TABLE *create_schema_table(THD *thd, TABLE_LIST *table_list)

{

  bool need_all_fieds= table_list->schema_table_reformed || // SHOW command

                       thd->lex->only_view_structure(); // need table structure

  ...

  create_tmp_table_for_schema( .... !need_all_fields ...);

  ...

}

use mysql;

show tables where tables_in_mysql in (select * from (values ('1'),('2'),('3')) dt);

use test;

create table t1 (nm varchar(32));

insert into t1 values ('1'),('2'),('3');

use mysql;

show tables where tables_in_mysql in (select * from (select * from test.t1 group by nm) dt);

$1 = 0x55555713bd80 <dbug_item_print_buf> "select information_schema.TABLE_NAMES.`TABLE_NAME` AS Tables_in_mysql from ((select test.t1.nm AS nm from test.t1 group by test.t1.nm) dt) where information_schema.TABLE_NAMES.`TABLE_NAME` = convert(d"...

select * from INFORMATION_SCHEMA.TABLES where TABLE_NAME in (select * from (select * from test.t1 group by nm) dt);

 show fields from test.t1

   where Field in (select * from (select nm from test.t1 group by nm) dt);

show fields from test.t1

   where Field in

        (select * from (select column_name from information_schema.columns

                          where table_name='t1'

                            group by column_name) dt);

diff --git a/sql/sql_base.cc b/sql/sql_base.cc

index 3403f9e..16689f8 100644

--- a/sql/sql_base.cc

+++ b/sql/sql_base.cc

@@ -4939,7 +4939,6 @@ bool open_normal_and_derived_tables(THD *thd, TABLE_LIST *tables, uint flags,

   uint counter;

   MDL_savepoint mdl_savepoint= thd->mdl_context.mdl_savepoint();

   DBUG_ENTER("open_normal_and_derived_tables");

-  DBUG_ASSERT(!thd->fill_derived_tables());

   if (open_tables(thd, &tables, &counter, flags, &prelocking_strategy) ||

       mysql_handle_derived(thd->lex, dt_phases))

     goto end;

diff --git a/sql/sql_lex.cc b/sql/sql_lex.cc

index c534ba7..149a2bb 100644

--- a/sql/sql_lex.cc

+++ b/sql/sql_lex.cc

@@ -3095,8 +3095,6 @@ bool LEX::only_view_structure()

 {

   switch (sql_command) {

   case SQLCOM_SHOW_CREATE:

-  case SQLCOM_SHOW_TABLES:

-  case SQLCOM_SHOW_FIELDS:

   case SQLCOM_REVOKE_ALL:

   case SQLCOM_REVOKE:

   case SQLCOM_GRANT:

diff --git a/sql/sql_base.cc b/sql/sql_base.cc

index 74ac1a3..031baee 100644

--- a/sql/sql_base.cc

+++ b/sql/sql_base.cc

@@ -5187,7 +5187,6 @@ bool open_normal_and_derived_tables(THD *thd, TABLE_LIST *tables, uint flags,

   uint counter;

   MDL_savepoint mdl_savepoint= thd->mdl_context.mdl_savepoint();

   DBUG_ENTER("open_normal_and_derived_tables");

-  DBUG_ASSERT(!thd->fill_derived_tables());

   if (open_tables(thd, &tables, &counter, flags, &prelocking_strategy) ||

       mysql_handle_derived(thd->lex, dt_phases))

     goto end;

diff --git a/sql/sql_lex.cc b/sql/sql_lex.cc

index 5604658..3866d82 100644

--- a/sql/sql_lex.cc

+++ b/sql/sql_lex.cc

@@ -3358,8 +3358,6 @@ bool LEX::only_view_structure()

   switch (sql_command) {

   case SQLCOM_SHOW_CREATE:

   case SQLCOM_CHECKSUM:

-  case SQLCOM_SHOW_TABLES:

-  case SQLCOM_SHOW_FIELDS:

   case SQLCOM_REVOKE_ALL:

   case SQLCOM_REVOKE:

   case SQLCOM_GRANT:

diff --git a/sql/sql_show.cc b/sql/sql_show.cc

index 6b020f6..bf72c59 100644

--- a/sql/sql_show.cc

+++ b/sql/sql_show.cc

@@ -8140,7 +8140,9 @@ TABLE *create_schema_table(THD *thd, TABLE_LIST *table_list)

   CHARSET_INFO *cs= system_charset_info;

   MEM_ROOT *mem_root= thd->mem_root;

   bool need_all_fieds= table_list->schema_table_reformed || // SHOW command

-                       thd->lex->only_view_structure(); // need table structure

+                       thd->lex->only_view_structure() || // need table structure

+                       thd->lex->sql_command == SQLCOM_SHOW_FIELDS ||

+                       thd->lex->sql_command == SQLCOM_SHOW_TABLES;

   DBUG_ENTER("create_schema_table");

   for (; fields_info->field_name; fields_info++)

  for (uint phase= 0; phase < DT_PHASES; phase++)

  {

    uint phase_flag= DT_INIT << phase;

    if (phase_flag > phases)

      break;

    if (!(phases & phase_flag))

      continue;

    /* Skip derived tables to which the phase isn't applicable.  */

    if (phase_flag != DT_PREPARE &&

        !(allowed_phases & phase_flag))

      continue;

    if (phase_flag >= DT_CREATE && !thd->fill_derived_tables())

      break;

    if ((res= (*processors[phase])(lex->thd, lex, derived)))

      break;

  }

bool open_tables_only_view_structure(THD *thd, TABLE_LIST *table_list,

                                     bool can_deadlock)

{

...

  bool rc= (thd->open_temporary_tables(table_list) ||

           open_normal_and_derived_tables(thd, table_list,

                                          (MYSQL_OPEN_IGNORE_FLUSH |

                                           MYSQL_OPEN_FORCE_SHARED_HIGH_PRIO_MDL |

                                           MYSQL_OPEN_GET_NEW_TABLE |

                                           (can_deadlock ?

                                            MYSQL_OPEN_FAIL_ON_MDL_CONFLICT : 0)),

                                          DT_INIT | DT_PREPARE | DT_CREATE));

...

}

diff --git a/sql/sql_base.cc b/sql/sql_base.cc

--- a/sql/sql_base.cc

+++ b/sql/sql_base.cc

@@ -5245,7 +5245,7 @@ bool open_tables_only_view_structure(THD *thd, TABLE_LIST *table_list,

                                            MYSQL_OPEN_GET_NEW_TABLE |

                                            (can_deadlock ?

                                             MYSQL_OPEN_FAIL_ON_MDL_CONFLICT : 0)),

-                                          DT_INIT | DT_PREPARE | DT_CREATE));

+                                          DT_INIT | DT_PREPARE));

   /*

     Restore old value of sql_command back as it is being looked at in

     process_table() function.

diff --git a/sql/sql_derived.cc b/sql/sql_derived.cc

--- a/sql/sql_derived.cc

+++ b/sql/sql_derived.cc

@@ -85,7 +85,7 @@ mysql_handle_derived(LEX *lex, uint phases)

       break;

     if (!(phases & phase_flag))

       continue;

-    if (phase_flag >= DT_CREATE && !thd->fill_derived_tables())

+    if (phase_flag >= DT_CREATE && thd->stmt_arena->is_stmt_prepare())

       break;

     for (SELECT_LEX *sl= lex->all_selects_list;

@@ -193,7 +193,7 @@ mysql_handle_single_derived(LEX *lex, TABLE_LIST *derived, uint phases)

     if (phase_flag != DT_PREPARE &&

         !(allowed_phases & phase_flag))

       continue;

-    if (phase_flag >= DT_CREATE && !thd->fill_derived_tables())

+    if (phase_flag >= DT_CREATE && thd->stmt_arena->is_stmt_prepare())

       break;

     if ((res= (*processors[phase])(lex->thd, lex, derived)))