\set ECHO queries
set enable_risky_query_detection=on;
--clean
drop schema public cascade;
\! @abs_srcdir@/script/find_risky_query_event.sh "Risky query schema change (DDL)" "drop schema public cascade;" "@abs_srcdir@/tmp_check/@datanode1@/pg_log"
\echo

create schema public;
\! @abs_srcdir@/script/find_risky_query_event.sh "Risky query schema change (DDL)" "create schema public;" "@abs_srcdir@/tmp_check/@datanode1@/pg_log"
\echo

--craete objects
create table employees
(
	id serial,
	last_name varchar(20),
	email varchar(20),
	salary int,
	job_id int,
	department_id int
);
\! @abs_srcdir@/script/find_risky_query_event.sh "Risky query schema change (DDL)" "create table employees" "@abs_srcdir@/tmp_check/@datanode1@/pg_log"
\echo

create table salary_range
(
	id serial,
	job_name varchar(20),
	min_sal int,
	max_sal int
);
\! @abs_srcdir@/script/find_risky_query_event.sh "Risky query schema change (DDL)" "create table salary_range" "@abs_srcdir@/tmp_check/@datanode1@/pg_log"
\echo

CREATE INDEX IF NOT EXISTS ON employees(department_id);
\! @abs_srcdir@/script/find_risky_query_event.sh "Risky query schema change (DDL)" "CREATE INDEX IF NOT EXISTS ON employees(department_id);" "@abs_srcdir@/tmp_check/@datanode1@/pg_log"
\echo

CREATE INDEX IF NOT EXISTS ON employees USING HASH (last_name);
\! @abs_srcdir@/script/find_risky_query_event.sh "Risky query schema change (DDL)" "CREATE INDEX IF NOT EXISTS ON employees USING HASH (last_name);" "@abs_srcdir@/tmp_check/@datanode1@/pg_log"
\echo

ALTER TABLE employees ADD COLUMN hire_date DATE;
\! @abs_srcdir@/script/find_risky_query_event.sh "Risky query schema change (DDL)" "ALTER TABLE employees ADD COLUMN hire_date DATE;" "@abs_srcdir@/tmp_check/@datanode1@/pg_log"
\echo

ALTER TABLE employees RENAME COLUMN last_name TO surname;
\! @abs_srcdir@/script/find_risky_query_event.sh "Risky query schema change (DDL)" "ALTER TABLE employees RENAME COLUMN last_name TO surname;" "@abs_srcdir@/tmp_check/@datanode1@/pg_log"
\echo

ALTER TABLE employees ALTER COLUMN salary TYPE NUMERIC;
\! @abs_srcdir@/script/find_risky_query_event.sh "Risky query schema change (DDL)" "ALTER TABLE employees ALTER COLUMN salary TYPE NUMERIC;" "@abs_srcdir@/tmp_check/@datanode1@/pg_log"
\echo

ALTER TABLE employees DROP COLUMN job_id;
\! @abs_srcdir@/script/find_risky_query_event.sh "Risky query schema change (DDL)" "ALTER TABLE employees DROP COLUMN job_id;" "@abs_srcdir@/tmp_check/@datanode1@/pg_log"
\echo

ALTER TABLE employees ADD CONSTRAINT unique_email UNIQUE (email);
\! @abs_srcdir@/script/find_risky_query_event.sh "Risky query schema change (DDL)" "ALTER TABLE employees ADD CONSTRAINT unique_email UNIQUE (email);" "@abs_srcdir@/tmp_check/@datanode1@/pg_log"
\echo

TRUNCATE TABLE employees;
\! @abs_srcdir@/script/find_risky_query_event.sh "Risky query truncate operation" "TRUNCATE TABLE employees;" "@abs_srcdir@/tmp_check/@datanode1@/pg_log"
\echo

ALTER TABLE employees RENAME TO company_employees;
\! @abs_srcdir@/script/find_risky_query_event.sh "Risky query schema change (DDL)" "ALTER TABLE employees RENAME TO company_employees;" "@abs_srcdir@/tmp_check/@datanode1@/pg_log"
\echo

DROP TABLE company_employees;
\! @abs_srcdir@/script/find_risky_query_event.sh "Risky query schema change (DDL)" "DROP TABLE company_employees;" "@abs_srcdir@/tmp_check/@datanode1@/pg_log"
\echo

--clean
drop schema public cascade;
\! @abs_srcdir@/script/find_risky_query_event.sh "Risky query schema change (DDL)" "drop schema public cascade;" "@abs_srcdir@/tmp_check/@datanode1@/pg_log"
\echo

create schema public;
\! @abs_srcdir@/script/find_risky_query_event.sh "Risky query schema change (DDL)" "create schema public;" "@abs_srcdir@/tmp_check/@datanode1@/pg_log"

set enable_risky_query_detection=off;