Hello, I've a problem with this query :

UPDATE TB_TEST SET COL='123'
WHERE ID_TEST IN (
SELECT FIRST 10 ID_TEST
FROM TB_TEST)

ok, that work but all the records are updated and I want to update
only the first 10 records, there are a other solution or it's a bug
from firebird ?

With stored procedure no problem but I want use SQL Query.

I use the last firebird version for linux.