In which task and step of the codelab can this issue be found?
Task 6, section "Logical operators with WHERE clauses"
Describe the problem
The task requests the execution of the following query:
"SELECT * FROM email
WHERE folder = 'inbox' AND read = false;"
The column "read", however, is of type INTEGER, and not BOOLEAN, and thus the query fails.
The correct query would be
"SELECT * FROM email
WHERE folder = 'inbox' AND read = 0;"
Steps to reproduce?
Go to the link
Reach the section "Logical operators with WHERE clauses"
URL of codelab https://developer.android.com/codelabs/basic-android-kotlin-compose-sql?continue=https%3A%2F%2Fdeveloper.android.com%2Fcourses%2Fpathways%2Fandroid-basics-compose-unit-6-pathway-1%23codelab-https%3A%2F%2Fdeveloper.android.com%2Fcodelabs%2Fbasic-android-kotlin-compose-sql#5
In which task and step of the codelab can this issue be found? Task 6, section "Logical operators with WHERE clauses"
Describe the problem The task requests the execution of the following query: "SELECT * FROM email WHERE folder = 'inbox' AND read = false;" The column "read", however, is of type INTEGER, and not BOOLEAN, and thus the query fails.
The correct query would be "SELECT * FROM email WHERE folder = 'inbox' AND read = 0;"
Steps to reproduce?