Icon View Incident Report

Serious Serious
Reported By: Michael Baytalsky
Reported On: 2/19/2007
For: Version 1.00 Build 1
# 2237 IDENTITY Columns Defined with ALWAYS Results in Incorrect Metadata In TableColumns Table

The folloing statement produces generator, which has GeneratedWhen = 'By Default' instead of 'Always' as I'd expect. It seems like it either creates it incorrectly or information schema returns incorrect value for the GeneratedWhen field.

CREATE TABLE "TestGen" (
 "ID" INTEGER GENERATED ALWAYS AS IDENTITY(START WITH 1, INCREMENT BY 1)
)



Resolution Resolution
Fixed Problem on 2/21/2007 in version 1.01 build 1


Products Affected Products Affected
ElevateDB Additional Software and Utilities
ElevateDB VCL Client-Server
ElevateDB VCL Client-Server with Source
ElevateDB VCL Standard
ElevateDB VCL Standard with Source
ElevateDB VCL Trial

Image