diff options
| author | Daniel Baumann <daniel.baumann@progress-linux.org> | 2024-07-01 18:15:00 +0000 |
|---|---|---|
| committer | Daniel Baumann <daniel.baumann@progress-linux.org> | 2024-07-01 18:15:00 +0000 |
| commit | a2a2e32c02643a0cec111511220227703fda1cd5 (patch) | |
| tree | 69cc2b631234c2a8e026b9cd4d72676c61c594df /plugin/type_uuid/mysql-test | |
| parent | Releasing progress-linux version 1:10.11.8-1~progress7.99u1. (diff) | |
| download | mariadb-a2a2e32c02643a0cec111511220227703fda1cd5.tar.xz mariadb-a2a2e32c02643a0cec111511220227703fda1cd5.zip | |
Merging upstream version 1:11.4.2.
Signed-off-by: Daniel Baumann <daniel.baumann@progress-linux.org>
Diffstat (limited to 'plugin/type_uuid/mysql-test')
| -rw-r--r-- | plugin/type_uuid/mysql-test/type_uuid/type_uuid.result | 14 |
1 files changed, 13 insertions, 1 deletions
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; # |