57 lines
2.6 KiB
Plaintext
57 lines
2.6 KiB
Plaintext
# TestFunctionEncodeSQLDigest
|
|
drop table if exists test_func_encode_sql_digest;
|
|
create table test_func_encode_sql_digest(id int primary key, v int);
|
|
select tidb_encode_sql_digest("begin");
|
|
select tidb_encode_sql_digest("select @@tidb_current_ts");
|
|
select tidb_encode_sql_digest("select id, v from test_func_decode_sql_digests where id = 1 for update");
|
|
select tidb_encode_sql_digest(null);
|
|
-- error 1582
|
|
select tidb_encode_sql_digest();
|
|
select (select tidb_encode_sql_digest('select 1')) = tidb_encode_sql_digest('select 1;');
|
|
select (select tidb_encode_sql_digest('select 1')) = tidb_encode_sql_digest('select 1 ;');
|
|
select (select tidb_encode_sql_digest('select 1')) = tidb_encode_sql_digest('select 2 ;');
|
|
|
|
# TestFunctionDecodeSQLDigestsPrivilege
|
|
drop user if exists 'testuser'@'localhost';
|
|
create user 'testuser'@'localhost';
|
|
|
|
connect (conn1, localhost, testuser,,);
|
|
connection conn1;
|
|
-- error 1227
|
|
select tidb_decode_sql_digests('["aa"]');
|
|
connection default;
|
|
|
|
grant process on *.* to 'testuser'@'localhost';
|
|
connection conn1;
|
|
select tidb_decode_sql_digests('["aa"]');
|
|
connection default;
|
|
disconnect conn1;
|
|
drop user 'testuser'@'localhost';
|
|
|
|
# TestFunctionDecodeSQLDigests
|
|
set global tidb_enable_stmt_summary = 1;
|
|
select @@global.tidb_enable_stmt_summary;
|
|
drop table if exists test_func_decode_sql_digests;
|
|
create table test_func_decode_sql_digests(id int primary key, v int);
|
|
begin;
|
|
--disable_result_log
|
|
select @@tidb_current_ts;
|
|
--enable_result_log
|
|
select id, v from test_func_decode_sql_digests where id = 1 for update;
|
|
rollback;
|
|
select tidb_decode_sql_digests('["e6f07d43b5c21db0fbb9a31feac2dc599787763393dd5acbfad80e247eb02ad5","58f3717da2d79c14773a1e3094aaddeff2b11747d3aef95741151af9acba9d44","7e9f826ed22a09940940a42d1aca47a75b3adc3c3fde252f4b912ac886194eb9"]', 0);
|
|
select tidb_decode_sql_digests('["e6f07d43b5c21db0fbb9a31feac2dc599787763393dd5acbfad80e247eb02ad5","58f3717da2d79c14773a1e3094aaddeff2b11747d3aef95741151af9acba9d44","7e9f826ed22a09940940a42d1aca47a75b3adc3c3fde252f4b912ac886194eb9"]', 24);
|
|
select tidb_decode_sql_digests('[]');
|
|
select tidb_decode_sql_digests(null);
|
|
select tidb_decode_sql_digests('["e6f07d43b5c21db0fbb9a31feac2dc599787763393dd5acbfad80e247eb02ad5",1,null,"58f3717da2d79c14773a1e3094aaddeff2b11747d3aef95741151af9acba9d44",{"a":1},[2],"7e9f826ed22a09940940a42d1aca47a75b3adc3c3fde252f4b912ac886194eb9","","abcde"]');
|
|
select tidb_decode_sql_digests('{"a":1}');
|
|
show warnings;
|
|
select tidb_decode_sql_digests('aabbccdd');
|
|
show warnings;
|
|
-- error 1582
|
|
select tidb_decode_sql_digests('a', 1, 2);
|
|
-- error 1582
|
|
select tidb_decode_sql_digests();
|
|
set global tidb_enable_stmt_summary = default;
|
|
|