summaryrefslogtreecommitdiff
path: root/mysql-test/r/constraints.result
diff options
context:
space:
mode:
Diffstat (limited to 'mysql-test/r/constraints.result')
-rw-r--r--mysql-test/r/constraints.result6
1 files changed, 3 insertions, 3 deletions
diff --git a/mysql-test/r/constraints.result b/mysql-test/r/constraints.result
index 8ab38bf1f35..017d03f7e67 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));
show create table t1;
Table Create Table
t1 CREATE TABLE `t1` (
- `a` int(11) DEFAULT NULL CHECK (a>0)
+ `a` int(11) DEFAULT NULL CHECK ((`a` > 0))
) ENGINE=MyISAM DEFAULT CHARSET=latin1
insert into t1 values (1);
insert into t1 values (0);
@@ -15,7 +15,7 @@ Table Create Table
t1 CREATE TABLE `t1` (
`a` int(11) DEFAULT NULL,
`b` int(11) DEFAULT NULL,
- CONSTRAINT `CONSTRAINT_1` CHECK (a>b)
+ CONSTRAINT `CONSTRAINT_1` CHECK ((`a` > `b`))
) ENGINE=MyISAM DEFAULT CHARSET=latin1
insert into t1 values (1,0);
insert into t1 values (0,1);
@@ -27,7 +27,7 @@ Table Create Table
t1 CREATE TABLE `t1` (
`a` int(11) DEFAULT NULL,
`b` int(11) DEFAULT NULL,
- CONSTRAINT `abc` CHECK (a>b)
+ CONSTRAINT `abc` CHECK ((`a` > `b`))
) ENGINE=MyISAM DEFAULT CHARSET=latin1
insert into t1 values (1,0);
insert into t1 values (0,1);