[EMAIL PROTECTED] uttered:
Christian Smith <[EMAIL PROTECTED]> wrote:
select ....
FROM instances as i
inner join instance_fields as count using(instanceid)
inner join instance_fields as first using (instanceid)
inner join instance_fields as last using (instanceid)
inner join instance_fields as severity using (instanceid)
inner join instance_fields as summary using (instanceid)
inner join instance_fields as node using (instanceid)
inner join instance_fields as source using (instanceid)
I believe that USING is broken when there are more than
two tables in the join. Try an ON clause instead and see
if that doesn't work better.
No, that didn't work either until I put the explicit integer type fix in
for instanceid in instance_fields.
Now the fix is in place, the join with USING works perfectly.
Worth creating a ticket?
--
D. Richard Hipp <[EMAIL PROTECTED]>
Christian
PS. An old SPARCclassic is an ideal machine to guage performance
differences between schemas and queries:)
Before schema change:
100.70 seconds to select from a view
After schema change:
11.75 seconds to select from a compatible view. Awesome!
--
/"\
\ / ASCII RIBBON CAMPAIGN - AGAINST HTML MAIL
X - AGAINST MS ATTACHMENTS
/ \
