Register
Login
YOUR CART IS EMPTY

MySQL, group by first character of a string -> Exception

Boy does time fly!

This thread looks to be a little on the old side and therefore may no longer be relevant. Please see if there is a newer thread on the subject and ensure you're using the most recent build of any software if your question regards a particular product.

This thread has been locked

This thread has been locked and is no longer accepting new posts, if you have a question regarding this topic please email us at support@mindscape.co.nz

dsmit
33 posts

Hi,

I haven't tested with nightlies, sorry if this is bogus:

Using a MySQL connection.

Linq that fails:

            var clients = (from client in JisRepository.FindAll<Integration.Jis.Client>()
                           orderby client.Cliname ascending
                           group client by client.Cliname.First() into groupedByFirstLetter
                           select new ClientListItemViewModel()
                           {
                               FirstLetter = groupedByFirstLetter.Key
                           }).ToList();

Exception:

The method 'First' is not supported.

at Mindscape.LightSpeed.Linq.Sqo.CriteriaSqo.ExtractMethodCriteria(LinqQueryPlanExpression plan, MethodCallExpression expression) at Mindscape.LightSpeed.Linq.Sqo.CriteriaSqo.ExtractCriteriaCore(LinqQueryPlanExpression plan, Expression expression) at Mindscape.LightSpeed.Linq.Sqo.CriteriaSqo.ExtractCriteria(LinqQueryPlanExpression plan, Expression expression) at Mindscape.LightSpeed.Linq.Sqo.CriteriaSqo.ExtractCriteriaCore(LinqQueryPlanExpression plan, Expression expression) at Mindscape.LightSpeed.Linq.Sqo.CriteriaSqo.ExtractCriteria(LinqQueryPlanExpression plan, Expression expression) at Mindscape.LightSpeed.Linq.Sqo.CriteriaSqo.ExtractCriteriaCore(LinqQueryPlanExpression plan, Expression expression) at Mindscape.LightSpeed.Linq.Sqo.CriteriaSqo.ExtractCriteria(LinqQueryPlanExpression plan, Expression expression) at Mindscape.LightSpeed.Linq.Sqo.GroupBy.HandleSingleGrouping(LinqQueryPlanExpression subplan, Expression expression) at Mindscape.LightSpeed.Linq.Sqo.GroupBy.Evaluate(ExpressionVisitor visitor, MethodCallExpression expression) at Mindscape.LightSpeed.Linq.Plan.LinqQueryBuilder.VisitMethodCall(MethodCallExpression exp) at Mindscape.LightSpeed.Linq.Plan.LinqQueryBuilder.Visit(Expression exp) at Mindscape.LightSpeed.Linq.Sqo.Select.Evaluate(ExpressionVisitor visitor, MethodCallExpression expression) at Mindscape.LightSpeed.Linq.Plan.LinqQueryBuilder.VisitMethodCall(MethodCallExpression exp) at Mindscape.LightSpeed.Linq.Plan.LinqQueryBuilder.Visit(Expression exp) at Mindscape.LightSpeed.Linq.Plan.LinqQueryBuilder.Build(Expression translation, LinqQueryProvider provider) at Mindscape.LightSpeed.Linq.LinqQueryProvider.GetExecutionPlan(Expression expression) at Mindscape.LightSpeed.Linq.LinqQueryProvider.Execute(Expression expression) at Mindscape.LightSpeed.Linq.LinqQueryProvider.System.Linq.IQueryProvider.Execute(Expression expression) at Mindscape.LightSpeed.Linq.LinqQuery1.GetEnumerator() at System.Collections.Generic.List1..ctor(IEnumerable1 collection) at System.Linq.Enumerable.ToList[TSource](IEnumerable1 source)

Linq that works:

            var clients = (from client in JisRepository.FindAll<Integration.Jis.Client>()
                           orderby client.Cliname ascending
                           group client by client.Cliname.Substring(0, 1) into groupedByFirstLetter
                           select new ClientListItemViewModel()
                           {
                               FirstLetter = groupedByFirstLetter.Key[0]
                           }).ToList();

The SQL from the working LINQ:

SELECT g1.clientdb.Cliname_SUBSTRING FROM ( SELECT SUBSTRING(clientdb.Cliname, 1, 1) AS "clientdb.Cliname_SUBSTRING" FROM clientdb clientdb GROUP BY SUBSTRING(clientdb.Cliname, 1, 1) ) g1

