diff options
| author | Sergei Golubchik <serg@mariadb.org> | 2022-04-21 10:04:04 +0200 |
|---|---|---|
| committer | Sergei Golubchik <serg@mariadb.org> | 2022-04-21 10:05:50 +0200 |
| commit | 6f6c74b0d18d5d4fa8a112a6793653ef5242726d (patch) | |
| tree | 0410c1f500341283233dbb9cb39511aab9baf123 /mysql-test/main/default_innodb.test | |
| parent | 4730314a70119ae5857edffe2d1bec86960ef22b (diff) | |
| parent | 5ba77222e9fe7af8ff403816b5338b18b342053c (diff) | |
| download | mariadb-git-6f6c74b0d18d5d4fa8a112a6793653ef5242726d.tar.gz | |
Merge branch '10.2' into 10.3
Diffstat (limited to 'mysql-test/main/default_innodb.test')
| -rw-r--r-- | mysql-test/main/default_innodb.test | 22 |
1 files changed, 22 insertions, 0 deletions
diff --git a/mysql-test/main/default_innodb.test b/mysql-test/main/default_innodb.test new file mode 100644 index 00000000000..2fc74950845 --- /dev/null +++ b/mysql-test/main/default_innodb.test @@ -0,0 +1,22 @@ + +--source include/have_innodb.inc + +--echo # +--echo # MDEV-26423: MariaDB server crash in Create_tmp_table::finalize +--echo # + +CREATE TABLE v0 ( + v2 DATE DEFAULT ( v1 MOD 68321183.000000 ) , + v1 DATETIME NULL ) engine=innodb; +SHOW DATABASES LIKE 'x'; +SELECT DISTINCT v2 , v1 , DEFAULT ( v2 ) FROM v0; +DROP TABLE v0; + +CREATE TABLE t1 (v1 DATE, v2 DATE DEFAULT(v1)) engine=innodb; +SELECT DISTINCT DEFAULT(v2) FROM t1 ; +DROP TABLE t1; + + +--echo # +--echo # End of 10.2 tests +--echo # |