Icon View Incident Report

Serious Serious
Reported By: Grzegorz Rewucki
Reported On: 5/29/2007
For: Version 1.03 Build 1
# 2361 Insensitive Queries on Tables with Text Indexes Can Cause Error Message

The following query raises exception:

ElevateDB Error #100 There is an error in the metadata for the index column (BLOB columns cannot be included in a non-text index)when RequestSensitive is False.

CREATE TABLE "OdsTab" (
"BizonCreator" VARCHAR(30) COLLATE "ANSI_CI" DEFAULT CURRENT_USER DESCRIPTION 'Twórca',
"BizonCreated" TIMESTAMP DEFAULT CURRENT_TIMESTAMP DESCRIPTION 'Utworzono',
"BizonModifier" VARCHAR(30) COLLATE "ANSI_CI" DESCRIPTION 'Ostatnio modyfikowal',
"BizonModified" TIMESTAMP DESCRIPTION 'Ostatnia modyfikacja',
"BizonSearch" CLOB COLLATE "PLK_CI" DESCRIPTION 'Indeks slów',
"Id" VARCHAR(10) COLLATE "PLK_CI" DESCRIPTION 'Symbol tabeli',
"Nazwa" VARCHAR(30) COLLATE "PLK_CI" DESCRIPTION 'Nazwa tabeli',
"Skala" SMALLINT DEFAULT 0 DESCRIPTION 'Skala',
CONSTRAINT "PK_ODSTAB" PRIMARY KEY ("Id"),
CONSTRAINT "UC_ODSTAB_NAZWA" UNIQUE ("Nazwa"),
CONSTRAINT "CK_ODSTAB_ID" CHECK (CHARACTER_LENGTH(Id) > 0),
CONSTRAINT "CK_ODSTAB_NAZWA" CHECK (CHARACTER_LENGTH(Nazwa) > 0),
CONSTRAINT "CK_ODSTAB_SKALA" CHECK (Skala IS NOT NULL))
DESCRIPTION 'Tabele odsetkowe' 
VERSION 1 
UNENCRYPTED 
INDEX PAGE SIZE 4096
BLOB BLOCK SIZE 512
MAX ROW BUFFER SIZE 32768
MAX INDEX BUFFER SIZE 65536
MAX BLOB BUFFER SIZE 32768

CREATE TEXT INDEX "BizonSearch" ON "OdsTab" (BizonSearch)

SELECT * FROM ODSTAB



Resolution Resolution
Fixed Problem on 5/30/2007 in version 1.04 build 1


Products Affected Products Affected
ElevateDB 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

Image