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.
_______________________________________________
Koha mailing list http://koha-community.org
[email protected]
Unsubscribe: https://lists.katipo.co.nz/mailman/listinfo/koha
