maropu edited a comment on issue #26595: [SPARK-29956][SQL] A literal number with an exponent should be parsed to Double URL: https://github.com/apache/spark/pull/26595#issuecomment-558489184 Actually, it seems this behaviour depends on implementations (the standard says so though). In PgSQL; ``` postgres=# select pg_typeof(1E2); pg_typeof ----------- numeric (1 row) postgres=# select pg_typeof(1.2); pg_typeof ----------- numeric (1 row) ``` Just in case, can you check the other system behaviour other than PgSQL/Presto? btw, when the PgSQL dialect enabled, should we follow the current Spark behaviour (that is, in both cases, we should regard them as `decimal`)?
---------------------------------------------------------------- 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]
