[Chicken-hackers] Collating prepared statements in sqlite3: bug?

[Peter Danenberg]

When I attempt to collate a prepared statement, the arguments to the
collation function are the names of the column and not the values
thereof.

Given a collation function of, for instance:

  (define-collation db "COLLATETHIS" (lambda (x y) ...))

and a prepared statement:

  "SELECT * FROM test ORDER BY ? COLLATE COLLATETHIS LIMIT ? OFFSET ?;"

x and y in COLLATETHIS will be "id", "id" and not, say, "1", "2".

ASC and DESC are similary afflicted, and don't seem to sort prepared
statements; I suspect that they, too, are passed not values but column
names.

Looking at sqlite3.scm, it's not immediately obvious how to fix it.