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

SP's 'out' parameter issue when doesn't match IN and OUT data type.

    XMLWordPrintable

Details

    • Bug
    • Status: Open (View Workflow)
    • Major
    • Resolution: Unresolved
    • 10.11.15
    • 10.11
    • None
    • None
    • Windows 11 64bit AMD

    Description

      When make a SP, we can set 'OUT' type argument that to return multiple results. But, for example, when a caller declare smallint, but the caller SP's OUT data type declared as double,
      totally break thread stack frame. especially multiply declare dozen or hundred OUT arguments.
      But kind of '@xxxxxxxxx' session variable used/passed for the return arguments seem no problem that seem automatically detects byte size and so while local decleared variable does not.

      What my point is (of cause stack frame breaking is a possibly be normal/expected behavior),
      but automatically detect whether wrong type or make warning message before forcely over write stack buffer of the return values since it actually break thread stack frame.

      Attachments

        Activity

          People

            danblack Daniel Black
            npdmailing@gmail.com Mitchell Lee
            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.