View Incident Report

Serious

Reported By: Ole Willy Tuv
Reported On: 6/25/2002
For: Version 3.10 Build 1

# 1145 Using an Invalid Column Alias in SQL CREATE INDEX Index Columns Does Not Cause Error

By mistake I typed '.' instead of ',' in the following SQL statement. he statement executed without an error, but created an index
on (SField5, TLastUpdate). Would be nice if the parser catches this syntax error.

CREATE IF NOT EXISTS INDEX ix_SField1_SField5_Stamp
ON MyTable(SField1. SField5, TLastUpdate);

Resolution

Fixed Problem on 7/1/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