Issue Details (XML | Word | Printable)

Key: CORE-4396
Type: Bug Bug
Status: Closed Closed
Resolution: Fixed
Priority: Major Major
Assignee: Adriano dos Santos Fernandes
Reporter: Simonov Denis
Votes: 0
Watchers: 2
Operations

If you were logged in you would be able to see more operations.
Firebird Core

incorrect result query if it is execute through "execute statement"

Created: 20/Apr/14 08:00 AM   Updated: 23/Sep/15 11:22 AM
Component/s: None
Affects Version/s: 3.0 Alpha 2
Fix Version/s: 3.0 Beta 1

Environment: isql, firebird 3.0.0.31070

QA Status: Done successfully


 Description  « Hide
Use CONNECT or CREATE DATABASE to specify a database
SQL> connect 'localhost/3051:horses' user 'sysdba' password 'masterkey';
Database: 'localhost/3051:horses', User: sysdba
SQL> select RDB$RELATION_ID from RDB$RELATIONS order by RDB$RELATION_ID rows 3;

RDB$RELATION_ID
===============
              0
              1
              2

SQL> set term ^;
SQL> execute block
CON> returns (
CON> id integer
CON> )
CON> as
CON> begin
CON> for execute statement
CON> 'select RDB$RELATION_ID from RDB$RELATIONS order by RDB$RELATION_ID rows 3'
CON> on external 'localhost/3051:horses' as user 'sysdba' password 'masterkey'
CON> into :id
CON> do suspend;
CON> end^

          ID
============
           0
           0
           0

SQL> set term ;^
SQL>

 All   Comments   Change History   Subversion Commits      Sort Order: Ascending order - Click to sort in descending order
Adriano dos Santos Fernandes made changes - 21/Apr/14 01:00 AM
Field Original Value New Value
Status Open [ 1 ] Resolved [ 5 ]
Assignee Adriano dos Santos Fernandes [ asfernandes ]
Fix Version/s 3.0 Beta 1 [ 10332 ]
Resolution Fixed [ 1 ]
Pavel Zotov made changes - 28/May/15 02:54 PM
Status Resolved [ 5 ] Resolved [ 5 ]
QA Status Done successfully
Pavel Cisar made changes - 23/Sep/15 11:22 AM
Status Resolved [ 5 ] Closed [ 6 ]