View Incident Report

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

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

Products Affected

DBISAM Additional Software and Utilities
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

More Support Options

Search Incident Reports

Support Forums

Frequently Asked Questions

Technical Bulletins

Technical Articles

Product Manuals

Roadmap