From a2a2e32c02643a0cec111511220227703fda1cd5 Mon Sep 17 00:00:00 2001 From: Daniel Baumann Date: Mon, 1 Jul 2024 20:15:00 +0200 Subject: Merging upstream version 1:11.4.2. Signed-off-by: Daniel Baumann --- plugin/type_uuid/mysql-test/type_uuid/type_uuid.result | 14 +++++++++++++- 1 file changed, 13 insertions(+), 1 deletion(-) (limited to 'plugin/type_uuid/mysql-test') diff --git a/plugin/type_uuid/mysql-test/type_uuid/type_uuid.result b/plugin/type_uuid/mysql-test/type_uuid/type_uuid.result index de17d6fb..d8603f56 100644 --- a/plugin/type_uuid/mysql-test/type_uuid/type_uuid.result +++ b/plugin/type_uuid/mysql-test/type_uuid/type_uuid.result @@ -38,6 +38,8 @@ PRIVILEGES # COLUMN_COMMENT IS_GENERATED NEVER GENERATION_EXPRESSION NULL +IS_SYSTEM_TIME_PERIOD_START NO +IS_SYSTEM_TIME_PERIOD_END NO DROP TABLE t1; CREATE TABLE t1 (a UUID); INSERT INTO t1 VALUES ('00000000-0000-0000-0000-000000000001'); @@ -98,6 +100,8 @@ PRIVILEGES # COLUMN_COMMENT IS_GENERATED NEVER GENERATION_EXPRESSION NULL +IS_SYSTEM_TIME_PERIOD_START NO +IS_SYSTEM_TIME_PERIOD_END NO TABLE_CATALOG def TABLE_SCHEMA test TABLE_NAME t1 @@ -120,6 +124,8 @@ PRIVILEGES # COLUMN_COMMENT IS_GENERATED NEVER GENERATION_EXPRESSION NULL +IS_SYSTEM_TIME_PERIOD_START NO +IS_SYSTEM_TIME_PERIOD_END NO TABLE_CATALOG def TABLE_SCHEMA test TABLE_NAME t1 @@ -142,6 +148,8 @@ PRIVILEGES # COLUMN_COMMENT IS_GENERATED NEVER GENERATION_EXPRESSION NULL +IS_SYSTEM_TIME_PERIOD_START NO +IS_SYSTEM_TIME_PERIOD_END NO TABLE_CATALOG def TABLE_SCHEMA test TABLE_NAME t1 @@ -164,6 +172,8 @@ PRIVILEGES # COLUMN_COMMENT IS_GENERATED NEVER GENERATION_EXPRESSION NULL +IS_SYSTEM_TIME_PERIOD_START NO +IS_SYSTEM_TIME_PERIOD_END NO TABLE_CATALOG def TABLE_SCHEMA test TABLE_NAME t1 @@ -186,6 +196,8 @@ PRIVILEGES # COLUMN_COMMENT IS_GENERATED NEVER GENERATION_EXPRESSION NULL +IS_SYSTEM_TIME_PERIOD_START NO +IS_SYSTEM_TIME_PERIOD_END NO DROP TABLE t1; CREATE TABLE t1 (c1 UUID DEFAULT 0x00); ERROR 42000: Invalid default value for 'c1' @@ -2524,7 +2536,7 @@ id select_type table type possible_keys key key_len ref rows Extra EXPLAIN SELECT * FROM t1 WHERE b IN (SELECT a AS a_inner FROM t1 GROUP BY a_inner); id select_type table type possible_keys key key_len ref rows Extra 1 PRIMARY t1 ALL NULL NULL NULL NULL 2 Using where -2 DEPENDENT SUBQUERY t1 index_subquery a a 17 func 2 Using index; Using where +2 DEPENDENT SUBQUERY t1 index_subquery a a 17 func 1 Using index; Using where SET @@optimizer_switch=DEFAULT; DROP TABLE t1; # -- cgit v1.2.3