diff options
author | Lena Startseva <lena.startseva@mariadb.com> | 2022-06-09 10:32:51 +0700 |
---|---|---|
committer | Lena Startseva <lena.startseva@mariadb.com> | 2022-09-23 17:36:20 +0700 |
commit | 72ba96a48eb3e99a967e0489cc79f378e865e3fd (patch) | |
tree | d68b640bd3b6f71c4c7e13967776a13aa29965a2 /mysql-test/main/precedence.test | |
parent | 1dd6255ffef901dddcff2191ddf975a2019799d9 (diff) | |
download | mariadb-git-72ba96a48eb3e99a967e0489cc79f378e865e3fd.tar.gz |
MDEV-27691: make working view-protocol
Tests with checking metadata or that cannot be run with
the view-protocol are excluded from --view-protocol.
For tests that do not allow the use of an additional connection,
the util connection is disabled with "--disable_service_connection".
Also cases with bugs for --view-protocol are disabled.
Diffstat (limited to 'mysql-test/main/precedence.test')
-rw-r--r-- | mysql-test/main/precedence.test | 6 |
1 files changed, 6 insertions, 0 deletions
diff --git a/mysql-test/main/precedence.test b/mysql-test/main/precedence.test index cd7cee4f911..b93aea72e65 100644 --- a/mysql-test/main/precedence.test +++ b/mysql-test/main/precedence.test @@ -4501,6 +4501,10 @@ create or replace view v1 as select 3 BETWEEN 1 AND 2 AND NULL, 3 BETWEEN (1 AND Select view_definition from information_schema.views where table_schema='test' and table_name='v1'; select 3 BETWEEN 1 AND 2 AND NULL, 3 BETWEEN (1 AND 2) AND NULL, 3 BETWEEN 1 AND (2 AND NULL), (3 BETWEEN 1 AND 2) AND NULL union select * from v1; +# Looks like it is necessary that the view protocol uses the same connection, +# not util connection +--disable_service_connection + set sql_mode=PIPES_AS_CONCAT; create or replace view v1 as select 2 OR 3 || 3, 2 OR (3 || 3), (2 OR 3) || 3; Select view_definition from information_schema.views where table_schema='test' and table_name='v1'; @@ -4788,4 +4792,6 @@ Select view_definition from information_schema.views where table_schema='test' a create or replace view v1 as select 2 IS TRUE = 3, 2 IS FALSE = 3, 2 IS UNKNOWN = 3, 2 IS NULL = 3, ISNULL(2) = 1; Select view_definition from information_schema.views where table_schema='test' and table_name='v1'; +--enable_service_connection + drop view v1; |