[CALCITE-119] Comparing Java type long with SQL type INTEGER gives wrong answer

• Type: Bug
• Status: Closed
• Priority: Major
• Resolution: Fixed
• Labels: github-import
• Assignee: Unassigned
• Reporter: GitHub Import
• Created: 18/Jun/14 08:12
• Updated: 17/Oct/24 01:09
• Resolved: 18/Jun/14 08:12

Description

When comparing a bigint value to an integer value, Optiq gives the wrong answer. Presumably it is converting both arguments to Java int. The query

```sql
select "wrapperLong" as c from "everyTypes" where "wrapperLong" > 0
```

should return the a row where c is 1, but it does not.

`JdbcTest.testJavaBoolean2` is a test-case.

---------------- Imported from GitHub ----------------
Url: https://github.com/julianhyde/optiq/issues/119
Created by: julianhyde
Labels:
Created at: Sat Jan 18 23:25:12 CET 2014
State: closed

Issue Links

• relates to: CALCITE-6631 The common type for a comparison operator returns the wrong type when comparing a Java type long with a SQL type INTEGER