Login ProductsSalesSupportDownloadsAbout |
Home » Technical Support » DBISAM Technical Support » Incident Reports » Incident Reports Reported for Version 4.19 » View Incident Report |
Serious |
Reported By: Helmut Schiefer Reported On: 4/14/2005 For: Version 4.19 Build 1 |
CREATE TABLE IF NOT EXISTS "Test1" ( "ID" AUTOINC, "PG" VARCHAR(10), "GSTK" INTEGER, "SSTK" INTEGER, "Fehler" VARCHAR(25), PRIMARY KEY ("RecordID") COMPRESS NONE LOCALE CODE 0 USER MAJOR VERSION 1 LAST AUTOINC 5 ); INSERT INTO "Test1" VALUES (1,'DI', 10, 2,'A'); INSERT INTO "Test1" VALUES (2,'DI', 0, 1,'B'); INSERT INTO "Test1" VALUES (3,'DI', 0, 2,'C'); INSERT INTO "Test1" VALUES (4,'DI', 100, 25,'B'); INSERT INTO "Test1" VALUES (5,'DI', 0, 10,'C'); * Example without aggregate expression --> OK Select PG, SUM(GSTK) as GUT, SUM(SSTK) as SCHLECHT, SUM(IF(Fehler='A' THEN SSTK ELSE 0)) as "SCHLECHT A", SUM(IF(Fehler='B' THEN SSTK ELSE 0)) as "SCHLECHT B", SUM(IF(Fehler='C' THEN SSTK ELSE 0)) as "SCHLECHT C" FROM Test1 GROUP BY PG * Example with aggregate expression --> Wrong result "SCHLECHT A", ... Select PG, SUM(GSTK) as GUT, SUM(SSTK) as SCHLECHT, ROUND(100*SUM(SSTK)/SUM(SSTK+GSTK) TO 2) as "SCHLECHT PROZENT", SUM(IF(Fehler='A' THEN SSTK ELSE 0)) as "SCHLECHT A", SUM(IF(Fehler='B' THEN SSTK ELSE 0)) as "SCHLECHT B", SUM(IF(Fehler='C' THEN SSTK ELSE 0)) as "SCHLECHT C" FROM Test1 GROUP BY PG * Example with aggregate expression --> Access Violation Select SUM(GSTK) as GUT, SUM(SSTK) as SCHLECHT, ROUND(100*SUM(SSTK)/SUM(SSTK+GSTK) TO 2) as "SCHLECHT PROZENT", PG, SUM(IF(Fehler='A' THEN SSTK ELSE 0)) as "SCHLECHT A", SUM(IF(Fehler='B' THEN SSTK ELSE 0)) as "SCHLECHT B", SUM(IF(Fehler='C' THEN SSTK ELSE 0)) as "SCHLECHT C" FROM Test1 GROUP BY PG
This web page was last updated on Wednesday, March 20, 2024 at 07:22 AM | Privacy PolicySite Map © 2024 Elevate Software, Inc. All Rights Reserved Questions or comments ? E-mail us at info@elevatesoft.com |