Query Error with field

1

Pretty simple query:

SELECT * FROM backend.entity.user_activity WHERE created_at >= 1505402494000

This query fails with:

AssertionError: mismatched type $4 ANY

The underlying query is doing this on the column:

(CASE WHEN i.created_ts IS NULL THEN NULL WHEN i.created_ts = ‘’ THEN NULL ELSE 1000*UNIX_TIMESTAMP(i.created_ts, ‘YYYY-MM-DD"T"HH24:MI:SS.FFFTZO’) END) AS created_at

Basically converting the string in ISO Date format to Epoch time in MS.

Attached is the query profile.

ce357199-de15-4a67-b175-1941c9c0cb21.zip (7.5 KB)

I cannot seem to work around this. Other columns in the where clause work fine.

2

Hi @jhaynie

Try this workaround,

Open the VDS backend.entity.user_activity
Edit Original SQL
Hit a space at the end of the sql like after created_at
Click Sve
Run your original query again

SELECT * FROM backend.entity.user_activity WHERE created_at >= 1505402494000

Thanks
@balaji.ramaswamy