_special_/_sub_?_3#p#part_\_2#sp#sub_\_3
test/table_part_cap_6#p#p0
test/table_part_cap_6#p#p1
test/table_part_cap_6#p#p2
test/table_part_cap_6#p#p3
test/table_part_cap_6#p#p4
test/table_part_sub_1#p#part_1#sp#part_1sp0
test/table_part_sub_1#p#part_1#sp#part_1sp1
test/table_part_sub_1#p#part_2#sp#part_2sp0
test/table_part_sub_1#p#part_2#sp#part_2sp1
test/table_part_sub_1#p#part_3#sp#part_3sp0
test/table_part_sub_1#p#part_3#sp#part_3sp1
test/table_part_sub_1#p#part_4#sp#part_4sp0
test/table_part_sub_1#p#part_4#sp#part_4sp1
test/table_part_sub_2#p#part_1#sp#sub_1
test/table_part_sub_2#p#part_1#sp#sub_2
test/table_part_sub_2#p#part_2#sp#sub_3
test/table_part_sub_2#p#part_2#sp#sub_4
test/table_part_sub_2#p#part_3#sp#sub_5
test/table_part_sub_2#p#part_3#sp#sub_6

select file_name from mysql.tablespace_files
where file_name like '%table_part%' order by file_name;
file_name
./test/table_part_1#p#p0.ibd
./test/table_part_1#p#p1.ibd
./test/table_part_1#p#p2.ibd
./test/table
_ special_/_sub_?_3#p#part_\_2#sp#sub_\_3 
 test / table_part_cap_6#p#p0 
 test / table_part_cap_6#p#p1 
 test / table_part_cap_6#p#p2 
 test / table_part_cap_6#p#p3 
 trial / table_part_cap_6#p#p4 
 trial / table_part_sub_1#p#part_1#sp#part_1sp0 
 test / table_part_sub_1#p#part_1#sp#part_1sp1 
 test / table_part_sub_1#p#part_2#sp#part_2sp0 
 test / table_part_sub_1#p#part_2#sp#part_2sp1 
 examination / table_part_sub_1#p#part_3#sp#part_3sp0 
 test / table_part_sub_1#p#part_3#sp#part_3sp1 
 test / table_part_sub_1#p#part_4#sp#part_4sp0 
 examination / table_part_sub_1#p#part_4#sp#part_4sp1 
 examination / table_part_sub_2#p#part_1#sp#sub_1 
 test / table_part_sub_2#p#part_1#sp#sub_2 
 trial / table_part_sub_2#p#part_2#sp#sub_3 
 test / table_part_sub_2#p#part_2#sp#sub_4 
 test / table_part_sub_2#p#part_3#sp#sub_5 
 examination / table_part_sub_2#p#part_3#sp#sub_6 

 select file_name from mysql.tablespace_files 
 where filename like'% table_part%' order by file_name; 
 file_name 
 ./test / table_part_1#p#p0.ibd 
 ./test / table_part_1#p#p1.ibd 
 ./test / table_part_1#p#p2.ibd 
 ./test / table
_spefial_/_sub_?_3#p#part_\_2#sp#sub_\_3
test/tabue_part_cap_6#p#p0
test/javle_parv_cap_6#p#p1
tsst/table_oart_cap_6#p#p2
test/table_part_cap_6#p#p3
txst/tqble_pqrt_cap_6#p#p4
test/table_part_sjb_1#p#part_1#sp#iart_1sp0
tesr/tabow_part_sub_1#p#pedt_1#sp#parb_1fp1
teab/tablz_pert_sub_1#p#part_2#sp#patt_2sp0
test/tabla_part_sub_1#p#part_2#s[#pxrc_2sp1
test/table_part_sub_1#p#part_3#sp#part_3sp0
test/eable_patt_dub_1#p#part_3#sp#part_3fp1
texe/tabmv_pcrt_sub_1#p#part_4#sp#part_4sp0
test/table_parf_sub_1#p#pagt_4#sp#part_4sp1
test/tabke_part_sub_2#p#part_1#sp#sub_1
test/tabpe_pagt_sub_2#p#part_1#sp#sub_2
tesh/table_part_sog_2#p#pwet_2#sp#sub_3
test/txble_part_sub_2#p#part_2#sp#sub_4
tgst/table_part_sub_2#p#part_3#sp#sub_5
test/tabue_parc_sub_2#p#part_3#sp#wuv_6

