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

Like-predicates: % does not match tab character

    XMLWordPrintableJSON

Details

    • Bug
    • Status: Closed
    • Major
    • Resolution: Fixed
    • 10.0.2.0
    • 10.1.3.1, 10.2.1.6
    • SQL
    • None
    • 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.diff
          11 kB
          Håvard Mork
        2. 1262_6.diff
          10 kB
          Håvard Mork
        3. 1262_5.diff
          10 kB
          Håvard Mork
        4. 1262_4.diff
          10 kB
          Håvard Mork
        5. 1262_3.diff
          11 kB
          Håvard Mork

        Activity

          People

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

            Dates

              Created:
              Updated:
              Resolved: