Subject Firebird 2.0 Release Notes: EXECUTE BLOCK, RETURNING CLAUSE, COMPOUND INDEX
Author crizoo4712
Hello all,

1. in the 2.0-Release Notes the EXECUTE BLOCK Syntax is announced.
The following statements works:
EXECUTE BLOCK returns (out integer)
AS
BEGIN
select first 1 f1 from T2 into out;
suspend;
END

In order to be able to return multiple rows, I changed it to:
EXECUTE BLOCK returns (out integer)
AS
BEGIN
for select f1 from T2 into out do
suspend;
END
This causes the error "-104 - Token unknown line 5, column 1 ;".
Whats up here?

2. The RETURNING CLAUSE for inserts is announced as available in DSQL
and PSQL. The usage in PSQL is no problem.
In contradiction to the announced DSQL-Availability it is written in
the Notes, that the INTO part is allowed in PSQL only and rejected in
DSQL (everybody expects this..).
And then: In DSQL, values are being returned within the same protocol
roundtrip as the INSERT itself is executed.
Now..is it available in DSQL or not? What is meant by "protocol
roundtrip"?

3. SELECTIVITY MAINTENANCE per Segment is announced.
Can one select values of columns which are the 2nd element of a
compound index for example and have an index access?
My optimizer shows a PLAN (NATURAL..)!?

Thanks for help, regards, Christoph