[
https://issues.apache.org/jira/browse/DERBY-4318?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=12738113#action_12738113
]
Eranda Sooriyabandara commented on DERBY-4318:
----------------------------------------------
Hi Bryan,
I solve the third problem in which the error was a Syntax error.
before,
st.executeUpdate(
" create view v1(c1)"
+ "as"
+ "select c1 from t1"
+ "union all"
+ "select c2 from t2 ");
after
st.executeUpdate(
" create view v1(c1)"
+ "as"
+ "(select c1 from t1)"
+ "union all"
+ "(select c2 from t2 )");
The change was use parenthesis on select c1 from t1 and select c2 from t2 .
The second problem was a nasty one and I ask help from derby-dev.
Thanks
> convert inbetween.sql to JUNIT
> ------------------------------
>
> Key: DERBY-4318
> URL: https://issues.apache.org/jira/browse/DERBY-4318
> Project: Derby
> Issue Type: Improvement
> Components: Test
> Reporter: Eranda Sooriyabandara
> Assignee: Eranda Sooriyabandara
> Priority: Minor
> Attachments: inbetween.junit, InbetweenTest.diff, InbetweenTest.diff,
> InbetweenTest.diff
>
>
> conversion of inbetween.sql to JUNIT
--
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.
