[MacPorts] #27506: Incorrect SQL in reg_entry_dependents() from cregistry/entry.c

[MacPorts]

#27506: Incorrect SQL in reg_entry_dependents() from cregistry/entry.c
-------------------------------------+--------------------------------------
 Reporter:  mmpestorich@…            |       Owner:  macports-tickets@…                   
     Type:  defect                   |      Status:  new                                  
 Priority:  Normal                   |   Milestone:                                       
Component:  base                     |     Version:  1.9.2                                
 Keywords:  sqlite entry dependents  |        Port:                                       
-------------------------------------+--------------------------------------

Comment(by mmpestorich@…):

 Woops. Sorry I wasn't clear. My MacBook is running OSX 10.6.5, MacPorts
 1.9.2 and SQLite 3.6.23.1 (the Apple installed version for 10.6.5) and
 runs correctly without the patch above. The other machine is a Linux box
 that I have been using MacPorts on for a couple years now with my own
 portfiles. I have done a few minor things to keep it compiling and running
 correctly on Linux (though as of 1.9.2 not much if anything  needs to be
 done anymore to have it successfully compile). On that Linux box I was
 previously running MacPorts 1.9.0 and SQLite 3.6.x using the flat file
 registry without any issues. Recently, I upgraded it to MacPorts 1.9.2 and
 SQLite 3.7.3 (and then converted the flat file registry to the newer
 SQLite one). After that, I ran into this problem.

 I understand that most on here don't really care much about the state of
 MacPorts on a Linux system, but it seemed to me that in this case, this
 was be a bug against a newer version of SQLite and had nothing to do with
 BSD vs Linux incompatabilities. Anyway, thought it might be helpful.

-- 
Ticket URL: <https://trac.macports.org/ticket/27506#comment:2>
MacPorts <http://www.macports.org/>
Ports system for Mac OS