HXTT JDBC Products: MS Access JDBC, Cobol JDBC, DBF JDBC, MS Excel JDBC,CSV JDBC, Text JDBC, Corel Paradox JDBC, PDF JDBC, Word JDBC, XML JDBC

Broken select distinct with nulls	Martin Ross	2006-03-20 00:00:00
select top 10 UNIK from ARCHIVE returns 930203386343 930203393470 930203395851 930203397836 930203405024 930203406727 930203408054 930203411757 930203413380 930203415859 select distinct UNIK from ARCHIVE returns no rows However select distinct UNIK from ARCHIVE where UNIK is not null returns rows This appears to me to be broken.
Re:Broken select distinct with nulls	HXTT Support	2006-03-20 00:00:00
Fixed a bug since v2.1.125 . That bug was only on memory temporary index for DISTINCT without WHERE clause. Please download the latest package.

Email: