Details
-
Bug
-
Status: Open (View Workflow)
-
Minor
-
Resolution: Unresolved
-
5.5, 10.0, 10.1, 10.5.9, 10.2, 10.3, 10.4, 10.5
-
None
-
n.a.
Description
When I create an aria table the first time page_checksum is not listed in show table status when the table is created the first time. when alter is done later it is listed:
|
create table t (id int) engine = aria;
|
|
show create table t\G
|
*************************** 1. row ***************************
|
Table: t
|
Create Table: CREATE TABLE `t` (
|
`id` int(11) DEFAULT NULL
|
) ENGINE=Aria DEFAULT CHARSET=latin1 PAGE_CHECKSUM=1
|
|
show table status like 't'\G
|
*************************** 1. row ***************************
|
Name: t
|
Engine: Aria
|
...
|
Checksum: NULL
|
Create_options: transactional=1
|
Comment:
|
|
alter table t table_checksum=1;
|
|
|
show create table t\G
|
*************************** 1. row ***************************
|
Table: t
|
Create Table: CREATE TABLE `t` (
|
`id` int(11) DEFAULT NULL
|
) ENGINE=Aria DEFAULT CHARSET=latin1 CHECKSUM=1 PAGE_CHECKSUM=1
|
|
show table status like 't'\G
|
*************************** 1. row ***************************
|
Name: t
|
Engine: Aria
|
Checksum: 0
|
Create_options: checksum=1 page_checksum=1 transactional=1
|
|
alter table t table_checksum=0;
|
show create table t\G
|
*************************** 1. row ***************************
|
Table: t
|
Create Table: CREATE TABLE `t` (
|
`id` int(11) DEFAULT NULL
|
) ENGINE=Aria DEFAULT CHARSET=latin1 PAGE_CHECKSUM=1
|
|
show table status like 't'\G
|
*************************** 1. row ***************************
|
Name: t
|
Engine: Aria
|
Checksum: NULL
|
Create_options: page_checksum=1 transactional=1
|
This makes this information less reliable for monitoring for example...