diff options
| author | Alexander Barkov <bar@mariadb.com> | 2022-09-02 17:32:14 +0400 |
|---|---|---|
| committer | Alexander Barkov <bar@mariadb.com> | 2022-09-12 22:10:39 +0400 |
| commit | f1544424de2b8c9d1c3faefbbdd15543db7dfd12 (patch) | |
| tree | ebac7186e67915f333a5e9fec2e801ae45c8eccc /mysql-test/main/check_constraint.result | |
| parent | 667df98c3e0f32d391af4eb65c618043720b6a2f (diff) | |
| download | mariadb-git-f1544424de2b8c9d1c3faefbbdd15543db7dfd12.tar.gz | |
MDEV-29446 Change SHOW CREATE TABLE to display default collation
Diffstat (limited to 'mysql-test/main/check_constraint.result')
| -rw-r--r-- | mysql-test/main/check_constraint.result | 18 |
1 files changed, 9 insertions, 9 deletions
diff --git a/mysql-test/main/check_constraint.result b/mysql-test/main/check_constraint.result index 522a5d39df9..8558268c1c8 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 |