ADS build 7.9.32

nCluster database

Below is from nCluster documentation

Name bit varying [ (n) ]

ALIAS varbit

Description variable-length bit string

But in Ncluster Server we cant actually create a table with the ALIAS varbit datatype.

CREATE DIMENSION TABLE public.test_varbit (
    A    varbit(4) NOT NULL
    )
GO

>[Error] Script lines: 1-5 --------------------------
 ERROR: syntax error at or near "varbit"

-----------------------------------------------------------------------------------------------------------------

-----------------------------------------------------------------------------------------------------------------

A bit varying datatype is possible. But the below table created in query window - ADS displays as VARBIT(4). When i try to script it give VARBIT, which when executed gives error

CREATE DIMENSION TABLE dbo."VARBIT_TEST_1" (
    A bit varying(4) NOT NULL
    )

SCRIPT generated by ADS

CREATE DIMENSION TABLE dbo.VARBIT_TEST_1 (
    a    varbit NOT NULL
    )
GO

1. To sum up, table properties for a bit varying data type should not be scripted as VARBIT in ADS GUI.

2. we need BIT VARYING data type in table create gui - Discuss with Niels

3. ER modeler should not have a VARBIT data type. To make changes depending on number 2