#15426: Descending keyword is extracted in Create index->Order column.

nileshhmali reported 2017-08-07T07:49:23Z · last modified 2017-08-09T05:48:52Z

Descending keyword is extracted in Create index->Order column.

Dev	ivangron
QA	tariqrahiman

Priority	Low
Complexity	Unknown

Component	DB - Sybase IQ
Version	19.0

Product: Aqua Data Studio

Version: 19.0.0-beta-34

Build #: 55403

Build Date: 2017-Aug-06 08:07:36 AM

Operating Environment: Linux (4.4.0-64-generic, amd64) / UTF-8 / en / US / Oracle Corporation 1.8.0_102-b14

Memory: Max=704,643,072; Total=322,961,408; Free=174,128,872; CPUs=8

Connect Sybase IQ-16.0/15.4

//Create table

CREATE TABLE "DBA"."Test_index_tb" (

"c1" varchar(25) NULL,

"c2" varchar(25) NULL

)

IN iq_main

GO

Steps:

Go to index tree node

Right click on index and select Create index option.

Create index tab opens

Enter index name

Select table "Test_index_tb"

Go to indexes column pane.

Click on order dropdown

Actual Result:

Descending keyword is extracted in Create index->Order column.

Select option descending from order column.

Switch to preview tab

you can see DESC keyword is extracted

Click on Create button

Displayed error message "SQL Anywhere Error -1000157: Columns for the index must be in ascending sort order."

Expected Result:

Descending order should not be extracted in Create index->Order column.

Please refer doc

SAP Sybase IQ does not permit the DESC keyword.

2 attachments

Desc.png

2017-08-07T07:49:23Z

180 KB
Verified_in_V19_beta-37.png

2017-08-09T05:46:18Z

89 KB

All Comments (3) Change History

nileshhmali 2017-08-07T07:51:17Z · (edited)

Note: I have set priority LOW because this issue is reproducible in ADS-19.0/18.0/16.0/15.0/17.0

Database
Sybase IQ-16.0 / 15.4 / 15.2 / 15.1
	Windows	Ubuntu
ADS19.0-beta-34	Y	Y
ADS18.0	Y	Y
ADS17.0	Y	Y
ADS16.0	Y	Y
Y - Yes, issue reproduced. N-issue is not reproduced.

ivangron 2017-08-08T19:28:31Z

The flag for supports index sort order has been true from initial implementation of Sybase IQ. I have changed flag to false. Committed revision: 55428

nileshhmali 2017-08-09T05:48:52Z · (edited)

Verified in ADS-19.0-beta-37(DESC keyword is not extracted)

Please refer Verified_in_V19_beta-37.png

Search Tips

Aqua Data Studio / nhilam

Descending keyword is extracted in Create index->Order column.

2 attachments

Issue #15426

Completion

Search Tips

Aqua Data Studio / nhilam

Title

Descending keyword is extracted in Create index->Order column.

2 attachments

Issue #15426

Completion