[DRILL-6850] JDBC integration tests failures

• Type: Bug
• Status: Resolved
• Priority: Major
• Resolution: Fixed
• Affects Version/s: 1.14.0
• Fix Version/s: 1.15.0
• Component/s: Storage - JDBC
• Labels: ready-to-commit
• Assignee: Vova Vysotskyi
• Reporter: Vitalii Diravka
• Reviewer: Arina Ielchiieva
• Created: 14/Nov/18 15:32
• Updated: 12/Dec/18 15:22
• Resolved: 26/Nov/18 16:29

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.

Issue Links

• is related to: DRILL-6893 Invalid output for star and self-join queries for RDBMS Storage Plugin
• supercedes: DRILL-4984 Limit 0 raises NullPointerException on JDBC storage sources
• links to: GitHub Pull Request #1542