row_count not updated in singleton select
-----------------------------------------
Key: CORE-4249
URL: http://tracker.firebirdsql.org/browse/CORE-4249
Project: Firebird Core
Issue Type: Bug
Components: ISQL
Affects Versions: 2.5.2 Update 1
Environment: Windows 2008 Foundation
Reporter: Alvaro Castiello
Not quite sure if this is a bug but ROW_COUNT does not have the correct value
depending on the syntax of the singleton used:
-- obtener el cliente de la póliza
aCLIENTE_ID = (
select POLIZA_CLIENTE_ID
from POLIZAS_CLIENTES
where
(POLIZA_COMPANIA_ID = :pCOMPANIA_ID) and
(POLIZA_NUMERO = :pNUMERO) and
(POLIZA_ID = :pPOLIZA_ID) and
(POLIZA_CLIENTE_NUMERO = :pCLIENTE_NUMERO)
);
-- row_count is always zero regardless of the data found
select POLIZA_CLIENTE_ID
from POLIZAS_CLIENTES
where
(POLIZA_COMPANIA_ID = :pCOMPANIA_ID) and
(POLIZA_NUMERO = :pNUMERO) and
(POLIZA_ID = :pPOLIZA_ID) and
(POLIZA_CLIENTE_NUMERO = :pCLIENTE_NUMERO) into aCLIENTE_ID;
-- works fine
in other words
aVar = (select..... does not show correct ROW_COUNT (always 0)
select... into aVar works fine
Best regards,
Alvaro Castiello de la Hidalga
--
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
------------------------------------------------------------------------------
October Webinars: Code for Performance
Free Intel webinars can help you accelerate application performance.
Explore tips for MPI, OpenMP, advanced profiling, and more. Get the most from
the latest Intel processors and coprocessors. See abstracts and register >
http://pubads.g.doubleclick.net/gampad/clk?id=60135991&iu=/4140/ostg.clktrk
Firebird-Devel mailing list, web interface at
https://lists.sourceforge.net/lists/listinfo/firebird-devel
