Product: Aqua Data Studio

Version: 18.0.0-devi-242

Build #: 51248

Build Date: 2016-Sep-22 08:18:57 PM

 

Operating Environment: Windows 10 (10.0, amd64) / Cp1252 / en / IN / Oracle Corporation 1.8.0_101-b13

Memory: Max=704,643,072;  Total=501,219,328;  Free=211,025,944;  CPUs=8

 

Issue: Not able to bind created rule to table column using CREATE TABLE UI

 

Scenario 1:

1.Connect to MS SQL Server(Use any version, 2005,2008,2012,2014,2016 or Enterprise)

2.Open QA and execute following script.

CREATE RULE range_rule  
AS   
@range>= $1000 AND @range <$20000
GO

CREATE RULE list_rule  
AS   
@list IN ('1389', '0736', '0877')
GO

CREATE RULE pattern_rule   
AS  
@value LIKE '__-%[0-9]'
GO

Result: Command was executed successfully.

 

3.Go to schema tree node and expand respective Database, Schema and Rules object folder.

 

Result: All created rules are displayed under 'Rules' folder.

 

4.Go to Tables object node and right click select 'CREATE TABLE' option.

5.Enter table_name and column_name with the data type in UI.

6.Select column name and go to Columns pane.

7.Select drop-down list provided for 'Rule Name' option.

 

Result: No rule names are listed in drop down.

 

8.Execute below script on QA, for binding rule name to the column.

USE SampleDB;  
GO  
EXEC sp_bindrule 'range_rule', 'a.a';

Result: Rule gets assigned to the column.

 

See attached screenshot.

 

Observation:

1. This issue is observed

    - v17,v16 & v15 build.

    - MS SQL Server 2005,2008,2012,2014,2016 & Enterprise.

2. As this issue was observed in all builds so not specified broken or working build.