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

but in the regexp

Details

    • Bug
    • Status: Closed (View Workflow)
    • Major
    • Resolution: Not a Bug
    • None
    • N/A
    • Data types
    • None
    • mariadb 11.7.2-1
      linux 6.13.5.arch1-1

    Description

      create table t (
      		 
      	tt varchar(3000) not null,
      		 
      	CHECK(tt REGEXP '^[a-z]+\.[a-z]+$')
      		 
      );

      allows both 'exe.com' and 'exe:com'
      the second string shouldn't match the pattern so there is most likely a but in your regex engine
      probably the error is that \. isn't seen as a dot but the wildcard that match any single character

      Attachments

        Activity

          danblack Daniel Black added a comment - - edited

          https://sqlize.online/sql/mariadb/45035bac6b923c70155fb0da61c72091/

          \ is first applied as SQL escaping. To apply it as REGEX escaping two \ are needed.

          danblack Daniel Black added a comment - - edited https://sqlize.online/sql/mariadb/45035bac6b923c70155fb0da61c72091/ \ is first applied as SQL escaping. To apply it as REGEX escaping two \ are needed.

          People

            Unassigned Unassigned
            dfg dgf
            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.