KamoCRM

CockroachDB-only SQL that PostgreSQL rejects

FixEmailService
Shipped
10 ஆகஸ்ட், 2026 அன்று 2:13 PM UTC
Author
Kamo
Commit
3afd5a2

CockroachDB spells the text type STRING; PostgreSQL and YugabyteDB use TEXT. 25 casts across native queries were still emitting CAST(x AS STRING) and ::STRING, which fail with 'type string does not exist'. That is what broke the mailbox dropdown on /messages -- SendableMailboxService could not run at all. Also in this sweep: UPSERT INTO -> INSERT .. ON CONFLICT DO UPDATE (OCRService) INVERTED INDEX -> CREATE INDEX .. USING GIN (email search vector) inline INVERTED INDEX inside CREATE TABLE hoisted out

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