Icon View Incident Report

Serious Serious
Reported By: Terry Swiers
Reported On: 9/17/2010
For: Version 2.04 Build 2
# 3313 Configuration Not Properly Saving Locking Information for Created Modules

There are several issues with the locking of external modules and word generators in 2.04b2 when performing optimizations on tables that reference them.

Steps to reproduce in EDB Manager

1. Create new database with 4 tables.

2. In tables 1 and 2, create a text index on a memo field using an external word generator.

3. In tables 3 and 4, create a trigger that calls a function in a external module.

SCRIPT
BEGIN
   EXECUTE IMMEDIATE 'CREATE TABLE Table1 (ID INTEGER, Notes CLOB)';

   EXECUTE IMMEDIATE 'INSERT INTO Table1 VALUES (100,''Test 100'')';
   EXECUTE IMMEDIATE 'INSERT INTO Table1 VALUES (200,''Test 200'')';
   EXECUTE IMMEDIATE 'INSERT INTO Table1 VALUES (300,''Test 300'')';
   EXECUTE IMMEDIATE 'INSERT INTO Table1 VALUES (400,''Test 400'')';

   EXECUTE IMMEDIATE 'CREATE TABLE Table2 (ID INTEGER, Notes CLOB)';

   EXECUTE IMMEDIATE 'INSERT INTO Table2 VALUES (100,''Test 100'')';
   EXECUTE IMMEDIATE 'INSERT INTO Table2 VALUES (200,''Test 200'')';
   EXECUTE IMMEDIATE 'INSERT INTO Table2 VALUES (300,''Test 300'')';
   EXECUTE IMMEDIATE 'INSERT INTO Table2 VALUES (400,''Test 400'')';

   EXECUTE IMMEDIATE 'CREATE TABLE Table3 (ID INTEGER, Notes CLOB)';

   EXECUTE IMMEDIATE 'INSERT INTO Table3 VALUES (100,''Test 100'')';
   EXECUTE IMMEDIATE 'INSERT INTO Table3 VALUES (200,''Test 200'')';
   EXECUTE IMMEDIATE 'INSERT INTO Table3 VALUES (300,''Test 300'')';
   EXECUTE IMMEDIATE 'INSERT INTO Table3 VALUES (400,''Test 400'')';

   EXECUTE IMMEDIATE 'CREATE TABLE Table4 (ID INTEGER, Notes CLOB)';

   EXECUTE IMMEDIATE 'INSERT INTO Table4 VALUES (100,''Test 100'')';
   EXECUTE IMMEDIATE 'INSERT INTO Table4 VALUES (200,''Test 200'')';
   EXECUTE IMMEDIATE 'INSERT INTO Table4 VALUES (300,''Test 300'')';
   EXECUTE IMMEDIATE 'INSERT INTO Table4 VALUES (400,''Test 400'')';

   EXECUTE IMMEDIATE 'CREATE TEXT INDEX Notes ON "Table1" (Notes COLLATE ANSI_CI)
                      INDEXED WORD LENGTH 30
                      WORD GENERATOR CustomWordGen';
   EXECUTE IMMEDIATE 'CREATE TEXT INDEX Notes ON "Table2" (Notes COLLATE ANSI_CI)
                      INDEXED WORD LENGTH 30
                      WORD GENERATOR CustomWordGen';

   EXECUTE IMMEDIATE 'CREATE FUNCTION "TestFunction" ()
RETURNS VARCHAR COLLATE ANSI
EXTERNAL NAME "extmodule"
VERSION 1.00';

   EXECUTE IMMEDIATE 'CREATE TRIGGER "TestTrigger" BEFORE ALL ON "Table3"
BEGIN
   DECLARE Test VARCHAR DEFAULT '''';
   SET Test = TestFunction();
END
';

   EXECUTE IMMEDIATE 'CREATE TRIGGER "TestTrigger" BEFORE ALL ON "Table4"
BEGIN
   DECLARE Test VARCHAR DEFAULT '''';
   SET Test = TestFunction();
END
';
END



Comments Comments
This issue requires a fix to any configuration that was updated using 2.04 B1 or B2, and contains external modules created with the CREATE MODULE statement. Please see your product release notes for information on the provided utility (edbfix204config) for fixing such configurations.


Resolution Resolution
Fixed Problem on 9/20/2010 in version 2.04 build 3


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