× Heads up!

Aqua Data Studio / nhilam

Follow
IDE for Relational Databases
×
Chandradip Jain
chandradipjain(*) reported 2014-05-06T13:43:03Z  · tariqrahiman last modified 2014-06-24T19:46:09Z

In Fluidshell, describe table command does not list all indexes.


Dev
Tariq Rahiman
tariqrahiman
QA
Tariq Rahiman
tariqrahiman
Priority Low
Complexity Unknown
Component DB - RedShift
Version 15.0
Aqua Data Studio 15.0.0-dev-268
Build #: 37692
Built on: 2014-May-05 05:40:21 PM
OS Environment: Windows 8(x64 bit)
 
Database : Amazon Redshift
 
 
Steps to reproduce:
 
For Amazon Redshift:
 
1. Connect to Redshift server --> Go to Databases folder
2. Select any schema 
3. Create Table
   
   CREATE TABLE "testredshift"."emp"  ( 
    "id"       int4 NOT NULL,
    "name"     varchar(25) NULL,
    "dept"     varchar(25) NULL,
    "salary"   int4 NULL,
    "join-date" date NULL,
    "Contact"   int4 NULL,
    CONSTRAINT "primary" PRIMARY KEY("id")
   )
   DISTSTYLE EVEN
   GO
   ALTER TABLE "testredshift"."emp"
    ADD CONSTRAINT "uniq"
    UNIQUE ("Contact")
   GO
 
4. Open FluidShell 
5. Execute below command
  
   describe -s testredshift emp
   
   Here it is observed that, Under Indexes system generated index on primary key is not listed only index on unique key is dispalyed. 
   
Please see attached screenshot.
2 attachments
  •  
  •  
  • No shares
  •  
All Comments (1) Change History
Sort 

Issue #12064
Closed
Won't Fix
Resolved 2014-06-24T19:46:09Z
 
 
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