Well, if a column is listed in the SELECT clause (without an aggregate
function), and it is NOT listed in the GROUP BY clause, what is the SQL
engine supposed to do with it? In this scenario, you are only displaying
one value out of multiple possible values. Which one?
This is a quote from one of many SQL online tutorials:
"When grouping, keep in mind that all columns that appear in your SELECT
column list, that are not aggregated (used along with one of the SQL
aggregate functions), have to appear in the GROUP BY clause too."
I'm not sure what MySQL does in this scenario. It's possible that I have
misunderstood the issue, but to me this is common sense as well as a SQL
requirement.
Mark
On Sat, Mar 24, 2012 at 9:17 PM, Will Daniels <m...@willdaniels.co.uk>wrote:
> On 24/03/12 19:41, elin wrote:
>> Whoa, that's great. We are also looking at some query changes in the CMS
>> that are needed for Postgres, and if you wanted to propose what you have
>> as
>> patches that would be great. What is good is to keep the patches to a size
>> that is manageable for people doing manual tests. If you could make a pull
>> request and then a linked tracker item for each of the commits that would
>> be great.
>> I think you might want to repost some this on the platform list
>> (specifically about standards compliance and I think most importantly the
>> date issue) because that is where the people working on database issues
>> tend to be most active. (This mailing list is more about extension, while
>> the CMS and Platform lists are about the core code).
>> Elin
>> On Saturday, March 24, 2012 2:32:39 PM UTC-4, Rouven Weßling wrote:
>>> Wow, impressive list of things. I noticed that some of the files affected
>>> are platform files (basically everything in libraries/joomla). Could you
>>> make a pull request for those changes to the platform repro? Seems like
>>> it
>>> aren't a lot of changes so we should be able to get that sorted out
>>> quickly.
>>> Best regards
>>> Rouven
> OK, so I will divide my changes by Platform and CMS. Then in the CMS by
> Front/Admin, then by component also? I guess this should be OK for unit
> testing.
> I have a lot of other work the next few days but should be done some time
> next week and I'll register a pull request then.
> So if I make patches also to solve the date literal quoting problem, these
> should make it into core eventually? Or does that need further discussion
> on the platform list?
> Thanks for the encouragement :)
> -Will
> --
> You received this message because you are subscribed to the Google Groups
> "Joomla! General Development" group.
> To post to this group, send an email to joomla-dev-general@**
> googlegroups.com <joomla-dev-general@googlegroups.com>.
> To unsubscribe from this group, send email to joomla-dev-general+**
> unsubscribe@googlegroups.com<joomla-dev-general%2Bunsubscribe@googlegroups. com>
> .
> For more options, visit this group at http://groups.google.com/**
> group/joomla-dev-general?hl=**en-GB<http://groups.google.com/group/joomla-dev-general?hl=en-GB>
> .
