Reported By: Adam Hair Reported On: 1/29/2014 For: Version 2.15 Build 3
# 4001ElevateDB 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
ResolutionFixed Problem on 1/30/2014 in version 2.16 build 1
Products AffectedElevateDB Additional Software and Utilities