diff options
| author | Marko Mäkelä <marko.makela@mariadb.com> | 2022-09-21 09:52:09 +0300 |
|---|---|---|
| committer | Marko Mäkelä <marko.makela@mariadb.com> | 2022-09-21 09:52:09 +0300 |
| commit | 4345d9310080e6e4cbf1040263a2653f7d3d9227 (patch) | |
| tree | 84b4f98615e1ec93d2bf12443e0de514783dd0db /mysql-test/main/check_constraint.result | |
| parent | 90d899c30f4091e67989167806545e9a1d933355 (diff) | |
| parent | 7c7ac6d4a4c77d4c302732da2efe6785b1f0e455 (diff) | |
| download | mariadb-git-4345d9310080e6e4cbf1040263a2653f7d3d9227.tar.gz | |
Merge 10.7 into 10.8
Diffstat (limited to 'mysql-test/main/check_constraint.result')
| -rw-r--r-- | mysql-test/main/check_constraint.result | 20 |
1 files changed, 10 insertions, 10 deletions
diff --git a/mysql-test/main/check_constraint.result b/mysql-test/main/check_constraint.result index a6480bb6133..01a71bf36a5 100644 --- a/mysql-test/main/check_constraint.result +++ b/mysql-test/main/check_constraint.result @@ -7,7 +7,7 @@ t1 CREATE TABLE `t1` ( `b` int(11) DEFAULT NULL CHECK (`b` > 20), CONSTRAINT `min` CHECK (`a` + `b` > 100), CONSTRAINT `max` CHECK (`a` + `b` < 500) -) ENGINE=MyISAM DEFAULT CHARSET=latin1 +) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci insert into t1 values (100,100); insert into t1 values (1,1); ERROR 23000: CONSTRAINT `t1.a` failed for `test`.`t1` @@ -58,7 +58,7 @@ t1 CREATE TABLE `t1` ( CONSTRAINT `min` CHECK (`a` + `b` > 100), CONSTRAINT `max` CHECK (`a` + `b` < 500), CONSTRAINT `CONSTRAINT_1` CHECK (`a` + `b` + `c` < 500) -) ENGINE=MyISAM DEFAULT CHARSET=latin1 +) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci insert into t1 values(105,105,105); ERROR 23000: CONSTRAINT `t1.c` failed for `test`.`t1` insert into t1 values(249,249,9); @@ -81,7 +81,7 @@ t2 CREATE TABLE `t2` ( CONSTRAINT `min` CHECK (`a` + `b` > 100), CONSTRAINT `max` CHECK (`a` + `b` < 500), CONSTRAINT `CONSTRAINT_1` CHECK (`a` + `b` + `c` < 500) -) ENGINE=MyISAM DEFAULT CHARSET=latin1 +) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci alter table t2 drop constraint c; ERROR 42000: Can't DROP CONSTRAINT `c`; check that it exists alter table t2 drop constraint if exists c; @@ -96,7 +96,7 @@ t2 CREATE TABLE `t2` ( `c` int(11) DEFAULT 0 CHECK (`c` < 10), CONSTRAINT `max` CHECK (`a` + `b` < 500), CONSTRAINT `CONSTRAINT_1` CHECK (`a` + `b` + `c` < 500) -) ENGINE=MyISAM DEFAULT CHARSET=latin1 +) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci drop table t1,t2; create or replace table t1 (a int, b int, constraint check (a>b)); show create table t1; @@ -105,7 +105,7 @@ t1 CREATE TABLE `t1` ( `a` int(11) DEFAULT NULL, `b` int(11) DEFAULT NULL, CONSTRAINT `CONSTRAINT_1` CHECK (`a` > `b`) -) ENGINE=MyISAM DEFAULT CHARSET=latin1 +) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci create or replace table t1 (a int, b int, constraint CONSTRAINT_1 check (a>1), constraint check (b>1)); @@ -116,7 +116,7 @@ t1 CREATE TABLE `t1` ( `b` int(11) DEFAULT NULL, CONSTRAINT `CONSTRAINT_1` CHECK (`a` > 1), CONSTRAINT `CONSTRAINT_2` CHECK (`b` > 1) -) ENGINE=MyISAM DEFAULT CHARSET=latin1 +) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci create or replace table t1 (a int, b int, constraint CONSTRAINT_1 check (a>1), constraint check (b>1), @@ -129,7 +129,7 @@ t1 CREATE TABLE `t1` ( CONSTRAINT `CONSTRAINT_1` CHECK (`a` > 1), CONSTRAINT `CONSTRAINT_3` CHECK (`b` > 1), CONSTRAINT `CONSTRAINT_2` CHECK (`a` > `b`) -) ENGINE=MyISAM DEFAULT CHARSET=latin1 +) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci drop table t1; create table t1(c1 int, c2 int as (c1 + 1), check (c2 > 2)); insert into t1(c1) values(1); @@ -214,7 +214,7 @@ t CREATE TABLE `t` ( CONSTRAINT `b` CHECK (`a` < `b`), CONSTRAINT `a` CHECK (`a` > 0), CONSTRAINT `x` CHECK (`a` > 10) -) ENGINE=MyISAM DEFAULT CHARSET=latin1 +) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci # Field constraint 'b' will fail insert into t values (-1, 0); ERROR 23000: CONSTRAINT `t.b` failed for `test`.`t` @@ -290,7 +290,7 @@ Table Create Table t1 CREATE TABLE `t1` ( `d` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp() CHECK (default(`d`) is true), `1` int(1) NOT NULL -) ENGINE=MyISAM DEFAULT CHARSET=latin1 +) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci drop table t1; # # End of 10.3 tests @@ -305,7 +305,7 @@ Table Create Table t1 CREATE TABLE `t1` ( `id` varchar(2) DEFAULT NULL, CONSTRAINT `id` CHECK (`id` regexp '[a-z]') -) ENGINE=MyISAM DEFAULT CHARSET=latin1 +) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci drop table t1; # # End of 10.4 tests |