[jira] Commented: (DERBY-4187) Convert altertable.sql to JUnit

[Eranda Sooriyabandara (JIRA)]

    [ 
https://issues.apache.org/jira/browse/DERBY-4187?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=12707717#action_12707717
 ] 

Eranda Sooriyabandara commented on DERBY-4187:
----------------------------------------------

Hi Bryan,

Here I post the AlterTableTest.java row 277-290

// select * prepared statements do see added columns after alter table

        rs = pSt.executeQuery();
        expColNames = new String [] {"C1", "C2"};
        JDBC.assertColumnNames(rs, expColNames);

        expRS = new String [][]
        {
            {"1", null},
            {"2", null}
        };

        JDBC.assertFullResultSet(rs, expRS, true);

It gives a failure ,

test_altertable(org.apache.derbyTesting.functionTests.tests.lang.AlterTableTest)junit.framework.A
ssertionFailedError: Unexpected column count: expected:<2> but was:<1>
        at org.apache.derbyTesting.junit.JDBC.assertColumnNames(JDBC.java:676)
        at 
org.apache.derbyTesting.functionTests.tests.lang.AlterTableTest.test_altertable(AlterTabl
eTest.java:282).

I change the code to,

// select * prepared statements do "not" see added columns after alter table

        rs = pSt.executeQuery();
        expColNames = new String [] {"C1"};
        JDBC.assertColumnNames(rs, expColNames);

        expRS = new String [][]
        {
            {"1"},
            {"2"}
        };

        JDBC.assertFullResultSet(rs, expRS, true);

as a testing.

Then the Failure in that row is not there when I was testing.
It means that <select * prepared statements do "not" see added columns
after alter table>
or another failure in some where else that causing to the result change.

But some how altertable.out shows two columns,

ij> -- select * prepared statements do see added columns after alter table
execute p1;
C1         |C2
-----------------------
1          |NULL
2          |NULL

Thanks
Eranda


> Convert altertable.sql to JUnit
> -------------------------------
>
>                 Key: DERBY-4187
>                 URL: https://issues.apache.org/jira/browse/DERBY-4187
>             Project: Derby
>          Issue Type: Test
>          Components: Test
>    Affects Versions: 10.4.2.1
>            Reporter: Eranda Sooriyabandara
>            Priority: Minor
>             Fix For: 10.5.1.2
>
>         Attachments: AlterTable.diff, AlterTable.java, AlterTableTest.diff, 
> AlterTableTest.diff, AlterTableTest.diff, AlterTableTest.java
>
>   Original Estimate: 486.08h
>  Remaining Estimate: 486.08h
>
> Converting altertable.sql harness test to JUnit

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