#1279 UI Result Limit is erroneously applied to INSERT...SELECT statement

[Paul Mogren]

Example script:

create table ##min_item_size(item_id int primary key clustered, item_size int);

insert ##min_item_size select item_id, min(item_size) [item_size] from item_size group by item_id;

When Limit Rows is checked in the UI, only that many rows are copied into ##min_item_size. The correct behavior would be to copy all rows and ignore the Limit Rows setting.

[Gerd Wagner]

Obviously your database/JDBC driver combination supports limiting rows in insert-select statements. SQuirreL just calls JDBC's limit rows method when a limit is given which I think shouldn't be changed.