Re: Text Reports query

On Thu, 27 Nov 2003 14:55:58 -0600
Russell Valentine <russ-98fVsw/2eqlQihsdzhub5di2O/[email protected]> wrote:

> I get both reports and advance queries fine, I have three bugs in my
> database and I try doing differt queries and sorting. It is all working
> for me. I'll put in other fake data/users to try to resolve the issue
> and readup more about joins again.

I checkout the reports query, I think it looks pretty good. I have a few
questions about the advanced query search.

I converted it from the MySQL query, so at the time I didn't get much into
the left join of that query. What is resolution sapposed to be? To me it
seems like this left join is messed up.

LEFT JOIN resolve_d on resolve_d.id = resolve_d.name

looks like it wants to do a outer join using itself, the condition
resolve_d.id = resolve_d.name will never equal each other, so there is
never going to be anything in the resolution column. This doesn't prevent
the report from showing up though. I'm going to setup a MySQL copying
going to I can compare the outputs.

If you don't mind, would it be possible to get a datadump of your test
database? Using pgdump?



Russell Valentine

_______________________________________________
Anthill-workers mailing list
Anthill-workers-+mQDA36h6dWw5LPnMra/[email protected]
http://vmlinuz.ca/mailman/listinfo/anthill-workers

-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.2.3 (GNU/Linux)

iD8DBQE/xndTO0EDJO5MgRYRAtrWAJ4mflBVPOQ38zwdTE59tFPTy0a3oACfUd5x
Nwt7utsrByddPpGN4POAdDg=
=6RS3
-----END PGP SIGNATURE-----