View Incident Report

Serious

Reported By: Rolf Frei
Reported On: 4/17/2002
For: Version 3.10 Build 1

# 1123 Using REDEFINE without an AT Clause Causes Column to Be Moved to End of Columns in Table

I have the following SQL. After this call the OrderDate is at the end of the table.

ALTER TABLE Orders REDEFINE "OrderDate" DATE DEFAULT "CURRENT_DATE"

Comments and Workarounds

The workaround is to explicitly use the AT clause.

Resolution

Fixed Problem on 4/20/2002 in version 3.11 build 1

More Support Options