two lookup input fields - no whitespace after AND in mysql query

[micm]

I have configured an automatic lookup from a mysql table via web interface. When I configure two lookup input fields I get a mysql syntax error. Just configuring one does work sql wise.

From the recent db connect errors search:

com.splunk.dbx.lookup.DBLookupException: SQL error while performing lookup: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'ANDportindex = 12' at line 1

mysql query log:

33409 Query SELECT slot,number,name FROM port WHERE switchdomain = 58 ANDportindex = 3

So there is missing a whitespace after the AND. Is there any workaround?

[ziegfried · Accepted solution]

This should be fixed in the latest release (1.0.7)

[micm]

Thanks, it works now.