UNCONFIRMED Bug 64585
Using no column in SQL Query should throw DATABASE_ERR. 
https://bugs.webkit.org/show_bug.cgi?id=64585
Summary Using no column in SQL Query should throw DATABASE_ERR.
jaebok.lee
Reported 2011-07-14 23:31:55 PDT
Created attachment 100938 [details] example_throw_SYNTAX_ERR I attached sample html file. Table USERS has no column named USER_NAMES in HTML file. That is not grammer error, so I expect it should throw DATABASE_ERR. <debug> WebKit uses sqlite3, but the return value of sqlite3_prepare16_v2 Call("SELECT USER_NAMES FROM USERS") is just SQLITE_ERROR. I wonder how to know if a statement has syntax problem or not. <SYNTAX_ERR in spec> The statement failed because of a syntax error, or the number of arguments did not match the number of ? placeholders in the statement, or the statement tried to use a statement that is not allowed, such as BEGIN, COMMIT, or ROLLBACK, or the statement tried to use a verb that could modify the database but the transaction was read-only. (http://www.w3.org/TR/webdatabase/#dom-sqlexception-code-syntax)
Attachments
example_throw_SYNTAX_ERR (913 bytes, text/html)
2011-07-14 23:31 PDT, jaebok.lee 		no flags
Details
View All Add attachment proposed patch, testcase, etc.
Note You need to log in before you can comment on or make changes to this bug.