maropu commented on a change in pull request #26492:
[SPARK-28885][SQL][FOLLOW-UP] Re-enable the ported PgSQL regression tests of
SQLQueryTestSuite
URL: https://github.com/apache/spark/pull/26492#discussion_r346009851
##########
File path:
sql/core/src/test/resources/sql-tests/inputs/postgreSQL/timestamp.sql
##########
@@ -16,19 +16,23 @@ CREATE TABLE TIMESTAMP_TBL (d1 timestamp) USING parquet;
-- block is entered exactly at local midnight; then 'now' and 'today' have
-- the same values and the counts will come out different.
-INSERT INTO TIMESTAMP_TBL VALUES ('now');
+-- PostgreSQL implicitly casts string literals to data with timestamp types,
but
+-- Spark does not support that kind of implicit casts.
+INSERT INTO TIMESTAMP_TBL VALUES timestamp(('now'));
Review comment:
oh, ok.
----------------------------------------------------------------
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.
For queries about this service, please contact Infrastructure at:
[email protected]
With regards,
Apache Git Services
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
