[Webkit-unassigned] [Bug 64585] New: Using no column in SQL Query should throw DATABASE_ERR.

bugzilla-daemon at webkit.org bugzilla-daemon at webkit.org
Thu Jul 14 23:31:55 PDT 2011


           Summary: Using no column in SQL Query should throw
           Product: WebKit
           Version: 528+ (Nightly build)
          Platform: PC
        OS/Version: Windows 7
            Status: UNCONFIRMED
          Severity: Normal
          Priority: P2
         Component: WebCore Misc.
        AssignedTo: webkit-unassigned at lists.webkit.org
        ReportedBy: jaebok.lee at gmail.com

Created an attachment (id=100938)
 --> (https://bugs.webkit.org/attachment.cgi?id=100938&action=review)

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.

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.

Configure bugmail: https://bugs.webkit.org/userprefs.cgi?tab=email
------- You are receiving this mail because: -------
You are the assignee for the bug.

More information about the webkit-unassigned mailing list