[jira] [Commented] (DERBY-7132) SQLDataException when executing CAST inside a CASE WHEN clause

[ https://issues.apache.org/jira/browse/DERBY-7132?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17610614#comment-17610614 ] Richard N. Hillegas commented on DERBY-7132: Thanks for pointing out that this is a duplicate

[jira] [Commented] (DERBY-7132) SQLDataException when executing CAST inside a CASE WHEN clause

[ https://issues.apache.org/jira/browse/DERBY-7132?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17610507#comment-17610507 ] Stamatis Zampetakis commented on DERBY-7132: Actually the CASE WHEN clause was introduced in

[jira] [Commented] (DERBY-7132) SQLDataException when executing CAST inside a CASE WHEN clause

[ https://issues.apache.org/jira/browse/DERBY-7132?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17610473#comment-17610473 ] Stamatis Zampetakis commented on DERBY-7132: I spend some more time on this problem and it

[jira] [Commented] (DERBY-7132) SQLDataException when executing CAST inside a CASE WHEN clause

[ https://issues.apache.org/jira/browse/DERBY-7132?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17501376#comment-17501376 ] Richard N. Hillegas commented on DERBY-7132: My suspicion is that Derby is over-aggressively

[jira] [Commented] (DERBY-7132) SQLDataException when executing CAST inside a CASE WHEN clause

[ https://issues.apache.org/jira/browse/DERBY-7132?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17501003#comment-17501003 ] Richard N. Hillegas commented on DERBY-7132: Thanks for that extra information. Here's

[jira] [Commented] (DERBY-7132) SQLDataException when executing CAST inside a CASE WHEN clause

[ https://issues.apache.org/jira/browse/DERBY-7132?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17500975#comment-17500975 ] Stamatis Zampetakis commented on DERBY-7132: The result of the sub-query (workaround proposed

[jira] [Commented] (DERBY-7132) SQLDataException when executing CAST inside a CASE WHEN clause

[ https://issues.apache.org/jira/browse/DERBY-7132?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17500968#comment-17500968 ] Stamatis Zampetakis commented on DERBY-7132: Please correct me if I am wrong but the

[jira] [Commented] (DERBY-7132) SQLDataException when executing CAST inside a CASE WHEN clause

[ https://issues.apache.org/jira/browse/DERBY-7132?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17500939#comment-17500939 ] Richard N. Hillegas commented on DERBY-7132: If the workaround does not work, then the

[jira] [Commented] (DERBY-7132) SQLDataException when executing CAST inside a CASE WHEN clause

[ https://issues.apache.org/jira/browse/DERBY-7132?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17500836#comment-17500836 ] Bryan Pendleton commented on DERBY-7132: Thanks for continuing to investigate this! There are

[jira] [Commented] (DERBY-7132) SQLDataException when executing CAST inside a CASE WHEN clause

[ https://issues.apache.org/jira/browse/DERBY-7132?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17500786#comment-17500786 ] Stamatis Zampetakis commented on DERBY-7132: Hey [~rhillegas], apologies for the late reply.

[jira] [Commented] (DERBY-7132) SQLDataException when executing CAST inside a CASE WHEN clause

[ https://issues.apache.org/jira/browse/DERBY-7132?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17494280#comment-17494280 ] Richard N. Hillegas commented on DERBY-7132: Does the following workaround run correctly for

[jira] [Commented] (DERBY-7132) SQLDataException when executing CAST inside a CASE WHEN clause

[ https://issues.apache.org/jira/browse/DERBY-7132?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17494191#comment-17494191 ] Stamatis Zampetakis commented on DERBY-7132: I uploaded a UML diagram with tables involved in

[jira] [Commented] (DERBY-7132) SQLDataException when executing CAST inside a CASE WHEN clause

[ https://issues.apache.org/jira/browse/DERBY-7132?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17494148#comment-17494148 ] Richard N. Hillegas commented on DERBY-7132: Schema information will help me understand the

[jira] [Commented] (DERBY-7132) SQLDataException when executing CAST inside a CASE WHEN clause

[ https://issues.apache.org/jira/browse/DERBY-7132?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17494064#comment-17494064 ] Stamatis Zampetakis commented on DERBY-7132: [~rhillegas] I can but I am afraid they will not

[jira] [Commented] (DERBY-7132) SQLDataException when executing CAST inside a CASE WHEN clause

[ https://issues.apache.org/jira/browse/DERBY-7132?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17494060#comment-17494060 ] Richard N. Hillegas commented on DERBY-7132: Can you include the table definition, including