There are more fields in each table, but for the sake of brevity, I ommited
them from the snippets below.
With smaller data sets, the second query works just fine as well.
SELECT COUNT(*) FROM link;
960219
SELECT COUNT(*) FROM node;
812193
Pvid's are INTEGERS.
On linux, the following query executes just fine from the interactive shell:
"SELECT COUNT(*) FROM link ld LEFT OUTER JOIN node n ON n.pvid =
ld.light_node_pvid WHERE ld.light_node_pvid != '-1' AND ld.light_node_pvid !=
'-2' AND n.pvid IS NULL;"
But, this one appears to hang(note the white space and eols in this one):
"SELECT COUNT(*) FROM
link ld
LEFT OUTER JOIN
node n
ON
n.pvid = ld.light_node_pvid
WHERE
ld.light_node_pvid != '-1'
AND
ld.light_node_pvid != '-2'
AND
n.pvid IS NULL;"
I get the same results with perl::dbi.
Any idea's?
The information contained in this communication may be CONFIDENTIAL and is
intended only for the use of the recipient(s) named above. If you are not the
intended recipient, you are hereby notified that any dissemination,
distribution, or copying of this communication, or any of its contents, is
strictly prohibited. If you have received this communication in error, please
notify the sender and delete/destroy the original message and any copy of it
from your computer or paper files.
_______________________________________________
sqlite-users mailing list
[email protected]
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
