[
https://issues.apache.org/jira/browse/DERBY-1620?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel#action_12476034
]
A B commented on DERBY-1620:
----------------------------
John Peterson > I will provide more extensive tests and their results shortly
John, are you still planning to provide test cases for the changes you have
contributed for this issue? And is there anything else that needs to be done
here or is the latest ConditionalNode.diff a complete resolution to this
problem?
I looked at what I think is the latest patch (ConditionalNode.diff from
01/09/2007) and it looks pretty good. There are, however, a lot of whitespace
diffs in the patch--in fact, if I'm not mistaken the last 160 lines of the
patch are whitespace-only changes? It'd be great if those could be removed.
If you are still planning to contribtue test cases and there is nothing else to
do for his issue (aside from whitespace cleanup), I'd be willing to commit your
changes to the Derby trunk for you. Please post a comment if you are still
interested.
Thank you for your time on this!
> SQL CASE statement returns ERROR 42X89 when including NULL as a return value
> ----------------------------------------------------------------------------
>
> Key: DERBY-1620
> URL: https://issues.apache.org/jira/browse/DERBY-1620
> Project: Derby
> Issue Type: Bug
> Components: SQL
> Affects Versions: 10.2.1.6
> Environment: Windows XP
> Reporter: John Peterson
> Assigned To: John Peterson
> Priority: Minor
> Attachments: ConditionalNode.diff, Derby_Community_Discussion.doc,
> derbyall_report.txt, sysinfo_and_example.txt
>
>
> This bug appears to be related to the DERBY-7 bug (NULLIF() function). When
> NULL is used during a CASE statement, Derby requires the NULL to be CAST to
> the appropriate type. This does not appear to meet the SQL 2003 Standard for
> the Case Expression (see attached Word document). See the attached Word
> document to view the Derby Community Discussion about this issue. See the
> attached .TXT to view the SYSINFO and to see an example of the steps to
> reproduce using IJ.
> Steps to Reproduce:
> ij>values case when 1=2 then 3 else NULL end;
> ERROR 42X89: Types 'INTEGER' and 'CHAR' are not type compatible. Neither
> type is assignable to the other type.
> Current Workaround:
> ij>values case when 1=2 then 3 else cast(NULL as INT) end;
--
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.