--> Time: 25 ms

SELECT clientdb.cliid AS "clientdb.cliid", clientdb.Cliattention AS "clientdb.Cliattention", clientdb.Clicity AS "clientdb.Clicity", clientdb.Clifax AS "clientdb.Clifax", clientdb.Cliname AS "clientdb.Cliname", clientdb.Clinational AS "clientdb.Clinational", clientdb.Cliproduct AS "clientdb.Cliproduct", clientdb.Clishort AS "clientdb.Clishort", clientdb.Clistartdate AS "clientdb.Clistartdate", clientdb.Clistate AS "clientdb.Clistate", clientdb.Clistatus AS "clientdb.Clistatus", clientdb.Clistreet AS "clientdb.Clistreet", clientdb.Clitel AS "clientdb.Clitel", clientdb.Clitrapri AS "clientdb.Clitrapri", clientdb.Clizip AS "clientdb.Clizip" FROM clientdb WHERE SUBSTRING(clientdb.Cliname, 1, 1) = 'A' ORDER BY clientdb.Cliname

--> Time: 21 ms

SELECT clientdb.cliid AS "clientdb.cliid", clientdb.Cliattention AS "clientdb.Cliattention", clientdb.Clicity AS "clientdb.Clicity", clientdb.Clifax AS "clientdb.Clifax", clientdb.Cliname AS "clientdb.Cliname", clientdb.Clinational AS "clientdb.Clinational", clientdb.Cliproduct AS "clientdb.Cliproduct", clientdb.Clishort AS "clientdb.Clishort", clientdb.Clistartdate AS "clientdb.Clistartdate", clientdb.Clistate AS "clientdb.Clistate", clientdb.Clistatus AS "clientdb.Clistatus", clientdb.Clistreet AS "clientdb.Clistreet", clientdb.Clitel AS "clientdb.Clitel", clientdb.Clitrapri AS "clientdb.Clitrapri", clientdb.Clizip AS "clientdb.Clizip" FROM clientdb WHERE SUBSTRING(clientdb.Cliname, 1, 1) = 'B' ORDER BY clientdb.Cliname

--> Time: 18 ms

SELECT clientdb.cliid AS "clientdb.cliid", clientdb.Cliattention AS "clientdb.Cliattention", clientdb.Clicity AS "clientdb.Clicity", clientdb.Clifax AS "clientdb.Clifax", clientdb.Cliname AS "clientdb.Cliname", clientdb.Clinational AS "clientdb.Clinational", clientdb.Cliproduct AS "clientdb.Cliproduct", clientdb.Clishort AS "clientdb.Clishort", clientdb.Clistartdate AS "clientdb.Clistartdate", clientdb.Clistate AS "clientdb.Clistate", clientdb.Clistatus AS "clientdb.Clistatus", clientdb.Clistreet AS "clientdb.Clistreet", clientdb.Clitel AS "clientdb.Clitel", clientdb.Clitrapri AS "clientdb.Clitrapri", clientdb.Clizip AS "clientdb.Clizip" FROM clientdb WHERE SUBSTRING(clientdb.Cliname, 1, 1) = 'C' ORDER BY clientdb.Cliname

--> Time: 17 ms

SELECT clientdb.cliid AS "clientdb.cliid", clientdb.Cliattention AS "clientdb.Cliattention", clientdb.Clicity AS "clientdb.Clicity", clientdb.Clifax AS "clientdb.Clifax", clientdb.Cliname AS "clientdb.Cliname", clientdb.Clinational AS "clientdb.Clinational", clientdb.Cliproduct AS "clientdb.Cliproduct", clientdb.Clishort AS "clientdb.Clishort", clientdb.Clistartdate AS "clientdb.Clistartdate", clientdb.Clistate AS "clientdb.Clistate", clientdb.Clistatus AS "clientdb.Clistatus", clientdb.Clistreet AS "clientdb.Clistreet", clientdb.Clitel AS "clientdb.Clitel", clientdb.Clitrapri AS "clientdb.Clitrapri", clientdb.Clizip AS "clientdb.Clizip" FROM clientdb WHERE SUBSTRING(clientdb.Cliname, 1, 1) = 'D' ORDER BY clientdb.Cliname

--> Time: 14 ms

