Add simple tests and meson build. Maxim Orlov <m.orlov@postgrespro.ru>
[online_analyze.git] / expected / online_analyze.out
diff --git a/expected/online_analyze.out b/expected/online_analyze.out
new file mode 100644 (file)
index 0000000..ddc7bcb
--- /dev/null
@@ -0,0 +1,47 @@
+LOAD 'online_analyze';
+SET online_analyze.enable = on;
+SET "online_analyze.verbose" = on;
+SET online_analyze.table_type = "all";
+SHOW online_analyze.enable;
+ online_analyze.enable 
+-----------------------
+ on
+(1 row)
+
+SHOW "online_analyze.verbose";
+ online_analyze.verbose 
+------------------------
+ on
+(1 row)
+
+SHOW online_analyze.table_type;
+ online_analyze.table_type 
+---------------------------
+ all
+(1 row)
+
+CREATE TABLE oa_tbl(
+       foo int,
+       bar text
+);
+SHOW online_analyze.exclude_tables;
+ online_analyze.exclude_tables 
+-------------------------------
+(1 row)
+
+SET online_analyze.exclude_tables = "oa_tbl";
+SHOW online_analyze.exclude_tables;
+ online_analyze.exclude_tables 
+-------------------------------
+ public.oa_tbl
+(1 row)
+
+DROP TABLE oa_tbl;
+SHOW online_analyze.exclude_tables;
+ online_analyze.exclude_tables 
+-------------------------------
+(1 row)
+
+SET online_analyze.enable = off;