db-derby-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Dag H. Wanvik (JIRA)" <j...@apache.org>
Subject [jira] Assigned: (DERBY-4212) Prepared statement with OFFSET/FETCH gives different results on subsequent execute
Date Tue, 05 May 2009 16:44:30 GMT

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

Dag H. Wanvik reassigned DERBY-4212:
------------------------------------

    Assignee: Dag H. Wanvik

> Prepared statement with OFFSET/FETCH gives different results on subsequent execute
> ----------------------------------------------------------------------------------
>
>                 Key: DERBY-4212
>                 URL: https://issues.apache.org/jira/browse/DERBY-4212
>             Project: Derby
>          Issue Type: Bug
>          Components: SQL
>    Affects Versions: 10.5.1.1
>            Reporter: Steve Radman
>            Assignee: Dag H. Wanvik
>         Attachments: derby-4212.diff, derby-4212.stat, test.diff
>
>
> A prepared statement with OFFSET/FETCH does not use the OFFSET/FETCH values after the
first EXECUTE (e.g. 2nd invocation of EXECUTE).
> NOTE: Only tested in ij with toursdb database
> ij> prepare foo as 'select * from cities where city_id <= 10 fetch first 5 rows
only';
> ij> execute foo;
> CITY_ID    |CITY_NAME               |COUNTRY                   |AIR&|LANGUAGE   
    |COU&
> ------------------------------------------------------------------------------------------
> 1          |Amsterdam               |Netherlands               |AMS |Dutch          
|NL
> 2          |Athens                  |Greece                    |ATH |Greek          
|GR
> 3          |Auckland                |New Zealand               |AKL |English        
|NZ
> 4          |Beirut                  |Lebanon                   |BEY |Arabic         
|LB
> 5          |Bogota                  |Colombia                  |BOG |Spanish        
|CO
> 5 rows selected
> ij> execute foo;
> CITY_ID    |CITY_NAME               |COUNTRY                   |AIR&|LANGUAGE   
    |COU&
> ------------------------------------------------------------------------------------------
> 0 rows selected
> ij> remove foo;
> ij> prepare foo as 'select * from cities where city_id <= 10 offset 5 rows';
> ij> execute foo;
> CITY_ID    |CITY_NAME               |COUNTRY                   |AIR&|LANGUAGE   
    |COU&
> ------------------------------------------------------------------------------------------
> 6          |Bombay                  |India                     |BOM |Hindi          
|IN
> 7          |Budapest                |Hungary                   |BUD |Hungarian      
|HU
> 8          |Buenos Aires            |Argentina                 |BUE |Spanish        
|AR
> 9          |Cairo                   |Egypt                     |CAI |Arabic         
|EG
> 10         |Calcutta                |India                     |CCU |Bengali        
|IN
> 5 rows selected
> ij> execute foo;
> CITY_ID    |CITY_NAME               |COUNTRY                   |AIR&|LANGUAGE   
    |COU&
> ------------------------------------------------------------------------------------------
> 1          |Amsterdam               |Netherlands               |AMS |Dutch          
|NL
> 2          |Athens                  |Greece                    |ATH |Greek          
|GR
> 3          |Auckland                |New Zealand               |AKL |English        
|NZ
> 4          |Beirut                  |Lebanon                   |BEY |Arabic         
|LB
> 5          |Bogota                  |Colombia                  |BOG |Spanish        
|CO
> 6          |Bombay                  |India                     |BOM |Hindi          
|IN
> 7          |Budapest                |Hungary                   |BUD |Hungarian      
|HU
> 8          |Buenos Aires            |Argentina                 |BUE |Spanish        
|AR
> 9          |Cairo                   |Egypt                     |CAI |Arabic         
|EG
> 10         |Calcutta                |India                     |CCU |Bengali        
|IN
> 10 rows selected

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


Mime
View raw message