QualDefsToQuals: unsupported qual value (type T_FuncExpr), skipping

[mariusgrigaitis]

It seems that some of the quals are not handled.

Example query:

SELECT key FROM jira_issue WHERE status = 'done' AND resolution_date >= (now() - '2 weeks'::interval)::timestamp

Results in the following warning (and whole qual is therefore skipped):

2025-02-04 20:54:29.494 UTC [INFO]  hub: failed to convert qual value; QualDefsToQuals: unsupported qual value (type T_FuncExpr), skipping

A simple fix for the situation I figured is to use (now() - '2 weeks'::interval)::timestamptz (note the timestamptz) however I'm not sure if that's always the case.

[pskrbasu]

Thanks @mariusgrigaitis, for raising this detailed issue. I will try and get it reproduced.

[github-actions]

This issue is stale because it has been open 60 days with no activity. Remove stale label or comment or this will be closed in 30 days.

[github-actions]

This issue was closed because it has been stalled for 90 days with no activity.

[github-actions]

This issue is stale because it has been open 60 days with no activity. Remove stale label or comment or this will be closed in 30 days.