Uploaded image for project: 'MariaDB Server'
  1. MariaDB Server
  2. MDEV-18658

10.3.9-MariaDB can not query equal operator with special character

    XMLWordPrintable

Details

    • Bug
    • Status: Closed (View Workflow)
    • Major
    • Resolution: Cannot Reproduce
    • 10.3.9
    • N/A
    • PL/SQL
    • None
    • Windows Server 2016 64 bit

    Description

      I have a MariaDB database that has a filed TagName with value ~!@#$%^&*()_+|}{":?><./';[]\=-`
      I had set mode

      SET @@SQL_MODE = CONCAT(@@SQL_MODE, ',NO_BACKSLASH_ESCAPES');
      

      When I try to created DB in MySQL 8.0.13, this query work well and return 1 row

      select * from taginfo1 where TagName = '~!@#$%^&*()_+|}{":?><./'';[]\\=-`';
      

      But in 10.3.9-MariaDB, the query

      select * from taginfo1 where TagName = '~!@#$%^&*()_+|}{":?><./'';[]\\=-`';
      

      can not return any result.

      Is this an issue or I missed some configuration?

      Attachments

        Activity

          People

            Unassigned Unassigned
            viethien Hien V Nguyen
            Votes:
            0 Vote for this issue
            Watchers:
            3 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved:

              Git Integration

                Error rendering 'com.xiplink.jira.git.jira_git_plugin:git-issue-webpanel'. Please contact your Jira administrators.