Add simple tests and meson build. Maxim Orlov <m.orlov@postgrespro.ru>

[online_analyze.git] / sql / online_analyze.sql

diff --git a/sql/online_analyze.sql b/sql/online_analyze.sql
new file mode 100644 (file)
index 0000000..760eaca
--- /dev/null
+++ b/sql/online_analyze.sql
@@ -0,0 +1,21 @@
+LOAD 'online_analyze';
+
+SET online_analyze.enable = on;
+SET "online_analyze.verbose" = on;
+SET online_analyze.table_type = "all";
+
+SHOW online_analyze.enable;
+SHOW "online_analyze.verbose";
+SHOW online_analyze.table_type;
+
+CREATE TABLE oa_tbl(
+       foo int,
+       bar text
+);
+SHOW online_analyze.exclude_tables;
+SET online_analyze.exclude_tables = "oa_tbl";
+SHOW online_analyze.exclude_tables;
+DROP TABLE oa_tbl;
+SHOW online_analyze.exclude_tables;
+
+SET online_analyze.enable = off;