[jira] [Assigned] (IGNITE-11251) SQL: getMoreResults() infinitely reports about update operation on zeroCursor

["Alexander Lapin (JIRA)" <ji...@apache.org>]

     [ https://issues.apache.org/jira/browse/IGNITE-11251?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Alexander Lapin reassigned IGNITE-11251:
----------------------------------------

    Assignee: Alexander Lapin

> SQL: getMoreResults() infinitely reports about update operation on zeroCursor
> -----------------------------------------------------------------------------
>
>                 Key: IGNITE-11251
>                 URL: https://issues.apache.org/jira/browse/IGNITE-11251
>             Project: Ignite
>          Issue Type: Bug
>          Components: jdbc, sql
>            Reporter: Pavel Kuznetsov
>            Assignee: Alexander Lapin
>            Priority: Major
>
> If we got sql query that contain empty statement, jdbc thin driver will allways return {{true}} from {{getMoreResults}} method.
> Jdbc spec says: 
> {noformat}
> oves to this Statement object's next result, returns true if it is a ResultSet object, 
> <...>
> Returns:
> true if the next result is a ResultSet object; false if it is an update count or there are no more results
> {noformat}
> so test : 
> {code:java}
>  @Test
>     public void test () throws Exception {
>         try (Connection c = GridTestUtils.connect(grid(0), null)) {
>             try (PreparedStatement p = c.prepareStatement(";")) {
>                 boolean isResultSet = p.execute();
>                 // Adding next line works the problem around:
>                 // p.getUpdateCount() == 0;
>                 
>                 boolean isResultSetReturned = p.getMoreResults();
>                 
>                // should be false:
>                 assertFalse(isResultSetReturned); // == true
>             }
>         }
>     }
> {code}
> {{getResultSet}} is {{null}} in this case.



--
This message was sent by Atlassian JIRA
(v7.6.3#76005)