Wrong behaviour of SELECT statements with ROWS parameters
----------------------------------------------------------
Key: CORE-3711
URL: http://tracker.firebirdsql.org/browse/CORE-3711
Project: Firebird Core
Issue Type: Bug
Components: Engine
Affects Versions: 2.5.1
Environment: Windows XP SP3
Reporter: Michael
1 .SQL> select * from rdb$database rows 0 to 1;
Statement failed, SQLSTATE = 42000
Invalid parameter to SKIP. Only integers >= 0 are allowed.
Should be "Invalid parameter to SKIP. Only integers > 0 are allowed."
2. select * from rdb$database rows 0 to 1 SHOULD display an empty recordset.
For more information see this thread:
http://www.sql.ru/forum/actualthread.aspx?tid=906663
--
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
------------------------------------------------------------------------------
Write once. Port to many.
Get the SDK and tools to simplify cross-platform app development. Create
new or port existing apps to sell to consumers worldwide. Explore the
Intel AppUpSM program developer opportunity. appdeveloper.intel.com/join
http://p.sf.net/sfu/intel-appdev
Firebird-Devel mailing list, web interface at
https://lists.sourceforge.net/lists/listinfo/firebird-devel
