Add datetime type convert e2e test (#31058)
* Add datetime type convert e2e test
* Add assertion
* Fix
* Fix
diff --git a/test/e2e/sql/src/test/resources/cases/dql/dql-integration-select.xml b/test/e2e/sql/src/test/resources/cases/dql/dql-integration-select.xml
index 9198cf2..2b3e2dd 100644
--- a/test/e2e/sql/src/test/resources/cases/dql/dql-integration-select.xml
+++ b/test/e2e/sql/src/test/resources/cases/dql/dql-integration-select.xml
@@ -26,11 +26,11 @@
</test-case>
<test-case sql="SELECT 1=1, 1!=1" db-types="MySQL" scenario-types="db_tbl_sql_federation" >
- <assertion />
+ <assertion expected-data-source-name="read_dataset" />
</test-case>
<test-case sql="SELECT 1=1, 1!=1, 1>1, 1<1, 1>=1, 1<=1" db-types="MySQL" scenario-types="db_tbl_sql_federation" >
- <assertion />
+ <assertion expected-data-source-name="read_dataset" />
</test-case>
<test-case sql="SELECT * FROM t_order WHERE remark LIKE '%张%'" db-types="MySQL,PostgreSQL,openGauss" scenario-types="db_tbl_sql_federation" >
@@ -268,4 +268,12 @@
<test-case sql="select * from shardingsphere.cluster_information;" db-types="MySQL,PostgreSQL,openGauss" scenario-types="db">
<assertion expected-data-file="select_cluster_information.xml" />
</test-case>
+
+ <test-case sql="SELECT type_datetime FROM t_product_extend" db-types="MySQL" scenario-types="db_tbl_sql_federation">
+ <assertion expected-data-source-name="read_dataset" />
+ </test-case>
+
+ <test-case sql="SELECT result.max_datetime FROM (SELECT MAX(type_datetime) AS max_datetime FROM t_product_extend) result" db-types="MySQL" scenario-types="db_tbl_sql_federation">
+ <assertion expected-data-source-name="read_dataset" />
+ </test-case>
</integration-test-cases>