diff options
| author | unknown <bell@sanja.is.com.ua> | 2004-05-13 23:47:20 +0300 |
|---|---|---|
| committer | unknown <bell@sanja.is.com.ua> | 2004-05-13 23:47:20 +0300 |
| commit | fd51cf47a9fd61dc1102cacfcb1e77cb1f19d702 (patch) | |
| tree | cedf6b9de442e03cc92b7d8d36e141e86ceddc58 /mysql-test/r/olap.result | |
| parent | d8522613d5395b63d2bd46ee6a0955bac78ed117 (diff) | |
| download | mariadb-git-fd51cf47a9fd61dc1102cacfcb1e77cb1f19d702.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 |