View Incident Report

Serious

Reported By: Ole Willy Tuv
Reported On: 11/24/2000
For: Version 2.04 Build 1

# 665 SQL ALTER TABLE Statements Require Repeat of Column Name for REDEFINE Clause

There's a glitch in the OLM ALTER TABLE REDEFINE example:

ALTER TABLE "Names.dat"
REDEFINE LastName CHAR(30)

Should be corrected to:

ALTER TABLE "Names.dat"
REDEFINE LastName LatName CHAR(30)

I think it would be nice if you could explain the REDEFINE syntax a bit more clear in the Online Manual.

REDEFINE LastName CHAR(30)

REDEFINE LastName NewName CHAR(30)

Comments and Workarounds

The Online Manual incorrectly stated that repeating the column name was not necessary for the REDEFINE clause. Now the Online Manual is correct, and you may choose to repeat the column name (if you wish to rename it) or not. Note that repeating the same column name will not cause any harm, so this fix will not break any existing SQL statements that use this syntax that was previously required.

Resolution

Fixed Problem on 11/25/2000 in version 2.05 build 1

More Support Options

Search Incident Reports

Support Forums

Frequently Asked Questions

Technical Bulletins

Technical Articles

Product Manuals

Roadmap