DEC abbreviation for DECIMAL unsupported?

EugeneM

When I use SQL prompt to template an insert into a table it does not recognize DEC as a valid type.
Here is a quick example to demonstrate. Note the missing e column.

CREATE TABLE #temp
  (
    id INTEGER IDENTITY(1, 1) NOT NULL PRIMARY KEY,
    a  VARCHAR(100),
    b  INTEGER,
    c  INT,
    d  DECIMAL(10, 5),
    e  DEC(10, 5)
  )



INSERT INTO #temp ( a,
                    b,
                    c,
                    d )
VALUES ( '',   -- a - varchar(100)
         NULL, -- b - integer
         0,    -- c - int
         NULL  -- d - decimal(10, 5)
  )

FredericoJ

Hi @EugeneM,

Thank you for reporting this. I've managed to reproduce the problem locally and I've created a bug (reference: SP-6640) to track it.

Best regards,

Frederico

krzysztofkroczak

Hello @EugeneM,

We fixed this issue in our latest version of SQL Prompt <9.1.2.4363> (installer here).

You can find more information about this release in this forum post.

Kind regards,
Krzysztof