comphead commented on issue #4761:
URL:
https://github.com/apache/arrow-datafusion/issues/4761#issuecomment-1368050411
Thanks @liukun4515, I can take some part of investigations if you share
whats your plan.
From my side I tried to investigate what is the result type between
timestamptz and date in PG but thats not so obviuos.
verbose plan doesn't show the cast.
There is a an internal cast table to between types, which registers
type_from, type_to, cast_function. But these casts registered for timestamptz
-> date, and opposite date -> timestamptz.
What I was not able to find is what exact cast is picked on query like
`select '2021-1-1'::date = now()`
Some helpful queries below:
```
-- 1184 timestamptz
-- 1082 date
--SELECT * from pg_cast where castsource = 1184
--SELECT oid, typname FROM pg_type WHERE oid = pg_typeof('2020-1-1'::date);
explain verbose select '2021-1-1'::date = now()
```
--
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]
