IssueTracker

Component used: LiveData, Room
Version used: 1.0.0-alpha2
Devices/Android versions reproduced on: Emulator 26

Room with LiveData throws exception on "WITH" clause. I think LiveData tries to register on the name of WITH clause as if it is a table. Same SQL query works with Room without LiveData.


SQL query:
   WITH split(i,l,c,r) AS (
       SELECT book.bookId, 1, author||'|', '' FROM book
     UNION ALL
       SELECT i,
              instr(c,'|') AS vLen,
              substr(c,instr(c,'|')+1) AS vRem,
              substr(c,1,instr(c,'|')-1) AS vCSV
       FROM split
       WHERE vLen>0
     )
   SELECT DISTINCT  split.r FROM book , split
   WHERE book.bookId=split.i AND split.r<>''
   ORDER BY split.r

Table example:
CREATE TABLE book (
     bookId INTEGER PRIMARY KEY,
     author TEXT
);

INSERT INTO book (author) VALUES
('|A||B||C|'),
('|A||D|'),
('|B||D|');

Exception:

FATAL EXCEPTION: pool-2-thread-1
       Process: tr.name.fatihdogan.books.debug, PID: 15674
       java.lang.IllegalArgumentException: There is no table with name split
                        at android.arch.persistence.room.InvalidationTracker.addObserver(InvalidationTracker.java:228)
                        at android.arch.persistence.room.InvalidationTracker.addWeakObserver(InvalidationTracker.java:255)
                        at tr.name.fatihdogan.books.repository.BookDao_Impl$7.compute(BookDao_Impl.java:621)
                        at tr.name.fatihdogan.books.repository.BookDao_Impl$7.compute(BookDao_Impl.java:609)
                        at android.arch.lifecycle.ComputableLiveData$2.run(ComputableLiveData.java:87)
                        at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1133)
                        at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:607)
                        at java.lang.Thread.run(Thread.java:761)