| 1 |
# Remove number output from "last_altered" value |
| 2 |
--let $p1=/("last_altered": )[0-9]+/\1NNN/ |
| 3 |
|
| 4 |
# Remove number output from "created" value |
| 5 |
--let $p2=/("created": )[0-9]+/\1NNN/ |
| 6 |
|
| 7 |
# Remove se_private_data: id & trx_id output. retain the root page number value |
| 8 |
--let $p3=/("se_private_data":) "id=[0-9]+;root=[0-9]+;space_id=[0-9]+;table_id=[0-9]+;trx_id=[0-9]+;"/\1 "id=A;root=B;space_id=C,table_id=D,trx_id=E"/ |
| 9 |
|
| 10 |
# Remove se_private_data: id & trx_id output. retain the root page number value |
| 11 |
--let $p4=/("se_private_data":) "id=[0-9]+;root=[0-9]+;trx_id=[0-9]+;"/\1 "id=X;root=Y;trx_id=Z"/ |
| 12 |
|
| 13 |
# Remove se_private_data: id. |
| 14 |
--let $p5=/("se_private_data":) "id=[0-9]+;"/\1 "id=X"/ |
| 15 |
|
| 16 |
# Remove se_private_data: table_id. |
| 17 |
--let $p6=/("se_private_data":) "table_id=[0-9]+;"/\1 "table_id=X"/ |
| 18 |
|
| 19 |
# Remove se_private_id: id. This is innodb table_id |
| 20 |
--let $p7=/("se_private_id":) [0-9]+/\1NNN/ |
| 21 |
|
| 22 |
# Remove object_id output |
| 23 |
--let $p8=/("id": )[0-9]+/\1X/ |
| 24 |
|
| 25 |
# Remove file_per_tablespace id output in dd::Table |
| 26 |
--let $p9=/("tablespace_ref": "innodb_file_per_table.)[0-9]+"/\1X"/ |
| 27 |
|
| 28 |
# Remove file_per_tablespace id output in dd::Tablespace |
| 29 |
--let p10=/("name": "innodb_file_per_table.)[0-9]+"/\1X"/ |
| 30 |
|
| 31 |
# Remove id output in se_prvate_data of dd::Tablespace |
| 32 |
--let $p11=/("se_private_data": ")(discard=[0-1];)*(flags=)([0-9]+)(;id=)([0-9]+)(;server_version=)([0-9]+)(;space_version=)([0-9]+);/\1\3X\5Y\7Z\9M;/ |
| 33 |
|
| 34 |
# Remove version id |
| 35 |
--let $p12=/("[a-z_]+_version_id": )[0-9]+/\1X/ |
| 36 |
|
| 37 |
# Remove extra path separator seen on windows and partition names |
| 38 |
--let $p13=/\/\//\// /#P#/#p#/ /#SP#/#sp#/ |
| 39 |
|
| 40 |
# Remove any version id |
| 41 |
--let $p15=/("[a-z_]+_version": )[0-9]+/\1X/ |
| 42 |
|
| 43 |
--let $ibd2sdi_pattern=$p1 $p2 $p3 $p4 $p5 $p6 $p7 $p8 $p9 $p10 $p11 $p12 $p13 $p15 |
| 44 |
|
| 45 |
# Remove se_private_data: null and table_id in dd::Column::se_private_data |
| 46 |
--let $p16=/("se_private_data":) "default_null=[0-1];table_id=[0-9]+;"/\1 "default_null=X;table_id=Y"/ |
| 47 |
|
| 48 |
--let $ibd2sdi_pattern=$p1 $p2 $p3 $p4 $p5 $p6 $p7 $p8 $p9 $p10 $p11 $p12 $p13 $p15 $p16 |
| 49 |
|
| 50 |
# Remove root also for tables in System tablespace |
| 51 |
--let $p3_1=/("se_private_data":) "id=[0-9]+;root=[0-9]+;space_id=[0-9]+;table_id=[0-9]+;trx_id=[0-9]+;"/\1 "id=A;root=B;space_id=C;table_id=D;trx_id=E"/ |
| 52 |
|
| 53 |
# Remove se_private_data: id & trx_id output. retain the root page number value |
| 54 |
--let $p3_2=/("se_private_data":) "id=[0-9]+;root=[0-9]+;trx_id=[0-9]+;"/\1 "id=X;root=Y;trx_id=Z"/ |
| 55 |
|
| 56 |
# Remove se_private_data: id. |
| 57 |
--let $p3_3=/("se_private_data":) "id=[0-9]+;"/\1 "id=X"/ |
| 58 |
|
| 59 |
# Remove se_private_data: table_id. |
| 60 |
--let $p3_4=/("se_private_data":) "table_id=[0-9]+;"/\1 "table_id=X"/ |
| 61 |
|
| 62 |
--let $ibd2sdi_pattern_system=$p1 $p2 $p3_1 $p3_2 $p3_3 $p3_4 $p4 $p5 $p6 $p7 $p8 $p9 $p10 $p11 $p12 $p13 $p15 $p16 |
| 63 |
|
| 64 |
# Remove collation_id only for dictionary tables |
| 65 |
--let $p15=/("collation_id": )[0-9]+/\1X/ |
| 66 |
|
| 67 |
--let $ibd2sdi_pattern_mysql= $ibd2sdi_pattern $p15 |