diff options
author | Alexander Barkov <bar@mariadb.com> | 2021-12-28 17:43:40 +0400 |
---|---|---|
committer | Alexander Barkov <bar@mariadb.com> | 2022-01-25 10:31:55 +0400 |
commit | 62e320c86dedce0624d56d76a72d2407fc3f3a11 (patch) | |
tree | 4b50325585dee662aec6bb93416f7f3e8f382760 /mysql-test/suite/innodb_i_s/innodb_cmpmem_reset.result | |
parent | e4b302e436c0a1e0d477a8e8e8e513112fd3ec7f (diff) | |
download | mariadb-git-62e320c86dedce0624d56d76a72d2407fc3f3a11.tar.gz |
MDEV-18918 SQL mode EMPTY_STRING_IS_NULL breaks RBR upon CREATE TABLE .. SELECT
The 10.5 version of the patch.
Removing DEFAULT from INFORMATION_SCHEMA columns.
DEFAULT in read-only tables is rather meaningless.
Upgrade should go smoothly.
Also fixes:
MDEV-20254 Problems with EMPTY_STRING_IS_NULL and I_S tables
Diffstat (limited to 'mysql-test/suite/innodb_i_s/innodb_cmpmem_reset.result')
-rw-r--r-- | mysql-test/suite/innodb_i_s/innodb_cmpmem_reset.result | 12 |
1 files changed, 6 insertions, 6 deletions
diff --git a/mysql-test/suite/innodb_i_s/innodb_cmpmem_reset.result b/mysql-test/suite/innodb_i_s/innodb_cmpmem_reset.result index 178cd244f9a..cf8b137f984 100644 --- a/mysql-test/suite/innodb_i_s/innodb_cmpmem_reset.result +++ b/mysql-test/suite/innodb_i_s/innodb_cmpmem_reset.result @@ -1,10 +1,10 @@ SHOW CREATE TABLE INFORMATION_SCHEMA.INNODB_CMPMEM_RESET; Table Create Table INNODB_CMPMEM_RESET CREATE TEMPORARY TABLE `INNODB_CMPMEM_RESET` ( - `page_size` int(5) NOT NULL DEFAULT 0, - `buffer_pool_instance` int(11) NOT NULL DEFAULT 0, - `pages_used` int(11) NOT NULL DEFAULT 0, - `pages_free` int(11) NOT NULL DEFAULT 0, - `relocation_ops` bigint(21) NOT NULL DEFAULT 0, - `relocation_time` int(11) NOT NULL DEFAULT 0 + `page_size` int(5) NOT NULL, + `buffer_pool_instance` int(11) NOT NULL, + `pages_used` int(11) NOT NULL, + `pages_free` int(11) NOT NULL, + `relocation_ops` bigint(21) NOT NULL, + `relocation_time` int(11) NOT NULL ) ENGINE=MEMORY DEFAULT CHARSET=utf8 |