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

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

                Dates

                Created:
                Updated:
                Resolved:

                  Git Integration