incorrect result query if it is execute through "execute statement"
-------------------------------------------------------------------
Key: CORE-4396
URL: http://tracker.firebirdsql.org/browse/CORE-4396
Project: Firebird Core
Issue Type: Bug
Affects Versions: 3.0 Alpha 2
Environment: isql, firebird 3.0.0.31070
Reporter: Simonov Denis
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>
--
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators:
http://tracker.firebirdsql.org/secure/Administrators.jspa
-
For more information on JIRA, see: http://www.atlassian.com/software/jira
------------------------------------------------------------------------------
Learn Graph Databases - Download FREE O'Reilly Book
"Graph Databases" is the definitive new guide to graph databases and their
applications. Written by three acclaimed leaders in the field,
this first edition is now available. Download your free book today!
http://p.sf.net/sfu/NeoTech
Firebird-Devel mailing list, web interface at
https://lists.sourceforge.net/lists/listinfo/firebird-devel
