Issue 326 in dblinq2007: Order by column named Count of size Int64 fails

2 views
Skip to first unread message

dblin...@googlecode.com

unread,
Feb 19, 2012, 4:52:53 AM2/19/12
to dblin...@googlegroups.com
Status: New
Owner: ----

New issue 326 by itsnatet...@gmail.com: Order by column named Count of size
Int64 fails
http://code.google.com/p/dblinq2007/issues/detail?id=326

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.

Attachments:
mysql-stack.txt 2.5 KB

dblin...@googlecode.com

unread,
Feb 19, 2012, 4:59:55 AM2/19/12
to dblin...@googlegroups.com

Comment #1 on issue 326 by itsnatet...@gmail.com: Order by column named

This is targeting MySql 5.1 though will likely repro on other versions.


dblin...@googlecode.com

unread,
Feb 19, 2012, 5:03:58 AM2/19/12
to dblin...@googlegroups.com

Comment #2 on issue 326 by itsnatet...@gmail.com: Order by column named

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

dblin...@googlecode.com

unread,
Feb 19, 2012, 6:21:10 AM2/19/12
to dblin...@googlegroups.com

Comment #3 on issue 326 by itsnatet...@gmail.com: Order by column named

Let me know if they when these get fixed

Great project :)

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

Reply all
Reply to author
Forward
0 new messages