db-derby-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Eranda Sooriyabandara (JIRA)" <j...@apache.org>
Subject [jira] Commented: (DERBY-4424) Convert outerjoin.sql into JUnit
Date Fri, 13 Nov 2009 19:20:39 GMT

    [ https://issues.apache.org/jira/browse/DERBY-4424?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=12777614#action_12777614

Eranda Sooriyabandara commented on DERBY-4424:

Hi Bryan,

I faced a problem with fix the error in convented code of,

ij> select max(name), max(resdate) from inventory join timeslots on
inventory.capacity is not null

left outer join reservations on inventory.itemno = reservations.itemno and
reservations.slot = timeslots.slot;




WARNING 01003: Null values were eliminated from the argument of a column

Because the converted code by the DERBY-2151 tool for the "warning
01003)" was,

if (usingEmbedded())


            if ((sqlWarn == null) && (st != null))

                sqlWarn = st.getWarnings();

            if (sqlWarn == null)

                sqlWarn = getConnection().getWarnings();

            assertNotNull("Expected warning but found none", sqlWarn);

            assertSQLState("01003", sqlWarn);

            sqlWarn = null;


which give me a error in "assertNotNull("Expected warning but found none",
sqlWarn);" saying that no warning was found.

I thought thats because of the statement returns result set and the warning
message must associates with the result set. I change the statement(st) with
the resultset(rs). But it give me the error message "Operation getWarning
not permitted. Verify that autocommit is off".

Can you help me to figure it out.

Here I am attaching the patch file with this.


> Convert outerjoin.sql into JUnit
> --------------------------------
>                 Key: DERBY-4424
>                 URL: https://issues.apache.org/jira/browse/DERBY-4424
>             Project: Derby
>          Issue Type: Improvement
>            Reporter: Eranda Sooriyabandara
>            Assignee: Eranda Sooriyabandara
>            Priority: Minor
>             Fix For:
> Conversion of the outerjoin test into JUnit

This message is automatically generated by JIRA.
You can reply to this email to add a comment to the issue online.

View raw message