jiacai2050 commented on code in PR #5124: URL: https://github.com/apache/arrow-datafusion/pull/5124#discussion_r1093341049
########## datafusion/core/tests/sqllogictests/test_files/ddl.slt: ########## @@ -465,3 +465,63 @@ query II rowsort select * from table_without_values; ---- 10 20 + +# Enable information_schema, so we can execute show create table +statement ok +set datafusion.catalog.information_schema = true; + +statement ok +CREATE OR REPLACE TABLE TABLE_WITH_NORMALIZATION(FIELD1 BIGINT, FIELD2 BIGINT); + +# Check table name is in lowercase +query CCCC +show create table table_with_normalization +---- +datafusion public table_with_normalization NULL + +# Check column name is in uppercase +query CCC +describe table_with_normalization +---- +field1 Int64 NO +field2 Int64 NO + +# Disable ident normalization +statement ok +set datafusion.sql_parser.enable_ident_normalization = false; + +statement ok +CREATE TABLE TABLE_WITHOUT_NORMALIZATION(FIELD1 BIGINT, FIELD2 BIGINT) AS VALUES (1,2); + +# Check table name is in uppercase +query CCCC +show create table TABLE_WITHOUT_NORMALIZATION +---- +datafusion public TABLE_WITHOUT_NORMALIZATION NULL + +# Check column name is in uppercase +query CCC +describe TABLE_WITHOUT_NORMALIZATION +---- +FIELD1 Int64 YES +FIELD2 Int64 YES + +query R +select 10000000000000000000.01 +---- +10000000000000000000 + +statement ok +set datafusion.sql_parser.parse_float_as_decimal = true; + +query R +select 10000000000000000000.01 +---- +10000000000000000000.01 Review Comment: Don't know this function, will add this test soon. -- This is an automated message from the Apache Git Service. To respond to the message, please log on to GitHub and use the URL above to go to the specific comment. To unsubscribe, e-mail: [email protected] For queries about this service, please contact Infrastructure at: [email protected]
