db-derby-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Chip Hartney (JIRA)" <j...@apache.org>
Subject [jira] Created: (DERBY-4032) Record not found in some SQL
Date Wed, 28 Jan 2009 16:02:01 GMT
Record not found in some SQL
----------------------------

                 Key: DERBY-4032
                 URL: https://issues.apache.org/jira/browse/DERBY-4032
             Project: Derby
          Issue Type: Bug
          Components: SQL
    Affects Versions: 10.3.2.1
         Environment: Windows XP

            Reporter: Chip Hartney


Per discussion at http://www.nabble.com/Record-not-found-in-some-SQL---Bug--td21700110.html...

I have a "Product" table with a "Num" column that contains a record that is only accessible
by some SQL and not others.  I have tested this by JDBC access from my Java app as well was
from IJ directly.

ij> select "Num", length("Num") as "Len" from app."Product" where "Num" like 'HG1549%';
Num            |Len
----------------------------
HG15490        |7
HG15493        |7
HG15497        |7   <== Found as expected
HG15499        |7
4 rows selected

ij> select "Num" from app."Product" where "Num" = 'HG15490';
Num
----------------
HG15490  <== Found as expected
1 row selected

ij> select "Num" from app."Product" where "Num" = 'HG15493';
Num
----------------
HG15493  <== Found as expected
1 row selected

ij> select "Num" from app."Product" where "Num" = 'HG15499';
Num
----------------
HG15499  <== Found as expected
1 row selected

ij> select "Num" from app."Product" where "Num" = 'HG15497';
Num
----------------
0 rows selected  <== Not found!!!

What could possibly hide the 'HG15497' record from the last SELECT?

And it's not just a matter of equality versus inequality...as the following SQL does return
the record:
    SELECT I."STYLE" FROM TEMP."ZJVINV2" AS I INNER JOIN APP."Product" AS P ON I."STYLE" =
P."Num" WHERE I."STYLE" = 'HG15497'; 

-- 
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.


Mime
View raw message