Uploaded image for project: 'MariaDB Connector/ODBC'
  1. MariaDB Connector/ODBC
  2. ODBC-419

add connection string option to prevent prefixing of SET STATEMENT max_statement_time=60 FOR' for SQL_ATTR_QUERY_TIMEOUT attribute

Details

    • New Feature
    • Status: Closed (View Workflow)
    • Minor
    • Resolution: Won't Fix
    • 3.1.20
    • N/A
    • General
    • None

    Description

      SQL_ATTR_QUERY_TIMEOUT attribute automatically prefixes all statements with 'SET STATEMENT max_statement_time=<attribute_value> FOR...' Need to add option to prevent that, or make it for SELECT's only

      Attachments

        Activity

          Ascending order - Click to sort in descending order
          Lawrin Lawrin Novitsky added a comment -

          As for SELECT's only, it was my idea. Does the user think it's a good think for them and would satisfy them? Or they need the ability to completely shut it off?

          Lawrin Lawrin Novitsky added a comment - As for SELECT's only, it was my idea. Does the user think it's a good think for them and would satisfy them? Or they need the ability to completely shut it off?
          Lawrin Lawrin Novitsky added a comment -

          QTIMEOUT connection string option has been introduced to control use of query timeout(SQL_ATTR_QUERY_TIMEOUT statement attribute). It has 3 states:
          0 - query timeouts disabled
          1 - used for SELECT statements only, and not for others
          2(>1) - enabled for all queries.

          Lawrin Lawrin Novitsky added a comment - QTIMEOUT connection string option has been introduced to control use of query timeout(SQL_ATTR_QUERY_TIMEOUT statement attribute). It has 3 states: 0 - query timeouts disabled 1 - used for SELECT statements only, and not for others 2(>1) - enabled for all queries.
          Lawrin Lawrin Novitsky added a comment -

          The change has been reverted as we decided it's the wrong thing to do

          Lawrin Lawrin Novitsky added a comment - The change has been reverted as we decided it's the wrong thing to do

          People

            Lawrin Lawrin Novitsky
            Koustuv Koustuv Chatterjee
            Votes:
            0 Vote for this issue
            Watchers:
            5 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.