Reported By: Tiago Ameller Reported On: 12/18/2003 For: Version 4.01 Build 1
# 1516SQL 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;
ResolutionFixed Problem on 12/20/2003 in version 4.02 build 1