View Incident Report

Serious

Reported By: Richard Harding
Reported On: 8/26/2009
For: Version 2.02 Build 15

# 3062 Using a Sub-Query that Returns a CLOB Expression in the SELECT Column Expressions Results in NULLs

I have 2 tables which in part look like the following.

Configuration only has 1 row.

I want to the result query to contain (ReportTitle Notes, PageHeader Notes, ReportSummary Notes).

I can obtain the IDs (ReportTitle ID, PageHeader ID, ReportSummary ID) with the following query.

When I try to get the Notes, I obtain a row of nulls.

CREATE TABLE "Configuration"
(
"ID" INTEGER,
"ReportTitle" VARCHAR(16) COLLATE "ANSI",
"PageHeader" VARCHAR(16) COLLATE "ANSI",
"ReportSummary" VARCHAR(16) COLLATE "ANSI",
)

CREATE TABLE "Template"
(
"ID" INTEGER GENERATED BY DEFAULT AS IDENTITY (START WITH 11, INCREMENT BY 1) NOT NULL,
"Name" VARCHAR(16) COLLATE "ANSI_CI" NOT NULL,
"Notes" CLOB COLLATE "ANSI"
)

SELECT
   (SELECT Notes FROM Template WHERE Template.Name = C.PageHeader) AS PageHeader,
   (SELECT Notes FROM Template WHERE Template.Name = C.ReportTitle) AS ReportTitle,
   (SELECT Notes FROM Template WHERE Template.Name = C.ReportSummary) AS ReportSummary
 FROM
   Configuration AS C

Comments and Workarounds

The problem only occurs when requesting a sensitive result set. The workaround is to not request a sensitive result set and get an insensitive result set.

Resolution

Fixed Problem on 8/27/2009 in version 2.03 build 1

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

More Support Options

Search Incident Reports

Support Forums

Frequently Asked Questions

Technical Bulletins

Technical Articles

Product Manuals

Roadmap