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

ER_NATIVE_FCT_NAME_COLLISION works differently in various protocols

Details

    Description

      I create this test:

      CREATE FUNCTION upper() RETURNS TEXT RETURN 'upper';
      		 
      SELECT test.upper();
      		 
      DROP FUNCTION upper;

      If I further run it with --ps or --cursor, it returns this diff:

      --- /home/bar/maria-git/11.8.m31736.fby2/mysql-test/main/AAA.result	2024-11-25 12:19:39.719701771 +0400
      		 
      +++ /home/bar/maria-git/11.8.m31736.fby2/mysql-test/main/AAA.reject	2024-11-25 12:20:00.710696886 +0400
      		 
      @@ -1,9 +1,5 @@
      		 
       CREATE FUNCTION upper() RETURNS TEXT RETURN 'upper';
      		 
      -Warnings:
      		 
      -Note	1585	This function 'upper' has the same name as a native function
      		 
       SELECT test.upper();
      		 
       test.upper()
      		 
       upper
      		 
      -Warnings:
      		 
      -Note	1585	This function 'upper' has the same name as a native function
      		 
       DROP FUNCTION upper;

      If I run it with --view, it returns this diff:

      --- /home/bar/maria-git/11.8.m31736.fby2/mysql-test/main/AAA.result	2024-11-25 12:19:39.719701771 +0400
      		 
      +++ /home/bar/maria-git/11.8.m31736.fby2/mysql-test/main/AAA.reject	2024-11-25 12:20:49.934685428 +0400
      		 
      @@ -6,4 +6,5 @@
      		 
       upper
      		 
       Warnings:
      		 
       Note	1585	This function 'upper' has the same name as a native function
      		 
      +Note	1585	This function 'upper' has the same name as a native function
      		 
       DROP FUNCTION upper;
      		 
       
      		 
      Result length mismatch

      Attachments

        Issue Links

          is part of

          Technical task - A technical task. MDEV-27691 make working view-protocol

          • Major - Major loss of function.
          • Closed

          Activity

            People

              bar Alexander Barkov
              bar Alexander Barkov
              Votes:
              0 Vote for this issue
              Watchers:
              2 Start watching this issue

              Dates

                Created:
                Updated:

                Git Integration

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