Login ProductsSalesSupportDownloadsAbout |
Home » Technical Support » ElevateDB Technical Support » Support Forums » ElevateDB SQL » View Thread |
Messages 1 to 3 of 3 total |
ElevateDB Error #9999 |
Fri, May 22 2009 7:09 AM | Permanent Link |
gienek majonez | 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 |
Tue, May 26 2009 1:10 PM | Permanent Link |
Tim Young [Elevate Software] Elevate Software, Inc. timyoung@elevatesoft.com | 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 |
Thu, May 28 2009 3:43 PM | Permanent Link |
Tim Young [Elevate Software] Elevate Software, Inc. timyoung@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 |
This web page was last updated on Tuesday, April 30, 2024 at 03:55 PM | Privacy PolicySite Map © 2024 Elevate Software, Inc. All Rights Reserved Questions or comments ? E-mail us at info@elevatesoft.com |