KamoCRM

DbNow() use CAST(now() AS timestamp), not now()::timestamp

Fixkamo-shared-library
Shipped
7 ஜூலை, 2026 அன்று 4:58 PM UTC
Author
Kamo
Commit
ba3dad1

The ::timestamp shorthand is mangled by Hibernate's native-query parser (it reads ':' as a named-parameter prefix, turning ::timestamp into :timestamp) -> CRDB 'at or near ":"' syntax error, so dbNow() still threw on every lock acquire/ heartbeat/sweep and task create. SQL-standard CAST(...) has no colons. Verified against live CRDB: returns 'timestamp without time zone'.

All changes

Like what you see shipping?

All of it arrives in your workspace on its own. Start on the free plan and read this page again in a month.

Start Free ForeverView Pricing