Debian Codegraph @

mysql-test/suite/innodb/r/innodb_stats_table_flag_sample_pages.result

raw
1 CREATE TABLE test_ps_sample_pages (a INT, PRIMARY KEY (a)) ENGINE=INNODB;
2 SHOW CREATE TABLE test_ps_sample_pages;
3 Table test_ps_sample_pages
4 Create Table CREATE TABLE `test_ps_sample_pages` (
5 `a` int NOT NULL,
6 PRIMARY KEY (`a`)
7 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
8 SELECT create_options FROM information_schema.tables
9 WHERE table_name='test_ps_sample_pages';
10 CREATE_OPTIONS
11 ALTER TABLE test_ps_sample_pages STATS_SAMPLE_PAGES=12345;
12 # restart
13 SHOW CREATE TABLE test_ps_sample_pages;
14 Table test_ps_sample_pages
15 Create Table CREATE TABLE `test_ps_sample_pages` (
16 `a` int NOT NULL,
17 PRIMARY KEY (`a`)
18 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci STATS_SAMPLE_PAGES=12345
19 SELECT create_options FROM information_schema.tables
20 WHERE table_name='test_ps_sample_pages';
21 CREATE_OPTIONS stats_sample_pages=12345
22 DROP TABLE test_ps_sample_pages;
23 CREATE TABLE test_ps_sample_pages (a INT, PRIMARY KEY (a)) ENGINE=INNODB
24 STATS_SAMPLE_PAGES=default;
25 SHOW CREATE TABLE test_ps_sample_pages;
26 Table test_ps_sample_pages
27 Create Table CREATE TABLE `test_ps_sample_pages` (
28 `a` int NOT NULL,
29 PRIMARY KEY (`a`)
30 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
31 SELECT create_options FROM information_schema.tables
32 WHERE table_name='test_ps_sample_pages';
33 CREATE_OPTIONS
34 DROP TABLE test_ps_sample_pages;
35 CREATE TABLE test_ps_sample_pages (a INT, PRIMARY KEY (a)) ENGINE=INNODB
36 STATS_SAMPLE_PAGES=-5;
37 ERROR 42000: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '-5' at line 2
38 CREATE TABLE test_ps_sample_pages (a INT, PRIMARY KEY (a)) ENGINE=INNODB
39 STATS_SAMPLE_PAGES=0;
40 ERROR 42000: The valid range for stats_sample_pages is [1, 65535]. Error near '0' at line 2
41 CREATE TABLE test_ps_sample_pages (a INT, PRIMARY KEY (a)) ENGINE=INNODB
42 STATS_SAMPLE_PAGES=67000;
43 ERROR 42000: The valid range for stats_sample_pages is [1, 65535]. Error near '67000' at line 2
44 CREATE TABLE test_ps_sample_pages (a INT, PRIMARY KEY (a)) ENGINE=INNODB
45 STATS_SAMPLE_PAGES=670000;
46 ERROR 42000: The valid range for stats_sample_pages is [1, 65535]. Error near '670000' at line 2
47 CREATE TABLE test_ps_sample_pages (a INT, PRIMARY KEY (a)) ENGINE=INNODB
48 STATS_SAMPLE_PAGES=65536;
49 ERROR 42000: The valid range for stats_sample_pages is [1, 65535]. Error near '65536' at line 2
50 CREATE TABLE test_ps_sample_pages (a INT, PRIMARY KEY (a)) ENGINE=INNODB
51 STATS_SAMPLE_PAGES=65535;
52 SHOW CREATE TABLE test_ps_sample_pages;
53 Table test_ps_sample_pages
54 Create Table CREATE TABLE `test_ps_sample_pages` (
55 `a` int NOT NULL,
56 PRIMARY KEY (`a`)
57 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci STATS_SAMPLE_PAGES=65535
58 DROP TABLE test_ps_sample_pages;
59 CREATE TABLE test_ps_sample_pages (a INT, PRIMARY KEY (a)) ENGINE=INNODB
60 STATS_SAMPLE_PAGES=1;
61 # restart
62 SHOW CREATE TABLE test_ps_sample_pages;
63 Table test_ps_sample_pages
64 Create Table CREATE TABLE `test_ps_sample_pages` (
65 `a` int NOT NULL,
66 PRIMARY KEY (`a`)
67 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci STATS_SAMPLE_PAGES=1
68 SELECT create_options FROM information_schema.tables
69 WHERE table_name='test_ps_sample_pages';
70 CREATE_OPTIONS stats_sample_pages=1
71 DROP TABLE test_ps_sample_pages;
72 CREATE TABLE test_ps_sample_pages (a INT, PRIMARY KEY (a)) ENGINE=INNODB
73 STATS_SAMPLE_PAGES=5678;
74 # restart
75 SHOW CREATE TABLE test_ps_sample_pages;
76 Table test_ps_sample_pages
77 Create Table CREATE TABLE `test_ps_sample_pages` (
78 `a` int NOT NULL,
79 PRIMARY KEY (`a`)
80 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci STATS_SAMPLE_PAGES=5678
81 SELECT create_options FROM information_schema.tables
82 WHERE table_name='test_ps_sample_pages';
83 CREATE_OPTIONS stats_sample_pages=5678
84 ALTER TABLE test_ps_sample_pages STATS_SAMPLE_PAGES=default;
85 # restart
86 SHOW CREATE TABLE test_ps_sample_pages;
87 Table test_ps_sample_pages
88 Create Table CREATE TABLE `test_ps_sample_pages` (
89 `a` int NOT NULL,
90 PRIMARY KEY (`a`)
91 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
92 SELECT create_options FROM information_schema.tables
93 WHERE table_name='test_ps_sample_pages';
94 CREATE_OPTIONS
95 DROP TABLE test_ps_sample_pages;