Uploaded image for project: 'MariaDB Connector/J'
  1. MariaDB Connector/J
  2. CONJ-795

getRow() method of the ResultSet is 0 if defaultFetchsize is part of the connection string.

Details

    Description

      To reproduce:

      Install SoapUI.
      copy mariadb JDBC driver into <soapUIfolder>/bin/ext
      Restart Soapui

      Create Empty Project
      Create TestSuite
      Create Test Step
      Add JDBC Request

      JDBC Request:

      Driver: org.mariadb.jdbc.Driver
      jdbc:mariadb://localhost/?user=tos&password=password&defaultFetchsize=10

      SQL Query:
      select * from <random table with content>

      Example:
      Result is

      <Results>
      		 
          <ResultSet fetchSize="10">
      		 
              <Row rowNumber="0">
      		 
                  <C3.A>1</C3.A>
      		 
                  <C3.B/>
      		 
              </Row>
      		 
              <Row rowNumber="0">
      		 
                  <C3.A>3</C3.A>
      		 
                  <C3.B>1</C3.B>
      		 
              </Row>
      		 
              <Row rowNumber="0">
      		 
                  <C3.A>2</C3.A>
      		 
                  <C3.B>2</C3.B>
      		 
              </Row>
      		 
              <Row rowNumber="0">
      		 
                  <C3.A/>
      		 
                  <C3.B>1</C3.B>
      		 
              </Row>
      		 
          </ResultSet>
      		 
      </Results>

      Should be:

      <Results>
      		 
          <ResultSet fetchSize="0">
      		 
              <Row rowNumber="1">
      		 
                  <C3.A>1</C3.A>
      		 
                  <C3.B/>
      		 
              </Row>
      		 
              <Row rowNumber="2">
      		 
                  <C3.A>3</C3.A>
      		 
                  <C3.B>1</C3.B>
      		 
              </Row>
      		 
              <Row rowNumber="3">
      		 
                  <C3.A>2</C3.A>
      		 
                  <C3.B>2</C3.B>
      		 
              </Row>
      		 
              <Row rowNumber="4">
      		 
                  <C3.A/>
      		 
                  <C3.B>1</C3.B>
      		 
              </Row>
      		 
          </ResultSet>
      		 
      </Results>

      Attachments

        Activity

          Ascending order - Click to sort in descending order
          Richard Richard Stracke created issue -
          ralf.gebhardt Ralf Gebhardt made changes -
          Field Original Value New Value
          Assignee Diego Dupin [ diego dupin ] Ralf Gebhardt [ ralf.gebhardt@mariadb.com ]
          diego dupin Diego Dupin made changes -
          Fix Version/s 2.6.1 [ 24276 ]
          diego dupin Diego Dupin made changes -
          issue.field.resolutiondate 2020-06-22 14:05:36.0 2020-06-22 14:05:36.009
          diego dupin Diego Dupin made changes -
          Assignee Ralf Gebhardt [ ralf.gebhardt@mariadb.com ] Diego Dupin [ diego dupin ]
          Resolution Fixed [ 1 ]
          Status Open [ 1 ] Closed [ 6 ]
          serg Sergei Golubchik made changes -
          Workflow MariaDB v3 [ 109640 ] MariaDB v4 [ 128420 ]

          People

            diego dupin Diego Dupin
            Richard Richard Stracke
            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.