@soegaard2 I’ve run into this as well with the way deta generates UPDATE and DELETE queries for SQLite. In fact, the pkg-build for deta fails exactly because of this problem: https://pkg-build.racket-lang.org/server/built/test-fail/deta-test.txt

There is mention of parser changes in 3.23 and up so I assume that’s when they fixed the problem. The syntax diagrams for SQLite (https://sqlite.org/syntaxdiagrams.html#qualified-table-name) show that the syntax should be legal so I’ve been treating this as something that’ll eventually go away on its own as OSs upgrade their version of SQLite.

Looks like this is the commit that fixed the problem:

https://github.com/sqlite/sqlite/commit/5e3a6ebf34aac81972b2ca9809494b8e7485c8d4

(first released in 3.24)

@soegaard2 I made a package that distributes a recent version (3.29) of libsqlite3 for linux:

https://github.com/Bogdanp/racket-libsqlite3

You can install it with the following command:

raco pkg install --name libsqlite3-x86_64-linux <https://racket.defn.io/libsqlite3-x86_64-linux-3.29.0.tar.gz>

I’d be curious to know if it solves your problem

@popa.bogdanp Thanks for this! The offending query is indeed a DELETE so I am sure this must be the reason.

Yep. It works beautifully.

Sweet

I’ve added it to the package server so you can make your application depend on it on Linux (once it successfully builds on the package server) with a platform-specific dependency declaration like this:

https://github.com/Bogdanp/deta/blob/master/deta-test/info.rkt#L5

Great - that means others can run the tutorial without running into the same problem.