[CALCITE-1178] Allow SqlBetweenOperator to compare DATE and TIMESTAMP - ASF JIRA

Voters

Watch issue

Watchers

Link

Clone

Update Comment Author

Replace String in Comment

Update Comment Visibility

Delete Comments

XML

Word

Printable

JSON

Details

Type: Improvement
Status: Closed
Priority: Major
Resolution: Fixed
Affects Version/s: None
Fix Version/s: 1.22.0
Component/s: core
Labels:
- pull-request-available

Description

An expression such as

date '1999-03-02' between date '1999-03-01' and timestamp '1999-03-03 00:00:00.0'

will incur SqlValidatorException since SqlBetweenOperator does not allow DATE and TIMESTAMP comparison. In terms of usability, it would be great if this type of comparison is allowed in Calcite.

Attachments

Issue Links

Add Link

links to

GitHub Pull Request #1470

Delete this link

Activity

Comment

This comment will be Viewable by All Users Viewable by All Users

Cancel

People

Assignee:: Danny Chen

Reporter:: Sean Hsuan-Yi Chu

Votes:: 1 Vote for this issue

Watchers:: 11 Start watching this issue

Dates

Created:: 30/Mar/16 00:36

Updated:: 06/Mar/20 04:36

Resolved:: 23/Sep/19 06:55

Time Tracking

Estimated:

Not Specified

Remaining:

Logged:

Allow SqlBetweenOperator to compare DATE and TIMESTAMP