David W. Van Couvering wrote:
This is an example where we find our code throwing the wrong SQL State,
but are we allowed to fix it? Lance says yes. Others providing support
for customers say (I think) no.
This ties into the discussion about the stability classification for SQL
States. If we mark it as Stable, then we can't change this. If we mark
it as Unstable, then we can.
Comments, thoughts?
Is there a document for Derby with error conditions and expected SQL
state ? If there is no such document, one cannot claim that the
classification for SQL state is Stable.
In general, I do not think any interface can be marked as stable, unless
documented.
Even if we do have a document of expected error conditions and expected
SQL state, we should be allowed to make bugfixes if the implementation
is incorrect w.r.t the document / specification.
Andreas