Bryan Pendleton wrote:
Kathey Marsden wrote:
I think setting the type should not change the nullability of the
column.
I agree; we have a separate ALTER TABLE command for modifying
nullability.
However, I don't recall this specific question being discussed during the
10.3 ALTER TABLE work, so it's quite possible that 10.3 isn't behaving
correctly, either.
Certainly looks like you've found a soft spot worthy of more
investigation.
Thanks Bryan,
I went ahead and filed DERBY-3566 for the difference in behavior. At
least 10.3 and
10.4 soft upgrade should behave the same. What do you think might be
the problem with
10.3?
Kathey