[MDEV-691] LP:425916 - CREATE TABLE with unsupported table option keeps the option Created: 2009-09-07  Updated: 2013-05-20  Resolved: 2013-05-20

Status: Closed
Project: MariaDB Server
Component/s: None
Affects Version/s: None
Fix Version/s: 5.5.31, 5.2.15, 5.3.13

Type: Bug Priority: Trivial
Reporter: Sergei Petrunia Assignee: Sergei Golubchik
Resolution: Fixed Votes: 0
Labels: Launchpad

Attachments: XML File LPexportBug425916.xml    

 Description   

CREATE TABLE will produce a warning when table's storage engine doesn't support transactional=0|1 attribute but won't produce warnings for page_checksum or row_format attributes.

Moreover, the attributes will be kept (in .frm file?) and displayed by SHOW CREATE TABLE which creates an illusion that the storage engine actually supports them:

mysql> create table t1 (a int) transactional=0;
 
Query OK, 0 rows affected, 1 warning (0.01 sec)
 
 
 
mysql> create table t2 (a int) page_checksum=1;
 
Query OK, 0 rows affected (0.01 sec)
 
 
 
mysql> create table t3 (a int) row_format=page;
 
Query OK, 0 rows affected (0.01 sec)
 
 
 
mysql> show create table t3\G
 
*************************** 1. row ***************************
 
       Table: t3
 
Create Table: CREATE TABLE `t3` (
 
  `a` int(11) DEFAULT NULL
 
) ENGINE=MyISAM DEFAULT CHARSET=latin1 ROW_FORMAT=PAGE
 
1 row in set (0.00 sec)
 
 
 
mysql> show create table t2\G
 
*************************** 1. row ***************************
 
       Table: t2
 
Create Table: CREATE TABLE `t2` (
 
  `a` int(11) DEFAULT NULL
 
) ENGINE=MyISAM DEFAULT CHARSET=latin1 PAGE_CHECKSUM=1
 
1 row in set (0.00 sec)

Suggested fix:

  • Discard unapplicable attributes
  • And produce a warning when doing that.

 Comments   
Comment by Oleksandr Byelkin [ 2009-09-08 ]

Re: CREATE TABLE with unsupported table option keeps the option
The behaviour can be changed/touched in https://askmonty.org/worklog/Server-BackLog/?tid=43

Comment by Oleksandr Byelkin [ 2009-12-09 ]

Re: CREATE TABLE with unsupported table option keeps the option
Storing attributes (even if they are not used) is correct behaviour. The bug is in absence of warning about unused attributes.

Comment by Hakan Küçükyılmaz (Inactive) [ 2010-05-26 ]

Re: CREATE TABLE with unsupported table option keeps the option
Sanja,

do you have an update about this bug?

Thanks,

Hakan

Comment by Sergei Golubchik [ 2010-05-27 ]

Re: CREATE TABLE with unsupported table option keeps the option
Additionally, the warning on TRANSACTIONAL uses an WARN_LEVEL_ERROR instead of WARN_LEVEL_WARN, as it should

Comment by Rasmus Johansson (Inactive) [ 2011-07-22 ]

Launchpad bug id: 425916

Comment by Sergei Golubchik [ 2013-05-20 ]

warning level for TRANSACTIONAL is fixed to be WARN_LEVEL_WARN

Generated at Thu Feb 08 06:30:38 UTC 2024 using Jira 8.20.16#820016-sha1:9d11dbea5f4be3d4cc21f03a88dd11d8c8687422.