Aqua Data Studio 15.0.0-dev-63
Build #: 35415
Built on: 2014-Jan-03 09:09:58 AM

Operating System: Windows 8

Database: Sybase Anywhere

 

Description:

     When we have two indexes on same table and we search for index columns through Object search tool then it searches with wrong index columns also.

 

 

Steps

Step 1:

Connect to Sybase Anywhere DB

Go to Schema

Create indexes

Index scripts

Index 1:

     CREATE INDEX "df"

        ON "123"."Date_Time"("c4", "c5")

GO

 

Index 2:

CREATE INDEX "tre"

        ON "123"."Date_Time"("c2", "c3")

GO

 

Step 2:

Right click on Schema

Go to tools option

Select Object Search option

 

Step 3:

Select database ‘test’ in Database section
Select Schema in Schema section
Check Indexes from Object Type
Check 'Index Columns' from Object search section
Click on Search button.

 

 

Here we can observe that wrong index columns are searched.