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