On Sun, Feb 20, 2011 at 10:15 AM, Paul Tomblin <ptomb...@xcski.com> wrote: > I have a field in my database, "id", which is the unique key. The id > is generated as an MD5 hash of some of the other data in the record, > and unfortunately the way I converted it to hex meant that sometimes I > get a negative value. I'm having a real hard time figuring out the
It turns out that the problem isn't the minus sign, the problem is that I keep expecting Solr to act like a relational database. In a relational database, if you do inserts, your queries will find those records even if you haven't committed them. It's only *other* database connections that won't find the records until you commit. But evidently in Solr, even the original connection/thread that inserted the records doesn't see them in a query until you commit them - I assume that's because a web connection is stateless. I added a commit before my query, and now I can find them. -- http://www.linkedin.com/in/paultomblin http://careers.stackoverflow.com/ptomblin
