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

COM_STMT_EXECUTE (bulk) returns error on INSERT .. SELECT ....

    XMLWordPrintable

    Details

      Description

      While a normal COM_STMT_EXECUTE with Insert and Select works fine, bulk insert fails:

      >>> cursor.execute("insert into t1 select NULL, ?", (54,))
      >>> cursor.rowcount
      1
      >>> cursor.executemany("insert into t1 select NULL, ?", [(55,),(56,)])
      Traceback (most recent call last):
        File "<stdin>", line 1, in <module>
        File "/usr/local/lib/python3.9/site-packages/mariadb-1.1.0b1-py3.9-linux-x86_64.egg/mariadb/cursors.py", line 322, in executemany
          self._execute_bulk()
      mariadb.OperationalError: This command is not supported in the prepared statement protocol yet
      

        Attachments

          Issue Links

            Activity

              People

              Assignee:
              sanja Oleksandr Byelkin
              Reporter:
              georg Georg Richter
              Votes:
              0 Vote for this issue
              Watchers:
              3 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.