SELECT clientdb.cliid AS "clientdb.cliid", clientdb.Cliattention AS "clientdb.Cliattention", clientdb.Clicity AS "clientdb.Clicity", clientdb.Clifax AS "clientdb.Clifax", clientdb.Cliname AS "clientdb.Cliname", clientdb.Clinational AS "clientdb.Clinational", clientdb.Cliproduct AS "clientdb.Cliproduct", clientdb.Clishort AS "clientdb.Clishort", clientdb.Clistartdate AS "clientdb.Clistartdate", clientdb.Clistate AS "clientdb.Clistate", clientdb.Clistatus AS "clientdb.Clistatus", clientdb.Clistreet AS "clientdb.Clistreet", clientdb.Clitel AS "clientdb.Clitel", clientdb.Clitrapri AS "clientdb.Clitrapri", clientdb.Clizip AS "clientdb.Clizip" FROM clientdb WHERE SUBSTRING(clientdb.Cliname, 1, 1) = 'E' ORDER BY clientdb.Cliname

--> Time: 18 ms

SELECT clientdb.cliid AS "clientdb.cliid", clientdb.Cliattention AS "clientdb.Cliattention", clientdb.Clicity AS "clientdb.Clicity", clientdb.Clifax AS "clientdb.Clifax", clientdb.Cliname AS "clientdb.Cliname", clientdb.Clinational AS "clientdb.Clinational", clientdb.Cliproduct AS "clientdb.Cliproduct", clientdb.Clishort AS "clientdb.Clishort", clientdb.Clistartdate AS "clientdb.Clistartdate", clientdb.Clistate AS "clientdb.Clistate", clientdb.Clistatus AS "clientdb.Clistatus", clientdb.Clistreet AS "clientdb.Clistreet", clientdb.Clitel AS "clientdb.Clitel", clientdb.Clitrapri AS "clientdb.Clitrapri", clientdb.Clizip AS "clientdb.Clizip" FROM clientdb WHERE SUBSTRING(clientdb.Cliname, 1, 1) = 'F' ORDER BY clientdb.Cliname

--> Time: 20 ms

SELECT clientdb.cliid AS "clientdb.cliid", clientdb.Cliattention AS "clientdb.Cliattention", clientdb.Clicity AS "clientdb.Clicity", clientdb.Clifax AS "clientdb.Clifax", clientdb.Cliname AS "clientdb.Cliname", clientdb.Clinational AS "clientdb.Clinational", clientdb.Cliproduct AS "clientdb.Cliproduct", clientdb.Clishort AS "clientdb.Clishort", clientdb.Clistartdate AS "clientdb.Clistartdate", clientdb.Clistate AS "clientdb.Clistate", clientdb.Clistatus AS "clientdb.Clistatus", clientdb.Clistreet AS "clientdb.Clistreet", clientdb.Clitel AS "clientdb.Clitel", clientdb.Clitrapri AS "clientdb.Clitrapri", clientdb.Clizip AS "clientdb.Clizip" FROM clientdb WHERE SUBSTRING(clientdb.Cliname, 1, 1) = 'H' ORDER BY clientdb.Cliname

--> Time: 15 ms

SELECT clientdb.cliid AS "clientdb.cliid", clientdb.Cliattention AS "clientdb.Cliattention", clientdb.Clicity AS "clientdb.Clicity", clientdb.Clifax AS "clientdb.Clifax", clientdb.Cliname AS "clientdb.Cliname", clientdb.Clinational AS "clientdb.Clinational", clientdb.Cliproduct AS "clientdb.Cliproduct", clientdb.Clishort AS "clientdb.Clishort", clientdb.Clistartdate AS "clientdb.Clistartdate", clientdb.Clistate AS "clientdb.Clistate", clientdb.Clistatus AS "clientdb.Clistatus", clientdb.Clistreet AS "clientdb.Clistreet", clientdb.Clitel AS "clientdb.Clitel", clientdb.Clitrapri AS "clientdb.Clitrapri", clientdb.Clizip AS "clientdb.Clizip" FROM clientdb WHERE SUBSTRING(clientdb.Cliname, 1, 1) = 'I' ORDER BY clientdb.Cliname

--> Time: 17 ms

