On Mon, Jul 25, 2011 at 01:13:54PM +0000, Pierre Casenove wrote: > > Hello,I've modified 4 queries in order to get this work... But I don't have > an oracle set up to test my queries.Moreover, I'm not sure the queries > actually returns the legitimate results. > I insist on the fact that I'm not a DBA. I'm really not sure that the > rewritten queries are correct. Please have a look on the diffs > Here are the diff on the three modifed files, in folder > /usr/lib/perl5/vendor_perl/5.8.8/RHN/DB/DataSource/xml:diff > config_queries.xml /root/config_queries.xml.orig85,90c85,90< FROM > rhnConfigFile CF< LEFT OUTER JOIN rhnConfigRevision CR ON > (CR.config_file_id = CF.id)< LEFT OUTER JOIN rhnSnapshotConfigRevision SCR > ON (SCR.config_revision_id = CR.id)< LEFT OUTER JOIN rhnConfigFileName CFN > ON (CFN.id = CF.config_file_name_id)< LEFT OUTER JOIN rhnConfigContent CCon > ON (CCon.id = CR.config_content_id)< LEFT OUTER JOIN rhnChecksumView Csum > ON (Csum.id = CCon.checksum_id)---> FROM rhnConfigContent CCon,> > rhnConfigFileName CFN,> rhnConfigFile CF,> rhnConfigRevision > CR,> rhnSnapshotConfigRevision SCR,> rhnChecksumView > Csum91a92,96> AND SCR.config_revision_id = CR.id> AND > CR.config_content_id = CCon.id (+)> AND CR.config_file_id = CF.id> AND > CF.config_file_name_id = CFN.id> AND CCon.checksum_id = Csum.id (+)
Pierre, could you please attach the diff? Your MUA seems to be screwing the newlines badly, so we really cannot use them. Thank you, -- Jan Pazdziora Principal Software Engineer, Satellite Engineering, Red Hat _______________________________________________ Spacewalk-list mailing list [email protected] https://www.redhat.com/mailman/listinfo/spacewalk-list
