From d9e4dabfffa3e8183d3f9992d50c41d3987bfa1c Mon Sep 17 00:00:00 2001
From: Bibiko <bibiko@eva.mpg.de>
Date: Tue, 26 Jan 2010 18:01:50 +0000
Subject: =?UTF-8?q?=E2=80=A2=20corrected=20regex=20to=20trigger=20table/db?=
 =?UTF-8?q?=20reload=20after=20executing=20a=20query=20in=20the=20Query=20?=
 =?UTF-8?q?Editor?=
MIME-Version: 1.0
Content-Type: text/plain; charset=UTF-8
Content-Transfer-Encoding: 8bit

---
 Source/CustomQuery.m | 5 +++--
 1 file changed, 3 insertions(+), 2 deletions(-)

(limited to 'Source')

diff --git a/Source/CustomQuery.m b/Source/CustomQuery.m
index 2e3b16c4..a02da041 100644
--- a/Source/CustomQuery.m
+++ b/Source/CustomQuery.m
@@ -629,9 +629,9 @@
 		} else {
 			// Check if table/db list needs an update
 			// The regex is a compromise between speed and usefullness. TODO: further improvements are needed
-			if(!tableListNeedsReload && [query isMatchedByRegex:@"(?i)(?<!show\\s+)\\b(create|alter|drop|rename)\\b\\s+."])
+			if(!tableListNeedsReload && [query isMatchedByRegex:@"(?i)^\\s*\\b(create|alter|drop|rename)\\b\\s+."])
 				tableListNeedsReload = YES;
-			if(!databaseWasChanged && [query isMatchedByRegex:@"(?i)\\b(use|drop\\s+database|drop\\s+schema)\\b\\s+."])
+			if(!databaseWasChanged && [query isMatchedByRegex:@"(?i)^\\s*\\b(use|drop\\s+database|drop\\s+schema)\\b\\s+."])
 				databaseWasChanged = YES;
 		}
 		// If the query was cancelled, end all queries.
@@ -649,6 +649,7 @@
 
 		// Reload table list
 		[[[tableWindow delegate] valueForKeyPath:@"tablesListInstance"] updateTables:self];
+
 	}
 	
 	if(usedQuery)
-- 
cgit v1.2.3