Query Error

Jul 24, 2015 at 4:56 PM
Edited Jul 24, 2015 at 7:37 PM
I was just testing an existing program that currently uses RaptorDB version 3.2.11. I upgraded to the latest version 3.2.13 (nothing else changed as far as the data and/or views). Now I'm getting an error when running this query.
string QueryText =  "startTime >= "7/23/2015 12:00:00 AM" AND startTime <= "7/23/2015 11:59:59 PM" AND 
( processName = "*APPROVE*" OR processName = "*CHECKIN*") AND ( processState= "Created" OR processState= "Ready" OR processState= "Canceled")";
The log shows the error(object reference error) is happening in WAHBitArray2,cs line 157, called from Hoot.cs line 222.

As soon I reverted back to the 3.2.11 version the query ran without error.
Jul 25, 2015 at 3:43 AM
You shouldn't need * for processName if it has words with spaces and you are using a fulltext index.

The only file changed since 3.2.10 is hoot.cs

It seems wildbits or bits is null, can you see which?
Jul 27, 2015 at 3:22 PM
I did confirm that the query completed without error when I removed the wildcard characters(*). I was trying to avoid refactoring our existing queries for the version upgrade(just doing it the simple way with using NuGet).

When using the remote debugger on our server that's running RaptorDB it wasn't loading the symbols properly (probably missing .pdb file info) so I couldn't tell which of the two was actually null. I will have some time soon to test again.
Aug 6, 2015 at 4:34 PM
It should all be fixed in v3.2.14