[ https://issues.apache.org/jira/browse/DRILL-6588?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Kunal Khatua updated DRILL-6588: -------------------------------- Reviewer: Arina Ielchiieva (was: Aman Sinha) > System table columns incorrectly marked as non-nullable > -------------------------------------------------------- > > Key: DRILL-6588 > URL: https://issues.apache.org/jira/browse/DRILL-6588 > Project: Apache Drill > Issue Type: Bug > Components: Metadata > Affects Versions: 1.13.0 > Reporter: Aman Sinha > Assignee: Kunal Khatua > Priority: Major > Fix For: 1.14.0 > > > System table columns can contain null values but they are incorrectly marked > as non-nullable as shown in example table below: > {noformat} > 0: jdbc:drill:drillbit=10.10.10.191> describe sys.boot; > +-------------------+--------------------+--------------+ > | COLUMN_NAME | DATA_TYPE | IS_NULLABLE | > +-------------------+--------------------+--------------+ > | name | CHARACTER VARYING | NO | > | kind | CHARACTER VARYING | NO | > | accessibleScopes | CHARACTER VARYING | NO | > | optionScope | CHARACTER VARYING | NO | > | status | CHARACTER VARYING | NO | > | num_val | BIGINT | NO | > | string_val | CHARACTER VARYING | NO | > | bool_val | BOOLEAN | NO | > | float_val | DOUBLE | NO | > +-------------------+--------------------+--------------+{noformat} > > Note that several columns are nulls: > {noformat} > +---------------------------------------------------+----------+------------------+-------------+--------+---------+------------+----------+-----------+ > | name | kind | > accessibleScopes | optionScope | status | num_val | string_val | bool_val | > float_val | > +---------------------------------------------------+----------+------------------+-------------+--------+---------+------------+----------+-----------+ > drill.exec.options.exec.udf.enable_dynamic_support | BOOLEAN | BOOT | BOOT | > BOOT | null | null | true | null |{noformat} > > Because of the not-null metadata, the predicates on these tables such as > `WHERE <column> IS NULL` evaluate to FALSE which is incorrect. > -- This message was sent by Atlassian JIRA (v7.6.3#76005)