Query:

SELECT * FROM triggersystem WHERE vmodul=0 AND vonfuncname='onaemodulinit'

Table DDL:

CREATE TABLE "TRIGGERSYSTEM"
(
"MINDEX" INTEGER GENERATED BY DEFAULT AS IDENTITY (START WITH 0, INCREMENT BY 1),
"VMODUL" INTEGER,
"VONFUNCNAME" VARCHAR(64) COLLATE "UNI",
"VSCRIPT" CLOB COLLATE "UNI",
"VENABLED" INTEGER,
"VUSERID" INTEGER,
"VLOG" CLOB COLLATE "UNI",
"IOSTATUS" INTEGER,
"NL" INTEGER,
"IODATUM" DATE,
"NLMINDEX" INTEGER,
"RO_NL" VARCHAR(15) COLLATE "UNI",
"VBESCHREIBUNG" CLOB COLLATE "UNI",
"VSORT" INTEGER,
"VPARAMS" CLOB COLLATE "UNI",
CONSTRAINT "MINDEX" PRIMARY KEY ("MINDEX")
)
VERSION 1.00
READWRITE
UNENCRYPTED
INDEX PAGE SIZE 8192
BLOB BLOCK SIZE 1024
PUBLISH BLOCK SIZE 1024
PUBLISH COMPRESSION 0
MAX ROW BUFFER SIZE 32768
MAX INDEX BUFFER SIZE 65536
MAX BLOB BUFFER SIZE 32768
MAX PUBLISH BUFFER SIZE 32768

---

 Comments

---

This was very similar to incident report #4709, but that prior incident report applied to string columns and the fix for it was not complete enough and did not address other column types when StandardNullBehavior was set to False.

---

 Resolution

---

Fixed Problem on 1/10/2019 in version 2.30 build 2

---

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