IssueTracker

Component used: Room on Android Studio 3.2
Version used: 2.0.0-rc01
Devices/Android versions reproduced on: it's an IDE issue

This is a simple DAO with the following query:

@Dao
abstract class MyDao {
    @Query("""
        SELECT p.`rowId`,
            CASE
                WHEN p.parent IS NULL THEN p.name
                ELSE '— ' || p.name
            END AS name,
            COUNT(i.id) as nbIssues,
            CASE
                WHEN p.parent IS NULL THEN p.name
                ELSE p2.name || p.name
            END AS sort_column
        FROM projects p
        LEFT JOIN projects p2 ON p2.id = p.parent
        LEFT JOIN issues i ON i.project = p.id
        WHERE p.status IN (:statuses)
        GROUP BY i.project
        ORDER BY sort_column
    """)
    abstract fun projectsSpinnerInfo(vararg statuses: ProjectEntity.Status = arrayOf(ProjectEntity.Status.STATUS_ACTIVE)):
LiveData<List<ProjectInformation>>
}

The compiler complains about not being able to resolve `sort_column` in the `ORDER BY` statement (see attn).
However said query works perfectly fine. Tested on a Pixel 3 XL through stetho (see 2nd attn).