Details

    • Task
    • Status: Closed (View Workflow)
    • Major
    • Resolution: Won't Do
    • None
    • N/A
    • Other
    • None

    Description

      Support COM_MULTI protocol, and implement server prepare statement PREPARE+EXECUTE in one call if supported

      Attachments

        Issue Links

          Activity

            diego dupin Diego Dupin added a comment - - edited

            Prepare cannot work on all query actually : Query like "select TMP.field1 from (select ? `field1` from dual) TMP" that use temporary table cannot be prepared (see MDEV-5535).

            Actual implementation of PreparedStatement (using "Connection.preparedStatement(String sql)" ) fall back ClientPreparedStatement when prepare cannot be done.

            Since "PREPARE" execution will be defered using COM_MULTI to the first execution to avoid one round-trip to server, driver will not be able to know if PREPARE can be done or not (or parsing query, but that will take to much additional time for each query).

            COM_MULTI will wait MDEV-5535 so all queries can be prepared.

            diego dupin Diego Dupin added a comment - - edited Prepare cannot work on all query actually : Query like "select TMP.field1 from (select ? `field1` from dual) TMP" that use temporary table cannot be prepared (see MDEV-5535 ). Actual implementation of PreparedStatement (using "Connection.preparedStatement(String sql)" ) fall back ClientPreparedStatement when prepare cannot be done. Since "PREPARE" execution will be defered using COM_MULTI to the first execution to avoid one round-trip to server, driver will not be able to know if PREPARE can be done or not (or parsing query, but that will take to much additional time for each query). COM_MULTI will wait MDEV-5535 so all queries can be prepared.
            diego dupin Diego Dupin added a comment -

            implementation done on "develop" branch.
            Waiting for MDEV-5535 for validation.

            diego dupin Diego Dupin added a comment - implementation done on "develop" branch. Waiting for MDEV-5535 for validation.
            diego dupin Diego Dupin added a comment -

            reopen, since 16mb packet cannot work with current implementation

            diego dupin Diego Dupin added a comment - reopen, since 16mb packet cannot work with current implementation
            diego dupin Diego Dupin added a comment -

            waiting for discussion result about SERVER_MORE_RESULT_EXISTS flags

            diego dupin Diego Dupin added a comment - waiting for discussion result about SERVER_MORE_RESULT_EXISTS flags

            People

              diego dupin Diego Dupin
              diego dupin Diego Dupin
              Votes:
              0 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.