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
There are no subversion log entries for this issue yet.