[Koha] Case Sensitivity and Koha SQL Statements

[Katrin Fischer]

Hi Charles,

the runtime parameters are not part of SQL, but are Koha specific. They
are replaced with proper SQL before being run. If you can point us to
where the documentation or Koha behavior is wrong, we can fix that. Best
would be to file bugs on https://bugs.koha-community.org/ separately for
the manual and Koha itself.

Hope this helps,

Katrin

On 01.10.21 06:35, Charles Kelley wrote:
> Hello, all!
>
>      In my previous experience with SQL, case did not matter, but here it
> does?
>
>      I've been tearing out my hair -- and I'm bald -- for the last several
> hours over a reported syntax error in a SQL statement I have been
> composing. It turns out that it wasn't a syntax error, per se -- and I
> studied for a doctorate in theoretical syntax -- rather a case sensitivity
> error.
>
>      The portion of the statement at hand is
>
> ... WHERE items.itype = <<Item type|ITEMTYPES>>
>
>      It turns out "ITEMTYPES" ought to be written "itemtypes". Only through
> trial and error did I learn that some identifiers are case sensitive. I
> sought in the Koha wiki confirmation, refutation, and qualification that
> CASE INDEED MATTERS IN IDENTIFIERS, but I could not find anything about
> that.
>
>      If case does indeed matter, please update the online and print SQL
> manual(s) accordingly. I would not have spent two hours on this if the
> correct word had been used in the error message. So please adjust the
> wording, too.
>
>      Many thanks.
>