Home
last modified time | relevance | path

Searched refs:GROUPING (Results 1 – 25 of 1706) sorted by relevance

12345678910>>...69

/dports/databases/xtrabackup8/percona-xtrabackup-8.0.14/mysql-test/t/
H A Dolap.test607 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 Dolap_myisam.test33 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 Dolap.result1155 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 Dolap_myisam.result25 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 Dgroup-analytics.sql.out150 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 Dinner-join.sql.out6 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 Dgrouping_set.sql.out29 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 Dgroupby_grouping_sets1.q9 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 Dinfer_bucket_sort_grouping_operators.q45 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 Dheader_frame.h47 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 DAccGroupInfo.cpp127 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 DAccGroupInfo.cpp127 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 DAccGroupInfo.cpp127 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 Dsubqueries_not_supported.out86 -- 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 Dfollower_single_node.out187 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 DAccGroupInfo.cpp110 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 DAccGroupInfo.cpp121 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 Dgenerate.c54 #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 DAccGroupInfo.cpp127 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 Dmail.c34 #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 Dweb.c28 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 Dgroupingsets.Rd10 …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 Ddist_partial_agg.out130 \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 Dnumeric_members.cc76 _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 Dnumeric_members.cc76 _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()

12345678910>>...69