Uploaded image for project: 'Ignite'
  1. Ignite
  2. IGNITE-14043

LIKE .. ESCAPE implemented inconsistently

    XMLWordPrintableJSON

    Details

    • Type: Bug
    • Status: Open
    • Priority: Major
    • Resolution: Unresolved
    • Affects Version/s: 2.9.1
    • Fix Version/s: None
    • Component/s: sql
    • Labels:
      None
    • Ignite Flags:
      Docs Required, Release Notes Required

      Description

      I'm confused about whether ESCAPE is really supported or not. This works

      SELECT 'a%b' LIKE '%!%%' ESCAPE '!';

      But this doesn't:

      CREATE TABLE t (i int PRIMARY KEY, j varchar(10));
      SELECT j LIKE '%!%%' ESCAPE '!' FROM t;

      I'm getting:

      SQL Error [1] [50000]: Unsupported query: (J LIKE '%Unable to render embedded object: File (%%' ESCAPE ') not found.')

      I dont' see any remarks about it not being supported here: https://ignite.apache.org/docs/latest/sql-reference/sql-conformance, so I guess it's just a bug

        Attachments

          Activity

            People

            • Assignee:
              Unassigned
              Reporter:
              lukas.eder Lukas Eder
            • Votes:
              0 Vote for this issue
              Watchers:
              1 Start watching this issue

              Dates

              • Created:
                Updated: