Uploaded image for project: 'MariaDB Connector/Python'
  1. MariaDB Connector/Python
  2. CONPY-133

Internal parser ignores special comment syntax

Details

    • Bug
    • Status: Closed (View Workflow)
    • Major
    • Resolution: Fixed
    • 1.0.4
    • 1.0.5
    • DBAPI 2.0
    • None

    Description

      The internal parser ignores MariaDB's comment syntax, special meanings like /*! not a comment */ are ignored and end up in an error:

      >>> import mariadb
      		 
      >>> conn= mariadb.connect()
      		 
      >>> cursor=conn.cursor()
      		 
      >>> cursor.execute("SELECT /*! ? */", (1,))
      		 
      Traceback (most recent call last):
      		 
        File "<stdin>", line 1, in <module>
      		 
      mariadb.DatabaseError.DataError: Invalid number of parameters

      Attachments

        Activity

          Ascending order - Click to sort in descending order
          georg Georg Richter created issue -
          georg Georg Richter made changes -
          Field Original Value New Value
          Description The internal parser ignores MariaDB's comment syntax, special meanings like /*! not a comment */ are ignored and end up in an error:

          {{>>> import mariadb
          >>> conn= mariadb.connect()
          >>> cursor=conn.cursor()
          >>> cursor.execute("SELECT /*! ? */", (1,))
          Traceback (most recent call last):
            File "<stdin>", line 1, in <module>
          mariadb.DatabaseError.DataError: Invalid number of parameters}}           		The internal parser ignores MariaDB's comment syntax, special meanings like /*! not a comment */ are ignored and end up in an error:
          {{
          >>> import mariadb
          >>> conn= mariadb.connect()
          >>> cursor=conn.cursor()
          >>> cursor.execute("SELECT /*! ? */", (1,))
          Traceback (most recent call last):
            File "<stdin>", line 1, in <module>
          mariadb.DatabaseError.DataError: Invalid number of parameters
          }}
          georg Georg Richter made changes -
          Description The internal parser ignores MariaDB's comment syntax, special meanings like /*! not a comment */ are ignored and end up in an error:
          {{
          >>> import mariadb
          >>> conn= mariadb.connect()
          >>> cursor=conn.cursor()
          >>> cursor.execute("SELECT /*! ? */", (1,))
          Traceback (most recent call last):
            File "<stdin>", line 1, in <module>
          mariadb.DatabaseError.DataError: Invalid number of parameters
          }}           		The internal parser ignores MariaDB's comment syntax, special meanings like /*! not a comment */ are ignored and end up in an error:

          {code:java}
          >>> import mariadb
          >>> conn= mariadb.connect()
          >>> cursor=conn.cursor()
          >>> cursor.execute("SELECT /*! ? */", (1,))
          Traceback (most recent call last):
            File "<stdin>", line 1, in <module>
          mariadb.DatabaseError.DataError: Invalid number of parameters
          {code}

          georg Georg Richter added a comment -

          Fixed. rev. a1c709b0e80d9d6590029a114506614dd5a4516a

          georg Georg Richter added a comment - Fixed. rev. a1c709b0e80d9d6590029a114506614dd5a4516a
          georg Georg Richter made changes -
          issue.field.resolutiondate 2020-11-24 13:28:17.0 2020-11-24 13:28:17.353
          georg Georg Richter made changes -
          Resolution Fixed [ 1 ]
          Status Open [ 1 ] Closed [ 6 ]
          serg Sergei Golubchik made changes -
          Workflow MariaDB v3 [ 116063 ] MariaDB v4 [ 135693 ]

          People

            georg Georg Richter
            georg Georg Richter
            Votes:
            1 Vote for this issue
            Watchers:
            1 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.