XMLWordPrintable

Details

    • Bug
    • Status: Closed (View Workflow)
    • Critical
    • Resolution: Won't Fix
    • None
    • N/A
    • DBAPI 2.0
    • None

    Description

      This query gives me a SQL error if I use parameter substitution:

      db = mariadb.connector(...)
      qr = db.cursor(buffered=True)
      qr.execute('select if((3 is ?), ?, ?)', (None, 'a', 'b'))
      

      This should be translated to:

      select if((3 is null), 'a', 'b')
      

      Is there a way to see/get formatted query just before execution?

      Attachments

        Activity

          People

            georg Georg Richter
            lucianobarcaro Luciano Barcaro
            Votes:
            0 Vote for this issue
            Watchers:
            2 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.