Improve rowid handling for Room [120407095]

Fixed

Feature Request

Status Update

No update yet.

Description

be...@google.com

created issue #1

Dec 3, 2018 12:04PM

Currently we cheat by muting the unresolved references inspection if the unresolved column is called "rowid", "oid" or "_rowid_". We should teach Room support code to properly understand the concept:

- take into account that views and temporary tables defined using WITH don't have rowid
- allow "docid" in FTS tables
- resolve rowid to an integer primary key field of the entity, if defined
- handle fields called oid etc. properly

See

https://www.sqlite.org/rowidtable.html and

https://www.sqlite.org/lang_createtable.html#rowid

Comments

be...@google.com <be...@google.com> Apr 9, 2019 03:38PM

Status: New

be...@google.com <be...@google.com> Apr 10, 2019 12:32PM

Assigned to ko...@google.com.

ko...@google.com <ko...@google.com> May 3, 2019 12:25PM

Accepted by ko...@google.com.

be...@google.com <be...@google.com> #2May 20, 2019 11:17AM

This is not a blocker for 3.5

ko...@google.com <ko...@google.com> May 24, 2019 10:00AM

Marked as fixed.

Issue 120407095