SELECT clientdb.cliid AS "clientdb.cliid", clientdb.Cliattention AS "clientdb.Cliattention", clientdb.Clicity AS "clientdb.Clicity", clientdb.Clifax AS "clientdb.Clifax", clientdb.Cliname AS "clientdb.Cliname", clientdb.Clinational AS "clientdb.Clinational", clientdb.Cliproduct AS "clientdb.Cliproduct", clientdb.Clishort AS "clientdb.Clishort", clientdb.Clistartdate AS "clientdb.Clistartdate", clientdb.Clistate AS "clientdb.Clistate", clientdb.Clistatus AS "clientdb.Clistatus", clientdb.Clistreet AS "clientdb.Clistreet", clientdb.Clitel AS "clientdb.Clitel", clientdb.Clitrapri AS "clientdb.Clitrapri", clientdb.Clizip AS "clientdb.Clizip" FROM clientdb WHERE SUBSTRING(clientdb.Cliname, 1, 1) = 'J' ORDER BY clientdb.Cliname

--> Time: 18 ms

SELECT clientdb.cliid AS "clientdb.cliid", clientdb.Cliattention AS "clientdb.Cliattention", clientdb.Clicity AS "clientdb.Clicity", clientdb.Clifax AS "clientdb.Clifax", clientdb.Cliname AS "clientdb.Cliname", clientdb.Clinational AS "clientdb.Clinational", clientdb.Cliproduct AS "clientdb.Cliproduct", clientdb.Clishort AS "clientdb.Clishort", clientdb.Clistartdate AS "clientdb.Clistartdate", clientdb.Clistate AS "clientdb.Clistate", clientdb.Clistatus AS "clientdb.Clistatus", clientdb.Clistreet AS "clientdb.Clistreet", clientdb.Clitel AS "clientdb.Clitel", clientdb.Clitrapri AS "clientdb.Clitrapri", clientdb.Clizip AS "clientdb.Clizip" FROM clientdb WHERE SUBSTRING(clientdb.Cliname, 1, 1) = 'K' ORDER BY clientdb.Cliname

--> Time: 13 ms

SELECT clientdb.cliid AS "clientdb.cliid", clientdb.Cliattention AS "clientdb.Cliattention", clientdb.Clicity AS "clientdb.Clicity", clientdb.Clifax AS "clientdb.Clifax", clientdb.Cliname AS "clientdb.Cliname", clientdb.Clinational AS "clientdb.Clinational", clientdb.Cliproduct AS "clientdb.Cliproduct", clientdb.Clishort AS "clientdb.Clishort", clientdb.Clistartdate AS "clientdb.Clistartdate", clientdb.Clistate AS "clientdb.Clistate", clientdb.Clistatus AS "clientdb.Clistatus", clientdb.Clistreet AS "clientdb.Clistreet", clientdb.Clitel AS "clientdb.Clitel", clientdb.Clitrapri AS "clientdb.Clitrapri", clientdb.Clizip AS "clientdb.Clizip" FROM clientdb WHERE SUBSTRING(clientdb.Cliname, 1, 1) = 'L' ORDER BY clientdb.Cliname

--> Time: 25 ms

SELECT clientdb.cliid AS "clientdb.cliid", clientdb.Cliattention AS "clientdb.Cliattention", clientdb.Clicity AS "clientdb.Clicity", clientdb.Clifax AS "clientdb.Clifax", clientdb.Cliname AS "clientdb.Cliname", clientdb.Clinational AS "clientdb.Clinational", clientdb.Cliproduct AS "clientdb.Cliproduct", clientdb.Clishort AS "clientdb.Clishort", clientdb.Clistartdate AS "clientdb.Clistartdate", clientdb.Clistate AS "clientdb.Clistate", clientdb.Clistatus AS "clientdb.Clistatus", clientdb.Clistreet AS "clientdb.Clistreet", clientdb.Clitel AS "clientdb.Clitel", clientdb.Clitrapri AS "clientdb.Clitrapri", clientdb.Clizip AS "clientdb.Clizip" FROM clientdb WHERE SUBSTRING(clientdb.Cliname, 1, 1) = 'M' ORDER BY clientdb.Cliname

--> Time: 23 ms

