THREAD_ID
bigint
= > >= < <= != LIKE LIKE %...% NOT LIKE IN (...) NOT IN (...) BETWEEN NOT BETWEEN IS NULL IS NOT NULL
EVENT_ID
bigint
= > >= < <= != LIKE LIKE %...% NOT LIKE IN (...) NOT IN (...) BETWEEN NOT BETWEEN IS NULL IS NOT NULL
END_EVENT_ID
bigint
= > >= < <= != LIKE LIKE %...% NOT LIKE IN (...) NOT IN (...) BETWEEN NOT BETWEEN IS NULL IS NOT NULL
EVENT_NAME
varchar(128)
utf8mb4_0900_ai_ci
LIKE LIKE %...% NOT LIKE = != REGEXP REGEXP ^...$ NOT REGEXP = '' != '' IN (...) NOT IN (...) BETWEEN NOT BETWEEN IS NULL IS NOT NULL
STATE
enum('ACTIVE', 'COMMITTED', 'ROLLED BACK')
utf8mb4_0900_ai_ci
= != IS NULL IS NOT NULL
ACTIVE
COMMITTED
ROLLED BACK
TRX_ID
bigint
= > >= < <= != LIKE LIKE %...% NOT LIKE IN (...) NOT IN (...) BETWEEN NOT BETWEEN IS NULL IS NOT NULL
GTID
varchar(64)
utf8mb4_0900_ai_ci
LIKE LIKE %...% NOT LIKE = != REGEXP REGEXP ^...$ NOT REGEXP = '' != '' IN (...) NOT IN (...) BETWEEN NOT BETWEEN IS NULL IS NOT NULL
XID_FORMAT_ID
int
= > >= < <= != LIKE LIKE %...% NOT LIKE IN (...) NOT IN (...) BETWEEN NOT BETWEEN IS NULL IS NOT NULL
XID_GTRID
varchar(130)
utf8mb4_0900_ai_ci
LIKE LIKE %...% NOT LIKE = != REGEXP REGEXP ^...$ NOT REGEXP = '' != '' IN (...) NOT IN (...) BETWEEN NOT BETWEEN IS NULL IS NOT NULL
XID_BQUAL
varchar(130)
utf8mb4_0900_ai_ci
LIKE LIKE %...% NOT LIKE = != REGEXP REGEXP ^...$ NOT REGEXP = '' != '' IN (...) NOT IN (...) BETWEEN NOT BETWEEN IS NULL IS NOT NULL
XA_STATE
varchar(64)
utf8mb4_0900_ai_ci
LIKE LIKE %...% NOT LIKE = != REGEXP REGEXP ^...$ NOT REGEXP = '' != '' IN (...) NOT IN (...) BETWEEN NOT BETWEEN IS NULL IS NOT NULL
SOURCE
varchar(64)
utf8mb4_0900_ai_ci
LIKE LIKE %...% NOT LIKE = != REGEXP REGEXP ^...$ NOT REGEXP = '' != '' IN (...) NOT IN (...) BETWEEN NOT BETWEEN IS NULL IS NOT NULL
TIMER_START
bigint
= > >= < <= != LIKE LIKE %...% NOT LIKE IN (...) NOT IN (...) BETWEEN NOT BETWEEN IS NULL IS NOT NULL
TIMER_END
bigint
= > >= < <= != LIKE LIKE %...% NOT LIKE IN (...) NOT IN (...) BETWEEN NOT BETWEEN IS NULL IS NOT NULL
TIMER_WAIT
bigint
= > >= < <= != LIKE LIKE %...% NOT LIKE IN (...) NOT IN (...) BETWEEN NOT BETWEEN IS NULL IS NOT NULL
ACCESS_MODE
enum('READ ONLY', 'READ WRITE')
utf8mb4_0900_ai_ci
= != IS NULL IS NOT NULL
READ ONLY
READ WRITE
ISOLATION_LEVEL
varchar(64)
utf8mb4_0900_ai_ci
LIKE LIKE %...% NOT LIKE = != REGEXP REGEXP ^...$ NOT REGEXP = '' != '' IN (...) NOT IN (...) BETWEEN NOT BETWEEN IS NULL IS NOT NULL
AUTOCOMMIT
enum('YES', 'NO')
utf8mb4_0900_ai_ci
= != IS NULL IS NOT NULL
YES
NO
NUMBER_OF_SAVEPOINTS
bigint
= > >= < <= != LIKE LIKE %...% NOT LIKE IN (...) NOT IN (...) BETWEEN NOT BETWEEN IS NULL IS NOT NULL
NUMBER_OF_ROLLBACK_TO_SAVEPOINT
bigint
= > >= < <= != LIKE LIKE %...% NOT LIKE IN (...) NOT IN (...) BETWEEN NOT BETWEEN IS NULL IS NOT NULL
NUMBER_OF_RELEASE_SAVEPOINT
bigint
= > >= < <= != LIKE LIKE %...% NOT LIKE IN (...) NOT IN (...) BETWEEN NOT BETWEEN IS NULL IS NOT NULL
OBJECT_INSTANCE_BEGIN
bigint
= > >= < <= != LIKE LIKE %...% NOT LIKE IN (...) NOT IN (...) BETWEEN NOT BETWEEN IS NULL IS NOT NULL
NESTING_EVENT_ID
bigint
= > >= < <= != LIKE LIKE %...% NOT LIKE IN (...) NOT IN (...) BETWEEN NOT BETWEEN IS NULL IS NOT NULL
NESTING_EVENT_TYPE
enum('TRANSACTION', 'STATEMENT', 'STAGE', 'WAIT')
utf8mb4_0900_ai_ci
= != IS NULL IS NOT NULL
TRANSACTION
STATEMENT
STAGE
WAIT
