You signed in with another tab or window. Reload to refresh your session.You signed out in another tab or window. Reload to refresh your session.You switched accounts on another tab or window. Reload to refresh your session.Dismiss alert
select d.id, d.data, d.mt_version from public.mt_doc_myentity as d where CAST(d.data -> 'Inner' ->> 'Integer1 ' as integer) = :p0 order by d.data -> 'Inner' ->> 'Integer2 ' desc;
which leads to alphanumeric ordering. Expected was numeric ordering.
I assume that marten misses to add the CAST operator such that the following sql was produced:
select d.id, d.data, d.mt_version from public.mt_doc_myentity as d where CAST(d.data -> 'Inner' ->> 'Integer1 ' as integer) = :p0 order by CAST(d.data -> 'Inner' ->> 'Integer2' as integer) desc;
Say there are two classes
and
Entity
is stored as a document by marten.When then querying like:
following sql gets produced:
select d.id, d.data, d.mt_version from public.mt_doc_myentity as d where CAST(d.data -> 'Inner' ->> 'Integer1 ' as integer) = :p0 order by d.data -> 'Inner' ->> 'Integer2 ' desc;
which leads to alphanumeric ordering. Expected was numeric ordering.
I assume that marten misses to add the
CAST
operator such that the following sql was produced:select d.id, d.data, d.mt_version from public.mt_doc_myentity as d where CAST(d.data -> 'Inner' ->> 'Integer1 ' as integer) = :p0 order by CAST(d.data -> 'Inner' ->> 'Integer2' as integer) desc;
Also discussed here on the marten discord
The text was updated successfully, but these errors were encountered: