BlogDocs

fix: Use of `HAVING` outside of `GROUP BY` should raise a suitable SQLSyntaxError(#19320)

Merged
Comparing
alexander-beedie:sql-invalid-having-clause
(
228c7cf
) with
main
(
dbc8368
)
-1%
IMPROVEMENTS
0
REGRESSIONS
0
UNTOUCHED
41
NEW
0
DROPPED
0
IGNORED
1

Benchmarks

Passed

test_groupby_h2oai_q4
py-polars/tests/benchmark/test_group_by.py::test_groupby_h2oai_q4
+17%
2.5 ms
2.1 ms
test_groupby_h2oai_q5
py-polars/tests/benchmark/test_group_by.py::test_groupby_h2oai_q5
+7%
2.2 ms
2 ms
test_groupby_h2oai_q1
py-polars/tests/benchmark/test_group_by.py::test_groupby_h2oai_q1
+5%
2.4 ms
2.3 ms
test_pdsh_q18
py-polars/tests/benchmark/test_pdsh.py::test_pdsh_q18
+4%
12 ms
11.6 ms
test_filter1
py-polars/tests/benchmark/test_filter.py::test_filter1
+4%
749.7 µs
722.9 µs
test_pdsh_q12
py-polars/tests/benchmark/test_pdsh.py::test_pdsh_q12
+4%
6.1 ms
5.9 ms
test_pdsh_q15
py-polars/tests/benchmark/test_pdsh.py::test_pdsh_q15
+3%
2.5 ms
2.5 ms
test_pdsh_q20
py-polars/tests/benchmark/test_pdsh.py::test_pdsh_q20
+2%
6.2 ms
6 ms
test_groupby_h2oai_q7
py-polars/tests/benchmark/test_group_by.py::test_groupby_h2oai_q7
+2%
2.1 ms
2.1 ms
test_groupby_h2oai_q10
py-polars/tests/benchmark/test_group_by.py::test_groupby_h2oai_q10
+2%
6.5 ms
6.3 ms
test_groupby_h2oai_q8
py-polars/tests/benchmark/test_group_by.py::test_groupby_h2oai_q8
+2%
3.1 ms
3.1 ms
test_pdsh_q11
py-polars/tests/benchmark/test_pdsh.py::test_pdsh_q11
+2%
4.1 ms
4 ms
test_single_inequality
py-polars/tests/benchmark/test_join_where.py::test_single_inequality
+1%
80.8 ms
79.6 ms
test_groupby_h2oai_q6
py-polars/tests/benchmark/test_group_by.py::test_groupby_h2oai_q6
+1%
12.6 ms
12.5 ms
test_pdsh_q16
py-polars/tests/benchmark/test_pdsh.py::test_pdsh_q16
+1%
7.3 ms
7.2 ms
test_pdsh_q14
py-polars/tests/benchmark/test_pdsh.py::test_pdsh_q14
+1%
2.1 ms
2.1 ms
test_pdsh_q19
py-polars/tests/benchmark/test_pdsh.py::test_pdsh_q19
0%
7.6 ms
7.6 ms
test_to_numpy_series_zero_copy
py-polars/tests/benchmark/interop/test_numpy.py::test_to_numpy_series_zero_copy
0%
123.8 µs
123.4 µs
test_to_numpy_series_chunked
py-polars/tests/benchmark/interop/test_numpy.py::test_to_numpy_series_chunked
0%
270 µs
269.5 µs
test_non_strict_inequalities
py-polars/tests/benchmark/test_join_where.py::test_non_strict_inequalities
0%
174.5 ms
174.3 ms
test_to_numpy_series_with_nulls
py-polars/tests/benchmark/interop/test_numpy.py::test_to_numpy_series_with_nulls
0%
435.3 µs
434.8 µs
test_pdsh_q9
py-polars/tests/benchmark/test_pdsh.py::test_pdsh_q9
0%
25.6 ms
25.5 ms
test_write_read_scan_large_csv
py-polars/tests/benchmark/test_io.py::test_write_read_scan_large_csv
0%
37.6 ms
37.7 ms
test_strict_inequalities
py-polars/tests/benchmark/test_join_where.py::test_strict_inequalities
0%
169.1 ms
169.8 ms
test_groupby_h2oai_q9
py-polars/tests/benchmark/test_group_by.py::test_groupby_h2oai_q9
0%
27.8 ms
27.9 ms
test_pdsh_q21
py-polars/tests/benchmark/test_pdsh.py::test_pdsh_q21
-1%
211.9 ms
213.6 ms
test_pdsh_q4
py-polars/tests/benchmark/test_pdsh.py::test_pdsh_q4
-2%
4.7 ms
4.8 ms
test_groupby_h2oai_q2
py-polars/tests/benchmark/test_group_by.py::test_groupby_h2oai_q2
-2%
4.6 ms
4.7 ms
test_pdsh_q13
py-polars/tests/benchmark/test_pdsh.py::test_pdsh_q13
-2%
9.8 ms
10.1 ms
test_datetime_range_fast_slow_paths
py-polars/tests/unit/functions/range/test_datetime_range.py::test_datetime_range_fast_slow_paths
-3%
338 ms
347.7 ms
test_pdsh_q2
py-polars/tests/benchmark/test_pdsh.py::test_pdsh_q2
-3%
3.7 ms
3.8 ms
test_pdsh_q10
py-polars/tests/benchmark/test_pdsh.py::test_pdsh_q10
-3%
6 ms
6.2 ms
test_pdsh_q8
py-polars/tests/benchmark/test_pdsh.py::test_pdsh_q8
-4%
5.3 ms
5.5 ms
test_pdsh_q17
py-polars/tests/benchmark/test_pdsh.py::test_pdsh_q17
-4%
6.5 ms
6.8 ms
test_pdsh_q6
py-polars/tests/benchmark/test_pdsh.py::test_pdsh_q6
-6%
1.8 ms
2 ms
test_pdsh_q7
py-polars/tests/benchmark/test_pdsh.py::test_pdsh_q7
-7%
9.1 ms
9.8 ms
test_pdsh_q1
py-polars/tests/benchmark/test_pdsh.py::test_pdsh_q1
-7%
16.2 ms
17.4 ms
test_pdsh_q5
py-polars/tests/benchmark/test_pdsh.py::test_pdsh_q5
-8%
4.6 ms
5 ms
test_pdsh_q22
py-polars/tests/benchmark/test_pdsh.py::test_pdsh_q22
-8%
6.6 ms
7.3 ms
test_pdsh_q3
py-polars/tests/benchmark/test_pdsh.py::test_pdsh_q3
-9%
5.4 ms
6 ms
test_groupby_h2oai_q3
py-polars/tests/benchmark/test_group_by.py::test_groupby_h2oai_q3
-19%
2.3 ms
2.8 ms

Ignored

test_filter2Ignored
py-polars/tests/benchmark/test_filter.py::test_filter2
+20%
1,101.9 µs
919.5 µs

Commits

Click on a commit to change the comparison range
base
main
dbc8368
-1%
fix: Use of `HAVING` outside of `GROUP BY` should raise a suitable SQLSyntaxError
228c7cf
8 days ago
by alexander-beedie
ResourcesHomePricingDocsBlogGitHubChangelog
Copyright © 2024 CodSpeed Technology SAS. All rights reserved.