Hello experts,

I've got a Ultralite BUG during a database schema upgrade using the ALTER DATABASE SCHEMA FROM FILE command.

If I try to add an index to a column of a existent table that already has an indexed column (by schema migration), the Ultralite database becomes invalid and the following error is shown during the database validation:

Validation failed:
Index validation failed for table Test, index Test with code: 120

Is there any workaround for it? I've used the SqlAnywhere 12.0.1.3505

• Create a new database (TestDatabase.udb)
  SybaseCentral: ulinit -p "4096" -S "0" --max_hash_size=4 --timestamp_increment=1 -y "TestDatabase.udb"
  

• Create a new table:
  Test (id SMALLINT PK, code VARCHAR(50) NOT NULL, value VARCHAR(50))

• Create a non-unique index to value column

• Feed the Test table with some data

• Create a copy of the database to design the second version of schema (TestDatabaseV2.udb)

• Add the unique constraint for code column of Test table (The Ultralite will add a index to this column automaticaly)

• Unload the schema for the second schema as a SQL file (TestDatabaseV2.sql)
  SybaseCentral: ulunload -v -y -c "DBN=TestDatabaseV2;CON=N_Sybase Central 1;DBF=TestDatabaseV2.udb" -b 1024 -n -s "TestDatabaseV2.sql"

• Connect to the first database and execute the schema upgrade using the command below:
  ALTER DATABASE SCHEMA FROM FILE 'TestDatabaseV2.sql'

• Check the database, using the "Validate Database..." option of Sybase Central. It will return an index error.
  SybaseCentral: ulvalid -v -c "DBN=TestDatabase;CON=N_Sybase Central 2;DBF=TestDatabase.udb"

The following output is shown:

Checking page (1)
Validating table Test
Validating index primary on table Test
Validating index Test on table Test
Incorrect row count for index Test on table Test
Validating index IX_test on table Test
Validating table sysuldata
Validating index primary on table sysuldata
Validation failed:
Index validation failed for table Test, index Test with code: 120