[
https://issues.apache.org/jira/browse/PHOENIX-3267?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15595841#comment-15595841
]
Julian Hyde commented on PHOENIX-3267:
--------------------------------------
It would be possible to change Calcite to handle this, but it would take effort
(of course) and would be non-standard (so would be only enabled with certain
compliance settings). I suspect that several mainstream databases do allow
'select null' but I'd have to check. I suspect that they have a special type
'nulltype' (better than what Phoenix does, which is to use a null pointer
instead of a type).
> Replace use of SELECT null with CAST(null AS <type>)
> ----------------------------------------------------
>
> Key: PHOENIX-3267
> URL: https://issues.apache.org/jira/browse/PHOENIX-3267
> Project: Phoenix
> Issue Type: Sub-task
> Reporter: James Taylor
> Assignee: Eric Lomore
>
> It appears that Calcite doesn't allow null as a SELECT expression. If this is
> difficult to change, we can change our tests to cast null to a given data
> type instead, like this: {{CAST(null AS VARCHAR)}}
--
This message was sent by Atlassian JIRA
(v6.3.4#6332)
