You signed in with another tab or window. Reload to refresh your session.You signed out in another tab or window. Reload to refresh your session.You switched accounts on another tab or window. Reload to refresh your session.Dismiss alert
When submitting a query to a worker node that contains CURRENT_DATE, the term is translated to ('now'::cstring)::date which produces the following error on the worker nodes:
ERROR: cannot cast type cstring to date at character 84
STATEMENT: SELECT NULL::unknown FROM ONLY sys_order_10130 WHERE (order_dt >= (('now'::cstring)::date - '7 days'::interval))
Thanks for the clear bug report and copy-paste repro case! One more thing for posterity's sake: what version of PostgreSQL were you testing this against?
When submitting a query to a worker node that contains
CURRENT_DATE
, the term is translated to('now'::cstring)::date
which produces the following error on the worker nodes:Steps to reproduce
After installing from a current git clone:
The text was updated successfully, but these errors were encountered: