Re: anti-join with SQL::Statement?

Reinier Post wrote:
>>   SELECT E.*
>>   FROM Employee AS E
>>     LEFT JOIN Dept AS D USING (DeptName)
>>   WHERE D.DeptName IS NULL
> 
> Thanks, I didn't know about USING.  Works fine, too:

That's good to hear.

>> Set::Relation is superfluous for this task actually.
> 
> I'd like to try it anyway,
> but it won't install on my (Cygwin 1.7) system:
> 
> #   Failed test 'use Set::Relation;'
> #   at t/Set_Relation_00_Compile.t line 9.
> #     Tried to use 'Set::Relation'.
> #     Error:  Can't use an undefined value as a HASH reference at
> #     /usr/lib/perl5/site_perl/5.10/namespace/autoclean.pm

That looks more like a namespace::autoclean problem, actually.  Are you using 
the latest version?

Strictly speaking, you could remove all references to namespace::autoclean and 
Set::Relation would still work, I believe; namespace::autoclean is more of a 
housekeeping utility.  There's just a line each in 3 files I believe.

Perl 5.10.0 is also known to have some significant bugs in it; I would use a 
newer version anyway if you can, 5.12.2 being the best.

But try removing the "use namespace::autoclean;" from the source and see if the 
problem goes away, if updating to the newest first doesn't work.

-- Darren Duncan