Reported By: Michael Baytalsky Reported On: 2/19/2007 For: Version 1.00 Build 1
# 2237IDENTITY 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)
ResolutionFixed Problem on 2/21/2007 in version 1.01 build 1
Products AffectedElevateDB 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