Android-AnnotatedSQL icon indicating copy to clipboard operation
Android-AnnotatedSQL copied to clipboard

Lib has an issue with support at least one sqlite aggregation function in @RawQuery

Open Gelassen opened this issue 10 years ago • 1 comments

Steps to reprodice:

  1. 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;

  1. Initiate request
  2. 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: expected Error:(69, 1997) error: expected

Gelassen avatar Dec 24 '15 09:12 Gelassen

As a workaround I define a custom content provider and override the query method to add the qery manually.

Gelassen avatar Dec 24 '15 10:12 Gelassen