This Bugzilla instance is a read-only archive of historic NetBeans bug reports. To report a bug in NetBeans please follow the project's instructions for reporting issues.

Bug 262847 - [82cat] Unique property for indexes is not reported as true for unique indexes
Summary: [82cat] Unique property for indexes is not reported as true for unique indexes
Status: RESOLVED FIXED
Alias: None
Product: db
Classification: Unclassified
Component: Code (show other bugs)
Version: 8.2
Hardware: PC Mac OS X
: P3 normal (vote)
Assignee: matthias42
URL:
Keywords:
Depends on:
Blocks:
 
Reported: 2016-07-18 09:42 UTC by brettryan
Modified: 2016-08-05 01:57 UTC (History)
0 users

See Also:
Issue Type: DEFECT
Exception Reporter:


Attachments

Note You need to log in before you can comment on or make changes to this bug.
Description brettryan 2016-07-18 09:42:44 UTC
Steps to Reproduce
------------------

1. Connect to the sample Derby DB database
2. Execute the following SQL against the sample database

create table test_unique_index (
  id    integer primary key,
  name  varchar(30)
);
create unique index ix_test_unique_index on test_unique_index (name);

3. Open the property window (Shift+CMD+7)
4. Navigate the connected database in the services tab to APP > Tables > TEST_UNIQUE_INDEX > Indexes
5. Select each of the index nodes in the indexes list and observe the properties in the properties window.


Actual Behaviour
----------------

Unique is never reported as ticked for any index highlighted.


Expected Behaviour
------------------

Unique should be ticked for any index that is known to be unique.
Comment 1 matthias42 2016-08-03 19:45:02 UTC
Fix pushed as:

http://hg.netbeans.org/core-main/rev/8048d1cd8717

The "writeable" attribute of the property was swapped with the value of the property. Thanks!
Comment 2 Quality Engineering 2016-08-05 01:57:16 UTC
Integrated into 'main-silver', will be available in build *201608050002* on http://bits.netbeans.org/dev/nightly/ (upload may still be in progress)

Changeset: http://hg.netbeans.org/main-silver/rev/8048d1cd8717
User: Matthias Blaesing <matthias42@netbeans.org>
Log: #262847: Unique property for indexes is not reported as true for unique indexes

The writeable property and the value itself were inverted.