diff options
| author | bell@sanja.is.com.ua <> | 2004-05-13 23:47:20 +0300 |
|---|---|---|
| committer | bell@sanja.is.com.ua <> | 2004-05-13 23:47:20 +0300 |
| commit | 4c774e0c18069bb93fa1b4f336888c85de5820d1 (patch) | |
| tree | cedf6b9de442e03cc92b7d8d36e141e86ceddc58 /mysql-test/r/olap.result | |
| parent | 0422d559b645e8cea1a13db5d9ef838afd6dc5f7 (diff) | |
| download | mariadb-git-4c774e0c18069bb93fa1b4f336888c85de5820d1.tar.gz | |
fixed flags of printed query
Diffstat (limited to 'mysql-test/r/olap.result')
| -rw-r--r-- | mysql-test/r/olap.result | 2 |
1 files changed, 1 insertions, 1 deletions
diff --git a/mysql-test/r/olap.result b/mysql-test/r/olap.result index 37e68d8b13e..50048808c39 100644 --- a/mysql-test/r/olap.result +++ b/mysql-test/r/olap.result @@ -85,7 +85,7 @@ explain extended select product, country_id , year, sum(profit) from t1 group by id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE t1 ALL NULL NULL NULL NULL 15 Using temporary; Using filesort Warnings: -Note 1003 select high_priority test.t1.product AS `product`,test.t1.country_id AS `country_id`,test.t1.year AS `year`,sum(test.t1.profit) AS `sum(profit)` from test.t1 group by test.t1.product,test.t1.country_id,test.t1.year with rollup +Note 1003 select test.t1.product AS `product`,test.t1.country_id AS `country_id`,test.t1.year AS `year`,sum(test.t1.profit) AS `sum(profit)` from test.t1 group by test.t1.product,test.t1.country_id,test.t1.year with rollup select product, country_id , sum(profit) from t1 group by product desc, country_id with rollup; product country_id sum(profit) TV 1 400 |