diff options
author | Guilhem Bichot <guilhem@mysql.com> | 2009-07-29 10:54:20 +0200 |
---|---|---|
committer | Guilhem Bichot <guilhem@mysql.com> | 2009-07-29 10:54:20 +0200 |
commit | b1073fb7a75f3647e818153d0d4caff47ea56fc3 (patch) | |
tree | 11695ad26b01f87834d8b8b7c8dece060209048c /mysql-test/r/create.result | |
parent | 9fc2f2e3220b8be00967f6725479d106266c16bb (diff) | |
download | mariadb-git-b1073fb7a75f3647e818153d0d4caff47ea56fc3.tar.gz |
Bug#45829 "CREATE TABLE TRANSACTIONAL PAGE_CHECKSUM ROW_FORMAT=PAGE accepted, does nothing":
those keywords do nothing in 5.1 (they are meant for future versions, for example featuring the Maria engine)
so they are here removed from the syntax. Adding those keywords to future versions when needed is:
- WL#5034 "Add TRANSACTIONA=0|1 and PAGE_CHECKSUM=0|1 clauses to CREATE TABLE"
- WL#5037 "New ROW_FORMAT value for CREATE TABLE: PAGE"
Diffstat (limited to 'mysql-test/r/create.result')
-rw-r--r-- | mysql-test/r/create.result | 14 |
1 files changed, 14 insertions, 0 deletions
diff --git a/mysql-test/r/create.result b/mysql-test/r/create.result index bd11a8725ef..3373d206952 100644 --- a/mysql-test/r/create.result +++ b/mysql-test/r/create.result @@ -1894,4 +1894,18 @@ DROP TABLE t1; create table `me:i`(id int); drop table `me:i`; +# -- +# -- Bug#45829: CREATE TABLE TRANSACTIONAL PAGE_CHECKSUM ROW_FORMAT=PAGE accepted, does nothing +# -- + +drop table if exists t1,t2,t3; +create table t1 (a int) transactional=0; +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 'transactional=0' at line 1 +create table t2 (a int) page_checksum=1; +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 'page_checksum=1' at line 1 +create table t3 (a int) row_format=page; +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 'page' at line 1 + +# -- End of Bug#45829 + End of 5.1 tests |