Hi,
We have small problem with "EDB 2.02b13" unicode when try to execute query.

1) Query:
//-------------------------------------------------------------
/* QUERY1 */
SELECT
 GGG.AAA,
 GGG.OOO as "BBB",
 GGG.VVV as "CCC",
 RRR."TTN",
 RRR.TTC,
 RRR."TTV",
 RRR.TTK,
 RRR.OOO as "XXX",
 COUNT( QQQ.AAA ) as "WWW"
FROM
 GGG
LEFT JOIN
 RRR ON
 GGG.AAA = RRR.AAA
LEFT JOIN
 QQQ ON
 (
   ( GGG.AAA = QQQ.AAA )
   AND
   (
     ( GGG.OOO = QQQ.ZZZ )
     OR
     (
       ( GGG.OOO = RRR.OOO ) AND
       ( QQQ.ZZZ IS NULL )
     )
   )
 )
GROUP BY
 QQQ.AAA,
 BBB

UNION

/* QUERY2 */
SELECT
 QQQ.AAA,
 CASE
   WHEN QQQ.ZZZ IS NULL THEN RRR.OOO
   ELSE QQQ.ZZZ
 END BBB,
 GGG.VVV as "CCC",
 RRR."TTN",
 RRR.TTC,
 RRR."TTV",
 RRR.TTK,
 RRR.OOO as "XXX",
 COUNT( QQQ.AAA ) as "WWW"
FROM
 QQQ
LEFT JOIN
 RRR ON
 QQQ.AAA = RRR.AAA
LEFT JOIN
 GGG ON
 (
   ( RRR.AAA = GGG.AAA )
   
   AND
   
   (
     ( GGG.OOO = QQQ.ZZZ )

     OR

     (
       ( GGG.OOO = RRR.OOO ) AND
       ( QQQ.ZZZ IS NULL )
     )
   )
 )
 
WHERE

 GGG.VVV IS NULL
 
GROUP BY

 QQQ.AAA,
 BBB



2) Tables:
//-------------------------------------------------------------

EXECUTE IMMEDIATE 'CREATE TABLE "GGG"
(
"ID" INTEGER GENERATED BY DEFAULT AS IDENTITY (START WITH 0, INCREMENT BY 1) NOT NULL,
"AAA" INTEGER NOT NULL,
"VVV" INTEGER NOT NULL,
"OOO" INTEGER NOT NULL
)
VERSION 1
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';

EXECUTE IMMEDIATE 'CREATE TABLE "RRR"
(
"AAA" INTEGER GENERATED ALWAYS AS IDENTITY (START WITH 0, INCREMENT BY 1) NOT NULL,
"TTN" VARCHAR(128) COLLATE "UNI" NOT NULL,
"TTV" VARCHAR(128) COLLATE "UNI",
"GUID" VARCHAR(80) COLLATE "UNI",
"OOO" SMALLINT NOT NULL,
"TTK" SMALLINT NOT NULL,
"TTC" VARCHAR(256) COLLATE "UNI"
)
VERSION 1
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';

EXECUTE IMMEDIATE 'CREATE TABLE "QQQ"
(
"ZZZ" INTEGER DEFAULT NULL,
"AAA" INTEGER NOT NULL
)
VERSION 1
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';


3) Comment
Error message:
  ElevateDB Error #9999 Access violation at address 00517DFB in module 'edbsrvr.exe'. Read of address 00000010
BUT when we try to execute:
 Query2
 UNION
 Query1
everything is ok... :-/

best regards,
g_m

Gienek,

<< We have small problem with "EDB 2.02b13" unicode when try to execute
query. >>

I will check this out and let you know what I find.

--
Tim Young
Elevate Software
www.elevatesoft.com

Gienek,

Okay, I've replicated the issue and a fix will be in Build 14.

Thanks,

--
Tim Young
Elevate Software
www.elevatesoft.com