Product: Aqua Data Studio
Version: 18.0.0-alpha-7
Build #: 51629
Build Date: 2016-Oct-23 11:10:37 PM
Operating Environment: Windows 10 (10.0, amd64) / Cp1252 / en / IN / Oracle Corporation 1.8.0_101-b13
Memory: Max=704,643,072; Total=429,916,160; Free=298,165,048; CPUs=4
Database: MS SQL 2016
1. Execute given script query analyzer
CREATE TABLE [dbo].[test] (
[c1] int NULL
)
GO
2. Navigate to Indexes node in Schema browser
3. Right click on Indexes node and Select option "Create Index"
4. In Create index visual editor, enter below details:
Name: ind
Scehma: dbo
Table : test
Column name: c1
5. Go to Options tab and check "Columnstore" option
6. In general tab set Sequence : 1 and Order as "Descending"
7. Go to Preview tab, observe script and click on Create icon
Actual Result : An error message "The statement failed because specifying sort
order (ASC or DESC) is not allowed when creating a columnstore index. Create
the columnstore index without specifying a sort order." gets displayed. The cause is the setting of sort order which is not allowed for columstore indexes.
Expected Result : Whenever we check option "Columnstore" in Options tab, we should be disabled /restrict the Order selection option in general tab.
Scenario 2:
1. Execute given script query analyzer
CREATE TABLE t3 (
c1 int NULL,
c2 text null
)
GO
2. Navigate to Indexes node in Schema browser
3. Right click on Indexes node and Select option "Create Index"
4. In Create index visual editor, enter below details:
Name: ind
Scehma: dbo
Table : t3
Column name: c2
Sequence : 1
5. Go to Options tab and check "Columnstore" option
6. Go to Preview tab, observe script and click on Create icon
Actual Result : An error message "The statement failed. Column 'c2' has a data
type that cannot participate in a columnstore index. Omit column 'c2'." gets displayed. The cause is the unsupported datatype for which columstore indexes not allowed.
Expected Result : Whenever we select column with below datatype we should disable the "Options tab > Columnstore" option
ntext, text, and image
varchar(max) and nvarchar(max)
rowversion (and timestamp)
sql_variant
CLR types (hierarchyid and spatial types)
xml
uniqueidentifier (Applies to SQL Server 2012)
Scenario 3:
1. Execute given script query analyzer on SQL Server 2012/2008/2005
CREATE TABLE t3 (
c1 int NULL,
c2 text null
)
GO
2. Navigate to Indexes node in Schema browser
3. Right click on Indexes node and Select option "Create Index"
4. In Create index visual editor, enter below details:
Name: ind
Scehma: dbo
Table : t3
Column name: c2
Sequence : 1
5. Go to Options tab and check "Columnstore" option
Actual Result : Option "Options tab > Columnstore" is enabled for SQL Server 2012/2008/2005 even though these versions does not support Columnstore indexes.
Expected Result : We should disable "Options tab > Columnstore" option for SQL Server 2012/2008/2005 as these versions does not support Columnstore indexes.
Observation:
|
ADS Builds
|
Database |
|
MS SQL 2016 |
MS SQL 2014 |
MS SQL 2012 |
MS SQL 2008 |
MS SQL 2005 |
|
Windows |
Ubuntu |
Windows |
Ubuntu |
Windows |
Ubuntu |
Windows |
Ubuntu |
Windows |
Ubuntu |
|
ADS 18-aplha-8 |
Y |
Y |
Y |
Y |
Y |
Y |
Y |
Y |
Y |
Y |
|
ADS v17 |
Y |
Y |
Y |
Y |
Y |
Y |
Y |
Y |
Y |
Y |
|
ADS v16 |
Y |
Y |
Y |
Y |
Y |
Y |
Y |
Y |
Y |
Y |
|
ADS v15 |
Y |
Y |
Y |
Y |
Y |
Y |
Y |
Y |
Y |
Y |
|
ADS v14 |
Y |
Y |
Y |
Y |
Y |
Y |
Y |
Y |
Y |
Y |
|
Y - Issue reproducible |
