Need to be run on Linux.

DROP TABLE IF EXISTS "MEMORY/WORK";

CREATE TABLE IF NOT EXISTS "MEMORY/WORK" (
FIELD1 INTEGER, FIELD2 INTEGER);

INSERT INTO "MEMORY/WORK" VALUES (1,1);
INSERT INTO "MEMORY/WORK" VALUES (2,2);

SELECT COUNT(*) FROM MEMORY/WORK;

---

 Comments

---

Problem was a bug in both Windows and Linux, however memory management peculiarities caused the bug to only appear under Linux.

---

 Resolution

---

Fixed Problem on 3/18/2003 in version 4.05 build 1