Derby doesn't support intervals on DATE columns, thus no arithmetic operations can be applied to those types of columns. Approximately 50 UPDATE statements from the OST benchmark (for TPCH), for example:
UPDATE tpch.lineitem
SET l_commitdate = l_commitdate + 1 day
WHERE tpch.lineitem.l_receiptdate
BETWEEN 'Mon Feb 16 16:19:56 PST 1998'
AND 'Sat Feb 28 16:19:56 PST 1998' RETURNING 7;
Derby doesn't support intervals on DATE columns, thus no arithmetic operations can be applied to those types of columns. Approximately 50 UPDATE statements from the OST benchmark (for TPCH), for example:
In the meantime we're just removing these.