search

jonpryor / dblinq2007

Automatically exported from code.google.com/p/dblinq2007
0 stars 0 forks source link

Limit of two columns in ORDER BY clause #274

Open GoogleCodeExporter opened 9 years ago

GoogleCodeExporter commented 9 years ago 
When executing a query like this:

from i in context.Table
orderby i.One, i.Two, i.Three
select i;

The column "three" is omitted from the generated ORDER BY clause.  In fact, 
only the first two "orderby" expressions appear to be considered at all; the 
later expressions are simple ignored.

The impact of this bug is that on cannot sort on more than two columns.  DbLinq 
does not throw an exception, it just doesn't generate the correct SQL.

What version of the product are you using? On what operating system?
0.20.1 on Debian Lenny with Mono 2.6.7.

Original issue reported on code.google.com by cdho...@gmail.com on 17 Aug 2010 at 7:39