Changes between Version 4 and Version 6 of Ticket #35941


Ignore:
Timestamp:
Dec 2, 2024, 1:11:26 AM (5 weeks ago)
Author:
Csirmaz Bendegúz
Comment:

Legend:

Unmodified
Added
Removed
Modified

  • Ticket #35941

    • Property Cc Peter Thomassen added
    • Property Has patch set

  • Ticket #35941 – Description

    v4 v6  
    882. ''CompositePrimaryKey'' is stored as a ''JSON array'' in `object_id`
    993. JOINs can be achieved with JSON functions (varies per db backend)
     10
     11*Joins:*
     12
     13After some experimentation with JSON functions, I believe the simplest solution is to construct JOINs like this:
     14
     15{{{
     16JOIN ON ((object_id::jsonb)->>0)::integer = id
     17    AND ((object_id::jsonb)->>1)::uuid = uuid
     18}}}
     19
     20Casting is a pain point, especially when joining on `DateTimeField`s, as we need to make sure the two columns are in the same format.
    1021
    1122**Risks:**
Back to Top