View Incident Report

Serious

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

# 1122 Using REDEFINE on a Column and the Primary Key in an ALTER TABLE Causes Incorrect Key Fields

I have a table with this primary key: CustomerID;SessionID;Pos. When I do the following SQL the new PK should be OrderID;Pos but it is now OrderID;Pos;Pos. It looks as the old third filed in the PK is not deleted.

SQL.Text := 'ALTER TABLE Orders ' +
        'REDEFINE CustomerID AT 3 , ' +
        'REDEFINE SessionID OrderID CHARACTER(25) AT 1,' +
        'REDEFINE PRIMARY KEY ("OrderID","Pos") COMPRESS DUPBYTE';

Resolution

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

More Support Options

Search Incident Reports

Support Forums

Frequently Asked Questions

Technical Bulletins

Technical Articles

Product Manuals

Roadmap