SELECT clientdb.cliid AS "clientdb.cliid", clientdb.Cliattention AS "clientdb.Cliattention", clientdb.Clicity AS "clientdb.Clicity", clientdb.Clifax AS "clientdb.Clifax", clientdb.Cliname AS "clientdb.Cliname", clientdb.Clinational AS "clientdb.Clinational", clientdb.Cliproduct AS "clientdb.Cliproduct", clientdb.Clishort AS "clientdb.Clishort", clientdb.Clistartdate AS "clientdb.Clistartdate", clientdb.Clistate AS "clientdb.Clistate", clientdb.Clistatus AS "clientdb.Clistatus", clientdb.Clistreet AS "clientdb.Clistreet", clientdb.Clitel AS "clientdb.Clitel", clientdb.Clitrapri AS "clientdb.Clitrapri", clientdb.Clizip AS "clientdb.Clizip" FROM clientdb WHERE SUBSTRING(clientdb.Cliname, 1, 1) = 'N' ORDER BY clientdb.Cliname

--> Time: 17 ms

SELECT clientdb.cliid AS "clientdb.cliid", clientdb.Cliattention AS "clientdb.Cliattention", clientdb.Clicity AS "clientdb.Clicity", clientdb.Clifax AS "clientdb.Clifax", clientdb.Cliname AS "clientdb.Cliname", clientdb.Clinational AS "clientdb.Clinational", clientdb.Cliproduct AS "clientdb.Cliproduct", clientdb.Clishort AS "clientdb.Clishort", clientdb.Clistartdate AS "clientdb.Clistartdate", clientdb.Clistate AS "clientdb.Clistate", clientdb.Clistatus AS "clientdb.Clistatus", clientdb.Clistreet AS "clientdb.Clistreet", clientdb.Clitel AS "clientdb.Clitel", clientdb.Clitrapri AS "clientdb.Clitrapri", clientdb.Clizip AS "clientdb.Clizip" FROM clientdb WHERE SUBSTRING(clientdb.Cliname, 1, 1) = 'O' ORDER BY clientdb.Cliname

--> Time: 22 ms

SELECT clientdb.cliid AS "clientdb.cliid", clientdb.Cliattention AS "clientdb.Cliattention", clientdb.Clicity AS "clientdb.Clicity", clientdb.Clifax AS "clientdb.Clifax", clientdb.Cliname AS "clientdb.Cliname", clientdb.Clinational AS "clientdb.Clinational", clientdb.Cliproduct AS "clientdb.Cliproduct", clientdb.Clishort AS "clientdb.Clishort", clientdb.Clistartdate AS "clientdb.Clistartdate", clientdb.Clistate AS "clientdb.Clistate", clientdb.Clistatus AS "clientdb.Clistatus", clientdb.Clistreet AS "clientdb.Clistreet", clientdb.Clitel AS "clientdb.Clitel", clientdb.Clitrapri AS "clientdb.Clitrapri", clientdb.Clizip AS "clientdb.Clizip" FROM clientdb WHERE SUBSTRING(clientdb.Cliname, 1, 1) = 'P' ORDER BY clientdb.Cliname

--> Time: 15 ms

SELECT clientdb.cliid AS "clientdb.cliid", clientdb.Cliattention AS "clientdb.Cliattention", clientdb.Clicity AS "clientdb.Clicity", clientdb.Clifax AS "clientdb.Clifax", clientdb.Cliname AS "clientdb.Cliname", clientdb.Clinational AS "clientdb.Clinational", clientdb.Cliproduct AS "clientdb.Cliproduct", clientdb.Clishort AS "clientdb.Clishort", clientdb.Clistartdate AS "clientdb.Clistartdate", clientdb.Clistate AS "clientdb.Clistate", clientdb.Clistatus AS "clientdb.Clistatus", clientdb.Clistreet AS "clientdb.Clistreet", clientdb.Clitel AS "clientdb.Clitel", clientdb.Clitrapri AS "clientdb.Clitrapri", clientdb.Clizip AS "clientdb.Clizip" FROM clientdb WHERE SUBSTRING(clientdb.Cliname, 1, 1) = 'R' ORDER BY clientdb.Cliname

--> Time: 13 ms

SELECT clientdb.cliid AS "clientdb.cliid", clientdb.Cliattention AS "clientdb.Cliattention", clientdb.Clicity AS "clientdb.Clicity", clientdb.Clifax AS "clientdb.Clifax", clientdb.Cliname AS "clientdb.Cliname", clientdb.Clinational AS "clientdb.Clinational", clientdb.Cliproduct AS "clientdb.Cliproduct", clientdb.Clishort AS "clientdb.Clishort", clientdb.Clistartdate AS "clientdb.Clistartdate", clientdb.Clistate AS "clientdb.Clistate", clientdb.Clistatus AS "clientdb.Clistatus", clientdb.Clistreet AS "clientdb.Clistreet", clientdb.Clitel AS "clientdb.Clitel", clientdb.Clitrapri AS "clientdb.Clitrapri", clientdb.Clizip AS "clientdb.Clizip" FROM clientdb WHERE SUBSTRING(clientdb.Cliname, 1, 1) = 'S' ORDER BY clientdb.Cliname

