357 lines
7.8 KiB
Plaintext
357 lines
7.8 KiB
Plaintext
CREATE SCHEMA xtest;
|
|
|
|
Insert: doc with _id (literal)
|
|
------------------------------
|
|
|
|
command ok
|
|
|
|
0 rows affected
|
|
|
|
1 rows affected
|
|
Got expected error (code 0)
|
|
doc
|
|
{"_id": "1", "one": 1}
|
|
0 rows affected
|
|
|
|
Insert: doc without _id (literal)
|
|
---------------------------------
|
|
|
|
command ok
|
|
|
|
0 rows affected
|
|
|
|
1 rows affected
|
|
auto-generated id(s): 0000XXXXXXXX0000000000000001
|
|
Got expected error (code 0)
|
|
doc
|
|
{"_id": "0000XXXXXXXX0000000000000001", "two": 2}
|
|
0 rows affected
|
|
|
|
Insert: doc with _id (object)
|
|
-----------------------------
|
|
|
|
command ok
|
|
|
|
0 rows affected
|
|
|
|
1 rows affected
|
|
Got expected error (code 0)
|
|
doc
|
|
{"_id": "1", "one": 1}
|
|
0 rows affected
|
|
|
|
Insert: doc without _id (object)
|
|
--------------------------------
|
|
|
|
command ok
|
|
|
|
0 rows affected
|
|
|
|
1 rows affected
|
|
auto-generated id(s): 0000XXXXXXXX0000000000000002
|
|
Got expected error (code 0)
|
|
doc
|
|
{"_id": "0000XXXXXXXX0000000000000002", "two": 2}
|
|
0 rows affected
|
|
|
|
Insert: doc with _id (placeholder)
|
|
----------------------------------
|
|
|
|
command ok
|
|
|
|
0 rows affected
|
|
|
|
1 rows affected
|
|
Got expected error (code 0)
|
|
doc
|
|
{"_id": "1", "one": 1}
|
|
0 rows affected
|
|
|
|
Insert: doc without _id (placeholder)
|
|
-------------------------------------
|
|
|
|
command ok
|
|
|
|
0 rows affected
|
|
|
|
1 rows affected
|
|
auto-generated id(s): 0000XXXXXXXX0000000000000003
|
|
Got expected error (code 0)
|
|
doc
|
|
{"_id": "0000XXXXXXXX0000000000000003", "two": 2}
|
|
0 rows affected
|
|
|
|
Insert: 2 doc without _id (literal)
|
|
-----------------------------------
|
|
|
|
command ok
|
|
|
|
0 rows affected
|
|
|
|
2 rows affected
|
|
auto-generated id(s): 0000XXXXXXXX0000000000000004,0000XXXXXXXX0000000000000005
|
|
Records: 2 Duplicates: 0 Warnings: 0
|
|
Got expected error (code 0)
|
|
doc
|
|
{"_id": "0000XXXXXXXX0000000000000004", "two": 2}
|
|
{"_id": "0000XXXXXXXX0000000000000005", "three": 3}
|
|
0 rows affected
|
|
|
|
Insert: 2 doc without _id (literal/object)
|
|
------------------------------------------
|
|
|
|
command ok
|
|
|
|
0 rows affected
|
|
|
|
2 rows affected
|
|
auto-generated id(s): 0000XXXXXXXX0000000000000006,0000XXXXXXXX0000000000000007
|
|
Records: 2 Duplicates: 0 Warnings: 0
|
|
Got expected error (code 0)
|
|
doc
|
|
{"_id": "0000XXXXXXXX0000000000000006", "three": 3}
|
|
{"_id": "0000XXXXXXXX0000000000000007", "two": 2}
|
|
0 rows affected
|
|
|
|
Insert: 2 doc with/without _id (literal)
|
|
----------------------------------------
|
|
|
|
command ok
|
|
|
|
0 rows affected
|
|
|
|
2 rows affected
|
|
auto-generated id(s): 0000XXXXXXXX0000000000000008
|
|
Records: 2 Duplicates: 0 Warnings: 0
|
|
Got expected error (code 0)
|
|
doc
|
|
{"_id": "0000XXXXXXXX0000000000000008", "three": 3}
|
|
{"_id": "1", "one": 1}
|
|
0 rows affected
|
|
|
|
Insert: 2 doc with/without _id (object)
|
|
---------------------------------------
|
|
|
|
command ok
|
|
|
|
0 rows affected
|
|
|
|
2 rows affected
|
|
auto-generated id(s): 0000XXXXXXXX0000000000000009
|
|
Records: 2 Duplicates: 0 Warnings: 0
|
|
Got expected error (code 0)
|
|
doc
|
|
{"_id": "0000XXXXXXXX0000000000000009", "two": 2}
|
|
{"_id": "1", "one": 1}
|
|
0 rows affected
|
|
|
|
Insert: bad doc (literal) no insert
|
|
-----------------------------------
|
|
|
|
command ok
|
|
|
|
0 rows affected
|
|
Got expected error: Invalid JSON text: "not a JSON text, may need CAST" at position 0 in value for column 'coll.doc'. (code 3140)
|
|
doc
|
|
0 rows affected
|
|
|
|
Insert: 2 doc (literal) one bad, no insert
|
|
------------------------------------------
|
|
|
|
command ok
|
|
|
|
0 rows affected
|
|
Got expected error: Invalid JSON text: "not a JSON text, may need CAST" at position 0 in value for column 'coll.doc'. (code 3140)
|
|
doc
|
|
0 rows affected
|
|
|
|
Insert: change of "unique_prefix"
|
|
---------------------------------
|
|
|
|
0 rows affected
|
|
|
|
command ok
|
|
|
|
0 rows affected
|
|
|
|
2 rows affected
|
|
auto-generated id(s): 00ffXXXXXXXX000000000000000a,00ffXXXXXXXX000000000000000b
|
|
Records: 2 Duplicates: 0 Warnings: 0
|
|
Got expected error (code 0)
|
|
doc
|
|
{"_id": "00ffXXXXXXXX000000000000000a", "two": 2}
|
|
{"_id": "00ffXXXXXXXX000000000000000b", "three": 3}
|
|
0 rows affected
|
|
|
|
Insert: change of "auto_increment_increment"
|
|
--------------------------------------------
|
|
|
|
0 rows affected
|
|
|
|
command ok
|
|
|
|
0 rows affected
|
|
|
|
2 rows affected
|
|
auto-generated id(s): 00ffXXXXXXXX0000000000000101,00ffXXXXXXXX0000000000000201
|
|
Records: 2 Duplicates: 0 Warnings: 0
|
|
Got expected error (code 0)
|
|
doc
|
|
{"_id": "00ffXXXXXXXX0000000000000101", "two": 2}
|
|
{"_id": "00ffXXXXXXXX0000000000000201", "three": 3}
|
|
0 rows affected
|
|
|
|
Insert: change of "auto_increment_offset"
|
|
-----------------------------------------
|
|
|
|
0 rows affected
|
|
|
|
command ok
|
|
|
|
0 rows affected
|
|
|
|
2 rows affected
|
|
auto-generated id(s): 00ffXXXXXXXX0000000000000280,00ffXXXXXXXX0000000000000380
|
|
Records: 2 Duplicates: 0 Warnings: 0
|
|
Got expected error (code 0)
|
|
doc
|
|
{"_id": "00ffXXXXXXXX0000000000000280", "two": 2}
|
|
{"_id": "00ffXXXXXXXX0000000000000380", "three": 3}
|
|
0 rows affected
|
|
|
|
Insert: reset of "unique_prefix", "auto_increment_increment" and "auto_increment_offset"
|
|
----------------------------------------------------------------------------------------
|
|
|
|
0 rows affected
|
|
|
|
0 rows affected
|
|
|
|
0 rows affected
|
|
|
|
command ok
|
|
|
|
0 rows affected
|
|
|
|
2 rows affected
|
|
auto-generated id(s): 0000XXXXXXXX0000000000000381,0000XXXXXXXX0000000000000382
|
|
Records: 2 Duplicates: 0 Warnings: 0
|
|
Got expected error (code 0)
|
|
doc
|
|
{"_id": "0000XXXXXXXX0000000000000381", "two": 2}
|
|
{"_id": "0000XXXXXXXX0000000000000382", "three": 3}
|
|
0 rows affected
|
|
|
|
Notice: insert doc with _id
|
|
---------------------------
|
|
|
|
command ok
|
|
|
|
0 rows affected
|
|
Mysqlx.Notice.Frame {
|
|
type: 3
|
|
scope: LOCAL
|
|
payload: "Mysqlx.Notice.SessionStateChanged { param: ROWS_AFFECTED\nvalue {\n type: V_UINT\n v_unsigned_int: 1\n}\n }"
|
|
}
|
|
|
|
Mysqlx.Sql.StmtExecuteOk {
|
|
}
|
|
|
|
|
|
Notice: insert doc without _id
|
|
------------------------------
|
|
|
|
command ok
|
|
|
|
0 rows affected
|
|
Mysqlx.Notice.Frame {
|
|
type: 3
|
|
scope: LOCAL
|
|
payload: "Mysqlx.Notice.SessionStateChanged { param: ROWS_AFFECTED\nvalue {\n type: V_UINT\n v_unsigned_int: 1\n}\n }"
|
|
}
|
|
|
|
Mysqlx.Notice.Frame {
|
|
type: 3
|
|
scope: LOCAL
|
|
payload: "Mysqlx.Notice.SessionStateChanged { param: GENERATED_DOCUMENT_IDS\nvalue {\n type: V_OCTETS\n v_octets {\n value: \"0000XXXXXXXX0000000000000383\"\n }\n}\n }"
|
|
}
|
|
|
|
Mysqlx.Sql.StmtExecuteOk {
|
|
}
|
|
|
|
|
|
Notice: insert 2 doc with/without _id
|
|
-------------------------------------
|
|
|
|
command ok
|
|
|
|
0 rows affected
|
|
Mysqlx.Notice.Frame {
|
|
type: 3
|
|
scope: LOCAL
|
|
payload: "Mysqlx.Notice.SessionStateChanged { param: PRODUCED_MESSAGE\nvalue {\n type: V_STRING\n v_string {\n value: \"Records: 2 Duplicates: 0 Warnings: 0\"\n }\n}\n }"
|
|
}
|
|
|
|
Mysqlx.Notice.Frame {
|
|
type: 3
|
|
scope: LOCAL
|
|
payload: "Mysqlx.Notice.SessionStateChanged { param: ROWS_AFFECTED\nvalue {\n type: V_UINT\n v_unsigned_int: 2\n}\n }"
|
|
}
|
|
|
|
Mysqlx.Notice.Frame {
|
|
type: 3
|
|
scope: LOCAL
|
|
payload: "Mysqlx.Notice.SessionStateChanged { param: GENERATED_DOCUMENT_IDS\nvalue {\n type: V_OCTETS\n v_octets {\n value: \"0000XXXXXXXX0000000000000384\"\n }\n}\n }"
|
|
}
|
|
|
|
Mysqlx.Sql.StmtExecuteOk {
|
|
}
|
|
|
|
|
|
Notice: insert 2 doc without _id
|
|
--------------------------------
|
|
|
|
command ok
|
|
|
|
0 rows affected
|
|
Mysqlx.Notice.Frame {
|
|
type: 3
|
|
scope: LOCAL
|
|
payload: "Mysqlx.Notice.SessionStateChanged { param: PRODUCED_MESSAGE\nvalue {\n type: V_STRING\n v_string {\n value: \"Records: 2 Duplicates: 0 Warnings: 0\"\n }\n}\n }"
|
|
}
|
|
|
|
Mysqlx.Notice.Frame {
|
|
type: 3
|
|
scope: LOCAL
|
|
payload: "Mysqlx.Notice.SessionStateChanged { param: ROWS_AFFECTED\nvalue {\n type: V_UINT\n v_unsigned_int: 2\n}\n }"
|
|
}
|
|
|
|
Mysqlx.Notice.Frame {
|
|
type: 3
|
|
scope: LOCAL
|
|
payload: "Mysqlx.Notice.SessionStateChanged { param: GENERATED_DOCUMENT_IDS\nvalue {\n type: V_OCTETS\n v_octets {\n value: \"0000XXXXXXXX0000000000000385\"\n }\n}\nvalue {\n type: V_OCTETS\n v_octets {\n value: \"0000XXXXXXXX0000000000000386\"\n }\n}\n }"
|
|
}
|
|
|
|
Mysqlx.Sql.StmtExecuteOk {
|
|
}
|
|
|
|
|
|
Notice: insert bad doc
|
|
----------------------
|
|
|
|
command ok
|
|
|
|
0 rows affected
|
|
Mysqlx.Error {
|
|
severity: ERROR
|
|
code: 3140
|
|
msg: "Invalid JSON text: \"not a JSON text, may need CAST\" at position 0 in value for column \'coll.doc\'."
|
|
sql_state: "22032"
|
|
}
|
|
|
|
Mysqlx.Ok {
|
|
msg: "bye!"
|
|
}
|
|
ok
|
|
set global mysqlx_document_id_unique_prefix = DEFAULT;
|
|
DROP SCHEMA IF EXISTS xtest;
|