× Heads up!

Aqua Data Studio / nhilam

Follow
IDE for Relational Databases
×
Diksha Kushwah
Diksha.kushwah(*) reported 2014-01-10T11:28:33Z  · tariqrahiman last modified 2014-10-24T22:36:11Z

Multiple Indexes does not delete in Teradata


Dev
John LH
JohnLH
QA
Tariq Rahiman
tariqrahiman
Priority Minor
Complexity Unknown
Component App - Visual Editing
Version Future - 0.1
ADS Version: 15.0.0-dev-66
Build #: 35415
Database: Teradata 14.0
 
Description:
 
1. connect Teradata 14.0
2. Execute the following Script in Query Analyser:
 
   CREATE SET TABLE TEST,
NO FALLBACK,
LOG,
CHECKSUM = DEFAULT ( 
c1 VARCHAR(25) CHARACTER SET LATIN,
c2 VARCHAR(25) CHARACTER SET LATIN,
c3 VARCHAR(25) CHARACTER SET LATIN 
)
    GO
 
    CREATE INDEX test_index (c3, c2, c1)
ON TEST
    GO
 
    CREATE INDEX test_create (c3)
ON TEST
 
3. Now Select two Indexes test_index and test_create -> Select Delete
4. Click on ok in Delete window
5. Message display that "Operation cancelled or stoped on error" in Delete window.
6. when we drop the single index then it drop
7. It should delete multiple indexes.
3 attachments
  •  
  •  
  • No shares
  •  
All Comments (2) Change History
Sort 

Issue #11324
Closed
Unreproducible
Resolved 2014-10-24T22:34:52Z
 
 
Completion
No due date
No fixed build
No time estimate

About AquaClusters Privacy Policy Support Version - 19.0.2-4 AquaFold, Inc Copyright © 2007-2017