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

binary protocol: default values not supported in prepared statements

    XMLWordPrintable

Details

    Description

      Default values are not supported by prepared statements. This slows down batch operations since you need to retrieve the default value for a column from information_schema:

        mysqll> CREATE TABLE t1 (a int  default 2);

        mysql_stmt_prepare(stmt, "INSERT INTO t1 VALUES (?)");
       
        for (i=0; i < numRows; i++)
        {
          if (RowPtr[i] == SQL_COLUMN_IGNORE)
          {
            /* since there is no MYSQL_TYPE_DEFAULT we need to retrieve
               the default value from information_schema. What a pain! */
          } else
          {
            bind[0].buffer_type= MYSQL_TYPE_LONG;
            bind{0].buffer= &RowValues[i];
          }
          mysql_stmt_execute(stmt);
        }

      Attachments

        Issue Links

          Activity

            People

              sanja Oleksandr Byelkin
              georg Georg Richter
              Votes:
              2 Vote for this issue
              Watchers:
              3 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved:

                Time Tracking

                  Estimated:
                  Original Estimate - 10d
                  10d
                  Remaining:
                  Remaining Estimate - 10d
                  10d
                  Logged:
                  Time Spent - Not Specified
                  Not Specified

                  Git Integration

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