Debian Codegraph @

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

raw
1 CREATE SCHEMA xtest DEFAULT CHARSET 'utf8mb4';
2
3 command ok
4
5 6 rows affected
6 Records: 6 Duplicates: 0 Warnings: 0
7
8 6 rows affected
9 Records: 6 Duplicates: 0 Warnings: 0
10
11 Issue #1
12 ========
13 Table approach
14 sum_f2 sum_f1
15 232 4
16 234 6
17 command ok
18 Collection approach
19 doc
20 {"sum_f1": 4, "sum_f2": 232}
21 {"sum_f1": 6, "sum_f2": 234}
22 command ok
23
24 Issue #2
25 ========
26 Table approach
27 Fld sum_f2
28 3 234
29 command ok
30 Collection approach (doc member in grouping criteria)
31 Got expected error: Invalid expression in grouping criteria (code 5154)
32 Collection approach (alias in grouping criteria)
33 doc
34 {"Fld": 3, "sum_f2": 234}
35 command ok
36 Mysqlx.Ok {
37 msg: "bye!"
38 }
39 ok