14690
83%
master: 87%

Ran 04 Dec 2018 10:44AM UTC

Jobs 1

Files 358

Run time 16min

Badge

Embed ▾

pending completion

Build # 14690

Build Type

push

travis-ci

Committed by

kshcherbatov

Commit Message

sql: support HAVING without GROUP BY clause

Allowed to make SELECT requests that have HAVING clause without
GROUP BY. It is possible when both - left and right parts of
request have aggregate function or constant value.

Closes #2364.

@TarantoolBot document
Title: HAVING without GROUP BY clause
A query with a having clause should also have a group by clause.
If you omit group by, all the rows not excluded by the where
clause return as a single group.
Because no grouping is performed between the where and having
clauses, they cannot act independently of each other. Having
acts like where because it affects the rows in a single group
rather than groups, except the having clause can still use
aggregates.
Having without group by is not supported for select from
multiple tables.

2011 SQL standard "Part 2: Foundation" 7.10 <having clause> p.381

Example:
SELECT MIN(s1) FROM te40 HAVING SUM(s1) > 0; -- is valid
SELECT 1 FROM te40 HAVING SUM(s1) > 0;       -- is valid
SELECT NULL FROM te40 HAVING SUM(s1) > 0;    -- is valid
SELECT date() FROM te40 HAVING SUM(s1) > 0;  -- is valid

Run Details

63787 of 77376 relevant lines covered (82.44%)

2520120.87 hits per line

Jobs

ID	Job ID	Ran	Files	Coverage
5	14690.5 (TARGET=coverage)	04 Dec 2018 10:44AM UTC	358	82.44	Travis Job 14690.5

tarantool / tarantool / 14690
83%
master: 87%

README BADGES
x

Markdown

Textile

RDoc

HTML

Rst

Jobs

Source Files on build 14690

tarantool / tarantool / 14690 83% master: 87%

README BADGES x

Markdown

Textile

RDoc

HTML

Rst

Jobs

Source Files on build 14690

tarantool / tarantool / 14690
83%
master: 87%

README BADGES
x