Home
last modified time | relevance | path

Searched refs:JSON_CONTAINS (Results 1 – 25 of 148) sorted by relevance

123456

/dports/databases/percona-toolkit/percona-toolkit-3.3.0/sandbox/servers/5.6/sys/mysql-test/suite/sysschema/r/
H A Dfn_ps_thread_trx_info.result29 SELECT JSON_CONTAINS(@json_doc, '"COMMITTED"', '$[0].state');
30 JSON_CONTAINS(@json_doc, '"COMMITTED"', '$[0].state')
32 SELECT JSON_CONTAINS(@json_doc, '"READ WRITE"', '$[0].mode');
33 JSON_CONTAINS(@json_doc, '"READ WRITE"', '$[0].mode')
35 SELECT JSON_CONTAINS(@json_doc, '"NO"', '$[0].autocommitted');
36 JSON_CONTAINS(@json_doc, '"NO"', '$[0].autocommitted')
38 SELECT JSON_CONTAINS(@json_doc, '"AUTOMATIC"', '$[0].gtid');
39 JSON_CONTAINS(@json_doc, '"AUTOMATIC"', '$[0].gtid')
41 SELECT JSON_CONTAINS(@json_doc, '"REPEATABLE READ"', '$[0].isolation');
42 JSON_CONTAINS(@json_doc, '"REPEATABLE READ"', '$[0].isolation')
[all …]
/dports/databases/percona-toolkit/percona-toolkit-3.3.0/sandbox/servers/5.7/sys/mysql-test/suite/sysschema/r/
H A Dfn_ps_thread_trx_info.result29 SELECT JSON_CONTAINS(@json_doc, '"COMMITTED"', '$[0].state');
30 JSON_CONTAINS(@json_doc, '"COMMITTED"', '$[0].state')
32 SELECT JSON_CONTAINS(@json_doc, '"READ WRITE"', '$[0].mode');
33 JSON_CONTAINS(@json_doc, '"READ WRITE"', '$[0].mode')
35 SELECT JSON_CONTAINS(@json_doc, '"NO"', '$[0].autocommitted');
36 JSON_CONTAINS(@json_doc, '"NO"', '$[0].autocommitted')
38 SELECT JSON_CONTAINS(@json_doc, '"AUTOMATIC"', '$[0].gtid');
39 JSON_CONTAINS(@json_doc, '"AUTOMATIC"', '$[0].gtid')
41 SELECT JSON_CONTAINS(@json_doc, '"REPEATABLE READ"', '$[0].isolation');
42 JSON_CONTAINS(@json_doc, '"REPEATABLE READ"', '$[0].isolation')
[all …]
/dports/databases/percona57-server/percona-server-5.7.36-39/mysql-test/suite/sysschema/r/
H A Dfn_ps_thread_trx_info.result29 SELECT JSON_CONTAINS(@json_doc, '"COMMITTED"', '$[0].state');
30 JSON_CONTAINS(@json_doc, '"COMMITTED"', '$[0].state')
32 SELECT JSON_CONTAINS(@json_doc, '"READ WRITE"', '$[0].mode');
33 JSON_CONTAINS(@json_doc, '"READ WRITE"', '$[0].mode')
35 SELECT JSON_CONTAINS(@json_doc, '"NO"', '$[0].autocommitted');
36 JSON_CONTAINS(@json_doc, '"NO"', '$[0].autocommitted')
38 SELECT JSON_CONTAINS(@json_doc, '"AUTOMATIC"', '$[0].gtid');
39 JSON_CONTAINS(@json_doc, '"AUTOMATIC"', '$[0].gtid')
41 SELECT JSON_CONTAINS(@json_doc, '"REPEATABLE READ"', '$[0].isolation');
42 JSON_CONTAINS(@json_doc, '"REPEATABLE READ"', '$[0].isolation')
[all …]
/dports/databases/xtrabackup/percona-xtrabackup-2.4.21/mysql-test/suite/sysschema/r/
H A Dfn_ps_thread_trx_info.result29 SELECT JSON_CONTAINS(@json_doc, '"COMMITTED"', '$[0].state');
30 JSON_CONTAINS(@json_doc, '"COMMITTED"', '$[0].state')
32 SELECT JSON_CONTAINS(@json_doc, '"READ WRITE"', '$[0].mode');
33 JSON_CONTAINS(@json_doc, '"READ WRITE"', '$[0].mode')
35 SELECT JSON_CONTAINS(@json_doc, '"NO"', '$[0].autocommitted');
36 JSON_CONTAINS(@json_doc, '"NO"', '$[0].autocommitted')
38 SELECT JSON_CONTAINS(@json_doc, '"AUTOMATIC"', '$[0].gtid');
39 JSON_CONTAINS(@json_doc, '"AUTOMATIC"', '$[0].gtid')
41 SELECT JSON_CONTAINS(@json_doc, '"REPEATABLE READ"', '$[0].isolation');
42 JSON_CONTAINS(@json_doc, '"REPEATABLE READ"', '$[0].isolation')
[all …]
/dports/databases/mysqlwsrep57-server/mysql-wsrep-wsrep_5.7.35-25.27/mysql-test/suite/sysschema/r/
H A Dfn_ps_thread_trx_info.result29 SELECT JSON_CONTAINS(@json_doc, '"COMMITTED"', '$[0].state');
30 JSON_CONTAINS(@json_doc, '"COMMITTED"', '$[0].state')
32 SELECT JSON_CONTAINS(@json_doc, '"READ WRITE"', '$[0].mode');
33 JSON_CONTAINS(@json_doc, '"READ WRITE"', '$[0].mode')
35 SELECT JSON_CONTAINS(@json_doc, '"NO"', '$[0].autocommitted');
36 JSON_CONTAINS(@json_doc, '"NO"', '$[0].autocommitted')
38 SELECT JSON_CONTAINS(@json_doc, '"AUTOMATIC"', '$[0].gtid');
39 JSON_CONTAINS(@json_doc, '"AUTOMATIC"', '$[0].gtid')
41 SELECT JSON_CONTAINS(@json_doc, '"REPEATABLE READ"', '$[0].isolation');
42 JSON_CONTAINS(@json_doc, '"REPEATABLE READ"', '$[0].isolation')
[all …]
/dports/databases/percona57-pam-for-mysql/percona-server-5.7.36-39/mysql-test/suite/sysschema/r/
H A Dfn_ps_thread_trx_info.result29 SELECT JSON_CONTAINS(@json_doc, '"COMMITTED"', '$[0].state');
30 JSON_CONTAINS(@json_doc, '"COMMITTED"', '$[0].state')
32 SELECT JSON_CONTAINS(@json_doc, '"READ WRITE"', '$[0].mode');
33 JSON_CONTAINS(@json_doc, '"READ WRITE"', '$[0].mode')
35 SELECT JSON_CONTAINS(@json_doc, '"NO"', '$[0].autocommitted');
36 JSON_CONTAINS(@json_doc, '"NO"', '$[0].autocommitted')
38 SELECT JSON_CONTAINS(@json_doc, '"AUTOMATIC"', '$[0].gtid');
39 JSON_CONTAINS(@json_doc, '"AUTOMATIC"', '$[0].gtid')
41 SELECT JSON_CONTAINS(@json_doc, '"REPEATABLE READ"', '$[0].isolation');
42 JSON_CONTAINS(@json_doc, '"REPEATABLE READ"', '$[0].isolation')
[all …]
/dports/databases/percona57-client/percona-server-5.7.36-39/mysql-test/suite/sysschema/r/
H A Dfn_ps_thread_trx_info.result29 SELECT JSON_CONTAINS(@json_doc, '"COMMITTED"', '$[0].state');
30 JSON_CONTAINS(@json_doc, '"COMMITTED"', '$[0].state')
32 SELECT JSON_CONTAINS(@json_doc, '"READ WRITE"', '$[0].mode');
33 JSON_CONTAINS(@json_doc, '"READ WRITE"', '$[0].mode')
35 SELECT JSON_CONTAINS(@json_doc, '"NO"', '$[0].autocommitted');
36 JSON_CONTAINS(@json_doc, '"NO"', '$[0].autocommitted')
38 SELECT JSON_CONTAINS(@json_doc, '"AUTOMATIC"', '$[0].gtid');
39 JSON_CONTAINS(@json_doc, '"AUTOMATIC"', '$[0].gtid')
41 SELECT JSON_CONTAINS(@json_doc, '"REPEATABLE READ"', '$[0].isolation');
42 JSON_CONTAINS(@json_doc, '"REPEATABLE READ"', '$[0].isolation')
[all …]
/dports/databases/mysql57-client/mysql-5.7.36/mysql-test/suite/sysschema/r/
H A Dfn_ps_thread_trx_info.result29 SELECT JSON_CONTAINS(@json_doc, '"COMMITTED"', '$[0].state');
30 JSON_CONTAINS(@json_doc, '"COMMITTED"', '$[0].state')
32 SELECT JSON_CONTAINS(@json_doc, '"READ WRITE"', '$[0].mode');
33 JSON_CONTAINS(@json_doc, '"READ WRITE"', '$[0].mode')
35 SELECT JSON_CONTAINS(@json_doc, '"NO"', '$[0].autocommitted');
36 JSON_CONTAINS(@json_doc, '"NO"', '$[0].autocommitted')
38 SELECT JSON_CONTAINS(@json_doc, '"AUTOMATIC"', '$[0].gtid');
39 JSON_CONTAINS(@json_doc, '"AUTOMATIC"', '$[0].gtid')
41 SELECT JSON_CONTAINS(@json_doc, '"REPEATABLE READ"', '$[0].isolation');
42 JSON_CONTAINS(@json_doc, '"REPEATABLE READ"', '$[0].isolation')
[all …]
/dports/databases/xtrabackup8/percona-xtrabackup-8.0.14/mysql-test/suite/sysschema/r/
H A Dfn_ps_thread_trx_info.result30 SELECT JSON_CONTAINS(@json_doc, '"COMMITTED"', '$[0].state');
31 JSON_CONTAINS(@json_doc, '"COMMITTED"', '$[0].state')
33 SELECT JSON_CONTAINS(@json_doc, '"READ WRITE"', '$[0].mode');
34 JSON_CONTAINS(@json_doc, '"READ WRITE"', '$[0].mode')
36 SELECT JSON_CONTAINS(@json_doc, '"NO"', '$[0].autocommitted');
37 JSON_CONTAINS(@json_doc, '"NO"', '$[0].autocommitted')
42 SELECT JSON_CONTAINS(@json_doc, '"REPEATABLE READ"', '$[0].isolation');
43 JSON_CONTAINS(@json_doc, '"REPEATABLE READ"', '$[0].isolation')
55 JSON_CONTAINS(@json_doc, '"trx"', '$[0].statements_executed[0].sch…
78 SELECT JSON_CONTAINS(@json_doc, '"COMMIT"', '$[0].statements_executed[1].sql_text');
[all …]
/dports/databases/percona-toolkit/percona-toolkit-3.3.0/sandbox/servers/5.7/sys/mysql-test/suite/sysschema/t/
H A Dfn_ps_thread_trx_info.test51 SELECT JSON_CONTAINS(@json_doc, '"COMMITTED"', '$[0].state');
52 SELECT JSON_CONTAINS(@json_doc, '"READ WRITE"', '$[0].mode');
53 SELECT JSON_CONTAINS(@json_doc, '"NO"', '$[0].autocommitted');
54 SELECT JSON_CONTAINS(@json_doc, '"AUTOMATIC"', '$[0].gtid');
55 SELECT JSON_CONTAINS(@json_doc, '"REPEATABLE READ"', '$[0].isolation');
62 SELECT JSON_CONTAINS(@json_doc, '"INSERT INTO info VALUES (1, \'foo\')"', '$[0].statements_executed…
63 SELECT JSON_CONTAINS(@json_doc, '"trx"', '$[0].statements_executed…
66 SELECT JSON_CONTAINS(@json_doc, '0', '$[0].statements_executed…
67 SELECT JSON_CONTAINS(@json_doc, '0', '$[0].statements_executed…
69 SELECT JSON_CONTAINS(@json_doc, '0', '$[0].statements_executed…
[all …]
/dports/databases/percona-toolkit/percona-toolkit-3.3.0/sandbox/servers/5.6/sys/mysql-test/suite/sysschema/t/
H A Dfn_ps_thread_trx_info.test51 SELECT JSON_CONTAINS(@json_doc, '"COMMITTED"', '$[0].state');
52 SELECT JSON_CONTAINS(@json_doc, '"READ WRITE"', '$[0].mode');
53 SELECT JSON_CONTAINS(@json_doc, '"NO"', '$[0].autocommitted');
54 SELECT JSON_CONTAINS(@json_doc, '"AUTOMATIC"', '$[0].gtid');
55 SELECT JSON_CONTAINS(@json_doc, '"REPEATABLE READ"', '$[0].isolation');
62 SELECT JSON_CONTAINS(@json_doc, '"INSERT INTO info VALUES (1, \'foo\')"', '$[0].statements_executed…
63 SELECT JSON_CONTAINS(@json_doc, '"trx"', '$[0].statements_executed…
66 SELECT JSON_CONTAINS(@json_doc, '0', '$[0].statements_executed…
67 SELECT JSON_CONTAINS(@json_doc, '0', '$[0].statements_executed…
69 SELECT JSON_CONTAINS(@json_doc, '0', '$[0].statements_executed…
[all …]
/dports/databases/percona57-server/percona-server-5.7.36-39/mysql-test/suite/sysschema/t/
H A Dfn_ps_thread_trx_info.test51 SELECT JSON_CONTAINS(@json_doc, '"COMMITTED"', '$[0].state');
52 SELECT JSON_CONTAINS(@json_doc, '"READ WRITE"', '$[0].mode');
53 SELECT JSON_CONTAINS(@json_doc, '"NO"', '$[0].autocommitted');
54 SELECT JSON_CONTAINS(@json_doc, '"AUTOMATIC"', '$[0].gtid');
55 SELECT JSON_CONTAINS(@json_doc, '"REPEATABLE READ"', '$[0].isolation');
62 SELECT JSON_CONTAINS(@json_doc, '"INSERT INTO info VALUES (1, \'foo\')"', '$[0].statements_executed…
63 SELECT JSON_CONTAINS(@json_doc, '"trx"', '$[0].statements_executed…
66 SELECT JSON_CONTAINS(@json_doc, '0', '$[0].statements_executed…
67 SELECT JSON_CONTAINS(@json_doc, '0', '$[0].statements_executed…
69 SELECT JSON_CONTAINS(@json_doc, '0', '$[0].statements_executed…
[all …]
/dports/databases/xtrabackup/percona-xtrabackup-2.4.21/mysql-test/suite/sysschema/t/
H A Dfn_ps_thread_trx_info.test51 SELECT JSON_CONTAINS(@json_doc, '"COMMITTED"', '$[0].state');
52 SELECT JSON_CONTAINS(@json_doc, '"READ WRITE"', '$[0].mode');
53 SELECT JSON_CONTAINS(@json_doc, '"NO"', '$[0].autocommitted');
54 SELECT JSON_CONTAINS(@json_doc, '"AUTOMATIC"', '$[0].gtid');
55 SELECT JSON_CONTAINS(@json_doc, '"REPEATABLE READ"', '$[0].isolation');
62 SELECT JSON_CONTAINS(@json_doc, '"INSERT INTO info VALUES (1, \'foo\')"', '$[0].statements_executed…
63 SELECT JSON_CONTAINS(@json_doc, '"trx"', '$[0].statements_executed…
66 SELECT JSON_CONTAINS(@json_doc, '0', '$[0].statements_executed…
67 SELECT JSON_CONTAINS(@json_doc, '0', '$[0].statements_executed…
69 SELECT JSON_CONTAINS(@json_doc, '0', '$[0].statements_executed…
[all …]
/dports/databases/percona57-pam-for-mysql/percona-server-5.7.36-39/mysql-test/suite/sysschema/t/
H A Dfn_ps_thread_trx_info.test51 SELECT JSON_CONTAINS(@json_doc, '"COMMITTED"', '$[0].state');
52 SELECT JSON_CONTAINS(@json_doc, '"READ WRITE"', '$[0].mode');
53 SELECT JSON_CONTAINS(@json_doc, '"NO"', '$[0].autocommitted');
54 SELECT JSON_CONTAINS(@json_doc, '"AUTOMATIC"', '$[0].gtid');
55 SELECT JSON_CONTAINS(@json_doc, '"REPEATABLE READ"', '$[0].isolation');
62 SELECT JSON_CONTAINS(@json_doc, '"INSERT INTO info VALUES (1, \'foo\')"', '$[0].statements_executed…
63 SELECT JSON_CONTAINS(@json_doc, '"trx"', '$[0].statements_executed…
66 SELECT JSON_CONTAINS(@json_doc, '0', '$[0].statements_executed…
67 SELECT JSON_CONTAINS(@json_doc, '0', '$[0].statements_executed…
69 SELECT JSON_CONTAINS(@json_doc, '0', '$[0].statements_executed…
[all …]
/dports/databases/mysqlwsrep57-server/mysql-wsrep-wsrep_5.7.35-25.27/mysql-test/suite/sysschema/t/
H A Dfn_ps_thread_trx_info.test51 SELECT JSON_CONTAINS(@json_doc, '"COMMITTED"', '$[0].state');
52 SELECT JSON_CONTAINS(@json_doc, '"READ WRITE"', '$[0].mode');
53 SELECT JSON_CONTAINS(@json_doc, '"NO"', '$[0].autocommitted');
54 SELECT JSON_CONTAINS(@json_doc, '"AUTOMATIC"', '$[0].gtid');
55 SELECT JSON_CONTAINS(@json_doc, '"REPEATABLE READ"', '$[0].isolation');
62 SELECT JSON_CONTAINS(@json_doc, '"INSERT INTO info VALUES (1, \'foo\')"', '$[0].statements_executed…
63 SELECT JSON_CONTAINS(@json_doc, '"trx"', '$[0].statements_executed…
66 SELECT JSON_CONTAINS(@json_doc, '0', '$[0].statements_executed…
67 SELECT JSON_CONTAINS(@json_doc, '0', '$[0].statements_executed…
69 SELECT JSON_CONTAINS(@json_doc, '0', '$[0].statements_executed…
[all …]
/dports/databases/percona57-client/percona-server-5.7.36-39/mysql-test/suite/sysschema/t/
H A Dfn_ps_thread_trx_info.test51 SELECT JSON_CONTAINS(@json_doc, '"COMMITTED"', '$[0].state');
52 SELECT JSON_CONTAINS(@json_doc, '"READ WRITE"', '$[0].mode');
53 SELECT JSON_CONTAINS(@json_doc, '"NO"', '$[0].autocommitted');
54 SELECT JSON_CONTAINS(@json_doc, '"AUTOMATIC"', '$[0].gtid');
55 SELECT JSON_CONTAINS(@json_doc, '"REPEATABLE READ"', '$[0].isolation');
62 SELECT JSON_CONTAINS(@json_doc, '"INSERT INTO info VALUES (1, \'foo\')"', '$[0].statements_executed…
63 SELECT JSON_CONTAINS(@json_doc, '"trx"', '$[0].statements_executed…
66 SELECT JSON_CONTAINS(@json_doc, '0', '$[0].statements_executed…
67 SELECT JSON_CONTAINS(@json_doc, '0', '$[0].statements_executed…
69 SELECT JSON_CONTAINS(@json_doc, '0', '$[0].statements_executed…
[all …]
/dports/databases/mysql57-client/mysql-5.7.36/mysql-test/suite/sysschema/t/
H A Dfn_ps_thread_trx_info.test51 SELECT JSON_CONTAINS(@json_doc, '"COMMITTED"', '$[0].state');
52 SELECT JSON_CONTAINS(@json_doc, '"READ WRITE"', '$[0].mode');
53 SELECT JSON_CONTAINS(@json_doc, '"NO"', '$[0].autocommitted');
54 SELECT JSON_CONTAINS(@json_doc, '"AUTOMATIC"', '$[0].gtid');
55 SELECT JSON_CONTAINS(@json_doc, '"REPEATABLE READ"', '$[0].isolation');
62 SELECT JSON_CONTAINS(@json_doc, '"INSERT INTO info VALUES (1, \'foo\')"', '$[0].statements_executed…
63 SELECT JSON_CONTAINS(@json_doc, '"trx"', '$[0].statements_executed…
66 SELECT JSON_CONTAINS(@json_doc, '0', '$[0].statements_executed…
67 SELECT JSON_CONTAINS(@json_doc, '0', '$[0].statements_executed…
69 SELECT JSON_CONTAINS(@json_doc, '0', '$[0].statements_executed…
[all …]
/dports/databases/xtrabackup8/percona-xtrabackup-8.0.14/mysql-test/suite/sysschema/t/
H A Dfn_ps_thread_trx_info.test60 SELECT JSON_CONTAINS(@json_doc, '"COMMITTED"', '$[0].state');
61 SELECT JSON_CONTAINS(@json_doc, '"READ WRITE"', '$[0].mode');
62 SELECT JSON_CONTAINS(@json_doc, '"NO"', '$[0].autocommitted');
69 SELECT JSON_CONTAINS(@json_doc, '"REPEATABLE READ"', '$[0].isolation');
76 SELECT JSON_CONTAINS(@json_doc, '"INSERT INTO info VALUES (1, \'foo\')"', '$[0].statements_executed…
77 SELECT JSON_CONTAINS(@json_doc, '"trx"', '$[0].statements_executed…
78 SELECT JSON_CONTAINS(@json_doc, '0', '$[0].statements_executed…
80 SELECT JSON_CONTAINS(@json_doc, '0', '$[0].statements_executed…
81 SELECT JSON_CONTAINS(@json_doc, '0', '$[0].statements_executed…
83 SELECT JSON_CONTAINS(@json_doc, '0', '$[0].statements_executed…
[all …]
/dports/databases/xtrabackup8/percona-xtrabackup-8.0.14/mysql-test/suite/binlog/r/
H A Dbinlog_multi_valued_index.result6 UPDATE t1 SET j = '[9,0]' WHERE JSON_CONTAINS(CAST(j AS JSON),'2');
9 UPDATE t1 SET j = '[11,12,13,14]' WHERE JSON_CONTAINS(CAST(j AS JSON),'10');
13 UPDATE t1 SET j = '[101,201,301,401]' WHERE JSON_CONTAINS(CAST(j AS JSON),'200');
80 UPDATE t1 SET j = '[2,9,10]' WHERE JSON_CONTAINS(CAST(j AS JSON),'2');
82 UPDATE t1 SET j = '[2,11,12]' WHERE JSON_CONTAINS(CAST(j AS JSON),'2');
84 UPDATE t1 SET j = '[2,13,14]' WHERE JSON_CONTAINS(CAST(j AS JSON),'2');
/dports/databases/xtrabackup8/percona-xtrabackup-8.0.14/mysql-test/suite/rpl/t/
H A Drpl_multi_valued_index_debug.test23 UPDATE t1 SET j = '[2,9,10]' WHERE JSON_CONTAINS(CAST(j AS JSON),'2');
28 DELETE FROM t1 WHERE JSON_CONTAINS(CAST(j AS JSON),'2');
40 UPDATE t1 SET j = '[2,9,10]' WHERE JSON_CONTAINS(CAST(j AS JSON),'2');
45 DELETE FROM t1 WHERE JSON_CONTAINS(CAST(j AS JSON),'2');
57 UPDATE t1 SET j = '[2,9,10]' WHERE JSON_CONTAINS(CAST(j AS JSON),'2');
62 DELETE FROM t1 WHERE JSON_CONTAINS(CAST(j AS JSON),'2');
74 UPDATE t1 SET j = '[2,9,10]' WHERE JSON_CONTAINS(CAST(j AS JSON),'2');
79 DELETE FROM t1 WHERE JSON_CONTAINS(CAST(j AS JSON),'2');
/dports/databases/xtrabackup8/percona-xtrabackup-8.0.14/mysql-test/suite/binlog/t/
H A Dbinlog_multi_valued_index.test39 UPDATE t1 SET j = '[9,0]' WHERE JSON_CONTAINS(CAST(j AS JSON),'2');
42 UPDATE t1 SET j = '[11,12,13,14]' WHERE JSON_CONTAINS(CAST(j AS JSON),'10');
46 UPDATE t1 SET j = '[101,201,301,401]' WHERE JSON_CONTAINS(CAST(j AS JSON),'200');
61 UPDATE t1 SET j = '[2,9,10]' WHERE JSON_CONTAINS(CAST(j AS JSON),'2');
64 UPDATE t1 SET j = '[2,11,12]' WHERE JSON_CONTAINS(CAST(j AS JSON),'2');
67 UPDATE t1 SET j = '[2,13,14]' WHERE JSON_CONTAINS(CAST(j AS JSON),'2');
/dports/databases/xtrabackup8/percona-xtrabackup-8.0.14/mysql-test/suite/rpl/r/
H A Drpl_multi_valued_index_debug.result22 UPDATE t1 SET j = '[2,9,10]' WHERE JSON_CONTAINS(CAST(j AS JSON),'2');
29 DELETE FROM t1 WHERE JSON_CONTAINS(CAST(j AS JSON),'2');
42 UPDATE t1 SET j = '[2,9,10]' WHERE JSON_CONTAINS(CAST(j AS JSON),'2');
49 DELETE FROM t1 WHERE JSON_CONTAINS(CAST(j AS JSON),'2');
62 UPDATE t1 SET j = '[2,9,10]' WHERE JSON_CONTAINS(CAST(j AS JSON),'2');
69 DELETE FROM t1 WHERE JSON_CONTAINS(CAST(j AS JSON),'2');
82 UPDATE t1 SET j = '[2,9,10]' WHERE JSON_CONTAINS(CAST(j AS JSON),'2');
89 DELETE FROM t1 WHERE JSON_CONTAINS(CAST(j AS JSON),'2');
/dports/databases/xtrabackup8/percona-xtrabackup-8.0.14/mysql-test/suite/group_replication/t/
H A Dgr_json_array_unique_key_conflict.test53 --let $local_transaction= UPDATE t1 SET data = '[6,7,8]' WHERE JSON_CONTAINS(CAST(data AS JSON),'1')
54 --let $remote_transaction=UPDATE t1 SET data = '[3,4,5]' WHERE JSON_CONTAINS(CAST(data AS JSON),'1')
77 --let $local_transaction= UPDATE t1 SET data = '[10,11]' WHERE JSON_CONTAINS(CAST(data AS JSON),'10…
78 --let $remote_transaction=UPDATE t1 SET data = '[9]' WHERE JSON_CONTAINS(CAST(data AS JSON),'3')
/dports/databases/xtrabackup/percona-xtrabackup-2.4.21/mysql-test/suite/json/r/
H A Djson_no_table.result2668 # Test of JSON_CONTAINS
2774 SELECT JSON_CONTAINS
2779 JSON_CONTAINS
2785 SELECT JSON_CONTAINS
2790 JSON_CONTAINS
2796 SELECT JSON_CONTAINS
2801 JSON_CONTAINS
2807 SELECT JSON_CONTAINS
2812 JSON_CONTAINS
2818 SELECT JSON_CONTAINS
[all …]
/dports/databases/percona57-pam-for-mysql/percona-server-5.7.36-39/mysql-test/suite/json/r/
H A Djson_no_table.result2668 # Test of JSON_CONTAINS
2774 SELECT JSON_CONTAINS
2779 JSON_CONTAINS
2785 SELECT JSON_CONTAINS
2790 JSON_CONTAINS
2796 SELECT JSON_CONTAINS
2801 JSON_CONTAINS
2807 SELECT JSON_CONTAINS
2812 JSON_CONTAINS
2818 SELECT JSON_CONTAINS
[all …]

123456