| 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 |