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

RLIKE: "." no longer matching new line

Details

    • Bug
    • Status: Closed (View Workflow)
    • Critical
    • Resolution: Fixed
    • 10.0.10
    • 10.0.11
    • None
    • None
    • Windows 8, Windows Server 2012 R2, maybe others

    Description

      In 5.5.36, RLIKE and REGEXP work as they always have:

      SELECT 
      'cat and
      		 
       dog' 
      RLIKE 'cat.*dog';
      		 
      => 1
      		 
       
      		 
      In 10.0.10, 
      SELECT 
      'cat and
      		 
       dog' 
      RLIKE 'cat.*dog';
      		 
      => 0

      I consider this to be a critical issue that would cause queries to not function as expected.

      Attachments

        Activity

          Ascending order - Click to sort in descending order
          rebelde M Kellogg created issue -
          elenst Elena Stepanova made changes -
          Field Original Value New Value
          Comment [ Works for me on Wheezy:
          {code:sql}
          MariaDB [test]> select 'cat and dog' rlike 'cat.*dog';
          +--------------------------------+
          | 'cat and dog' rlike 'cat.*dog' |
          +--------------------------------+
          | 1 |
          +--------------------------------+
          1 row in set (0.03 sec)

          MariaDB [test]> select @@version;
          +-----------------+
          | @@version |
          +-----------------+
          | 10.0.10-MariaDB |
          +-----------------+
          1 row in set (0.00 sec)
          {code}

          I'll try Windows too.
          Meanwhile, could you please attach your cnf file?
          ]
          elenst Elena Stepanova made changes -
          Description In 5.5.36, RLIKE and REGEXP work as they always have:

          SELECT
          'cat and
           dog'
          RLIKE 'cat.*dog';
          => 1

          In 10.0.10,
          SELECT
          'cat and
           dog'
          RLIKE 'cat.*dog';
          => 0

          I consider this to be a critical issue that would cause queries to not function as expected.           		In 5.5.36, RLIKE and REGEXP work as they always have:
          {code:sql}
          SELECT
          'cat and
           dog'
          RLIKE 'cat.*dog';
          => 1

          In 10.0.10,
          SELECT
          'cat and
           dog'
          RLIKE 'cat.*dog';
          => 0
          {code}

          I consider this to be a critical issue that would cause queries to not function as expected.
          elenst Elena Stepanova made changes -
          Fix Version/s 10.0.11 [ 15200 ]
          elenst Elena Stepanova made changes -
          Assignee Alexander Barkov [ bar ]
          bar Alexander Barkov made changes -
          Status Open [ 1 ] In Progress [ 3 ]
          bar Alexander Barkov made changes -
          Status In Progress [ 3 ] Stalled [ 10000 ]
          bar Alexander Barkov made changes -
          Resolution Fixed [ 1 ]
          Status Stalled [ 10000 ] Closed [ 6 ]
          serg Sergei Golubchik made changes -
          Workflow defaullt [ 38200 ] MariaDB v2 [ 42921 ]
          ratzpo Rasmus Johansson (Inactive) made changes -
          Workflow MariaDB v2 [ 42921 ] MariaDB v3 [ 61952 ]
          serg Sergei Golubchik made changes -
          Workflow MariaDB v3 [ 61952 ] MariaDB v4 [ 147748 ]

          People

            bar Alexander Barkov
            rebelde M Kellogg
            Votes:
            1 Vote for this issue
            Watchers:
            5 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.