[jira] Commented: (DERBY-4318) convert inbetween.sql to JUNIT

[Eranda Sooriyabandara (JIRA)]

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

Eranda Sooriyabandara commented on DERBY-4318:
----------------------------------------------

Hi Bryan,

I did some search on the RuntimeStaticParser and finally end up some coding
 which succeed.

rs=st.executeQuery("SELECT R FROM t");
        while(rs.next()){}
        rs.close();

        rs = st.executeQuery(
            " values SYSCS_UTIL.SYSCS_GET_RUNTIMESTATISTICS()");
        rs.next();

        if(usingEmbedded()){
            RuntimeStatisticsParser rtsp = new
RuntimeStatisticsParser(rs.getString(1));
            rs.close();
            assertTrue(rtsp.usedTableScan());
            assertFalse(rtsp.usedDistinctScan());
        }

Is it fare to use this code here? Are there any problem with using this
code?
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
>
>
> 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.