Icon View Incident Report

Serious Serious
Reported By: Tiago Ameller
Reported On: 12/18/2003
For: Version 4.01 Build 1
# 1516 SQL CREATE INDEX Statement Reversing the Order of Columns During Index Creation

When trying to create the following index, DBISAM creates the index incorrectly.

Type this:

CREATE NOCASE INDEX IF NOT EXISTS "ixFecha" ON "APACTU" 
("Codigo" ASC, "Activa" ASC ,"App" ASC ,"Fecha" DESC) COMPRESS FULL;

and DBISAM will create this: (reversed enginered using DBSYS)

CREATE NOCASE INDEX IF NOT EXISTS "ixFecha" ON "APACTU" ("Codigo"
DESC,"Activa","App","Fecha") COMPRESS FULL;



Resolution Resolution
Fixed Problem on 12/20/2003 in version 4.02 build 1
Image