Cannot get table Primary Key in query

[josh9060]

Hi all,

I am using room for persistence.

I have a table Holiday that has a PK holidayId.

This query does not work: SELECT holidayId FROM holiday.

I get this error: no such column: holiday (Sqlite code 1 SQLITE_ERROR): , while compiling: SELECT [holiday]Id FROM [holiday], (OS error - 2:No such file or directory).

However, in that error it clearly identifies the column name: 0: {isPrimary: true, title: "holidayId"}.

If I get another column in the query, e.g. date - SELECT date FROM holiday - it works.

Any help would be appreciated.