Reported By: Fernando Monteiro Reported On: 2/25/2004 For: Version 4.04 Build 1
# 1580SELECT COUNT(*) Returning an Empty Result Set Under Linux Select Count(*) is returning an empty dataset on Linux. It is working on Windows.
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;
CommentsProblem was a bug in both Windows and Linux, however memory management peculiarities caused the bug to only appear under Linux.
ResolutionFixed Problem on 3/18/2003 in version 4.05 build 1