#11566: Constraint column checkbox is not working properly in Object search in Paraccel

vaibhavladdha271(*) reported 2014-01-30T05:08:19Z · last modified 2014-06-24T22:47:03Z

Dev	JohnLH
QA	tariqrahiman

Priority	Low
Complexity	Unknown

Component	Tools - Object Search
Version	Future - 0.1

Aqua Data Studio 15.0.0-dev-86
Build #: 35703
Built on: 2014-Jan-27 10:31:45 AM

Database:Paraccel 4.0.2.4

Operating environment:Windows 7 x64

Connect to Paraccel

Create 2 tables named 'project','organization'

Create table script:

CREATE TABLE [test_schema].[project] (

[pid] int4 NOT NULL ENCODE RAW,

[name] varchar(25) NULL ENCODE RAW,

[companyname] varchar(25) NULL ENCODE RAW,

PRIMARY KEY([pid])

)

DISTSTYLE EVEN

CREATE TABLE [test_schema].[organization] (

[branch] varchar(25) NULL ENCODE RAW,

[address] varchar(25) NULL ENCODE RAW

)

DISTSTYLE EVEN

Right click on created table

Select Tools option

Select Object search option

Select database & schema under which table is created

Check Constraint columns checkbox

Click on Search

It is observed that it shows constraint columns for those tables where constraint columns are not present.

Also it shows all constraints with same name which cannot exist

All Comments (0) Change History