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

The database part is not case sensitive in SP names

Details

    Description

      I start MariaDB with lower-case-table-names=0 and run this script:

      CREATE DATABASE DB1;
      CREATE DATABASE db1;
      CREATE PROCEDURE DB1.sp() SELECT 'This is DB1.sp';
      CREATE PROCEDURE db1.sp() SELECT 'This is db1.sp';
      CALL DB1.sp();
      

      +----------------+
      | This is DB1.sp |
      +----------------+
      | This is DB1.sp |
      +----------------+
      

      So far so good. The first procedure DB1 works fine.

      Now I call the second procedure db1.

      CALL db1.sp();
      

      +----------------+
      | This is DB1.sp |
      +----------------+
      | This is DB1.sp |
      +----------------+
      

      Notice, it erroneously called the first procedure DB1.

      Attachments

        Issue Links

          Activity

            bar Alexander Barkov created issue -
            bar Alexander Barkov made changes -
            Field Original Value New Value
            bar Alexander Barkov made changes -
            bar Alexander Barkov made changes -
            Fix Version/s 10.4 [ 22408 ]
            bar Alexander Barkov made changes -
            Status Open [ 1 ] In Progress [ 3 ]
            bar Alexander Barkov made changes -
            issue.field.resolutiondate 2023-12-27 11:05:36.0 2023-12-27 11:05:36.191
            bar Alexander Barkov made changes -
            Fix Version/s 10.4.33 [ 29516 ]
            Fix Version/s 10.5.24 [ 29517 ]
            Fix Version/s 10.6.17 [ 29518 ]
            Fix Version/s 10.11.7 [ 29519 ]
            Fix Version/s 11.0.5 [ 29520 ]
            Fix Version/s 11.1.4 [ 29024 ]
            Fix Version/s 11.2.3 [ 29521 ]
            Fix Version/s 11.3.2 [ 29522 ]
            Fix Version/s 11.4.1 [ 29523 ]
            Fix Version/s 10.8.8 [ 28518 ]
            Fix Version/s 10.4 [ 22408 ]
            Fix Version/s 11.4 [ 29301 ]
            Resolution Fixed [ 1 ]
            Status In Progress [ 3 ] Closed [ 6 ]

            People

              bar Alexander Barkov
              bar Alexander Barkov
              Votes:
              0 Vote for this issue
              Watchers:
              2 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.