Projection of null in set operation. Illegal use of 'NULL'

1

Dremio server 14.0.0-202103011714040666-9a0c2e10
Dremio JDBC 14.0.0-202103011714040666-9a0c2e10

Appears that the parser does not attempt to infer a type based on context. Have to explicitly cast the null value specification to a specific type. Scenarios, such as this are supported in other systems.

select rnum, 123 from cert.tbint
union all
select rnum, null from cert.tint

(org.apache.calcite.runtime.CalciteContextException) From line 3, column 14 to line 3, column 17: Illegal use of ‘NULL’
sun.reflect.GeneratedConstructorAccessor236.newInstance():-1
sun.reflect.DelegatingConstructorAccessorImpl.newInstance():45
java.lang.reflect.Constructor.newInstance():423
org.apache.calcite.runtime.Resources$ExInstWithCause.ex():463
org.apache.calcite.sql.SqlUtil.newContextException():803
org.apache.calcite.sql.SqlUtil.newContextException():788
org.apache.calcite.sql.validate.SqlValidatorImpl.newValidationError():4478

2

@dqmdev

As you rightly said, I see Postgres and MySQL handle it. I will file an internal bug on this. Thanks for reporting