ADBA feedback
Mark Rotteveel
mark at lawinegevaar.nl
Tue May 1 11:37:49 UTC 2018
On 30-4-2018 18:25, Douglas Surber wrote:
> If there are several similar columns in sequence, then an off-by-one error may be difficult to detect. The redundant specification of the column makes it easier to detect such errors. While it allows runtime detection of errors, it doesn’t eliminate column counting and index shifting.
>
> With respect to case, I’d say the spec should be silent. Vendors can do whatever is appropriate for their database. For example Oracle Database would likely ignore case but would support case-sensitive double quoted identifiers, “\”lower case identifier with spaces\”’.
I would really prefer if ADBA uses the same rules as JDBC, instead of
just making this a free-for-all which will only lead to confusion and
mismatches in expectations between drivers. Consistency is important.
Mark
--
Mark Rotteveel
More information about the jdbc-spec-discuss
mailing list