ALTER TABLE defaultValueTest ALTER COLUMN dateA WITH DEFAULT DATE('2007-08-09')and getting the error: “An attempt was made to get a data value of type 'long' from a data value of type 'DATE'.”
It's possible you're hitting https://issues.apache.org/jira/browse/DERBY-2371, which was fixed in both the 10.3 and 10.2 code lines, but the 10.2 fix was *after* the 10.2.2.0 release, so you'd have to build the 10.2 branch yourself to get that fix. thanks, bryan
