Default page

Your IP: 216.73.216.124
Server IP: 50.28.103.30
Server: Linux host.jcukjv-lwsites.com 4.18.0-553.22.1.el8_10.x86_64 #1 SMP Tue Sep 24 05:16:59 EDT 2024 x86_64
Server Software: nginx/1.28.0
PHP Version: 8.3.12
Buat File | Buat Folder

Dir : ~/www/server/mysql/mysql-test/suite/x/r/

View File Name : crud_find_doc_groupby.result

install plugin mysqlx soname "mysqlx.so";
call mtr.add_suppression("Plugin mysqlx reported: .Failed at SSL configuration: .SSL context is not usable without certificate and private key..");
call mtr.add_suppression("Plugin mysqlx reported: .SSL_CTX_load_verify_locations failed.");
DROP SCHEMA IF EXISTS xtest;
Warnings:
Note	1008	Can't drop database 'xtest'; database doesn't exist
CREATE SCHEMA xtest DEFAULT CHARSET 'utf8mb4';
CREATE TABLE xtest.xcoll (doc JSON, _id VARBINARY(16) GENERATED ALWAYS AS (JSON_UNQUOTE(JSON_EXTRACT(doc, '$._id'))) STORED PRIMARY KEY);
INSERT INTO xtest.xcoll (doc) VALUES
('{"_id": 1, "age": 1, "name": "foo"}'),
('{"_id": 2, "age": 2, "name": "bar"}'),
('{"_id": 3, "age": 3, "name": "baz", "date": {"day": 20, "month": "Apr"}} '),
('{"_id": 4, "age": 7, "name": "foo"}'),
('{"_id": 5, "age": 17, "name": "buz"}');
group by name
doc
{"name": "bar"}
{"name": "baz"}
{"name": "buz"}
{"name": "foo"}
command ok
group by name and count
doc
{"name": "bar", "count": 1}
{"name": "baz", "count": 1}
{"name": "buz", "count": 1}
{"name": "foo", "count": 2}
command ok
group by name, age and count
doc
{"age": 2, "name": "bar", "count": 1}
{"age": 3, "name": "baz", "count": 1}
{"age": 17, "name": "buz", "count": 1}
{"age": 1, "name": "foo", "count": 1}
{"age": 7, "name": "foo", "count": 1}
command ok
no projection - error expected
Got expected error: Invalid empty projection list for grouping (code 5114)
group by name, count name and criteria on count
Got expected error: Invalid expression in grouping criteria (code 5154)
group by name, criteria on max(age)
doc
{"my_age": "17", "my_name": "buz"}
{"my_age": "7", "my_name": "foo"}
command ok
Mysqlx.Ok {
  msg: "bye!"
}
ok
DROP SCHEMA IF EXISTS xtest;
UNINSTALL PLUGIN mysqlx;