summaryrefslogtreecommitdiff
path: root/mysql-test/main/partition_alter.result
diff options
context:
space:
mode:
authorSergey Vojtovich <svoj@mariadb.org>2018-04-11 16:50:32 +0400
committerSergey Vojtovich <svoj@mariadb.org>2018-04-30 19:34:08 +0400
commit9a8498066865b508239b36853403f2700800af2b (patch)
tree265e8c8abb576d57960a8f43ac6e5b4e0b9f9bf2 /mysql-test/main/partition_alter.result
parent8bbcc0d5050dcbd44c0bc396c6b1acd488d3dfe2 (diff)
downloadmariadb-git-9a8498066865b508239b36853403f2700800af2b.tar.gz
MDEV-12645 - mysql_install_db: no install test db option
Added --skip-test-db option to mysql_install_db. If specified, no test database created and relevant grants issued. Removed --skip-auth-anonymous-user option of mysql_install_db. Now it is covered by --skip-test-db. Dropped some Debian patches that did the same. Removed unused make_win_bin_dist.1, make_win_bin_dist and mysql_install_db.pl.in.
Diffstat (limited to 'mysql-test/main/partition_alter.result')
-rw-r--r--mysql-test/main/partition_alter.result2
1 files changed, 2 insertions, 0 deletions
diff --git a/mysql-test/main/partition_alter.result b/mysql-test/main/partition_alter.result
index e42604ba056..448c26c7919 100644
--- a/mysql-test/main/partition_alter.result
+++ b/mysql-test/main/partition_alter.result
@@ -76,6 +76,7 @@ t1 CREATE TABLE `t1` (
insert t1 values (2, '2020-01-03', 20);
ERROR 23000: CONSTRAINT `CONSTRAINT_1` failed for `test`.`t1`
drop table t1;
+db.opt
create table t1(id int, d date not null, b bool not null default 0, primary key(id,d))
partition by range columns (d) (
partition p1 values less than ('2016-10-18'),
@@ -100,6 +101,7 @@ t1 CREATE TABLE `t1` (
insert t1 values (2, '2020-01-03', 20);
ERROR 23000: CONSTRAINT `CONSTRAINT_1` failed for `test`.`t1`
drop table t1;
+db.opt
create table t1 (id_1 int auto_increment, id_2 int, id_3 int, d1 date, dt1 datetime default current_timestamp, dt2 datetime default current_timestamp on update current_timestamp, primary key (id_2, id_3), key(id_1)) partition by hash(id_2) partitions 3 (partition p01, partition p02, partition p03);
insert into t1 values(0, 1, 1, NULL, now(), now());
alter online table t1 delay_key_write=1;