/dports/databases/percona-toolkit/percona-toolkit-3.3.0/sandbox/servers/5.6/sys/mysql-test/suite/sysschema/r/ |
H A D | fn_ps_thread_trx_info.result | 29 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 D | fn_ps_thread_trx_info.result | 29 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 D | fn_ps_thread_trx_info.result | 29 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 D | fn_ps_thread_trx_info.result | 29 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 D | fn_ps_thread_trx_info.result | 29 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 D | fn_ps_thread_trx_info.result | 29 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 D | fn_ps_thread_trx_info.result | 29 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 D | fn_ps_thread_trx_info.result | 29 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 D | fn_ps_thread_trx_info.result | 30 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 D | fn_ps_thread_trx_info.test | 51 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 D | fn_ps_thread_trx_info.test | 51 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 D | fn_ps_thread_trx_info.test | 51 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 D | fn_ps_thread_trx_info.test | 51 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 D | fn_ps_thread_trx_info.test | 51 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 D | fn_ps_thread_trx_info.test | 51 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 D | fn_ps_thread_trx_info.test | 51 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 D | fn_ps_thread_trx_info.test | 51 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 D | fn_ps_thread_trx_info.test | 60 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 D | binlog_multi_valued_index.result | 6 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 D | rpl_multi_valued_index_debug.test | 23 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 D | binlog_multi_valued_index.test | 39 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 D | rpl_multi_valued_index_debug.result | 22 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 D | gr_json_array_unique_key_conflict.test | 53 --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 D | json_no_table.result | 2668 # 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 D | json_no_table.result | 2668 # 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 …]
|