SQL Window TAB directives

[cct]

I really like the tab directives added in 11, but have a problem with the Totals one. In a multi query script, use the Tab, Records and Totals option before each script, the first two work fine, but the Totals only appear on the last query window.

If I select a single query and run it then they appear fine, or if I refresh a particular query, but not all from a single run.

Makes no difference if I change the order of the directives. IF I just select two and run, then again only the last has the totals.

This is in Version 11.0.4.1774 on Win 7 connecting through 10 client to an 11G database.

Any ideas?

Thanks

--
Chris

 

[Marco Kalter]

This seems like a bug. We'll fix it.

 

[William Robertson]

Wow, a nice feature I hadn't spotted.

Looking forward to the bug fix though, as the Totals seems to be applied to the last query even if there is no matching column, in which case it gives an error (though with a DSA option so we can suppress it).

-- tab=Sequences
-- records=5
-- totals=max:last_number
select * from user_sequences;

-- tab=Views
-- records=10
select * from user_views;

gives error: Unknown colum for totals: "LAST_NUMBER"

("column" is also miss-spelled.)