Uploaded image for project: 'Apache Drill'
  1. Apache Drill
  2. DRILL-6850

JDBC integration tests failures

    XMLWordPrintableJSON

    Details

      Description

      The following command will run Drill integratiom tests for RDBMS (Derby and MySQL):
      mvn integration-test failsafe:integration-test -pl contrib/storage-jdbc

      Currently some drill/exec/store/jdbc TestJdbcPluginWithDerbyIT and TestJdbcPluginWithMySQLIT tests fail:

      Results :
      
      Failed tests: 
        TestJdbcPluginWithDerbyIT.showTablesDefaultSchema:117 expected:<1> but was:<0>
      Tests in error: 
        TestJdbcPluginWithDerbyIT.describe » UserRemote VALIDATION ERROR: Unknown tabl...
        TestJdbcPluginWithDerbyIT.pushdownDoubleJoinAndFilter:111->PlanTestBase.testPlanMatchingPatterns:84->PlanTestBase.testPlanMatchingPatterns:89->PlanTestBase.getPlanInString:369->BaseTestQuery.testSqlWithResults:322->BaseTestQuery.testRunAndReturn:341 » Rpc
        TestJdbcPluginWithDerbyIT.testCrossSourceMultiFragmentJoin » UserRemote VALIDA...
        TestJdbcPluginWithDerbyIT.validateResult:71 »  at position 0 column '`NUMERIC_...
        TestJdbcPluginWithMySQLIT.validateResult:108 »  at position 0 column '`numeric...
      
      Tests run: 14, Failures: 1, Errors: 5, Skipped: 0
      

      Most likely these are old regressions.

      Additionally NPE for empty result is resolved:
      http://drill.apache.org/blog/2018/08/05/drill-1.14-released/#comment-4082559169

      Also, in the scope of this Jira will be allowed configuring table names case sensitivity for JDBC storage plugin. Some databases, like derby or postgres are case insensitive regarding table names, but other databases like mySQL(depending on its configuration) may be case sensitive regarding table names. Therefore will be provided a parameter for storage plugin caseInsensitiveTableNames which determines whether table names should be handled considering case sensitivity.

        Attachments

          Issue Links

            Activity

              People

              • Assignee:
                vvysotskyi Volodymyr Vysotskyi
                Reporter:
                vitalii Vitalii Diravka
                Reviewer:
                Arina Ielchiieva
              • Votes:
                0 Vote for this issue
                Watchers:
                4 Start watching this issue

                Dates

                • Created:
                  Updated:
                  Resolved: