View Incident Report

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

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

Products Affected

ElevateDB Additional Software and Utilities

More Support Options

Search Incident Reports

Support Forums

Frequently Asked Questions

Technical Bulletins

Technical Articles

Product Manuals

Roadmap