blob: b57489fbc821fe943c1e9d3d772bcd02bbdaff05 [file] [log] [blame]
set `planner.enable_nljoin_for_scalar_only`=false;
select s.name,s.gpa,v.registration from student s left join voter v on v.registration not in ('independent','republican','green');
reset `planner.enable_nljoin_for_scalar_only`;