diff options
Diffstat (limited to 'mysql-test/suite/period/r/create.result')
-rw-r--r-- | mysql-test/suite/period/r/create.result | 6 |
1 files changed, 3 insertions, 3 deletions
diff --git a/mysql-test/suite/period/r/create.result b/mysql-test/suite/period/r/create.result index 69d7e918804..dcae15c0772 100644 --- a/mysql-test/suite/period/r/create.result +++ b/mysql-test/suite/period/r/create.result @@ -9,7 +9,7 @@ t CREATE TABLE `t` ( `e` date NOT NULL, PERIOD FOR `mytime` (`s`, `e`), PRIMARY KEY (`id`) -) ENGINE=MyISAM DEFAULT CHARSET=latin1 +) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci create or replace table t (id int primary key, s timestamp(6), e timestamp(6), period for mytime(s,e)); show create table t; @@ -20,7 +20,7 @@ t CREATE TABLE `t` ( `e` timestamp(6) NOT NULL DEFAULT '0000-00-00 00:00:00.000000', PERIOD FOR `mytime` (`s`, `e`), PRIMARY KEY (`id`) -) ENGINE=MyISAM DEFAULT CHARSET=latin1 +) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci # SQL16, Part 2, 11.3 <table definition>, Syntax Rules, 2)a) # 2) If a <table period definition> TPD is specified, then: # a) <table scope> shall not be specified. @@ -93,7 +93,7 @@ t CREATE TABLE `t` ( `e` date NOT NULL, PERIOD FOR `mytime` (`s`, `e`), CONSTRAINT `mytime` CHECK (`x` > 1) -) ENGINE=MyISAM DEFAULT CHARSET=latin1 +) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci insert t values (2, '2001-01-01', '2001-01-01'); ERROR 23000: CONSTRAINT `mytime_1` failed for `test`.`t` show status like "Feature_application_time_periods"; |