[jira] [Created] (OPENJPA-2935) Timestamp + coalesce + orderBy + Postgres makes Postgres syntax errors

[Pawel Veselov (Jira)]

Pawel Veselov created OPENJPA-2935:
--------------------------------------

             Summary: Timestamp + coalesce + orderBy + Postgres makes Postgres 
syntax errors
                 Key: OPENJPA-2935
                 URL: https://issues.apache.org/jira/browse/OPENJPA-2935
             Project: OpenJPA
          Issue Type: Improvement
          Components: jdbc
    Affects Versions: 3.1.2
            Reporter: Pawel Veselov


{code:java}
public class E {
  @Column(name = "due")
  private Timestamp due;
}
{code}
 
Using criteria API, when querying from E, say:

Timestamp ts = new Timestamp();
{{query.orderBy(cb.asc(cb.coalesce(root.get(E_.due), ts)))}}
Same if using {{cb.literal()}}

 Results in:
{noformat}
Caused by: org.apache.openjpa.lib.jdbc.ReportingSQLException: ERROR: syntax 
error at or near "11"
  Position: 77 {prepstmnt 575413488 SELECT t0.X, COALESCE(t0.due,2025-04-08 
11:56:02.93), t0.id FROM E t0 ORDER BY  COALESCE(t0.due,2025-04-08 11:56:02.93) 
ASC, t0.id ASC LIMIT ? [params=(long)
 1]} [code=0, state=42601]

{noformat}




--
This message was sent by Atlassian Jira
(v8.20.10#820010)