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

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