node-sqlite3 icon indicating copy to clipboard operation
node-sqlite3 copied to clipboard

Add character offset to error message

Open andrewitsover opened this issue 1 year ago • 0 comments

Summary

Currently, when an error occurs, an Error object is thrown with the error message. When debugging errors in SQL, it is very useful to know where in the SQL the error occurred. Therefore, a custom error object should be thrown with error offset information included.

Proposed implementation

sqlite3_error_offset should be called after sqlite3_errmsg to obtain the offset within the SQL that caused the error. It will be -1 if the problem does not relate to the SQL syntax itself. This should be returned in JavaScript via a custom Error class that includes the message as standard, and the offset as additional information.

andrewitsover avatar Apr 13 '24 04:04 andrewitsover