Icon View Incident Report

Minor Minor
Reported By: Ralf Bertoldi
Reported On: 10/7/2009
For: Version 4.29 Build 1
# 3079 SQL DISTINCT Clause Not Working Properly for NUMERIC Fields

I have a problem with DISTINCT and NUMERIC values. In the example the result should be 1 Record, but it's 2.


DROP TABLE IF EXISTS "Memory\Table1";
CREATE TABLE "Memory\Table1" (
  "Field1" NUMERIC(0,4),
  "Field2" NUMERIC(0,4) 
);
INSERT INTO "Memory\Table1" VALUES(0,0);
INSERT INTO "Memory\Table1" VALUES(0,0);
INSERT INTO "Memory\Table1" VALUES(0,0);
SELECT DISTINCT Field1,Field2 FROM "Memory\Table1";



Resolution Resolution
Fixed Problem on 10/8/2009 in version 4.29 build 2


Products Affected Products Affected
DBISAM Additional Software and Utilities
DBISAM CLX Client-Server
DBISAM CLX Client-Server with Source
DBISAM CLX Standard
DBISAM CLX Standard with Source
DBISAM ODBC Client-Server
DBISAM ODBC Client-Server with Source
DBISAM ODBC Standard
DBISAM ODBC Standard with Source
DBISAM ODBC Trial
DBISAM VCL Client-Server
DBISAM VCL Client-Server with Source
DBISAM VCL Standard
DBISAM VCL Standard with Source
DBISAM VCL Trial

Image