This is an automated email from the ASF dual-hosted git repository.
zhangliang pushed a commit to branch master
in repository https://gitbox.apache.org/repos/asf/shardingsphere.git
The following commit(s) were added to refs/heads/master by this push:
new 21d1f2c758f Add more test cases on Doris SQL parser (#37636)
21d1f2c758f is described below
commit 21d1f2c758f2e3a93b0635aa0836decbcde48030
Author: Liang Zhang <[email protected]>
AuthorDate: Sun Jan 4 20:23:48 2026 +0800
Add more test cases on Doris SQL parser (#37636)
---
.../resources/sql/supported/dcl/create-role.xml | 6 ++---
.../resources/sql/supported/dcl/create-user.xml | 28 +++++++++++-----------
.../main/resources/sql/supported/dcl/drop-role.xml | 6 ++---
.../main/resources/sql/supported/dcl/drop-user.xml | 10 ++++----
.../sql/supported/dcl/set-default-role.xml | 8 +++----
.../resources/sql/supported/dcl/set-password.xml | 6 ++---
.../main/resources/sql/supported/dcl/set-role.xml | 14 +++++------
.../main/resources/sql/supported/dml/delete.xml | 10 ++++----
.../main/resources/sql/supported/dml/insert.xml | 22 ++++++++---------
.../main/resources/sql/supported/dml/replace.xml | 18 +++++++-------
.../main/resources/sql/supported/dml/update.xml | 12 +++++-----
11 files changed, 70 insertions(+), 70 deletions(-)
diff --git
a/test/it/parser/src/main/resources/sql/supported/dcl/create-role.xml
b/test/it/parser/src/main/resources/sql/supported/dcl/create-role.xml
index 970ef54c485..4599d415dd2 100644
--- a/test/it/parser/src/main/resources/sql/supported/dcl/create-role.xml
+++ b/test/it/parser/src/main/resources/sql/supported/dcl/create-role.xml
@@ -17,9 +17,9 @@
-->
<sql-cases>
- <sql-case id="create_role" value="CREATE ROLE role1"
db-types="MySQL,Oracle,PostgreSQL,openGauss,SQLServer,Firebird" />
- <sql-case id="create_roles" value="CREATE ROLE role1, role2"
db-types="MySQL" />
- <sql-case id="create_role_if_not_exists" value="CREATE ROLE IF NOT EXISTS
role1" db-types="MySQL" />
+ <sql-case id="create_role" value="CREATE ROLE role1"
db-types="MySQL,Oracle,PostgreSQL,openGauss,SQLServer,Firebird,Doris" />
+ <sql-case id="create_roles" value="CREATE ROLE role1, role2"
db-types="MySQL,Doris" />
+ <sql-case id="create_role_if_not_exists" value="CREATE ROLE IF NOT EXISTS
role1" db-types="MySQL,Doris" />
<sql-case id="create_no_identified_role" value="CREATE ROLE role1 NOT
IDENTIFIED" db-types="Oracle" />
<sql-case id="create_external_role" value="CREATE ROLE role1 IDENTIFIED
EXTERNALLY" db-types="Oracle" />
<sql-case id="create_global_role" value="CREATE ROLE role1 IDENTIFIED
GLOBALLY" db-types="Oracle" />
diff --git
a/test/it/parser/src/main/resources/sql/supported/dcl/create-user.xml
b/test/it/parser/src/main/resources/sql/supported/dcl/create-user.xml
index 2b377726813..cde675ae6fc 100644
--- a/test/it/parser/src/main/resources/sql/supported/dcl/create-user.xml
+++ b/test/it/parser/src/main/resources/sql/supported/dcl/create-user.xml
@@ -17,24 +17,24 @@
-->
<sql-cases>
- <sql-case id="create_user_with_hostname" value="CREATE USER
'user_dev_new'@'localhost' default role role1" db-types="MySQL" />
+ <sql-case id="create_user_with_hostname" value="CREATE USER
'user_dev_new'@'localhost' default role role1" db-types="MySQL,Doris" />
<sql-case id="create_user_without_hostname" value="CREATE USER
user_dev_new" db-types="PostgreSQL,openGauss" />
- <sql-case id="create_user_identified_by_with_hostname" value="CREATE USER
'user_dev_new'@'localhost' identified by 'passwd_dev' default role role1"
db-types="MySQL" />
+ <sql-case id="create_user_identified_by_with_hostname" value="CREATE USER
'user_dev_new'@'localhost' identified by 'passwd_dev' default role role1"
db-types="MySQL,Doris" />
<sql-case id="create_user_identified_by_without_hostname" value="CREATE
USER user_dev_new identified by passwd_dev" db-types="Oracle" />
<sql-case id="create_user_identified_by_for" value="CREATE USER
user_dev_new FOR LOGIN login_dev" db-types="SQLServer" />
<sql-case id="create_user_password" value="CREATE USER user_dev_new
PASSWORD 'passwd_dev'" db-types="PostgreSQL,openGauss,Firebird" />
- <sql-case id="create_user" value="CREATE USER user1 DEFAULT ROLE role1"
db-types="MySQL" />
- <sql-case id="create_users" value="CREATE USER user1, user2 DEFAULT ROLE
role1" db-types="MySQL" />
- <sql-case id="create_user_if_not_exists" value="CREATE USER IF NOT EXISTS
user1 DEFAULT ROLE role1" db-types="MySQL" />
- <sql-case id="create_local_user" value="CREATE USER 'user1'@'localhost'
DEFAULT ROLE role1" db-types="MySQL" />
- <sql-case id="create_user_with_roles" value="CREATE USER user1 DEFAULT
ROLE role1, role2" db-types="MySQL" />
- <sql-case id="create_user_with_password_default_role" value="CREATE USER
user1 IDENTIFIED BY RANDOM password DEFAULT ROLE role1" db-types="MySQL" />
- <sql-case id="create_user_with_resource_option" value="CREATE USER user1
DEFAULT ROLE role1 WITH MAX_QUERIES_PER_HOUR 1" db-types="MySQL" />
- <sql-case id="create_user_with_resource_options" value="CREATE USER user1
DEFAULT ROLE role1 WITH MAX_QUERIES_PER_HOUR 1 MAX_UPDATES_PER_HOUR 1"
db-types="MySQL" />
- <sql-case id="create_user_with_password_option" value="CREATE USER user1
DEFAULT ROLE role1 PASSWORD EXPIRE DEFAULT" db-types="MySQL" />
- <sql-case id="create_user_with_password_options" value="CREATE USER user1
DEFAULT ROLE role1 PASSWORD EXPIRE DEFAULT PASSWORD HISTORY DEFAULT"
db-types="MySQL" />
- <sql-case id="create_user_with_lock_option" value="CREATE USER user1
DEFAULT ROLE role1 ACCOUNT LOCK" db-types="MySQL" />
- <sql-case id="create_user_with_options" value="CREATE USER user1 DEFAULT
ROLE role1 WITH MAX_QUERIES_PER_HOUR 1 MAX_UPDATES_PER_HOUR 1 PASSWORD EXPIRE
DEFAULT PASSWORD HISTORY DEFAULT ACCOUNT LOCK" db-types="MySQL" />
+ <sql-case id="create_user" value="CREATE USER user1 DEFAULT ROLE role1"
db-types="MySQL,Doris" />
+ <sql-case id="create_users" value="CREATE USER user1, user2 DEFAULT ROLE
role1" db-types="MySQL,Doris" />
+ <sql-case id="create_user_if_not_exists" value="CREATE USER IF NOT EXISTS
user1 DEFAULT ROLE role1" db-types="MySQL,Doris" />
+ <sql-case id="create_local_user" value="CREATE USER 'user1'@'localhost'
DEFAULT ROLE role1" db-types="MySQL,Doris" />
+ <sql-case id="create_user_with_roles" value="CREATE USER user1 DEFAULT
ROLE role1, role2" db-types="MySQL,Doris" />
+ <sql-case id="create_user_with_password_default_role" value="CREATE USER
user1 IDENTIFIED BY RANDOM password DEFAULT ROLE role1" db-types="MySQL,Doris"
/>
+ <sql-case id="create_user_with_resource_option" value="CREATE USER user1
DEFAULT ROLE role1 WITH MAX_QUERIES_PER_HOUR 1" db-types="MySQL,Doris" />
+ <sql-case id="create_user_with_resource_options" value="CREATE USER user1
DEFAULT ROLE role1 WITH MAX_QUERIES_PER_HOUR 1 MAX_UPDATES_PER_HOUR 1"
db-types="MySQL,Doris" />
+ <sql-case id="create_user_with_password_option" value="CREATE USER user1
DEFAULT ROLE role1 PASSWORD EXPIRE DEFAULT" db-types="MySQL,Doris" />
+ <sql-case id="create_user_with_password_options" value="CREATE USER user1
DEFAULT ROLE role1 PASSWORD EXPIRE DEFAULT PASSWORD HISTORY DEFAULT"
db-types="MySQL,Doris" />
+ <sql-case id="create_user_with_lock_option" value="CREATE USER user1
DEFAULT ROLE role1 ACCOUNT LOCK" db-types="MySQL,Doris" />
+ <sql-case id="create_user_with_options" value="CREATE USER user1 DEFAULT
ROLE role1 WITH MAX_QUERIES_PER_HOUR 1 MAX_UPDATES_PER_HOUR 1 PASSWORD EXPIRE
DEFAULT PASSWORD HISTORY DEFAULT ACCOUNT LOCK" db-types="MySQL,Doris" />
<sql-case id="create_external_user" value="CREATE USER user1 IDENTIFIED
EXTERNALLY" db-types="Oracle" />
<sql-case id="create_global_user" value="CREATE USER user1 IDENTIFIED
GLOBALLY" db-types="Oracle" />
<sql-case id="create_user_with_password" value="CREATE USER user1
IDENTIFIED BY RANDOM password default role role1" db-types="H2,MySQL" />
diff --git a/test/it/parser/src/main/resources/sql/supported/dcl/drop-role.xml
b/test/it/parser/src/main/resources/sql/supported/dcl/drop-role.xml
index af70937bbf5..de7500097cd 100644
--- a/test/it/parser/src/main/resources/sql/supported/dcl/drop-role.xml
+++ b/test/it/parser/src/main/resources/sql/supported/dcl/drop-role.xml
@@ -17,8 +17,8 @@
-->
<sql-cases>
- <sql-case id="drop_role" value="DROP ROLE role1"
db-types="MySQL,Oracle,PostgreSQL,openGauss,SQLServer" />
- <sql-case id="drop_roles" value="DROP ROLE role1, role2"
db-types="MySQL,PostgreSQL,openGauss" />
- <sql-case id="drop_role_if_exists" value="DROP ROLE IF EXISTS role1"
db-types="MySQL,PostgreSQL,openGauss,SQLServer" />
+ <sql-case id="drop_role" value="DROP ROLE role1"
db-types="MySQL,Oracle,PostgreSQL,openGauss,SQLServer,Doris" />
+ <sql-case id="drop_roles" value="DROP ROLE role1, role2"
db-types="MySQL,PostgreSQL,openGauss,Doris" />
+ <sql-case id="drop_role_if_exists" value="DROP ROLE IF EXISTS role1"
db-types="MySQL,PostgreSQL,openGauss,SQLServer,Doris" />
<sql-case id="drop_role_appsuser" value="DROP ROLE apps_user"
db-types="Oracle" />
</sql-cases>
diff --git a/test/it/parser/src/main/resources/sql/supported/dcl/drop-user.xml
b/test/it/parser/src/main/resources/sql/supported/dcl/drop-user.xml
index c46b3f8b138..5366a52ad4d 100644
--- a/test/it/parser/src/main/resources/sql/supported/dcl/drop-user.xml
+++ b/test/it/parser/src/main/resources/sql/supported/dcl/drop-user.xml
@@ -18,11 +18,11 @@
<sql-cases>
<sql-case id="drop_user_without_hostname" value="DROP USER user_dev"
db-types="Oracle,PostgreSQL,openGauss,SQLServer" />
- <sql-case id="drop_user_with_hostname" value="DROP USER
user_dev@localhost" db-types="MySQL" />
- <sql-case id="drop_user_with_ip" value="DROP USER [email protected]"
db-types="MySQL" />
+ <sql-case id="drop_user_with_hostname" value="DROP USER
user_dev@localhost" db-types="MySQL,Doris" />
+ <sql-case id="drop_user_with_ip" value="DROP USER [email protected]"
db-types="MySQL,Doris" />
<sql-case id="drop_user_cascade" value="DROP USER user_dev CASCADE"
db-types="Oracle,openGauss" />
<sql-case id="drop_user_restrict" value="DROP USER user_name RESTRICT"
db-types="openGauss" />
- <sql-case id="drop_user" value="DROP USER user1"
db-types="MySQL,Oracle,PostgreSQL,openGauss,SQLServer" />
- <sql-case id="drop_users" value="DROP USER user1, user2"
db-types="MySQL,PostgreSQL,openGauss" />
- <sql-case id="drop_user_if_exists" value="DROP USER IF EXISTS user1"
db-types="MySQL,PostgreSQL,openGauss,SQLServer" />
+ <sql-case id="drop_user" value="DROP USER user1"
db-types="MySQL,Oracle,PostgreSQL,openGauss,SQLServer,Doris" />
+ <sql-case id="drop_users" value="DROP USER user1, user2"
db-types="MySQL,PostgreSQL,openGauss,Doris" />
+ <sql-case id="drop_user_if_exists" value="DROP USER IF EXISTS user1"
db-types="MySQL,PostgreSQL,openGauss,SQLServer,Doris" />
</sql-cases>
diff --git
a/test/it/parser/src/main/resources/sql/supported/dcl/set-default-role.xml
b/test/it/parser/src/main/resources/sql/supported/dcl/set-default-role.xml
index 79c4d8fa1c1..19d564414cc 100644
--- a/test/it/parser/src/main/resources/sql/supported/dcl/set-default-role.xml
+++ b/test/it/parser/src/main/resources/sql/supported/dcl/set-default-role.xml
@@ -17,8 +17,8 @@
-->
<sql-cases>
- <sql-case id="set_default_none_role" value="SET DEFAULT ROLE NONE TO
user1" db-types="MySQL" />
- <sql-case id="set_default_all_role" value="SET DEFAULT ROLE ALL TO user1"
db-types="MySQL" />
- <sql-case id="set_default_role_to_user" value="SET DEFAULT ROLE role1 TO
user1" db-types="MySQL" />
- <sql-case id="set_default_roles_to_users" value="SET DEFAULT ROLE role1,
role2 TO user1, user2" db-types="MySQL" />
+ <sql-case id="set_default_none_role" value="SET DEFAULT ROLE NONE TO
user1" db-types="MySQL,Doris" />
+ <sql-case id="set_default_all_role" value="SET DEFAULT ROLE ALL TO user1"
db-types="MySQL,Doris" />
+ <sql-case id="set_default_role_to_user" value="SET DEFAULT ROLE role1 TO
user1" db-types="MySQL,Doris" />
+ <sql-case id="set_default_roles_to_users" value="SET DEFAULT ROLE role1,
role2 TO user1, user2" db-types="MySQL,Doris" />
</sql-cases>
diff --git
a/test/it/parser/src/main/resources/sql/supported/dcl/set-password.xml
b/test/it/parser/src/main/resources/sql/supported/dcl/set-password.xml
index d73d0ec7ea0..79f92d1d7b1 100644
--- a/test/it/parser/src/main/resources/sql/supported/dcl/set-password.xml
+++ b/test/it/parser/src/main/resources/sql/supported/dcl/set-password.xml
@@ -17,9 +17,9 @@
-->
<sql-cases>
- <sql-case id="set_password" value="SET PASSWORD = 'password'"
db-types="MySQL" />
- <sql-case id="set_password_for_user" value="SET PASSWORD FOR user1 =
'password'" db-types="MySQL" />
- <sql-case id="set_password_for_local_user" value="SET PASSWORD FOR
'user1'@'localhost' = 'password'" db-types="MySQL" />
+ <sql-case id="set_password" value="SET PASSWORD = 'password'"
db-types="MySQL,Doris" />
+ <sql-case id="set_password_for_user" value="SET PASSWORD FOR user1 =
'password'" db-types="MySQL,Doris" />
+ <sql-case id="set_password_for_local_user" value="SET PASSWORD FOR
'user1'@'localhost' = 'password'" db-types="MySQL,Doris" />
<sql-case id="replace_password" value="SET PASSWORD FOR user1 = 'password'
REPLACE 'password'" db-types="MySQL" />
<sql-case id="set_password_and_retain" value="SET PASSWORD FOR user1 =
'password' RETAIN CURRENT PASSWORD" db-types="MySQL" />
</sql-cases>
diff --git a/test/it/parser/src/main/resources/sql/supported/dcl/set-role.xml
b/test/it/parser/src/main/resources/sql/supported/dcl/set-role.xml
index 797b88937fd..aab5e3bc13c 100644
--- a/test/it/parser/src/main/resources/sql/supported/dcl/set-role.xml
+++ b/test/it/parser/src/main/resources/sql/supported/dcl/set-role.xml
@@ -17,13 +17,13 @@
-->
<sql-cases>
- <sql-case id="set_role_default" value="SET ROLE DEFAULT" db-types="MySQL"
/>
- <sql-case id="set_role" value="SET ROLE role1" db-types="MySQL,Oracle" />
+ <sql-case id="set_role_default" value="SET ROLE DEFAULT"
db-types="MySQL,Doris" />
+ <sql-case id="set_role" value="SET ROLE role1"
db-types="MySQL,Oracle,Doris" />
<sql-case id="set_role_identified_by_password" value="SET ROLE role1
IDENTIFIED BY password1" db-types="Oracle" />
- <sql-case id="set_roles" value="SET ROLE role1, role2"
db-types="MySQL,Oracle" />
+ <sql-case id="set_roles" value="SET ROLE role1, role2"
db-types="MySQL,Oracle,Doris" />
<sql-case id="set_roles_identified_by_passwords" value="SET ROLE role1
IDENTIFIED BY password1, role2 IDENTIFIED BY password2" db-types="Oracle" />
- <sql-case id="set_none_role" value="SET ROLE NONE" db-types="MySQL,Oracle"
/>
- <sql-case id="set_all_role" value="SET ROLE ALL" db-types="MySQL,Oracle" />
- <sql-case id="set_all_expect_role" value="SET ROLE ALL EXCEPT role1"
db-types="MySQL,Oracle" />
- <sql-case id="set_all_expect_roles" value="SET ROLE ALL EXCEPT role1,
role2" db-types="MySQL,Oracle" />
+ <sql-case id="set_none_role" value="SET ROLE NONE"
db-types="MySQL,Oracle,Doris" />
+ <sql-case id="set_all_role" value="SET ROLE ALL"
db-types="MySQL,Oracle,Doris" />
+ <sql-case id="set_all_expect_role" value="SET ROLE ALL EXCEPT role1"
db-types="MySQL,Oracle,Doris" />
+ <sql-case id="set_all_expect_roles" value="SET ROLE ALL EXCEPT role1,
role2" db-types="MySQL,Oracle,Doris" />
</sql-cases>
diff --git a/test/it/parser/src/main/resources/sql/supported/dml/delete.xml
b/test/it/parser/src/main/resources/sql/supported/dml/delete.xml
index 890ae205dbf..f78241e1f4a 100644
--- a/test/it/parser/src/main/resources/sql/supported/dml/delete.xml
+++ b/test/it/parser/src/main/resources/sql/supported/dml/delete.xml
@@ -19,10 +19,10 @@
<sql-cases>
<sql-case id="delete_with_sharding_value" value="DELETE FROM t_order WHERE
order_id = ? AND user_id = ? AND status=?" />
<sql-case id="delete_without_sharding_value" value="DELETE FROM t_order
WHERE status=?" />
- <sql-case id="delete_with_special_character_without_sharding_value"
value="DELETE FROM `t_order` WHERE `status`='init'" db-types="MySQL" />
- <sql-case id="delete_with_alias" value="DELETE FROM t_order AS o WHERE
status=?" db-types="MySQL,SQLServer" />
+ <sql-case id="delete_with_special_character_without_sharding_value"
value="DELETE FROM `t_order` WHERE `status`='init'" db-types="MySQL,Doris" />
+ <sql-case id="delete_with_alias" value="DELETE FROM t_order AS o WHERE
status=?" db-types="MySQL,SQLServer,Doris" />
<sql-case id="delete_with_alias_without_as" value="DELETE
product_price_history pp WHERE (product_id, currency_code, effective_from_date)
IN (SELECT product_id, currency_code, MAX(effective_from_date) FROM
product_price_history GROUP BY product_id, currency_code)" db-types="Oracle" />
- <sql-case id="delete_with_order_by_row_count" value="DELETE FROM t_order
WHERE order_id = ? AND user_id = ? AND status=? ORDER BY order_id LIMIT ?"
db-types="MySQL" />
+ <sql-case id="delete_with_order_by_row_count" value="DELETE FROM t_order
WHERE order_id = ? AND user_id = ? AND status=? ORDER BY order_id LIMIT ?"
db-types="MySQL,Doris" />
<sql-case id="delete_with_output_clause" value="DELETE FROM t_order OUTPUT
DELETED.order_id, DELETED.user_id INTO @MyTableVar (temp_order_id,
temp_user_id) WHERE order_id = ?" db-types="SQLServer" />
<sql-case id="delete_with_output_clause_without_output_table_columns"
value="DELETE FROM t_order OUTPUT DELETED.order_id, DELETED.user_id INTO
@MyTableVar WHERE order_id = ?" db-types="SQLServer" />
<sql-case id="delete_with_output_clause_without_output_table"
value="DELETE FROM t_order OUTPUT DELETED.order_id, DELETED.user_id WHERE
order_id = ?" db-types="SQLServer" />
@@ -32,8 +32,8 @@
<sql-case id="delete_with_with_clause" value="WITH cte (order_id, user_id)
AS (SELECT order_id, user_id FROM t_order) DELETE t_order FROM cte WHERE
t_order.order_id = cte.order_id" db-types="SQLServer" />
<sql-case id="delete_using_with_clause" value="WITH cte AS (SELECT
order_id FROM t_order WHERE order_id = 1000) DELETE FROM t_order USING t_order
JOIN cte ON t_order.order_id = cte.order_id" db-types="MySQL" />
<sql-case id="delete_without_columns_with_with_clause" value="WITH cte AS
(SELECT order_id, user_id FROM t_order) DELETE t_order FROM cte WHERE
t_order.order_id = cte.order_id" db-types="SQLServer" />
- <sql-case id="delete_multi_tables" value="DELETE t_order, t_order_item
from t_order, t_order_item where t_order.order_id = t_order_item.order_id and
t_order.status = ?" db-types="MySQL,Presto" />
- <sql-case id="delete_multi_tables_with_using" value="DELETE from t_order,
t_order_item using t_order left join t_order_item on t_order.order_id =
t_order_item.order_id where t_order.status = ?" db-types="MySQL" />
+ <sql-case id="delete_multi_tables" value="DELETE t_order, t_order_item
from t_order, t_order_item where t_order.order_id = t_order_item.order_id and
t_order.status = ?" db-types="MySQL,Presto,Doris" />
+ <sql-case id="delete_multi_tables_with_using" value="DELETE from t_order,
t_order_item using t_order left join t_order_item on t_order.order_id =
t_order_item.order_id where t_order.status = ?" db-types="MySQL,Doris" />
<sql-case id="delete_with_query_hint" value="DELETE FROM t_order WHERE
order_id = ?" db-types="SQLServer" />
<sql-case id="delete_with_simple_table" value="DELETE FROM
product_descriptions WHERE language_id = 'AR'" db-types="Oracle" />
<sql-case id="delete_with_simple_subquery" value="DELETE FROM (SELECT *
FROM employees) WHERE job_id = 'SA_REP' AND commission_pct < 0.2"
db-types="Oracle" />
diff --git a/test/it/parser/src/main/resources/sql/supported/dml/insert.xml
b/test/it/parser/src/main/resources/sql/supported/dml/insert.xml
index 0f3491e21e1..7ed81a3cd4e 100644
--- a/test/it/parser/src/main/resources/sql/supported/dml/insert.xml
+++ b/test/it/parser/src/main/resources/sql/supported/dml/insert.xml
@@ -32,31 +32,31 @@
<sql-case id="insert_with_special_syntax" value="INSERT /*+ index(field1)
*/ INTO t_order (order_id, user_id, status) VALUES (1, 1, 'insert') RETURNING
order_id, *, t_order.*, user_id u, t_order.status as s, 'OK' result"
db-types="PostgreSQL,openGauss" />
<sql-case id="insert_with_all_placeholders_for_table_identifier"
value="INSERT INTO t_order (t_order.order_id, t_order.user_id, t_order.status)
VALUES (?, ?, ?)" />
<sql-case id="insert_without_columns_with_all_placeholders" value="INSERT
INTO t_order VALUES (?, ?, ?)" />
- <sql-case id="insert_set_with_all_placeholders" value="INSERT INTO t_order
SET order_id = ?, user_id = ?, status = ?" db-types="MySQL,Presto" />
+ <sql-case id="insert_set_with_all_placeholders" value="INSERT INTO t_order
SET order_id = ?, user_id = ?, status = ?" db-types="MySQL,Presto,Doris" />
<sql-case id="insert_duplicate_key_update" value="INSERT INTO t_order SET
b='11', a=0 AS n ON DUPLICATE KEY UPDATE b=n.a, a=n.b" db-types="MySQL" />
<sql-case id="insert_with_underscore_charset" value="INSERT INTO t_order
VALUES(_utf16 0x1EC2), (_utf16 0x1EC3), (_utf16 0x1EC5), (_utf16 0x1EC0),
(_utf16 0x1EC7), (_Utf16 0x1EBF)" db-types="MySQL" />
<sql-case id="insert_set_with_all_placeholders_for_table_identifier"
value="INSERT INTO t_order SET t_order.order_id = ?, t_order.user_id = ?,
t_order.status = ?" db-types="MySQL" />
<sql-case id="insert_with_partial_placeholders" value="INSERT INTO t_order
(order_id, user_id, status) VALUES (?, ?, 'insert')" />
<sql-case id="insert_set_with_partial_placeholders" value="INSERT INTO
t_order SET order_id = ?, user_id = ?, status = 'insert'" db-types="MySQL" />
<sql-case id="insert_with_generate_key_column" value="INSERT INTO
t_order_item(item_id, order_id, user_id, status, creation_date) VALUES (?, ?,
?, 'insert', '2017-08-08')" />
- <sql-case id="insert_set_with_generate_key_column" value="INSERT INTO
t_order_item SET item_id = ?, order_id = ?, user_id = ?, status = 'insert',
creation_date='2017-08-08'" db-types="MySQL" />
+ <sql-case id="insert_set_with_generate_key_column" value="INSERT INTO
t_order_item SET item_id = ?, order_id = ?, user_id = ?, status = 'insert',
creation_date='2017-08-08'" db-types="MySQL,Doris" />
<sql-case id="insert_without_generate_key_column" value="INSERT INTO
t_order_item(order_id, user_id, status, creation_date) VALUES (?, ?, 'insert',
'2017-08-08')" />
<sql-case id="insert_without_columns_and_with_generate_key_column"
value="INSERT INTO t_order_item VALUES(?, ?, ?, 'insert', '2017-08-08')" />
<sql-case id="insert_without_columns_and_without_generate_key_column"
value="INSERT INTO t_order_item VALUES(?, ?, 'insert', '2017-08-08')" />
<sql-case id="insert_set_without_generate_key_column" value="INSERT INTO
t_order_item SET order_id = ?, user_id = ?, status = 'insert',
creation_date='2017-08-08'" db-types="MySQL" />
- <sql-case id="insert_with_batch" value="INSERT INTO t_order (order_id,
user_id, status) VALUES (?, ?, ?), (?, ?, ?)" db-types="MySQL, SQLServer,
PostgreSQL,openGauss" />
- <sql-case id="insert_with_batch_and_irregular_parameters" value="INSERT
INTO t_order (order_id, user_id, status) VALUES (?, 1, 'insert'), (?, ?, ?)"
db-types="MySQL, SQLServer, PostgreSQL,openGauss" />
+ <sql-case id="insert_with_batch" value="INSERT INTO t_order (order_id,
user_id, status) VALUES (?, ?, ?), (?, ?, ?)" db-types="MySQL, SQLServer,
PostgreSQL,openGauss,Doris" />
+ <sql-case id="insert_with_batch_and_irregular_parameters" value="INSERT
INTO t_order (order_id, user_id, status) VALUES (?, 1, 'insert'), (?, ?, ?)"
db-types="MySQL, SQLServer, PostgreSQL,openGauss,Doris" />
<sql-case id="insert_with_batch_and_composite_expression" value="INSERT
INTO t_order (order_id, user_id, status) VALUES (?, ?, SUBSTR(?, 1)), (?, ?,
SUBSTR(?, 1))" db-types="H2,MySQL" />
- <sql-case id="insert_with_batch_and_with_generate_key_column"
value="INSERT INTO t_order_item(item_id, order_id, user_id, status,
creation_date) values (?, ?, ?, 'insert', '2017-08-08'), (?, ?, ?, 'insert',
'2017-08-08')" db-types="MySQL, SQLServer, PostgreSQL,openGauss" />
- <sql-case id="insert_with_batch_and_without_generate_key_column"
value="INSERT INTO t_order_item(order_id, user_id, status, creation_date)
values (?, ?, 'insert', '2017-08-08'), (?, ?, 'insert', '2017-08-08')"
db-types="MySQL, SQLServer, PostgreSQL,openGauss" />
- <sql-case id="insert_on_duplicate_key_update" value="INSERT INTO t_order
(order_id, user_id, status) VALUES (?, ?, ?) ON DUPLICATE KEY UPDATE status =
VALUES(status)" db-types="MySQL,openGauss,Presto" />
- <sql-case id="insert_on_duplicate_key_update_with_placeholders"
value="INSERT INTO t_order (order_id, user_id, status) VALUES (?, ?, ?) ON
DUPLICATE KEY UPDATE status = ?" db-types="MySQL,openGauss,Presto" />
+ <sql-case id="insert_with_batch_and_with_generate_key_column"
value="INSERT INTO t_order_item(item_id, order_id, user_id, status,
creation_date) values (?, ?, ?, 'insert', '2017-08-08'), (?, ?, ?, 'insert',
'2017-08-08')" db-types="MySQL, SQLServer, PostgreSQL,openGauss,Doris" />
+ <sql-case id="insert_with_batch_and_without_generate_key_column"
value="INSERT INTO t_order_item(order_id, user_id, status, creation_date)
values (?, ?, 'insert', '2017-08-08'), (?, ?, 'insert', '2017-08-08')"
db-types="MySQL, SQLServer, PostgreSQL,openGauss,Doris" />
+ <sql-case id="insert_on_duplicate_key_update" value="INSERT INTO t_order
(order_id, user_id, status) VALUES (?, ?, ?) ON DUPLICATE KEY UPDATE status =
VALUES(status)" db-types="MySQL,openGauss,Presto,Doris" />
+ <sql-case id="insert_on_duplicate_key_update_with_placeholders"
value="INSERT INTO t_order (order_id, user_id, status) VALUES (?, ?, ?) ON
DUPLICATE KEY UPDATE status = ?" db-types="MySQL,openGauss,Presto,Doris" />
<sql-case id="insert_on_duplicate_key_update_with_placeholders_postgres"
value="INSERT INTO t_order (order_id, user_id, status) VALUES (?, ?, ?) ON
CONFLICT (order_id) DO UPDATE SET status = ?" db-types="PostgreSQL" />
- <sql-case id="insert_on_duplicate_key_update_with_complicated_expression"
value="INSERT INTO emp(order_id,emp_id,age,salary) VALUES (?,?,?,?) ON
DUPLICATE KEY UPDATE salary = VALUES(salary)+VALUES(salary)*0.2"
db-types="MySQL" />
+ <sql-case id="insert_on_duplicate_key_update_with_complicated_expression"
value="INSERT INTO emp(order_id,emp_id,age,salary) VALUES (?,?,?,?) ON
DUPLICATE KEY UPDATE salary = VALUES(salary)+VALUES(salary)*0.2"
db-types="MySQL,Doris" />
<sql-case id="insert_with_multiple_values" value="INSERT INTO t_order
(order_id, user_id, status) VALUES (1, 1, 'insert'), (2, 2, 'insert2')"
db-types="MySQL" />
<sql-case id="insert_on_duplicate_key_update_with_table_identifier"
value="INSERT INTO t_order (t_order.order_id, t_order.user_id, t_order.status)
VALUES (?, ?, ?) ON DUPLICATE KEY UPDATE t_order.status =
VALUES(t_order.status)" db-types="MySQL" />
<sql-case id="insert_with_geography" value="INSERT INTO t_order(user_id,
order_id, start_point,rule) VALUES (?, ?,
ST_GeographyFromText('SRID=4326;POINT(100 200)'), ?::jsonb)"
db-types="PostgreSQL,openGauss" />
- <sql-case id="insert_with_one_auto_increment_column" value="INSERT INTO
t_auto_increment_table VALUES()" db-types="MySQL" />
+ <sql-case id="insert_with_one_auto_increment_column" value="INSERT INTO
t_auto_increment_table VALUES()" db-types="MySQL,Doris" />
<sql-case id="insert_with_double_value" value="INSERT INTO
t_double_test(col1) VALUES(1.22)" db-types="MySQL" />
<sql-case id="insert_with_null_value" value="INSERT INTO
t_null_value_test(col1) VALUES(null)" db-types="MySQL" />
<sql-case id="insert_with_blob_value" value="INSERT INTO
t_blob_value_test(col1) VALUES(_BINARY'This is a binary value.')"
db-types="MySQL" />
@@ -67,7 +67,7 @@
<sql-case id="insert_on_duplicate_key_update_with_base64_aes_encrypt"
value="INSERT INTO t_order SET order_id = ?, user_id = ?, status =
convert(to_base64(aes_encrypt(?, 'key')) USING utf8) ON DUPLICATE KEY UPDATE
status = VALUES(status)" db-types="MySQL" />
<sql-case id="insert_all_with_all_placeholders" value="INSERT ALL INTO
t_order (order_id, user_id, status) VALUES (?, ?, ?) INTO t_order (order_id,
user_id, status) VALUES (?, ?, ?) INTO t_order (order_id, user_id, status)
VALUES (?, ?, ?) SELECT * FROM dual" db-types="Oracle" />
<sql-case id="insert_with_str_date_add" value="INSERT INTO
t_order(present_date, order_id, user_id) VALUES (date_add(now(),interval ?
second), ?, ?)" db-types="MySQL" />
- <sql-case id="insert_select_with_all_columns" value="INSERT INTO t_order
(order_id, user_id, status) SELECT order_id, user_id, status FROM t_order WHERE
order_id = ?" db-types="MySQL,PostgreSQL,openGauss,Presto" />
+ <sql-case id="insert_select_with_all_columns" value="INSERT INTO t_order
(order_id, user_id, status) SELECT order_id, user_id, status FROM t_order WHERE
order_id = ?" db-types="MySQL,PostgreSQL,openGauss,Presto,Doris" />
<sql-case id="insert_select_without_columns" value="INSERT INTO t_order
SELECT order_id, user_id, status FROM t_order WHERE order_id = ?"
db-types="MySQL,PostgreSQL,openGauss" />
<sql-case id="insert_select_with_generate_key_column" value="INSERT INTO
t_order_item(item_id, order_id, user_id, status, creation_date) SELECT item_id,
order_id, user_id, 'insert', '2017-08-08' FROM t_order_item WHERE item_id = ?"
db-types="MySQL" />
<sql-case id="insert_select_without_generate_key_column" value="INSERT
INTO t_order_item(order_id, user_id, status, creation_date) SELECT order_id,
user_id, 'insert', '2017-08-08' FROM t_order_item WHERE order_id = ?"
db-types="MySQL" />
diff --git a/test/it/parser/src/main/resources/sql/supported/dml/replace.xml
b/test/it/parser/src/main/resources/sql/supported/dml/replace.xml
index 14e7abc297c..4c0600a71e3 100644
--- a/test/it/parser/src/main/resources/sql/supported/dml/replace.xml
+++ b/test/it/parser/src/main/resources/sql/supported/dml/replace.xml
@@ -17,24 +17,24 @@
-->
<sql-cases>
- <sql-case id="replace_with_all_placeholders" value="REPLACE INTO t_order
(order_id, user_id, status) VALUES (?, ?, ?)" db-types="MySQL" />
+ <sql-case id="replace_with_all_placeholders" value="REPLACE INTO t_order
(order_id, user_id, status) VALUES (?, ?, ?)" db-types="MySQL,Doris" />
<sql-case id="replace_with_now_function" value="REPLACE INTO t_order_item
(item_id, order_id, user_id, status, creation_date) VALUES (?, ?, ?, 'replace',
now())" db-types="MySQL" />
- <sql-case id="replace_without_parameters" value="REPLACE INTO t_order
(order_id, user_id, status) VALUES (1, 1, 'replace')" db-types="MySQL" />
+ <sql-case id="replace_without_parameters" value="REPLACE INTO t_order
(order_id, user_id, status) VALUES (1, 1, 'replace')" db-types="MySQL,Doris" />
<sql-case id="replace_with_special_characters" value="REPLACE INTO
`t_order` (`order_id`, `user_id`, `status`) VALUES (1, 1, 'replace')"
db-types="MySQL" />
<sql-case id="replace_with_all_placeholders_for_table_identifier"
value="REPLACE INTO t_order (t_order.order_id, t_order.user_id, t_order.status)
VALUES (?, ?, ?)" db-types="MySQL" />
<sql-case id="replace_without_columns_with_all_placeholders"
value="REPLACE INTO t_order VALUES (?, ?, ?)" db-types="MySQL" />
- <sql-case id="replace_set_with_all_placeholders" value="REPLACE INTO
t_order SET order_id = ?, user_id = ?, status = ?" db-types="MySQL" />
+ <sql-case id="replace_set_with_all_placeholders" value="REPLACE INTO
t_order SET order_id = ?, user_id = ?, status = ?" db-types="MySQL,Doris" />
<sql-case id="replace_set_with_all_placeholders_for_table_identifier"
value="REPLACE INTO t_order SET t_order.order_id = ?, t_order.user_id = ?,
t_order.status = ?" db-types="MySQL" />
- <sql-case id="replace_with_partial_placeholders" value="REPLACE INTO
t_order (order_id, user_id, status) VALUES (?, ?, 'replace')" db-types="MySQL"
/>
- <sql-case id="replace_set_with_partial_placeholders" value="REPLACE INTO
t_order SET order_id = ?, user_id = ?, status = 'replace'" db-types="MySQL" />
+ <sql-case id="replace_with_partial_placeholders" value="REPLACE INTO
t_order (order_id, user_id, status) VALUES (?, ?, 'replace')"
db-types="MySQL,Doris" />
+ <sql-case id="replace_set_with_partial_placeholders" value="REPLACE INTO
t_order SET order_id = ?, user_id = ?, status = 'replace'"
db-types="MySQL,Doris" />
<sql-case id="replace_with_generate_key_column" value="REPLACE INTO
t_order_item(item_id, order_id, user_id, status, creation_date) values (?, ?,
?, 'replace', '2017-08-08')" db-types="MySQL" />
<sql-case id="replace_set_with_generate_key_column" value="REPLACE INTO
t_order_item SET item_id = ?, order_id = ?, user_id = ?, status = 'replace',
creation_date='2017-08-08'" db-types="MySQL" />
<sql-case id="replace_without_generate_key_column" value="REPLACE INTO
t_order_item(order_id, user_id, status, creation_date) values (?, ?, 'replace',
'2017-08-08')" db-types="MySQL" />
<sql-case id="replace_without_columns_and_with_generate_key_column"
value="REPLACE INTO t_order_item values(?, ?, ?, 'replace', '2017-08-08')"
db-types="MySQL" />
<sql-case id="replace_without_columns_and_without_generate_key_column"
value="REPLACE INTO t_order_item values(?, ?, 'replace', '2017-08-08')"
db-types="MySQL" />
<sql-case id="replace_set_without_generate_key_column" value="REPLACE INTO
t_order_item SET order_id = ?, user_id = ?, status = 'replace',
creation_date='2017-08-08'" db-types="MySQL" />
- <sql-case id="replace_with_batch" value="REPLACE INTO t_order (order_id,
user_id, status) VALUES (?, ?, ?), (?, ?, ?)" db-types="MySQL" />
- <sql-case id="replace_with_batch_and_irregular_parameters" value="REPLACE
INTO t_order (order_id, user_id, status) VALUES (?, 1, 'replace'), (?, ?, ?)"
db-types="MySQL" />
+ <sql-case id="replace_with_batch" value="REPLACE INTO t_order (order_id,
user_id, status) VALUES (?, ?, ?), (?, ?, ?)" db-types="MySQL,Doris" />
+ <sql-case id="replace_with_batch_and_irregular_parameters" value="REPLACE
INTO t_order (order_id, user_id, status) VALUES (?, 1, 'replace'), (?, ?, ?)"
db-types="MySQL,Doris" />
<sql-case id="replace_with_batch_and_with_generate_key_column"
value="REPLACE INTO t_order_item(item_id, order_id, user_id, status,
creation_date) values (?, ?, ?, 'replace', '2017-08-08'), (?, ?, ?, 'replace',
'2017-08-08')" db-types="MySQL" />
<sql-case id="replace_with_batch_and_without_generate_key_column"
value="REPLACE INTO t_order_item(order_id, user_id, status, creation_date)
values (?, ?, 'replace', '2017-08-08'), (?, ?, 'replace', '2017-08-08')"
db-types="MySQL" />
<sql-case id="replace_with_multiple_values" value="REPLACE INTO t_order
(order_id, user_id, status) VALUES (1, 1, 'replace'), (2, 2, 'replace2')"
db-types="MySQL" />
@@ -46,8 +46,8 @@
<sql-case id="replace_with_unix_timestamp_function" value="REPLACE INTO
t_order(status, order_id, user_id) VALUES (unix_timestamp(?), ?, ?)"
db-types="MySQL" />
<sql-case id="replace_with_str_to_date" value="REPLACE INTO
t_order(present_date, order_id, user_id) VALUES (str_to_date(?, '%Y-%m-%d'), ?,
?)" db-types="MySQL" />
<sql-case id="replace_with_str_date_add" value="REPLACE INTO
t_order(present_date, order_id, user_id) VALUES (date_add(now(),interval ?
second), ?, ?)" db-types="MySQL" />
- <sql-case id="replace_select_with_all_columns" value="REPLACE INTO t_order
(order_id, user_id, status) SELECT order_id, user_id, status FROM t_order WHERE
order_id = ?" db-types="MySQL" />
- <sql-case id="replace_select_without_columns" value="REPLACE INTO t_order
SELECT order_id, user_id, status FROM t_order WHERE order_id = ?"
db-types="MySQL" />
+ <sql-case id="replace_select_with_all_columns" value="REPLACE INTO t_order
(order_id, user_id, status) SELECT order_id, user_id, status FROM t_order WHERE
order_id = ?" db-types="MySQL,Doris" />
+ <sql-case id="replace_select_without_columns" value="REPLACE INTO t_order
SELECT order_id, user_id, status FROM t_order WHERE order_id = ?"
db-types="MySQL,Doris" />
<sql-case id="replace_select_with_generate_key_column" value="REPLACE INTO
t_order_item(item_id, order_id, user_id, status, creation_date) SELECT item_id,
order_id, user_id, 'insert', '2017-08-08' FROM t_order_item WHERE item_id = ?"
db-types="MySQL" />
<sql-case id="replace_select_without_generate_key_column" value="REPLACE
INTO t_order_item(order_id, user_id, status, creation_date) SELECT order_id,
user_id, 'insert', '2017-08-08' FROM t_order_item WHERE order_id = ?"
db-types="MySQL" />
<sql-case id="replace_returning_expressions" value="REPLACE INTO t2 (id)
VALUES (2),(3) RETURNING id,t&t" db-types="MySQL" />
diff --git a/test/it/parser/src/main/resources/sql/supported/dml/update.xml
b/test/it/parser/src/main/resources/sql/supported/dml/update.xml
index 6d76f1ae655..d68cef9586f 100644
--- a/test/it/parser/src/main/resources/sql/supported/dml/update.xml
+++ b/test/it/parser/src/main/resources/sql/supported/dml/update.xml
@@ -18,12 +18,12 @@
<sql-cases>
<sql-case id="update_without_alias" value="UPDATE t_order SET status = ?
WHERE order_id = ? AND user_id = ?" />
- <sql-case id="update_with_alias" value="UPDATE t_order AS o SET o.status =
? WHERE o.order_id = ? AND o.user_id = ?" db-types="MySQL,H2,openGauss,Oracle"
/>
+ <sql-case id="update_with_alias" value="UPDATE t_order AS o SET o.status =
? WHERE o.order_id = ? AND o.user_id = ?"
db-types="MySQL,H2,openGauss,Oracle,Doris" />
<sql-case id="update_with_unicode_escape_alias" value="UPDATE t_order AS u
SET status = ? WHERE u.order_id = ? AND u.user_id = ?"
db-types="PostgreSQL,openGauss" />
<sql-case id="update_equal_with_geography" value="UPDATE t_order SET
start_time = ?, status = 0, start_point =
ST_GeographyFromText('SRID=4326;POINT('||?||' '||?||')'), rule = ?::jsonb,
discount_type = ?, order_type = ? WHERE user_id = ? AND order_id = ?"
db-types="PostgreSQL,openGauss" />
- <sql-case id="update_without_condition" value="UPDATE t_order o SET
o.status = 'finished'" db-types="MySQL,H2" />
- <sql-case id="update_with_extra_keywords" value="UPDATE LOW_PRIORITY
IGNORE t_order SET status = ? WHERE order_id = ? AND user_id = ?"
db-types="MySQL" />
- <sql-case id="update_with_special_character" value="UPDATE `t_order` SET
`status` = ? WHERE `order_id` = ? AND user_id = ?" db-types="MySQL" />
+ <sql-case id="update_without_condition" value="UPDATE t_order o SET
o.status = 'finished'" db-types="MySQL,H2,Doris" />
+ <sql-case id="update_with_extra_keywords" value="UPDATE LOW_PRIORITY
IGNORE t_order SET status = ? WHERE order_id = ? AND user_id = ?"
db-types="MySQL,Doris" />
+ <sql-case id="update_with_special_character" value="UPDATE `t_order` SET
`status` = ? WHERE `order_id` = ? AND user_id = ?" db-types="MySQL,Doris" />
<sql-case id="update_without_parameters" value="UPDATE t_order SET status
= 'update' WHERE order_id = 1000 AND user_id = 10" />
<sql-case id="update_with_or" value="UPDATE t_order SET status = 'update'
WHERE (order_id = ? OR order_id = ?) AND user_id = ?" />
<sql-case id="update_with_set_calculation" value="UPDATE t_order SET
status = status - ? WHERE order_id = ? AND user_id = ?" />
@@ -31,7 +31,7 @@
<sql-case id="update_with_column_equal_column" value="update t_order set
order_id = order_id, status = 'init' where order_id = order_id AND order_id =
?" db-types="MySQL" />
<sql-case id="update_with_case_when" value="update stock_freeze_detail set
row_status=case WHEN (id=?) THEN ? WHEN (id=?) THEN ? WHEN (id=?) THEN ? end,
update_user=case WHEN (id=?) THEN ? WHEN (id=?) THEN ? WHEN (id=?) THEN ?
end, update_time=case WHEN (id=?) THEN ? end where tenant_id = ?"
db-types="MySQL,Oracle" />
- <sql-case id="update_with_order_by_row_count" value="UPDATE t_order SET
status = ? WHERE order_id = ? AND user_id = ? ORDER BY order_id LIMIT ?"
db-types="MySQL,Presto" />
+ <sql-case id="update_with_order_by_row_count" value="UPDATE t_order SET
status = ? WHERE order_id = ? AND user_id = ? ORDER BY order_id LIMIT ?"
db-types="MySQL,Presto,Doris" />
<sql-case id="update_with_number" value="UPDATE t_order SET order_id = ?
WHERE user_id = ?" db-types="PostgreSQL,openGauss" />
<sql-case id="update_with_with_clause" value="WITH cte (order_id, user_id,
status) AS (SELECT order_id, user_id, status FROM t_order) UPDATE t_order SET
status = ? FROM t_order AS t JOIN cte AS c ON t.order_id = c.order_id WHERE
c.order_id = ?" db-types="SQLServer" />
<sql-case id="update_with_from_clause" value="UPDATE t_order SET status =
? FROM t_order AS t JOIN t_order_item AS i ON t.order_id = i.order_id WHERE
i.order_id = ?" db-types="PostgreSQL,openGauss,SQLServer" />
@@ -43,7 +43,7 @@
<sql-case id="update_with_multiple_set" value="UPDATE employees SET job_id
= 'SA_MAN', salary = 1000, department_id = 120 WHERE last_name = 'Douglas
Grant'" db-types="Oracle" />
<sql-case id="update_with_set_value" value="UPDATE people_demo1 p SET
VALUE(p) = (SELECT VALUE(q) FROM people_demo2 q WHERE p.department_id =
q.department_id) WHERE p.department_id = 10" db-types="Oracle" />
<sql-case id="update_with_multi_columns" value="UPDATE employees a SET
department_id = (SELECT department_id FROM departments WHERE location_id =
'2100'), (salary, commission_pct) = (SELECT 1.1*AVG(salary),
1.5*AVG(commission_pct) FROM employees b WHERE a.department_id =
b.department_id)" db-types="Oracle" />
- <sql-case id="update_with_force_index" value="UPDATE t_order FORCE INDEX
(PRIMARY) SET status = ? WHERE order_id = ?" db-types="MySQL" />
+ <sql-case id="update_with_force_index" value="UPDATE t_order FORCE INDEX
(PRIMARY) SET status = ? WHERE order_id = ?" db-types="MySQL,Doris" />
<sql-case id="update_with_subquery_using_interval" value="UPDATE employees
a SET salary = (SELECT salary FROM employees AS OF TIMESTAMP (SYSTIMESTAMP -
INTERVAL '2' MINUTE) WHERE last_name = 'Chung') WHERE last_name = 'Chung'"
db-types="Oracle" />
<sql-case id="update_with_translate_function" value="UPDATE translate_tab
SET char_col = TRANSLATE (nchar_col USING CHAR_CS);" db-types="Oracle"/>
<sql-case id="update_with_dot_column_name" value="UPDATE employees SET
salary =.salary + 10 WHERE employee_id BETWEEN 1 and 10; " db-types="Oracle" />
