Android-AnnotatedSQL
Android-AnnotatedSQL copied to clipboard
Lib has an issue with support at least one sqlite aggregation function in @RawQuery
Steps to reprodice:
- Define rawquery as
SELECT AI._id, GROUP_CONCAT(Name, ", ") AS GroupedName FROM ABSTRACTS_ITEM AI JOIN AUTHORS_ABSTRACT AAB ON AI.ID = AAB.ABSTRACTSITEM_ID JOIN ABSTRACT_AUTHOR AAU ON AAU._id = AAB.ABSTRACTAUTHOR_ID GROUP BY tbl._id;
- Initiate request
- Build application
Expected result: App successfully is built and request works well
Actual result: App is crashed during build. Error in autogenerated dbschema with errors:
Error:(69, 1903) error: ';' expected
Error:(69, 1914) error:
As a workaround I define a custom content provider and override the query method to add the qery manually.