[
https://issues.apache.org/jira/browse/DERBY-2256?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel#action_12484671
]
Bryan Pendleton commented on DERBY-2256:
I'm sold!
I see that while integer and decimal are compatible, ther
[
https://issues.apache.org/jira/browse/DERBY-2256?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel#action_12484514
]
A B commented on DERBY-2256:
> Did you consider having this query return an error? If the user provides a
> floating poin
[
https://issues.apache.org/jira/browse/DERBY-2256?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel#action_12484306
]
Bryan Pendleton commented on DERBY-2256:
Hi Army, the comments and explanation are great and they make a lot
[
https://issues.apache.org/jira/browse/DERBY-2256?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel#action_12482938
]
A B commented on DERBY-2256:
It looks like the various incorrect results reported in this Jira are all
caused by one of
[
https://issues.apache.org/jira/browse/DERBY-2256?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel#action_12466118
]
A B commented on DERBY-2256:
Yip's most recent comment agrees with what Mike wrote on derby-dev:
http://thread.gmane.o
[
https://issues.apache.org/jira/browse/DERBY-2256?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel#action_12466114
]
Yip Ng commented on DERBY-2256:
---
I think Derby will transform this statement's IN predicate
i in (2.8, 4.23);
to the
[
https://issues.apache.org/jira/browse/DERBY-2256?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel#action_12466094
]
A B commented on DERBY-2256:
There is code in InListOperatorNode.java that creates a BETWEEN clause from an
IN-list if t
[
https://issues.apache.org/jira/browse/DERBY-2256?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel#action_12465963
]
Yip Ng commented on DERBY-2256:
---
Another error cases:
-- ok
ij> select * from t1 where i in (4, 4.23);
I
---
4