CREATE TABLE "Test"
(
"ID" INTEGER GENERATED BY DEFAULT AS IDENTITY (START WITH 0, INCREMENT BY 1) NOT NULL,
"Number" INTEGER NOT NULL,
"Category" VARCHAR(3) COLLATE "ANSI" NOT NULL,
"TestID1" VARCHAR(10) COLLATE "ANSI" COMPUTED ALWAYS AS Category || '/' || CAST(Number AS
VARCHAR)
)

"ID","Number","Category","TestID1"
1,1,"AAA","AAA/"
2,2,"bbb","bbb/"

---

 Comments and Workarounds

---

The problem was that the concatenated string was being truncated to the Category length instead of the defined length for the column. The workaround is the following:

CREATE TABLE "Test"
(
"ID" INTEGER GENERATED BY DEFAULT AS IDENTITY (START WITH 0, INCREMENT BY
1) NOT NULL,
"Number" INTEGER NOT NULL,
"Category" VARCHAR(3) COLLATE "ANSI" NOT NULL,
"TestID1" VARCHAR(10) COLLATE "ANSI" COMPUTED ALWAYS AS CAST(Category ||
'/' || CAST(Number AS VARCHAR) AS VARCHAR(10))
)

---

 Resolution

---

Fixed Problem on 5/1/2008 in version 1.09 build 4

---

 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 VCL Client-Server
ElevateDB VCL Client-Server with Source
ElevateDB VCL Standard
ElevateDB VCL Standard with Source
ElevateDB VCL Trial