fix test - reduce warnings

Vladimir Ershov · Vladimir Ershov · commit 6e38c0f31f55 · 2017-04-28T18:23:14.000+03:00
diff --git a/expected/sr_plan.out b/expected/sr_plan.out
@@ -34,19 +34,16 @@ SELECT * FROM test_table WHERE test_attr1 = 15;
 
 UPDATE sr_plans SET enable = true;
 SELECT * FROM test_table WHERE test_attr1 = _p(10);
-WARNING:  Ok we find saved plan.
  test_attr1 | test_attr2 
 ------------+------------
 (0 rows)
 
 SELECT * FROM test_table WHERE test_attr1 = _p(15);
-WARNING:  Ok we find saved plan.
  test_attr1 | test_attr2 
 ------------+------------
 (0 rows)
 
 SELECT * FROM test_table WHERE test_attr1 = 10;
-WARNING:  Ok we find saved plan.
  test_attr1 | test_attr2 
 ------------+------------
 (0 rows)
diff --git a/sr_plan--1.0.sql b/sr_plan--1.0.sql
@@ -14,7 +14,6 @@ CREATE TABLE sr_plans (
 
 CREATE INDEX sr_plans_query_hash_idx ON sr_plans (query_hash);
 --CREATE INDEX sr_plans_plan_hash_idx ON sr_plans (plan_hashs);
---create function _p(anyelement) returns anyelement as $$ select $1; $$ language sql VOLATILE;
 
 CREATE FUNCTION _p(anyelement)
 RETURNS anyelement
@@ -32,4 +31,4 @@ CREATE FUNCTION sr_plan_invalid_table() RETURNS event_trigger
 
 CREATE EVENT TRIGGER sr_plan_invalid_table ON sql_drop
 --	WHEN TAG IN ('DROP TABLE')
-    EXECUTE PROCEDURE sr_plan_invalid_table();
+    EXECUTE PROCEDURE sr_plan_invalid_table();
diff --git a/sr_plan.c b/sr_plan.c
@@ -210,8 +210,7 @@ PlannedStmt *sr_planner(Query *parse,
 		HeapTuple local_tuple;
 		local_tuple = index_getnext(query_index_scan, ForwardScanDirection);
 
-		if (local_tuple == NULL)
-			break;
+		if (local_tuple == NULL) break;
 
 		heap_deform_tuple(local_tuple, sr_plans_heap->rd_att,
 						  search_values, search_nulls);
@@ -227,7 +226,7 @@ PlannedStmt *sr_planner(Query *parse,
 	
 	if (find_ok)
 	{
-		elog(WARNING, "Ok we find saved plan.");
+		/* elog(WARNING, "Ok we find saved plan."); */
 		out_jsonb2 = (Jsonb *)DatumGetPointer(PG_DETOAST_DATUM(search_values[3]));
 		if (query_params != NULL)
 			pl_stmt = jsonb_to_node_tree(out_jsonb2, &replace_fake);
