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
The @Timestamp property wrapper has an optional format: parameter which determines how the underlying value is stored.
Some formats (like .iso8601) result in types like String however when trying to query these properties in a type safe manner like:
.filter(\Model.$iso8601Property, >= someDate)
The generated SQL does not perform any allowances for the type mismatch and results in the follow error (and failed query)
operator does not exist: text >= timestamp with time zone
Describe the bug
The
@Timestamp
property wrapper has an optionalformat:
parameter which determines how the underlying value is stored.Some formats (like
.iso8601
) result in types likeString
however when trying to query these properties in a type safe manner like:.filter(\Model.$iso8601Property, >= someDate)
The generated SQL does not perform any allowances for the type mismatch and results in the follow error (and failed query)
To Reproduce
Then attempt a query like
Expected behavior
I would expect the SQL to convert the right side value to a String so the query is successful
Environment
The text was updated successfully, but these errors were encountered: