| 1 |
# |
| 2 |
# WL7900 -- New DD: Support flexible creation and versioning of |
| 3 |
# virtual P_S tables |
| 4 |
# |
| 5 |
CALL mtr.add_suppression("Native table .* has the wrong structure"); |
| 6 |
# Case 1: |
| 7 |
# Restart server with the actual P_S version number differed |
| 8 |
# from the expected version number. |
| 9 |
# - Using a debug flag for testing. |
| 10 |
# - Check if abandoned P_S table is removed, in case server version is |
| 11 |
# changed. The test case expects P_S.cond_instances to be missed. |
| 12 |
# check that in normal mode the table P_S.cond_instances exists. |
| 13 |
SELECT COUNT(*) FROM performance_schema.cond_instances; |
| 14 |
COUNT(*) |
| 15 |
# |
| 16 |
# restart:--debug=+d,test_p_s_metadata_version |
| 17 |
SELECT COUNT(*) FROM performance_schema.cond_instances; |
| 18 |
ERROR 42S02: Table 'performance_schema.cond_instances' doesn't exist |
| 19 |
# Case 2: |
| 20 |
# Restart server should fail if P_S version is changed |
| 21 |
# and --innodb-read-only mode is ON. |
| 22 |
Can't open shared library component_reference_cache |
| 23 |
Can't open shared library component_reference_cache |
| 24 |
# restart:--debug=-d,test_p_s_metadata_version |