SQLDelight: Is this not a standard SQL syntax to ...

# squarelibraries

[Richard Glen]

SQLDelight:

Is this not a standard SQL syntax to not be supported?

[hfhbd]

Which dialect do you use? The error message might look like a missing internal import.

As a workaround you can use a join.

[Richard Glen]

Using mysql dialect. Sorry I dont follow how to use JOIN to replace what i need.

I need to get the max id

[hfhbd]

SELECT r.id, r.filename, r.parsingType, r.description FROM seedingProcessResult r
JOIN seedingProcessResultItem ON r.id = seedingProcessResultId
JOIN (
SELECT MAX(id) AS mid FROM seedingProcessResult) m ON r.id = m.mid

You might need to adopt it to your schema that I guessed.