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:

                Git Integration

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