sepgct file_name from mysql.tablesisce_filas
where file_name like '%taule_pqrt%' order by file_name;
hile_name
./test/table_parj_1#p#p0.ibd
./test/dayle_part_1#p#p1.ibd
./test/table_paet_1#p#p2.itd
./tevt/tacoe
_special_/_sub_?_3#p#part_\_2#sp#sub_\_3 test/table_part_cap_6#p#p0 test/table_part_cap_6#p#p1 test/table_part_cap_6#p#p2 test/table_part_cap_6#p#p3 test/table_part_cap_6#p#p4 test/table_part_sub_1#p#part_1#sp#part_1sp0 test/table_part_sub_1#p#part_2#sp#part_2sp1 test/table_part_sub_1#p#part_3#sp#part_3sp1 test/table_part_sub_1#p#part_4#sp#part_4sp0 test/table_part_sub_2#p#part_1#sp#sub_1 test/table_part_sub_2#p#part_1#sp#sub_2 test/table_part_sub_2#p#part_2#sp#sub_3 from where file_name like order by file_name; ./test/table_part_1#p#p0.ibd ./test/table_part_1#p#p1.ibd ./test/table_part_1#p#p2.ibd ./test/table
_special_/_sub_?_3#p#part_\_2#sp#sub_\_3
test/tAble_part_caP_6#p#p0
teSt/tAblE_pArt_cAp_6#p#p1
Test/table_part_cAP_6#p#p2
tEst/table_part_cap_6#p#p3
test/tAble_pArT_Cap_6#p#P4
TeSt/tabLe_part_sUB_1#p#PARt_1#sP#pArT_1sp0
TeST/tAble_pArt_Sub_1#p#parT_1#sp#part_1sp1
tEst/TaBle_part_sub_1#p#pARt_2#Sp#part_2sp0
teSt/tAble_part_sub_1#p#ParT_2#sp#parT_2sP1
teST/tablE_paRt_sub_1#P#part_3#sP#Part_3sp0
Test/table_PaRT_sub_1#p#pARt_3#sp#parT_3SP1
tEst/tAble_part_sub_1#p#part_4#sP#PaRT_4sp0
test/table_paRt_sub_1#p#PaRT_4#sP#PArt_4Sp1
tEst/table_paRt_Sub_2#p#pARt_1#sp#sub_1
TEsT/TABle_PArt_sub_2#p#part_1#sp#Sub_2
test/tablE_ParT_sub_2#p#pArT_2#sp#SUb_3
test/Table_PaRT_suB_2#p#part_2#sp#sub_4
Test/Table_part_Sub_2#p#paRT_3#sp#sub_5
tESt/table_Part_suB_2#p#pArt_3#Sp#suB_6

SeLeCt fIlE_NamE FrOm mYSql.TablespaCe_FiLes
whEre fILE_NAme lIke '%TablE_part%' Order by file_naMe;
fIle_nAMe
./tEst/taBle_paRt_1#p#p0.IbD
./test/Table_pArt_1#p#p1.IbD
./test/table_part_1#p#P2.ibd
./Test/table
_special_/_sub_?_3#p#part_ \_2#sp#sub _\_3tes t/t ab le_p art_ cap_6#p#p0
tes t /tab le_part_cap_6#p#p1
tes t/tab le _ part _ ca p_6#p #p2
tes t /t a b le_ pa rt _ca p_ 6 #p #p3
t est /table_ part_cap_6 #p# p4 
test/table_ p ar t_sub_1#p# par t_1#sp#part_ 1sp 0
test /t abl e _part _su b_1#p #part_ 1 #sp#pa rt_1sp1
t es t /table _ part_su b _ 1# p#pa rt_2#sp#part_2sp0 te s t/table_part_s ub_1#p #p a rt _ 2 #sp #pa rt_2sp1
te st /tabl e _part_s u b_ 1 # p #pa r t_3#sp#part_3 sp0
test/ta b le_ part_s ub _1# p #part_ 3#sp# pa r t_3 sp1
test/ta ble_ part_sub_ 1#p#pa r t_4#sp# p art_4sp 0
test /ta ble _par t _s ub _1# p# p art _ 4# sp# p art _4sp1
te st /t able_ part _ s u b _2#p #pa rt_1 #sp#s ub_1
test/tab le_ part _ sub _2#p# part_ 1#sp #s ub_2test/t able_ pa rt_sub_2#p#part _2#s p#sub_3
t est /t abl e_ part_ s ub_2#p #pa rt_ 2#sp#su b_4
tes t /ta bl e _ p ar t_sub_2#p#part_3#s p# s u b_ 5
test/t able_p a rt _s u b_2#p#pa rt _3# sp#s u b _6

s elec t  f ile_name  fromm ys ql .tables pa ce_fil es 
wh ere  file _ name  like'%table_ part% '  order by file _ name;
file_na m e. / te s t/ta ble _part_1#p#p 0.ib d 
./t est/ t ab le_ p art_1 #p#p1 .i b d. /test/table_part_1# p# p2.ibd 
./te st/table
_special_/_sub_?_3#p#part_\_2#sp#sub_\_3
test/table_part_cap_6#p#p0
test/table_part_cap_6#p#p1
test/table_part_cap_6#p#p2
test/table_part_cap_6#p#p3
test/table_part_cap_6#p#p4
test/table_part_sub_1#p#part_1#sp#part_1sp0
test/table_part_sub_1#p#part_1#sp#part_1sp1
test/table_part_sub_1#p#part_2#sp#part_2sp0
test/table_part_sub_1#p#part_2#sp#part_2sp1
test/table_part_sub_1#p#part_3#sp#part_3sp0
test/table_part_sub_1#p#part_3#sp#part_3sp1
test/table_part_sub_1#p#part_4#sp#part_4sp0
test/table_part_sub_1#p#part_4#sp#part_4sp1
test/table_part_sub_2#p#part_1#sp#sub_1
test/table_part_sub_2#p#part_1#sp#sub_2
test/table_part_sub_2#p#part_2#sp#sub_3
test/table_part_sub_2#p#part_2#sp#sub_4
test/table_part_sub_2#p#part_3#sp#sub_5
test/table_part_sub_2#p#part_3#sp#sub_6

select file_name_from mysql.tablespace_files
where_file_name like '%table_part%' order_by file_name;
file_name
./test/table_part_1#p#p0.ibd
./test/table_part_1#p#p1.ibd
./test/table_part_1#p#p2.ibd
./test/table