----- Forwarded message from Dave Dyer <dd...@real-me.net> ----- Date: Tue, 01 Sep 2015 12:40:00 -0700 From: Dave Dyer <dd...@real-me.net> To: tim.bu...@pobox.com Subject: perl DBI bug report
This query produces results with lots of trailing nulls embedded in the "outcome" value. I suppose this might be expected to do something odd at the sql engine level, but embedding null characters, which do not occur in any of the elements, can't be correct. my $q = "select matchgroup.status,player,points,tournament,outcome,played," . " matchparticipant.comment,tournament_group,matchparticipant.uid" . " from matchparticipant left join matchgroup " . " on matchparticipant.tournament = matchgroup.uid and matchgroup.name = matchparticipant.tournament_group " . " where matchid=$qm " # note that because of the particular structure of this join query, $outcome seems to be padded with a lot of nulls . " union select matchgroup.status,-2,0,tournament,if(admin='winner',admin_winner,admin),played," . " matchrecord.comment,tournament_group,'A'" . " from matchrecord left join matchgroup " . " on matchrecord.tournament = matchgroup.uid and matchgroup.name = matchrecord.tournament_group " . " where matchid=$qm " . " order by uid "; ----- End forwarded message -----