Something I just noticed:

Using only

select first x skip y * from messages;

works fine for any value!

So the problem has something to do with the select from multiple
tables or the WHERE clause?

--- In firebird-support@yahoogroups.com, "salisburyproject"
<kiril@o...> wrote:

>
> Hi,
>
> I am trying to use the FIRST x SKIP y syntax and I see some strange
> problem:
>
> The SELECT without FIRST,SKIP returns 6070 rows. Here is example of
> the select:
>
> select distinct messages.*, msg_to.to_email, msg_to.to_name,
> msg_to.to_type from messages,msg_to where (messages.common_id =
> msg_to.common_id) order by messages.msg_key asc, msg_to.to_type desc
>
> All rows have unique ID (msg_key), incremented for each row. No
> missing rows.
>
> Then, using syntax like:
>
> select first 10 skip 10 distinct messages.*, msg_to.to_email,
> msg_to.to_name, msg_to.to_type from messages,msg_to where
> (messages.common_id = msg_to.common_id) order by messages.msg_key
> asc, msg_to.to_type desc
>
> works fine (e.g. returns records 11 to 20).
>
> But this (note the skip 100):
>
> select first 10 skip 100 distinct messages.*, msg_to.to_email,
> msg_to.to_name, msg_to.to_type from messages,msg_to where
> (messages.common_id = msg_to.common_id) order by messages.msg_key
> asc, msg_to.to_type desc
>
> returns records 76,77,78 - yes, only three records.
>
> Using values 30, 600, returns rows 176 to 182 - total of 7 rows...
>
> FB is superserver 1.5.2. I am using the Firebird ODBC driver,

latest

> version.
>
> Any ideas?
> Thanks!
>
> Kiril.