Uploaded image for project: 'Derby'
  1. Derby
  2. DERBY-1262

Like-predicates: % does not match tab character

    XMLWordPrintableJSON

    Details

    • Type: Bug
    • Status: Closed
    • Priority: Major
    • Resolution: Fixed
    • Affects Version/s: 10.0.2.0
    • Fix Version/s: 10.1.3.1, 10.2.1.6
    • Component/s: SQL
    • Labels:
      None
    • Environment:
      Embedded, Solaris 10 x86

      Description

      % in like predicates does not seem to match tab character. In the following example all whitespace in character literals is the tab character:

      ij> create table t4(i integer primary key, j integer, c varchar(10));
      0 rows inserted/updated/deleted
      ij> insert into t4 values (1, 1, 'abc def');
      1 row inserted/updated/deleted
      ij> select * from t4 where c like 'abc%';
      I |J |C
      ----------------------------------

      0 rows selected
      ij> select * from t4 where c like 'abc %';
      I |J |C
      ----------------------------------
      1 |1 |abc def

      1 row selected

        Attachments

        1. 1262_3.diff
          11 kB
          Håvard Mork
        2. 1262_4.diff
          10 kB
          Håvard Mork
        3. 1262_5.diff
          10 kB
          Håvard Mork
        4. 1262_6.diff
          10 kB
          Håvard Mork
        5. 1262.diff
          11 kB
          Håvard Mork

          Activity

            People

            • Assignee:
              hmork Håvard Mork
              Reporter:
              oysteing Oystein Grovlen
            • Votes:
              0 Vote for this issue
              Watchers:
              0 Start watching this issue

              Dates

              • Created:
                Updated:
                Resolved: