Error when processing an empty data set by window function, if reading indexed
------------------------------------------------------------------------------
Key: CORE-4131
URL: http://tracker.firebirdsql.org/browse/CORE-4131
Project: Firebird Core
Issue Type: Bug
Components: Engine
Affects Versions: 3.0 Initial
Environment: Firebird 3.0.0.30472 x86
Windows 7 x86
Reporter: Simonov Denis
when execute sql query
select row_number() over(order by f.rdb$field_name) as rn,
f.rdb$field_name as name
from rdb$fields f
where f.rdb$field_name = '000000'
Error message:
The cursor identified in the UPDATE or DELETE statement is not positioned on a
row. no current record for fetch operation.
when execute sql query (non index read)
select row_number() over(order by f.RDB$QUERY_NAME) as rn,
f.RDB$QUERY_NAME as name
from rdb$fields f
where f.RDB$QUERY_NAME = 'ddd'
Result is correct.
RN NAME
-------------------
NULL NULL
--
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
------------------------------------------------------------------------------
This SF.net email is sponsored by Windows:
Build for Windows Store.
http://p.sf.net/sfu/windows-dev2dev
Firebird-Devel mailing list, web interface at
https://lists.sourceforge.net/lists/listinfo/firebird-devel
