ORACLE and INTERVAL columns

This migration note is related to the correction of bug 16341, fixed in 2.30.00 build 1566.

Before this fix, negative (and only negative) INTERVAL values were inserted incorrectly. For example, it was not possible to compare an INTERVAL value inserted by a program with an INTERVAL literal:

SELECT ... FROM table
  WHERE interval_col = INTERVAL '-55555-11' YEAR(9) TO MONTH

You must correct the values in your tables if you are using:

INTERVAL YEAR(p) TO MONTH

INTERVAL DAY(p) TO FRACTION(n)

(Other INTERVAL types are stored in a CHAR(50).)

A simple INTERVAL to CHAR to INTERVAL conversion will fix the values:

UPDATE table SET interval_col = TO_CHAR(interval_col)