bart-samwel commented on pull request #29022:
URL: https://github.com/apache/spark/pull/29022#issuecomment-654771295
> Hive 2.3 and PostgreSQL seem to be aliases:
>
> ```sql
> hive> CREATE TABLE test_float1 as SELECT 1.0F, 2.0D;
> hive> DESC test_float1;
> OK
> f decimal(1,0)
> _c1 double
> Time taken: 0.763 seconds, Fetched: 2 row(s)
> ```
>
> ```sql
> postgres=# CREATE TABLE test_float1 as SELECT 1.0F, 2.0D;
> postgres=# \d test_float1;
> Table "public.test_float1"
> Column | Type | Collation | Nullable | Default
> --------+---------+-----------+----------+---------
> f | numeric | | |
> d | numeric | | |
> ```
I wonder what postgresql does with `1.0e2` -- does it treat it like 1.0
with alias e2 or like 1.0 * 10^2? And `1.0e` probably is an alias then. These
kinds of discontinuities are terrible and we should stay far away from them...
----------------------------------------------------------------
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:
us...@infra.apache.org
---------------------------------------------------------------------
To unsubscribe, e-mail: reviews-unsubscr...@spark.apache.org
For additional commands, e-mail: reviews-h...@spark.apache.org
