[jira] [Created] (SPARK-16058) JDBC Source: Wrong Results when lowerBound is larger than upperBound in Column Partitioning

["Xiao Li (JIRA)" <ji...@apache.org>]

Xiao Li created SPARK-16058:
-------------------------------

             Summary: JDBC Source: Wrong Results when lowerBound is larger than upperBound in Column Partitioning
                 Key: SPARK-16058
                 URL: https://issues.apache.org/jira/browse/SPARK-16058
             Project: Spark
          Issue Type: Bug
          Components: SQL
    Affects Versions: 2.0.0
            Reporter: Xiao Li


{noformat}
spark.read.jdbc(
  url = urlWithUserAndPass,
  table = "TEST.seq",
  columnName = "id",
  lowerBound = 0,
  upperBound = 4,
  numPartitions = 0,
  connectionProperties = new Properties)
{noformat}

Currently, Spark SQL generates wrong results due to wrong partitions:
{noformat}
  Part 0 id < 3 or id is null
  Part 1 id >= 3 AND id < 2
  Part 2 id >= 2
{noformat}




--
This message was sent by Atlassian JIRA
(v6.3.4#6332)

---------------------------------------------------------------------
To unsubscribe, e-mail: issues-unsubscribe@spark.apache.org
For additional commands, e-mail: issues-help@spark.apache.org