NOTE: use Perl; is on undef hiatus. You can read content, but you can't post it. More info will be forthcoming forthcomingly.
All the Perl that's Practical to Extract and Report
about I/O disciplines and I should retire to the Tassili-in-Aijer
mountains in Sahara as a camel herder :-)
-- Jarkko Hietaniemi
Stories, comments, journals, and other submissions on use Perl; are Copyright 1998-2006, their respective owners.
Missing aggregate function? (Score:1)
The weird part is that the join is a 1-m, right? That is, conceptbindings.conceptid is not UNIQUE. Thus, c.rtype should not be admissible in the SELECT clause. A proper DBMS would complain about the fact that you need an aggregate function (like COUNT, or MIN).
MySQL does not complain, right?
Re: (Score:1)
Exactly.
c.rtypeshouldn't be there, or an aggregate function should be used. Or, you couldGROUP BY c.rtypetoo.But as it is, it shouldn't work. At least within my current understanding of SQL...
And yes, it's MySQL 5.
Re:Missing aggregate function? (Score:1)
I think MySQL takes the first value it sees for that file, within the group
The reasonableness of this is debatable, but at least make getting some result easier...
Reply to This
Parent