SQLite4Unity3d icon indicating copy to clipboard operation
SQLite4Unity3d copied to clipboard

Row Value Comparison Unsupported?

Open pwade-tvc opened this issue 5 years ago • 0 comments

Not sure if this is an issue here or with sqlite-net but I figured I'd start here. I'm getting an SQLiteException trying to execute the following SQL:

SELECT lastName, firstName FROM attendee WHERE (lastName, firstName) > ('Doe', 'Jane')

There error seems to be on the first comma. The SQL executes correctly in DB Browser and if I remove one of the columns from the clause it executes correctly in code. Is this is a known limitation or am I doing something wrong?

Thanks!

pwade-tvc avatar Feb 13 '20 23:02 pwade-tvc