Aman Sinha created DRILL-6588:
---------------------------------
Summary: 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
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)
