Details

    • Type: Bug Bug
    • Status: Closed
    • Priority: Major Major
    • Resolution: Cannot Reproduce
    • Affects Version/s: 10.3.2.1
    • Fix Version/s: None
    • Component/s: SQL
    • Labels:
      None
    • Environment:
      Windows XP
    • Urgency:
      Normal
    • Bug behavior facts:
      Data corruption, Seen in production, Wrong query result

      Description

      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';

      1. OrderEntryDB-seg0-part7.zip
        5.43 MB
        Chip Hartney
      2. OrderEntryDB-seg0-part6.zip
        5.90 MB
        Chip Hartney
      3. OrderEntryDB-seg0-part5.zip
        6.24 MB
        Chip Hartney
      4. OrderEntryDB-seg0-part4.zip
        8.97 MB
        Chip Hartney
      5. OrderEntryDB-seg0-part3.zip
        9.41 MB
        Chip Hartney
      6. OrderEntryDB-seg0-part2.zip
        9.10 MB
        Chip Hartney
      7. OrderEntryDB-seg0-part1.zip
        4.75 MB
        Chip Hartney
      8. OrderEntryDB-base.zip
        3 kB
        Chip Hartney
      9. check-table.txt
        91 kB
        Knut Anders Hatlen

        Activity

        No work has yet been logged on this issue.

          People

          • Assignee:
            Unassigned
            Reporter:
            Chip Hartney
          • Votes:
            0 Vote for this issue
            Watchers:
            1 Start watching this issue

            Dates

            • Created:
              Updated:
              Resolved:

              Development