41 lines
673 B
Plaintext
41 lines
673 B
Plaintext
CREATE SCHEMA xtest DEFAULT CHARSET 'utf8mb4';
|
|
|
|
command ok
|
|
|
|
6 rows affected
|
|
Records: 6 Duplicates: 0 Warnings: 0
|
|
|
|
6 rows affected
|
|
Records: 6 Duplicates: 0 Warnings: 0
|
|
|
|
Issue #1
|
|
========
|
|
Table approach
|
|
sum_f2 sum_f1
|
|
232 4
|
|
234 6
|
|
command ok
|
|
Collection approach
|
|
doc
|
|
{"sum_f1": 4, "sum_f2": 232}
|
|
{"sum_f1": 6, "sum_f2": 234}
|
|
command ok
|
|
|
|
Issue #2
|
|
========
|
|
Table approach
|
|
Fld sum_f2
|
|
3 234
|
|
command ok
|
|
Collection approach (doc member in grouping criteria)
|
|
Got expected error: Invalid expression in grouping criteria (code 5154)
|
|
Collection approach (alias in grouping criteria)
|
|
doc
|
|
{"Fld": 3, "sum_f2": 234}
|
|
command ok
|
|
Mysqlx.Ok {
|
|
msg: "bye!"
|
|
}
|
|
ok
|
|
DROP SCHEMA IF EXISTS xtest;
|