pgpool2.git / summary / log / commit / refs

commit    656804ebc0d65c23c543eb03a1bdbf506ff1c10b
Author:   Nozomi Anzai <anzai@sraoss.co.jp>
Date:     Fri May 25 01:35:44 2012 +0000

    Fix not to cache all views if white_memqcache_table_list is empty and black_memqcache_table_list isn't empty.


 pool_memqcache.c | 21 +++++++++++----------
 1 file changed, 11 insertions(+), 10 deletions(-)

diff --git a/pool_memqcache.c b/pool_memqcache.c
index b8a158b9b..3c8abc99b 100644
--- a/pool_memqcache.c
+++ b/pool_memqcache.c
@@ -717,19 +717,20 @@ bool pool_is_allow_to_cache(Node *node, char *query)
 	{
 		if (num_oids < 0)
 			num_oids = pool_extract_table_oids_from_select_stmt(node, &ctx);
-	}
-	if (num_oids > 0)
-	{
-		for (i = 0; i < num_oids; i++)
+
+		if (num_oids > 0)
 		{
-			char *table = ctx.table_names[i];
-			pool_debug("pool_is_allow_to_cache: check table_names[%d] = %s", i, table);
-			if (is_view(table) || is_unlogged_table(table))
+			for (i = 0; i < num_oids; i++)
 			{
-				if (pool_is_table_to_cache(table) == false)
+				char *table = ctx.table_names[i];
+				pool_debug("pool_is_allow_to_cache: check table_names[%d] = %s", i, table);
+				if (is_view(table) || is_unlogged_table(table))
 				{
-					pool_debug("pool_is_allow_to_cache: false");
-					return false;
+					if (pool_is_table_to_cache(table) == false)
+					{
+						pool_debug("pool_is_allow_to_cache: false");
+						return false;
+					}
 				}
 			}
 		}


[parent: 76a97746bad5]