check50 -l cs50/problems/2023/sql/meteorites gives this error
:( import.sql creates a table named "meteorites"
Error when executing query: no such table: sqlite_schema
The test might be corrected by querying sqlite_master instead of sqlite_schema in the test script. The sqlite3 version in python on cs50.dev is 3.31.1 and does not have sqlite_schema table. I found anecdotal evidence this was fixed in sqlite v3.30.
Additionally, 'y' needs to be the first line in the script when checked locally because of the sqlite3 wrapper.
check50 -l cs50/problems/2023/sql/meteoritesgives this errorThe test might be corrected by querying
sqlite_masterinstead ofsqlite_schemain the test script. The sqlite3 version in python on cs50.dev is 3.31.1 and does not havesqlite_schematable. I found anecdotal evidence this was fixed in sqlite v3.30.Additionally, 'y' needs to be the first line in the script when checked locally because of the sqlite3 wrapper.