Hello,
I have a strange situation going on in my MAX DB database ( version 7.5.0 Build 023-123-087-292, on Windows XP ).
I'm joining 3 tables with their primary keys, then sub-selecting records which match a particular text string on a column which is a component of the primary key on one of the joined tables.
When I try the string match as a LIKE clause, I get back some records.
SELECT col1 ... FROM ... WHERE col1 LIKE 'test%' returns:
testABC ... testEFG ... testHIJ ...
But when I try the string match as an equality test, using one of value returned above, I get no records returned:
SELECT col1 ... FROM ... WHERE col1 = 'testABC' returns no records.
I have examined the contents of the table column carefully, to make sure there is no trailing whitespace, etc. It looks like the equality test should certainly match the same records returned by the LIKE test.
Anyone run into this? Do MaxDB databases need regular index drop/re-create to stay healthy? This database gets a lot of insert/update/delete activity, as it's used in automated testing where we build up a bunch of test data then delete it once the test completes.
thanks,
Scott Maxson
-- MaxDB Discussion Mailing List For list archives: http://lists.mysql.com/maxdb To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
