[power-matchmaker] r2774 committed - Fix for missing space after 'AND' in queries when there are multiple c...

[power-ma...@googlecode.com]

Revision: 2774
Author: fridgebuzz
Date: Fri Jan 28 06:39:15 2011
Log: Fix for missing space after 'AND' in queries when there are multiple
columns in a source table's PK.
http://code.google.com/p/power-matchmaker/source/detail?r=2774

Modified:
/branches/0.9.7/src/ca/sqlpower/matchmaker/MatchPool.java

=======================================
--- /branches/0.9.7/src/ca/sqlpower/matchmaker/MatchPool.java Thu Jan 27
10:06:15 2011
+++ /branches/0.9.7/src/ca/sqlpower/matchmaker/MatchPool.java Fri Jan 28
06:39:15 2011
@@ -328,7 +328,7 @@
int i = 0;
for (SQLIndex.Column col:
(List<SQLIndex.Column>)sourceTableIndex.getChildren()) {
if (i > 0) {
- sql.append(" AND");
+ sql.append(" AND ");
}
sql.append("DUP_CANDIDATE_1").append(i).append(" = ");
if (SQL.isNumeric(col.getColumn().getType()) ||
SQL.isBoolean(col.getColumn().getType())) {