Debian Codegraph @

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

raw
1 create schema xtest default charset='utf8mb4';
2
3 command ok
4 send Mysqlx.Crud.Insert {
5 collection {
6 name: "mycoll"
7 schema: "xtest"
8 }
9 data_model: DOCUMENT
10 row {
11 field {
12 type: LITERAL
13 literal {
14 type: V_STRING
15 v_string {
16 value: "\n{\n \"_id\": \"X999_Y999\",\n \"from\": {\n \"name\": \"Tom Brady\", \"id\": \"X12\"\n },\n \"message\": \"Looking forward to 2010!\",\n \"actions\": [\n {\n \"name\": \"Comment\",\n \"link\": \"http://www.facebook.com/X999/posts/Y999\"\n },\n {\n \"name\": \"Like\",\n \"link\": \"http://www.facebook.com/X999/posts/Y999\"\n }\n ],\n \"type\": \"status\",\n \"created_time\": \"2010-08-02T21:27:44+0000\",\n \"updated_time\": \"2010-08-02T21:27:44+0000\"\n }\n"
17 }
18 }
19 }
20 }
21 }
22
23
24 1 rows affected
25 send Mysqlx.Crud.Insert {
26 collection {
27 name: "mycoll"
28 schema: "xtest"
29 }
30 data_model: DOCUMENT
31 row {
32 field {
33 type: LITERAL
34 literal {
35 type: V_STRING
36 v_string {
37 value: "\n{\n \"_id\": \"X999_Y999\",\n \"from\": {\n \"name\": \"Tom Brady\", \"id\": \"X12\"\n },\n \"message\": \"Looking forward to 2010!\",\n \"actions\": [\n {\n \"name\": \"Comment\",\n \"link\": \"http://www.facebook.com/X999/posts/Y999\"\n },\n {\n \"name\": \"Like\",\n \"link\": \"http://www.facebook.com/X999/posts/Y999\"\n }\n ],\n \"type\": \"status\",\n \"created_time\": \"2010-08-02T21:27:44+0000\",\n \"updated_time\": \"2010-08-02T21:27:44+0000\"\n }\n"
38 }
39 }
40 }
41 }
42 }
43
44 Mysqlx.Error {
45 severity: ERROR
46 code: 5116
47 msg: "Document contains a field value that is not unique but required to be"
48 sql_state: "HY000"
49 }
50
51 Mysqlx.Ok {
52 msg: "bye!"
53 }
54 ok