Watch, Follow, &
Connect with Us

Please visit our new home
community.embarcadero.com.

Public Report
Report From: Blackfish SQL/SQL    [ Add a report in this area ]  
Report #:  25328   Status: Need Feedback
Select of 5 values only returns 4
Project:  JDataStore Build #:  007.004.011.000
Version:    6 Submitted By:   John Dow
Report Type:  Basic functionality failure Date Reported:  2/23/2006 6:13:00 PM
Severity:    Serious / Highly visible problem Last Updated: 4/1/2009 4:49:23 PM
Platform:    All versions Internal Tracking #:  
Resolution: Need More Info (Resolution Comments) Resolved in Build: : None
Duplicate of:  None
Voting and Rating
Overall Rating: No Ratings Yet
0.00 out of 5
Total Votes: None
Description
None
Steps to Reproduce:
The following query misbehaves.

SELECT * FROM MYTABLE WHERE ID IN
('004366','063580','004982','054290','007162','011324');

It only returns 5 of the 6 rows. Row 063580 is missing. If I change the query to use ID = 'XXX' OR ID = 'XXX' etc (instead of IN) it still fails. Changing the order of the values being tested makes no difference. Selecting row 063580 by itself works.

This is with server version 007.004.011.000.

I also have server version 007.000.289.000, for which I purchased a license. It behaves properly, finding all 6 rows.
Workarounds
None
Attachment
None
Comments

John Dow at 2/23/2006 7:06:59 PM -
Amending my own report.

The short description should be "Select of 6 values only returns 5"

Also, this is JDataStore7, not 6, but the Version dropdown didn't give me that choice.

Markus Humm at 4/1/2009 2:21:49 PM -
Could you please list the contents of the table? Esp. for this field you're having the in for?

Server Response from: ETNACODE01