| 1 |
@@ -18,7 +18,7 @@ |
| 2 |
test.test_ps_flag analyze status OK |
| 3 |
SELECT COUNT(*) AS cnt_after FROM mysql.innodb_table_stats WHERE table_name = 'test_ps_flag'; |
| 4 |
cnt_after |
| 5 |
-1 |
| 6 |
+0 |
| 7 |
DROP TABLE test_ps_flag; |
| 8 |
CREATE TABLE test_ps_flag (a INT) ENGINE=INNODB STATS_PERSISTENT=default; |
| 9 |
SHOW CREATE TABLE test_ps_flag; |
| 10 |
@@ -37,7 +37,7 @@ |
| 11 |
test.test_ps_flag analyze status OK |
| 12 |
SELECT COUNT(*) AS cnt_after FROM mysql.innodb_table_stats WHERE table_name = 'test_ps_flag'; |
| 13 |
cnt_after |
| 14 |
-1 |
| 15 |
+0 |
| 16 |
DROP TABLE test_ps_flag; |
| 17 |
===== |
| 18 |
=== Test ANALYZE behavior after creation with explicit PS=OFF |
| 19 |
@@ -142,7 +142,7 @@ |
| 20 |
test.test_ps_flag analyze status OK |
| 21 |
SELECT COUNT(*) AS cnt_after FROM mysql.innodb_table_stats WHERE table_name = 'test_ps_flag'; |
| 22 |
cnt_after |
| 23 |
-1 |
| 24 |
+0 |
| 25 |
DROP TABLE test_ps_flag; |
| 26 |
===== |
| 27 |
=== Test ANALYZE behavior after creation with explicit PS=ON, |
| 28 |
@@ -203,5 +203,5 @@ |
| 29 |
test.test_ps_flag analyze status OK |
| 30 |
SELECT COUNT(*) AS cnt_after FROM mysql.innodb_table_stats WHERE table_name = 'test_ps_flag'; |
| 31 |
cnt_after |
| 32 |
-1 |
| 33 |
+0 |
| 34 |
DROP TABLE test_ps_flag; |