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

ER_NATIVE_FCT_NAME_COLLISION works differently in various protocols

    XMLWordPrintable

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

          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.