blob: 846bc5d60e49c11c5770a60ca0113047c3349ef3 [file] [log] [blame]
set `planner.enable_nljoin_for_scalar_only`=false;
select v1.name, v2.registration, v1.registered_date from voter v1 left join voter v2 on v2.registration not similar to '%(dem|pub|pen|lib)%' order by v2.registration,v1.name,v1.registered_date;
reset `planner.enable_nljoin_for_scalar_only`;