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

POSIX collating elements are not supported

Details

    • Bug
    • Status: Closed (View Workflow)
    • Minor
    • Resolution: Won't Fix
    • 10.0.14
    • N/A
    • OTHER
    • Ubuntu 14.04

    Description

      When running the following queries, you will get an error, which in my case breaks replication as the master is currently MySQL 5.5.40

      SELECT ' ' REGEXP '[[.space.]]';
      		 
       
      		 
      SELECT '.' REGEXP '[[.period.]]';

      Error: 

      ERROR 1139 (42000): Got error 'POSIX collating elements are not supported at offset 1' from regexp

      Attachments

        Activity

          Ascending order - Click to sort in descending order
          TheReaper Johann created issue -
          serg Sergei Golubchik made changes -
          Field Original Value New Value
          Description When running the following queries, you will get an error, which in my case breaks replication as the master is currently MySQL 5.5.40

          SELECT ' ' REGEXP '[[.space.]]';

          SELECT '.' REGEXP '[[.period.]]';


          Error:
          ERROR 1139 (42000): Got error 'POSIX collating elements are not supported at offset 1' from regexp           		When running the following queries, you will get an error, which in my case breaks replication as the master is currently MySQL 5.5.40
          {code:sql}
          SELECT ' ' REGEXP '[[.space.]]';

          SELECT '.' REGEXP '[[.period.]]';
          {code}
          Error:
          {noformat}
          ERROR 1139 (42000): Got error 'POSIX collating elements are not supported at offset 1' from regexp
          {noformat}
          elenst Elena Stepanova made changes -
          Labels MariaDB_10.0
          elenst Elena Stepanova made changes -
          Component/s OTHER [ 10125 ]
          Component/s Character Sets [ 10801 ]
          Assignee Alexander Barkov [ bar ]
          serg Sergei Golubchik made changes -
          Labels regexp
          bar Alexander Barkov made changes -
          Fix Version/s 10.0 [ 16000 ]
          bar Alexander Barkov made changes -
          Priority Major [ 3 ] Critical [ 2 ]
          bar Alexander Barkov made changes -
          Priority Critical [ 2 ] Minor [ 4 ]
          ratzpo Rasmus Johansson (Inactive) made changes -
          Workflow MariaDB v2 [ 58610 ] MariaDB v3 [ 65156 ]
          serg Sergei Golubchik made changes -
          Workflow MariaDB v3 [ 65156 ] MariaDB v4 [ 139732 ]
          serg Sergei Golubchik made changes -
          Fix Version/s 10.0 [ 16000 ]
          serg Sergei Golubchik made changes -
          Fix Version/s N/A [ 14700 ]
          Resolution Won't Fix [ 2 ]
          Status Open [ 1 ] Closed [ 6 ]

          People

            bar Alexander Barkov
            TheReaper Johann
            Votes:
            1 Vote for this issue
            Watchers:
            7 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.