search

Jaguar-dart / jaguar_orm

Source-generated ORM with relations (one-to-one, one-to-many, many-to-many), preloading, cascading, polymorphic relations, etc
https://jaguar-dart.github.io
BSD 3-Clause "New" or "Revised" License
217 stars 52 forks source link

Compose find for sqflite adapter wrong #132

Closed mikeroneer closed 5 years ago

mikeroneer commented 5 years ago

The GROUP BY clause is always the very last clause in the SELECT statement, no matter in which order the calling code orders the clauses. This leads to an SQL exception when used together with ORDER BY or LIMIT. According to https://www.sqlite.org/syntaxdiagrams.html#select-stmt, this is invalid syntax.

tejainece commented 5 years ago

I am guessing this issue is fixed. Please reopen if that is not the case.