google-code-export / dblinq2007

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

Order by column named Count of size Int64 fails #326

Open GoogleCodeExporter opened 9 years ago

GoogleCodeExporter commented 9 years ago
What steps will reproduce the problem?
class Foo
{
  public long Count;
}

db.Foo.OrderBy(f=>f.Count);

What is the expected output? What do you see instead?
Valid query is generated. MySql throws syntax error

What version of the product are you using? On what operating system?
DbLinq 0.20.0.0
MySql.Data 6.4.4.0

Please provide any additional information below.
stack provided.

Original issue reported on code.google.com by itsnatet...@gmail.com on 19 Feb 2012 at 9:51

Attachments:

GoogleCodeExporter commented 9 years ago
This is targeting MySql 5.1 though will likely repro on other versions.

Original comment by itsnatet...@gmail.com on 19 Feb 2012 at 9:59

GoogleCodeExporter commented 9 years ago
Also, I have not tried; but you might want to regression test against the other 
built-in names:

http://dev.mysql.com/doc/refman/5.0/en/func-op-summary-ref.html such as 

Original comment by itsnatet...@gmail.com on 19 Feb 2012 at 9:59

GoogleCodeExporter commented 9 years ago
Let me know if they when these get fixed

Great project :)

http://wasntnate.com/2012/02/mysql-to-linq-dblinq-bug

Original comment by itsnatet...@gmail.com on 19 Feb 2012 at 11:20