/dports/databases/xtrabackup8/percona-xtrabackup-8.0.14/mysql-test/t/ |
H A D | olap.test | 607 SELECT a, b FROM t1 GROUP BY GROUPING(a),GROUPING(b) WITH ROLLUP; 888 ORDER BY GROUPING(i),i,GROUPING(j),j; 892 ORDER BY GROUPING(i),i,GROUPING(j),j LIMIT 5; 919 ORDER BY GROUPING(i),i, GROUPING(j),j, GROUPING(k),k; 923 ORDER BY GROUPING(i),i, GROUPING(j),j) as tmp; 931 HAVING GROUPING(i) = 1 ORDER BY GROUPING(i); 933 HAVING 1 + 2 - GROUPING(i) = 2 ORDER BY GROUPING(i); 935 HAVING GROUPING(j)+AVG(j) > 11 ORDER BY GROUPING(i); 939 WITH ROLLUP HAVING GROUPING(i) = 1 OR GROUPING (j) = 1 940 ORDER BY GROUPING(i),i,GROUPING(j),j; [all …]
|
H A D | olap_myisam.test | 33 SELECT GROUPING(alias2.pk) AS field2 FROM t2 AS alias1 LEFT JOIN t1 AS alias2 34 ON 0 GROUP BY alias2.pk WITH ROLLUP ORDER BY GROUPING(alias2.pk); 72 HAVING (field2 <> 239 ) ORDER BY GROUPING(field2);
|
/dports/databases/xtrabackup8/percona-xtrabackup-8.0.14/mysql-test/r/ |
H A D | olap.result | 1155 GROUPING(a) 1700 ORDER BY GROUPING(i),i,GROUPING(j),j; 1719 ORDER BY GROUPING(i),i,GROUPING(j),j LIMIT 5; 1793 ORDER BY GROUPING(i),i, GROUPING(j),j, GROUPING(k),k; 1829 ORDER BY GROUPING(i),i, GROUPING(j),j) as tmp; 1866 HAVING GROUPING(i) = 1 ORDER BY GROUPING(i); 1893 ORDER BY GROUPING(i),i,GROUPING(j),j; 1894 i j SUM(k) GROUPING(i) GROUPING(j) 1902 GROUPING(i) GROUPING(j) 1907 ORDER BY GROUPING(i), GROUPING(j); [all …]
|
H A D | olap_myisam.result | 25 SELECT GROUPING(alias2.pk) AS field2 FROM t2 AS alias1 LEFT JOIN t1 AS alias2 26 ON 0 GROUP BY alias2.pk WITH ROLLUP ORDER BY GROUPING(alias2.pk); 59 HAVING (field2 <> 239 ) ORDER BY GROUPING(field2);
|
/dports/devel/spark/spark-2.1.1/sql/core/src/test/resources/sql-tests/results/ |
H A D | group-analytics.sql.out | 150 SELECT course, year, SUM(earnings) FROM courseSales GROUP BY course, year GROUPING SETS(year) 160 GROUP BY course, earnings GROUPING SETS((), (course), (course, earnings)) ORDER BY course, sum 176 GROUP BY course, earnings GROUPING SETS((), (course), (course, earnings)) ORDER BY course, sum 191 SELECT course, year, GROUPING(course), GROUPING(year), GROUPING_ID(course, year) FROM courseSales 208 SELECT course, year, GROUPING(course) FROM courseSales GROUP BY course, year 236 HAVING GROUPING(year) = 1 AND GROUPING_ID(course, year) > 0 246 SELECT course, year FROM courseSales GROUP BY course, year HAVING GROUPING(course) > 0 273 SELECT course, year, GROUPING(course), GROUPING(year) FROM courseSales GROUP BY CUBE(course, year) 274 ORDER BY GROUPING(course), GROUPING(year), course, year 291 ORDER BY GROUPING(course), GROUPING(year), course, year [all …]
|
H A D | inner-join.sql.out | 6 CREATE TEMPORARY VIEW t1 AS SELECT * FROM VALUES (1) AS GROUPING(a) 14 CREATE TEMPORARY VIEW t2 AS SELECT * FROM VALUES (1) AS GROUPING(a) 22 CREATE TEMPORARY VIEW t3 AS SELECT * FROM VALUES (1), (1) AS GROUPING(a) 30 CREATE TEMPORARY VIEW t4 AS SELECT * FROM VALUES (1), (1) AS GROUPING(a)
|
H A D | grouping_set.sql.out | 29 SELECT a, b, c, count(d) FROM grouping GROUP BY a, b, c GROUPING SETS (()) 37 SELECT a, b, c, count(d) FROM grouping GROUP BY a, b, c GROUPING SETS ((a)) 47 SELECT a, b, c, count(d) FROM grouping GROUP BY a, b, c GROUPING SETS ((c)) 57 SELECT COUNT(1) FROM grouping_null GROUP BY e GROUPING SETS (e)
|
/dports/devel/spark/spark-2.1.1/sql/hive/src/test/resources/ql/src/test/queries/clientpositive/ |
H A D | groupby_grouping_sets1.q | 9 SELECT a, b, count(*) FROM T1 GROUP BY a, b GROUPING SETS (a, (a, b), b, ()); 11 SELECT a, b, count(*) FROM T1 GROUP BY a, b GROUPING SETS (a, (a, b)); 13 SELECT a FROM T1 GROUP BY a, b, c GROUPING SETS (a, b, c); 15 SELECT a FROM T1 GROUP BY a GROUPING SETS ((a), (a)); 17 SELECT a + b, count(*) FROM T1 GROUP BY a + b GROUPING SETS (a+b);
|
H A D | infer_bucket_sort_grouping_operators.q | 45 SELECT key, value, count(1) FROM src GROUP BY key, value GROUPING SETS (key, value); 48 SELECT key, value, count(1) FROM src GROUP BY key, value GROUPING SETS (key, value); 55 SELECT key, value, GROUPING__ID, count(1) FROM src GROUP BY key, value GROUPING SETS (key, value);
|
/dports/audio/id3lib/id3lib-3.8.3/src/ |
H A D | header_frame.h | 47 GROUPING = 1 << 5 enumerator 65 bool SetGrouping(bool b) { return this->SetFlags(GROUPING, b); } in SetGrouping() 69 bool GetGrouping() const { return _flags.test(GROUPING); } in GetGrouping()
|
/dports/lang/spidermonkey78/firefox-78.9.0/accessible/base/ |
H A D | AccGroupInfo.cpp | 127 if (parentRole != roles::GROUPING) return; in Update() 156 if (containerRole == roles::OUTLINEITEM && item->Role() == roles::GROUPING) in FirstItemOf() 171 if (item->Role() == roles::GROUPING && in FirstItemOf() 224 case roles::GROUPING: in TotalItemCount()
|
/dports/www/firefox-esr/firefox-91.8.0/accessible/base/ |
H A D | AccGroupInfo.cpp | 127 if (parentRole != roles::GROUPING) return; in Update() 157 item->Role() == roles::GROUPING) { in FirstItemOf() 174 if (item->Role() == roles::GROUPING && in FirstItemOf() 228 case roles::GROUPING: in TotalItemCount()
|
/dports/mail/thunderbird/thunderbird-91.8.0/accessible/base/ |
H A D | AccGroupInfo.cpp | 127 if (parentRole != roles::GROUPING) return; in Update() 157 item->Role() == roles::GROUPING) { in FirstItemOf() 174 if (item->Role() == roles::GROUPING && in FirstItemOf() 228 case roles::GROUPING: in TotalItemCount()
|
/dports/databases/pg_citus/citus-10.2.3/src/test/regress/expected/ |
H A D | subqueries_not_supported.out | 86 -- We do not support GROUPING SETS in subqueries 88 SELECT * FROM (SELECT user_id, value_1 FROM users_table GROUP BY GROUPING SETS ((user_id), (value_1… 89 ERROR: could not run distributed query with GROUPING SETS, CUBE, or ROLLUP 92 ERROR: could not run distributed query with GROUPING SETS, CUBE, or ROLLUP 95 ERROR: could not run distributed query with GROUPING SETS, CUBE, or ROLLUP
|
H A D | follower_single_node.out | 187 SELECT count(*) FROM test WHERE false GROUP BY GROUPING SETS (x,y); 200 SELECT count(*) FROM test WHERE false GROUP BY GROUPING SETS (x,y); 212 SELECT count(*) FROM test WHERE false GROUP BY GROUPING SETS (x,y); 224 SELECT count(*) FROM test WHERE false GROUP BY GROUPING SETS (x,y); 336 SELECT count(*) FROM test WHERE false GROUP BY GROUPING SETS (x,y); 349 SELECT count(*) FROM test WHERE false GROUP BY GROUPING SETS (x,y);
|
/dports/lang/spidermonkey60/firefox-60.9.0/accessible/base/ |
H A D | AccGroupInfo.cpp | 110 if (parentRole != roles::GROUPING) return; in Update() 139 if (containerRole == roles::OUTLINEITEM && item->Role() == roles::GROUPING) in FirstItemOf() 154 if (item->Role() == roles::GROUPING && in FirstItemOf()
|
/dports/www/firefox-legacy/firefox-52.8.0esr/accessible/base/ |
H A D | AccGroupInfo.cpp | 121 if (parentRole != roles::GROUPING) in Update() 154 if (containerRole == roles::OUTLINEITEM && item->Role() == roles::GROUPING) in FirstItemOf() 170 if (item->Role() == roles::GROUPING && in FirstItemOf()
|
/dports/textproc/modlogan/modlogan-0.8.13/src/output/webalizer/ |
H A D | generate.c | 54 #define GROUPING 2 116 if ((opt & GROUPING) && 435 …show_mhash(ext_conf, f,staweb->req_url_hash, conf->max_req_urls, HIGHLIGHT | GROUPING | INDEX | NO… 448 show_mhash(ext_conf, f,staweb->os_hash, conf->max_os, GROUPING | VISITS | INDEX); 461 show_mhash(ext_conf, f,staweb->host_hash, conf->max_hosts, GROUPING | INDEX); 472 show_mhash(ext_conf, f,staweb->ref_url_hash, conf->max_ref_urls, HIGHLIGHT | GROUPING | INDEX); 518 show_mhash(ext_conf, f,staweb->ua_hash, conf->max_ua, GROUPING | VISITS | INDEX); 584 show_mhash(ext_conf, f, staweb->status_missing_file, conf->max_broken_links, GROUPING | INDEX); 612 …show_mhash(ext_conf, f,staweb->searchsite, conf->max_search_engines, HIGHLIGHT | GROUPING | INDEX);
|
/dports/www/firefox/firefox-99.0/accessible/base/ |
H A D | AccGroupInfo.cpp | 127 if (parentRole != roles::GROUPING) return; in Update() 180 item->Role() == roles::GROUPING) { in FirstItemOf() 197 if (item->Role() == roles::GROUPING && in FirstItemOf() 258 case roles::GROUPING: in TotalItemCount()
|
/dports/textproc/modlogan/modlogan-0.8.13/src/output/template/ |
H A D | mail.c | 34 #define GROUPING 2 macro 144 if ((opt & GROUPING) && mdata_is_grouped(data)) { in show_mhash_mail() 227 HIGHLIGHT | GROUPING | INDEX | PERCENT | VISITS | VISITS_TRAFFIC, in get_reports_mail() 242 HIGHLIGHT | GROUPING | INDEX | PERCENT | VISITS | VISITS_TRAFFIC | SORT_BY_VCOUNT, in get_reports_mail() 256 HIGHLIGHT | GROUPING | INDEX | PERCENT | VISITS | VISITS_TRAFFIC, in get_reports_mail() 271 HIGHLIGHT | GROUPING | INDEX | PERCENT | VISITS | VISITS_TRAFFIC | SORT_BY_VCOUNT, in get_reports_mail() 286 HIGHLIGHT | GROUPING | INDEX | PERCENT | VISITS | VISITS_TRAFFIC, in get_reports_mail() 316 HIGHLIGHT | GROUPING | INDEX | PERCENT | VISITS | VISITS_TRAFFIC, in get_reports_mail() 346 HIGHLIGHT | GROUPING | INDEX | PERCENT, in get_reports_mail() 361 HIGHLIGHT | GROUPING | INDEX | PERCENT, in get_reports_mail() [all …]
|
H A D | web.c | 28 const int GROUPING = BV(1); 281 if ((opt & GROUPING) && mdata_is_grouped(data)) { 1023 HIGHLIGHT | GROUPING | INDEX | PERCENT, 1049 GROUPING | VISITS | INDEX | PERCENT, 1063 GROUPING | INDEX | VISITS | PERCENT, 1115 GROUPING | VISITS | INDEX | PERCENT, 1181 GROUPING | INDEX | BROKEN_LINK | PERCENT, 1209 INDEX | PERCENT | GROUPING, 1223 HIGHLIGHT | GROUPING | INDEX | PERCENT, 1294 GROUPING | INDEX | VISITS | PERCENT, [all …]
|
/dports/devel/R-cran-data.table/data.table/man/ |
H A D | groupingsets.Rd | 10 …levels of groupings producing multiple (sub-)totals. Reflects SQLs \emph{GROUPING SETS} operations. 39 \url{https://www.postgresql.org/docs/9.5/static/queries-table-expressions.html#QUERIES-GROUPING-SET… 40 \url{https://www.postgresql.org/docs/9.5/static/functions-aggregate.html#FUNCTIONS-GROUPING-TABLE}
|
/dports/databases/timescaledb/timescaledb-2.5.1/tsl/test/expected/ |
H A D | dist_partial_agg.out | 130 \set GROUPING 'location' 137 :PREFIX SELECT :GROUPING, 172 GROUP BY :GROUPING, timec 201 :PREFIX SELECT :GROUPING, 238 :PREFIX SELECT :GROUPING, 284 :PREFIX SELECT :GROUPING, 316 :PREFIX SELECT :GROUPING 356 :PREFIX SELECT :GROUPING, 547 :PREFIX SELECT :GROUPING 583 \set GROUPING 'location' [all …]
|
/dports/devel/zpu-gcc/zpu-toolchain-1.0/toolchain/gcc/libstdc++-v3/config/locale/gnu/ |
H A D | numeric_members.cc | 76 _M_data->_M_grouping = __nl_langinfo_l(GROUPING, __cloc); in _M_initialize_numpunct() 144 _M_data->_M_grouping = __nl_langinfo_l(GROUPING, __cloc); in _M_initialize_numpunct()
|
/dports/devel/zpu-binutils/zpu-toolchain-1.0/toolchain/gcc/libstdc++-v3/config/locale/gnu/ |
H A D | numeric_members.cc | 76 _M_data->_M_grouping = __nl_langinfo_l(GROUPING, __cloc); in _M_initialize_numpunct() 144 _M_data->_M_grouping = __nl_langinfo_l(GROUPING, __cloc); in _M_initialize_numpunct()
|