Uploaded image for project: 'Phoenix'
  1. Phoenix
  2. PHOENIX-2645

Wildcard characters do not match newline characters

    XMLWordPrintableJSON

    Details

    • Type: Bug
    • Status: Closed
    • Priority: Major
    • Resolution: Fixed
    • Affects Version/s: 4.7.0
    • Fix Version/s: 4.9.0, 4.8.1
    • Labels:
    • Environment:

      Phoenix 4.7.0 on Calcite 1.5

      Description

      Wildcard characters do not match newline characters

      0: jdbc:phoenix:thin:url=http://localhost:876> create table testnewline (pk varchar(10) primary key)
      . . . . . . . . . . . . . . . . . . . . . . .> ;
      No rows affected (2.643 seconds)
      0: jdbc:phoenix:thin:url=http://localhost:876> upsert into testnewline values ('AA\nA');
      1 row affected (0.079 seconds)
      0: jdbc:phoenix:thin:url=http://localhost:876> select * from testnewline where pk like 'AA%'
      . . . . . . . . . . . . . . . . . . . . . . .> ;
      +------------+
      |     PK     |
      +------------+
      | AA
      A       |
      +------------+
      1 row selected (0.086 seconds)
      0: jdbc:phoenix:thin:url=http://localhost:876> select * from testnewline where pk like 'AA_A';
      +------------+
      |     PK     |
      +------------+
      +------------+
      No rows selected (0.053 seconds)
      0: jdbc:phoenix:thin:url=http://localhost:876> select * from testnewline where pk like 'AA%A';
      +------------+
      |     PK     |
      +------------+
      +------------+
      No rows selected (0.032 seconds)
      0: jdbc:phoenix:thin:url=http://localhost:876> 
      
      

        Attachments

          Issue Links

            Activity

              People

              • Assignee:
                kliew Kevin Liew
                Reporter:
                kliew Kevin Liew
              • Votes:
                0 Vote for this issue
                Watchers:
                6 Start watching this issue

                Dates

                • Created:
                  Updated:
                  Resolved: