You signed in with another tab or window. Reload to refresh your session.You signed out in another tab or window. Reload to refresh your session.You switched accounts on another tab or window. Reload to refresh your session.Dismiss alert
In SQLPage, we parse SQL queries using sqlparser in order to be able to modify them, and then dump them as text to run them on the database. This requires the process of parsing and then stringifying back not to break the semantics nor the syntax of the query.
However, the following SQLite query:
SELECTCURRENT_TIMESTAMP;
when parsed and then dumped back, gives:
SELECTCURRENT_TIMESTAMP();
This breaks the syntax for SQLite, which gives
sqlite> SELECT CURRENT_TIMESTAMP();
Error: in prepare, near "(": syntax error (1)
The text was updated successfully, but these errors were encountered:
In SQLPage, we parse SQL queries using sqlparser in order to be able to modify them, and then dump them as text to run them on the database. This requires the process of parsing and then stringifying back not to break the semantics nor the syntax of the query.
However, the following SQLite query:
when parsed and then dumped back, gives:
This breaks the syntax for SQLite, which gives
The text was updated successfully, but these errors were encountered: