Debian Codegraph @

mysql-test/suite/x/r/crud_find_doc_groupby.result

raw
1 CREATE SCHEMA xtest DEFAULT CHARSET 'utf8mb4';
2
3 command ok
4
5 5 rows affected
6 Records: 5 Duplicates: 0 Warnings: 0
7 group by name
8 doc
9 {"name": "foo"}
10 {"name": "bar"}
11 {"name": "baz"}
12 {"name": "buz"}
13 command ok
14 group by name and count
15 doc
16 {"name": "foo", "count": 2}
17 {"name": "bar", "count": 1}
18 {"name": "baz", "count": 1}
19 {"name": "buz", "count": 1}
20 command ok
21 group by name, age and count
22 doc
23 {"age": 1, "name": "foo", "count": 1}
24 {"age": 2, "name": "bar", "count": 1}
25 {"age": 3, "name": "baz", "count": 1}
26 {"age": 7, "name": "foo", "count": 1}
27 {"age": 17, "name": "buz", "count": 1}
28 command ok
29 no projection - error expected
30 Got expected error: Invalid empty projection list for grouping (code 5114)
31 group by name, count name and criteria on count
32 Got expected error: Invalid expression in grouping criteria (code 5154)
33 group by name, criteria on max(age)
34 doc
35 {"my_age": "17", "my_name": "buz"}
36 {"my_age": "7", "my_name": "foo"}
37 command ok
38 Mysqlx.Ok {
39 msg: "bye!"
40 }
41 ok