--> Time: 20 ms

SELECT clientdb.cliid AS "clientdb.cliid", clientdb.Cliattention AS "clientdb.Cliattention", clientdb.Clicity AS "clientdb.Clicity", clientdb.Clifax AS "clientdb.Clifax", clientdb.Cliname AS "clientdb.Cliname", clientdb.Clinational AS "clientdb.Clinational", clientdb.Cliproduct AS "clientdb.Cliproduct", clientdb.Clishort AS "clientdb.Clishort", clientdb.Clistartdate AS "clientdb.Clistartdate", clientdb.Clistate AS "clientdb.Clistate", clientdb.Clistatus AS "clientdb.Clistatus", clientdb.Clistreet AS "clientdb.Clistreet", clientdb.Clitel AS "clientdb.Clitel", clientdb.Clitrapri AS "clientdb.Clitrapri", clientdb.Clizip AS "clientdb.Clizip" FROM clientdb WHERE SUBSTRING(clientdb.Cliname, 1, 1) = 'T' ORDER BY clientdb.Cliname

--> Time: 15 ms

SELECT clientdb.cliid AS "clientdb.cliid", clientdb.Cliattention AS "clientdb.Cliattention", clientdb.Clicity AS "clientdb.Clicity", clientdb.Clifax AS "clientdb.Clifax", clientdb.Cliname AS "clientdb.Cliname", clientdb.Clinational AS "clientdb.Clinational", clientdb.Cliproduct AS "clientdb.Cliproduct", clientdb.Clishort AS "clientdb.Clishort", clientdb.Clistartdate AS "clientdb.Clistartdate", clientdb.Clistate AS "clientdb.Clistate", clientdb.Clistatus AS "clientdb.Clistatus", clientdb.Clistreet AS "clientdb.Clistreet", clientdb.Clitel AS "clientdb.Clitel", clientdb.Clitrapri AS "clientdb.Clitrapri", clientdb.Clizip AS "clientdb.Clizip" FROM clientdb WHERE SUBSTRING(clientdb.Cliname, 1, 1) = 'V' ORDER BY clientdb.Cliname

--> Time: 18 ms

SELECT clientdb.cliid AS "clientdb.cliid", clientdb.Cliattention AS "clientdb.Cliattention", clientdb.Clicity AS "clientdb.Clicity", clientdb.Clifax AS "clientdb.Clifax", clientdb.Cliname AS "clientdb.Cliname", clientdb.Clinational AS "clientdb.Clinational", clientdb.Cliproduct AS "clientdb.Cliproduct", clientdb.Clishort AS "clientdb.Clishort", clientdb.Clistartdate AS "clientdb.Clistartdate", clientdb.Clistate AS "clientdb.Clistate", clientdb.Clistatus AS "clientdb.Clistatus", clientdb.Clistreet AS "clientdb.Clistreet", clientdb.Clitel AS "clientdb.Clitel", clientdb.Clitrapri AS "clientdb.Clitrapri", clientdb.Clizip AS "clientdb.Clizip" FROM clientdb WHERE SUBSTRING(clientdb.Cliname, 1, 1) = 'Y' ORDER BY clientdb.Cliname

--> Time: 17 ms

Conclusion:

Room for improvement? ;-)

Thanks!

Dennis

Posted on May 11 2012

jeremy
3,400 posts

First() and other IEnumerable extension methods are not supported on grouping keys. We support standard entity properties (including translatable functions such as your use of Substring above) and some basic aggregates such as Count().

We are making changes in LightSpeed 5.0 to improve the way our querying API handles groupings which will allow for single statements to be issued in situations like with LINQ rather than the "find grouping keys, then find results for each grouping key" approach that is currently required so it will be improved as part of that work :)

Jeremy

Posted on May 11 2012

MySQL, group by first character of a string -> Exception

Data Products

DevOp Tools

Visual Controls

Popular Products

Quick Links