mirror of
https://github.com/GreptimeTeam/greptimedb.git
synced 2026-10-16 17:02:33 +00:00
Lei, HUANGandWeny Xu
12b7ebe7d5
* test: backport request-level skip-WAL integration coverage Backport #9093 as the shared protocol and storage test harness prerequisite for bulk request WAL skipping. Signed-off-by: WenyXu <wenymedia@gmail.com> (cherry picked from commita673e084b2) Signed-off-by: Lei, HUANG <ratuthomm@gmail.com> * feat: backport request-level bulk WAL skipping Backport #9110 with its protocol update and Flight/Prometheus coverage. Keep the release branch's write dispatcher and partition-column retention, including the skip-WAL flag when retry routing rebuilds bulk requests. Signed-off-by: WenyXu <wenymedia@gmail.com> (cherry picked from commit737025760e) Signed-off-by: Lei, HUANG <ratuthomm@gmail.com> --------- Signed-off-by: Lei, HUANG <ratuthomm@gmail.com> Co-authored-by: Weny Xu <wenymedia@gmail.com>
119 lines
2.5 KiB
SQL
119 lines
2.5 KiB
SQL
CREATE TABLE session_skip_wal(host STRING, ts TIMESTAMP TIME INDEX);
|
|
|
|
-- MYSQL: SET persists across statements on the same connection.
|
|
-- SQLNESS PROTOCOL MYSQL
|
|
SET skip_wal = true;
|
|
|
|
-- Invalid SET must leave the enabled policy unchanged.
|
|
|
|
-- SQLNESS PROTOCOL MYSQL
|
|
SET skip_wal = 'invalid';
|
|
|
|
-- SQLNESS PROTOCOL MYSQL
|
|
SET skip_wal = 1;
|
|
|
|
-- SQLNESS PROTOCOL MYSQL
|
|
SET skip_wal = NULL;
|
|
|
|
-- SQLNESS PROTOCOL MYSQL
|
|
SET skip_wal = false, true;
|
|
|
|
-- SQLNESS PROTOCOL MYSQL
|
|
INSERT INTO session_skip_wal VALUES ('skipped', 1000);
|
|
|
|
-- SQLNESS PROTOCOL MYSQL
|
|
SELECT * FROM session_skip_wal ORDER BY ts;
|
|
|
|
-- SQLNESS ARG restart=true
|
|
-- SQLNESS PROTOCOL MYSQL
|
|
SELECT * FROM session_skip_wal ORDER BY ts;
|
|
|
|
-- SQLNESS PROTOCOL MYSQL
|
|
SET skip_wal = false;
|
|
|
|
-- SQLNESS PROTOCOL MYSQL
|
|
SET skip_wal = 'true';
|
|
|
|
-- SQLNESS PROTOCOL MYSQL
|
|
SET skip_wal = 'false';
|
|
|
|
-- SQLNESS PROTOCOL MYSQL
|
|
INSERT INTO session_skip_wal VALUES ('persisted', 2000);
|
|
|
|
-- SQLNESS PROTOCOL MYSQL
|
|
SELECT * FROM session_skip_wal ORDER BY ts;
|
|
|
|
-- SQLNESS ARG restart=true
|
|
-- SQLNESS PROTOCOL MYSQL
|
|
SELECT * FROM session_skip_wal ORDER BY ts;
|
|
|
|
TRUNCATE TABLE session_skip_wal;
|
|
|
|
-- POSTGRES: SET persists across statements on the same connection.
|
|
-- SQLNESS PROTOCOL POSTGRES
|
|
SET skip_wal = true;
|
|
|
|
-- Invalid SET must leave the enabled policy unchanged.
|
|
|
|
-- SQLNESS PROTOCOL POSTGRES
|
|
SET skip_wal = 'invalid';
|
|
|
|
-- SQLNESS PROTOCOL POSTGRES
|
|
SET skip_wal = 1;
|
|
|
|
-- SQLNESS PROTOCOL POSTGRES
|
|
SET skip_wal = NULL;
|
|
|
|
-- SQLNESS PROTOCOL POSTGRES
|
|
SET skip_wal = false, true;
|
|
|
|
-- SQLNESS PROTOCOL POSTGRES
|
|
INSERT INTO session_skip_wal VALUES ('skipped', 1000);
|
|
|
|
-- SQLNESS PROTOCOL POSTGRES
|
|
SELECT * FROM session_skip_wal ORDER BY ts;
|
|
|
|
-- SQLNESS ARG restart=true
|
|
-- SQLNESS PROTOCOL POSTGRES
|
|
SELECT * FROM session_skip_wal ORDER BY ts;
|
|
|
|
-- SQLNESS PROTOCOL POSTGRES
|
|
SET skip_wal = false;
|
|
|
|
-- SQLNESS PROTOCOL POSTGRES
|
|
SET skip_wal = 'true';
|
|
|
|
-- SQLNESS PROTOCOL POSTGRES
|
|
SET skip_wal = 'false';
|
|
|
|
-- SQLNESS PROTOCOL POSTGRES
|
|
INSERT INTO session_skip_wal VALUES ('persisted', 2000);
|
|
|
|
-- SQLNESS PROTOCOL POSTGRES
|
|
SELECT * FROM session_skip_wal ORDER BY ts;
|
|
|
|
-- SQLNESS ARG restart=true
|
|
-- SQLNESS PROTOCOL POSTGRES
|
|
SELECT * FROM session_skip_wal ORDER BY ts;
|
|
|
|
TRUNCATE TABLE session_skip_wal;
|
|
|
|
DROP TABLE session_skip_wal;
|
|
|
|
-- The default gRPC protocol has request-scoped contexts, not a persistent SQL session.
|
|
SET skip_wal = true;
|
|
|
|
SET skip_wal = false;
|
|
|
|
SET skip_wal = 'true';
|
|
|
|
SET skip_wal = 'false';
|
|
|
|
SET skip_wal = 'invalid';
|
|
|
|
SET skip_wal = 1;
|
|
|
|
SET skip_wal = NULL;
|
|
|
|
SET skip_wal = false, true;
|