Icon View Incident Report

Serious Serious
Reported By: Lucian Radulescu
Reported On: 1/7/2010
For: Version 2.03 Build 6
# 3124 Creating a Generated Expression Column with NOT NULL Constraint Causes Parsing Error

I created a table in edb manager but the script failed in the end. Here's the script (reduced to the minimum that fails):


EXECUTE IMMEDIATE 'CREATE TABLE "generictypes"
(
"intgenexp" INTEGER GENERATED ALWAYS AS 2 NOT NULL
)



Comments Comments and Workarounds
The problem was with the parser getting confused by the 2 NOT NULL expression. The workaround was to use this instead:

CREATE TABLE "generictypes"
(
"intgenexp" INTEGER GENERATED ALWAYS AS 2
CONSTRAINT "intgenexp_req" CHECK "intgenexp" IS NOT NULL
)


Resolution Resolution
Fixed Problem on 1/8/2010 in version 2.03 build 7


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

Image