How can a case sensitive table (or field) name be used?

Question

How can a case sensitive table (or field) name be used?

Opened this issue 10 years ago · 3 comments

For instance, I have a table named 'theTest' in MySQL. Table names are case sensitive in MySQL, so a query selecting from 'thetest' will fail.

Using the sxql syntax, I can't find how to do something like:

(with-connection (db)
  (retrieve-all
    (select :*
      (from :theTest))))

As the keyword ':theTest' becomes 'thetest' for the table name. Escaping via bars fails as well. It also seems like it is not possible to just call it as a string, such as "theTest".

Answer 1 · 2014-12-30T17:49:13.000Z

:|theTest|, I believe.

Answer 2 · 2014-12-30T23:36:37.000Z

I wish it did, but unfortunately this still presents an error, "DB Error: Table 'database.thetest' doesn't exist (Code: 1146)".

Answer 3 · 2014-12-31T00:32:11.000Z

There is an issue with the datafly part of sxql, filed an issue there, possible fix pending (also the correct way seems to be double quoting it, so it becomes "theTest").