This is an automated email from the ASF dual-hosted git repository.
yiguolei pushed a commit to branch branch-2.1
in repository https://gitbox.apache.org/repos/asf/doris.git
commit cd9eb6d0fc31700f6350b7f2fc95a061b6c8bfe4
Author: zy-kkk <zhongy...@gmail.com>
AuthorDate: Fri Apr 12 17:38:52 2024 +0800
[test](bi) add dbeaver and datagrip connect doris test (#33487)
---
.../suites/query_p0/bi_p0/datagrip.groovy | 43 +++++++++++++++++++++
.../suites/query_p0/bi_p0/dbeaver.groovy | 44 ++++++++++++++++++++++
2 files changed, 87 insertions(+)
diff --git a/regression-test/suites/query_p0/bi_p0/datagrip.groovy
b/regression-test/suites/query_p0/bi_p0/datagrip.groovy
new file mode 100644
index 00000000000..b7402686fe0
--- /dev/null
+++ b/regression-test/suites/query_p0/bi_p0/datagrip.groovy
@@ -0,0 +1,43 @@
+// Licensed to the Apache Software Foundation (ASF) under one
+// or more contributor license agreements. See the NOTICE file
+// distributed with this work for additional information
+// regarding copyright ownership. The ASF licenses this file
+// to you under the Apache License, Version 2.0 (the
+// "License"); you may not use this file except in compliance
+// with the License. You may obtain a copy of the License at
+//
+// http://www.apache.org/licenses/LICENSE-2.0
+//
+// Unless required by applicable law or agreed to in writing,
+// software distributed under the License is distributed on an
+// "AS IS" BASIS, WITHOUT WARRANTIES OR CONDITIONS OF ANY
+// KIND, either express or implied. See the License for the
+// specific language governing permissions and limitations
+// under the License.
+
+suite("datagrip") {
+ sql """SET net_write_timeout=600"""
+ sql """select table_name, table_type, table_comment, engine,
table_collation, create_options from information_schema.tables where
table_schema = '__internal_schema'"""
+ sql """select ordinal_position, column_name, column_type, column_default,
generation_expression, table_name, column_comment, is_nullable, extra,
collation_name from information_schema.columns where table_schema =
'__internal_schema' order by table_name, ordinal_position"""
+ sql """select table_name, auto_increment from information_schema.tables
where table_schema = '__internal_schema'"""
+ sql """select table_name, auto_increment from information_schema.tables
where table_schema = '__internal_schema' and auto_increment is not null"""
+ sql """select table_name, index_name, index_comment, index_type,
non_unique, column_name, sub_part, collation, null expression from
information_schema.statistics where table_schema = '__internal_schema' and
index_schema = '__internal_schema' order by index_schema, table_name,
index_name, index_type, seq_in_index"""
+ sql """select c.constraint_name, c.constraint_schema, c.table_name,
c.constraint_type, false enforced from information_schema.table_constraints
c where c.table_schema = '__internal_schema'"""
+ sql """select constraint_name, table_name, column_name,
referenced_table_schema, referenced_table_name, referenced_column_name from
information_schema.key_column_usage where table_schema = '__internal_schema'
and referenced_column_name is not null order by table_name , constraint_name
, ordinal_position"""
+ sql """select table_name, partition_name, subpartition_name,
partition_ordinal_position, subpartition_ordinal_position, partition_method,
subpartition_method, partition_expression, subpartition_expression,
partition_description, partition_comment/*, tablespace_name*/ from
information_schema.partitions where partition_name is not null and table_schema
= 'demo'"""
+ sql """select trigger_name, event_object_table,
event_manipulation, action_timing, definer from
information_schema.triggers where trigger_schema = 'demo'"""
+ sql """select event_name, event_comment, definer, event_type = 'RECURRING'
recurring, interval_value, interval_field, cast(coalesce(starts, execute_at) as
char) starts, cast(ends as char) ends, status, on_completion = 'PRESERVE'
preserve, last_executed from information_schema.events where event_schema =
'demo'"""
+ sql """select routine_name, routine_type, routine_definition,
routine_comment, dtd_identifier, definer, is_deterministic = 'YES'
is_deterministic, cast(sql_data_access as char(1)) sql_data_access,
cast(security_type as char(1)) security_type from information_schema.routines
where routine_schema = 'demo'"""
+ sql """select Host, User, Routine_name, Proc_priv, Routine_type =
'PROCEDURE' as is_proc from mysql.procs_priv where Db = 'demo';"""
+ sql """select grantee, table_name, column_name, privilege_type,
is_grantable from information_schema.column_privileges where table_schema =
'demo' union all select grantee, table_name, '' column_name, privilege_type,
is_grantable from information_schema.table_privileges where table_schema =
'demo' order by table_name, grantee, privilege_type"""
+ sql """select specific_name, ordinal_position, parameter_name,
parameter_mode, dtd_identifier from information_schema.parameters where
specific_schema = 'demo' and ordinal_position > 0 order by specific_name,
ordinal_position"""
+ sql """select table_name, view_definition, definer from
information_schema.views where table_schema = 'demo'"""
+ sql """select table_name, table_type, table_comment, engine,
table_collation, create_options from information_schema.tables where
table_schema = 'information_schema'"""
+ sql """select table_name, auto_increment from information_schema.tables
where table_schema = 'mysql' and auto_increment is not null"""
+ sql """select table_name, partition_name, subpartition_name,
partition_ordinal_position, subpartition_ordinal_position, partition_method,
subpartition_method, partition_expression, subpartition_expression,
partition_description, partition_comment/*, tablespace_name*/ from
information_schema.partitions where partition_name is not null and table_schema
= 'mysql'"""
+ sql """select trigger_name, event_object_table, event_manipulation,
action_timing, definer from information_schema.triggers where trigger_schema =
'mysql'"""
+ sql """select event_name, event_comment, definer, event_type =
'RECURRING' recurring, interval_value, interval_field,
cast(coalesce(starts, execute_at) as char) starts, cast(ends as char) ends,
status, on_completion = 'PRESERVE' preserve, last_executed from
information_schema.events where event_schema = 'mysql'"""
+ sql """select routine_name, routine_type, routine_definition,
routine_comment, dtd_identifier, definer, is_deterministic = 'YES'
is_deterministic, cast(sql_data_access as char(1)) sql_data_access,
cast(security_type as char(1)) security_type from information_schema.routines
where routine_schema = 'mysql'"""
+ sql """select Host, User, Routine_name, Proc_priv, Routine_type =
'PROCEDURE' as is_proc from mysql.procs_priv where Db = 'mysql';"""
+ sql """select grantee, table_name, column_name, privilege_type,
is_grantable from information_schema.column_privileges where table_schema =
'mysql' union all select grantee, table_name, '' column_name, privilege_type,
is_grantable from information_schema.table_privileges where table_schema =
'mysql' order by table_name, grantee, privilege_type"""
+}
\ No newline at end of file
diff --git a/regression-test/suites/query_p0/bi_p0/dbeaver.groovy
b/regression-test/suites/query_p0/bi_p0/dbeaver.groovy
new file mode 100644
index 00000000000..ddf5461e5b9
--- /dev/null
+++ b/regression-test/suites/query_p0/bi_p0/dbeaver.groovy
@@ -0,0 +1,44 @@
+// Licensed to the Apache Software Foundation (ASF) under one
+// or more contributor license agreements. See the NOTICE file
+// distributed with this work for additional information
+// regarding copyright ownership. The ASF licenses this file
+// to you under the Apache License, Version 2.0 (the
+// "License"); you may not use this file except in compliance
+// with the License. You may obtain a copy of the License at
+//
+// http://www.apache.org/licenses/LICENSE-2.0
+//
+// Unless required by applicable law or agreed to in writing,
+// software distributed under the License is distributed on an
+// "AS IS" BASIS, WITHOUT WARRANTIES OR CONDITIONS OF ANY
+// KIND, either express or implied. See the License for the
+// specific language governing permissions and limitations
+// under the License.
+
+suite("dbeaver") {
+ sql """SELECT @@session.auto_increment_increment AS
auto_increment_increment, @@character_set_client AS character_set_client,
@@character_set_connection AS character_set_connection, @@character_set_results
AS character_set_results, @@character_set_server AS character_set_server,
@@collation_server AS collation_server, @@collation_connection AS
collation_connection, @@init_connect AS init_connect, @@interactive_timeout AS
interactive_timeout, @@license AS license, @@lower_case_table_ [...]
+ sql """SET character_set_results = NULL"""
+ sql """SET autocommit=1"""
+ sql """SET sql_mode='STRICT_TRANS_TABLES'"""
+ sql """SET autocommit=1"""
+ sql """SELECT DATABASE()"""
+ sql """SHOW ENGINES"""
+ sql """SHOW CHARSET"""
+ sql """SHOW COLLATION"""
+ sql """SELECT @@GLOBAL.character_set_server,@@GLOBAL.collation_server"""
+ sql """SHOW PLUGINS"""
+ sql """SHOW VARIABLES LIKE 'lower_case_table_names'"""
+ sql """show databases"""
+ sql """SELECT * FROM information_schema.TABLES t WHERE t.TABLE_SCHEMA
= 'information_schema' AND t.TABLE_NAME = 'CHECK_CONSTRAINTS'"""
+ sql """SHOW FULL PROCESSLIST"""
+ sql """SHOW PRIVILEGES"""
+ sql """SHOW GRANTS FOR 'admin'@'%'"""
+ sql """SHOW STATUS"""
+ sql """SHOW GLOBAL STATUS"""
+ sql """SHOW VARIABLES"""
+ sql """SHOW GLOBAL VARIABLES"""
+ sql """SHOW FULL TABLES FROM `__internal_schema`"""
+ sql """SHOW TABLE STATUS FROM `__internal_schema`"""
+ sql """SELECT * FROM information_schema.COLUMNS WHERE
TABLE_SCHEMA='__internal_schema' AND TABLE_NAME='column_statistics' ORDER BY
ORDINAL_POSITION"""
+ sql """SELECT * FROM mysql.user ORDER BY user"""
+}
\ No newline at end of file
---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscr...@doris.apache.org
For additional commands, e-mail: commits-h...@doris.apache.org
