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

Output of show function code does not show FETCH GROUP NEXT ROW for custom aggregates

Details

    • Bug
    • Status: Closed (View Workflow)
    • Critical
    • Resolution: Fixed
    • 10.3(EOL)
    • 10.3.7
    • Stored routines
    • None
    • 10.3.6-1

    Description

      create aggregate function f1(x INT) returns double
      		 
      begin
      		 
      declare z double default 0;
      		 
      declare continue handler for not found return z;
      		 
      loop
      		 
      fetch group next row;
      		 
      set z = z + x;
      		 
      end loop;
      		 
      end|


      show function code f1;
      		 
      Pos	Instruction
      		 
      0	set z@1 0
      		 
      1	hpush_jump 3 2 CONTINUE
      		 
      2	freturn double z@1
      		 
      3	
      4	set z@1 z@1 + x@0
      		 
      5	jump 3
      		 
      6	hpop 1

      Attachments

        Activity

          Ascending order - Click to sort in descending order
          varun Varun Gupta (Inactive) created issue -
          varun Varun Gupta (Inactive) made changes -
          Field Original Value New Value
          Component/s Stored routines [ 13905 ]
          varun Varun Gupta (Inactive) made changes -
          Assignee Varun Gupta [ varun ]
          elenst Elena Stepanova made changes -
          Fix Version/s 10.3 [ 22126 ]
          varun Varun Gupta (Inactive) made changes -
          Status Open [ 1 ] In Progress [ 3 ]
          varun Varun Gupta (Inactive) made changes -
          Assignee Varun Gupta [ varun ] Vicentiu Ciorbaru [ cvicentiu ]
          Status In Progress [ 3 ] In Review [ 10002 ]
          varun Varun Gupta (Inactive) added a comment -

          http://lists.askmonty.org/pipermail/commits/2017-December/011768.html

          varun Varun Gupta (Inactive) added a comment - http://lists.askmonty.org/pipermail/commits/2017-December/011768.html
          serg Sergei Golubchik made changes -
          Sprint 10.3.6-0 [ 237 ]
          serg Sergei Golubchik made changes -
          Priority Major [ 3 ] Critical [ 2 ]
          cvicentiu Vicențiu Ciorbaru added a comment -

          Let's try and follow cfetch syntax somewhat. Let's name the instruction agg_cfetch. Ok to push.

          cvicentiu Vicențiu Ciorbaru added a comment - Let's try and follow cfetch syntax somewhat. Let's name the instruction agg_cfetch. Ok to push.
          cvicentiu Vicențiu Ciorbaru made changes -
          Status In Review [ 10002 ] Stalled [ 10000 ]
          cvicentiu Vicențiu Ciorbaru made changes -
          Assignee Vicentiu Ciorbaru [ cvicentiu ] Varun Gupta [ varun ]
          varun Varun Gupta (Inactive) made changes -
          Fix Version/s 10.3.7 [ 23005 ]
          Fix Version/s 10.3 [ 22126 ]
          Resolution Fixed [ 1 ]
          Status Stalled [ 10000 ] Closed [ 6 ]
          serg Sergei Golubchik made changes -
          Workflow MariaDB v3 [ 84382 ] MariaDB v4 [ 153333 ]

          People

            varun Varun Gupta (Inactive)
            varun Varun Gupta (Inactive)
            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.