diff options
| author | Luis Soares <luis.soares@sun.com> | 2010-02-11 13:50:18 +0000 |
|---|---|---|
| committer | Luis Soares <luis.soares@sun.com> | 2010-02-11 13:50:18 +0000 |
| commit | c4f1de9f11b8a49f596cbba460e452b1057f9f27 (patch) | |
| tree | b264e2b5d923a09aa178285bb9be21688d3a40c4 /mysql-test/r/constraints.result | |
| parent | d142fca3bddace488b99b91e35991a8dbde57b98 (diff) | |
| parent | 7ae4c06da7e037daf4114d70ca217611e6b1db51 (diff) | |
| download | mariadb-git-c4f1de9f11b8a49f596cbba460e452b1057f9f27.tar.gz | |
Automerge from mysql-next-mr-bugfixing.
Diffstat (limited to 'mysql-test/r/constraints.result')
| -rw-r--r-- | mysql-test/r/constraints.result | 18 |
1 files changed, 17 insertions, 1 deletions
diff --git a/mysql-test/r/constraints.result b/mysql-test/r/constraints.result index 116efe429d5..46a718e4c42 100644 --- a/mysql-test/r/constraints.result +++ b/mysql-test/r/constraints.result @@ -3,7 +3,7 @@ create table t1 (a int check (a>0)); insert into t1 values (1); insert into t1 values (0); drop table t1; -create table t1 (a int ,b int, check a>b); +create table t1 (a int, b int, check (a>b)); insert into t1 values (1,0); insert into t1 values (0,1); drop table t1; @@ -27,3 +27,19 @@ t1 CREATE TABLE `t1` ( UNIQUE KEY `key_2` (`a`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1 drop table t1; +drop table if exists t_illegal; +create table t_illegal (a int, b int, check a>b); +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 'a>b)' at line 1 +create table t_illegal (a int, b int, constraint abc check a>b); +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 'a>b)' at line 1 +create table t_illegal (a int, b int, constraint abc); +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 ')' at line 1 +drop table if exists t_11714; +create table t_11714(a int, b int); +alter table t_11714 add constraint cons1; +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 '' at line 1 +drop table t_11714; +CREATE TABLE t_illegal (col_1 INT CHECK something (whatever)); +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 'something (whatever))' at line 1 +CREATE TABLE t_illegal (col_1 INT CHECK something); +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 'something)' at line 1 |