Icon View Incident Report

Minor Minor
Reported By: Adam Hair
Reported On: 1/29/2014
For: Version 2.15 Build 3
# 4001 ElevateDB Manager Allows Invalid Generated Column Data Types

When I open up one of my tables that contains an AutoInc field, and try to change it to a GUID field I get the error:

ElevateDB Error #700 An error was found in the statement at line 2 and column 22 (Expected SmallInt, Integer, or BigInt expression but instead found )

The SQL that it generates is not valid (see below).


ALTER TABLE "Customer"
ALTER COLUMN "ID" AS GUID COLLATE "ANSI" GENERATED ALWAYS AS IDENTITY 
(START WITH 0, INCREMENT BY 1) NOT NULL



Resolution Resolution
Fixed Problem on 1/30/2014 in version 2.16 build 1


Products Affected Products Affected
ElevateDB Additional Software and Utilities

Image