Call to OrderBy with an expression that is not a simple property selection results in invalid SQL.

[sflanker]

See test case:

Invio.QueryProvider.MySql/test/Invio.QueryProvider.MySql.Test/MySqlQueryableTest.cs

Lines 103 to 106 in 03146ab

	[Fact(Skip = "BUG: Expression in OrderBy results in invalid SQL string.")]
	public override void OrderBy_Expression() {
	base.OrderBy_Expression();
	}

In this example the sorting expression is the product of two numeric fields. Currently this expression results in the SQL text:

... ORDER BY T.`UnitsInStock`T.`UnitPrice` ASC

The expected SQL text is:

... ORDER BY (T.`UnitsInStock` * T.`UnitPrice`) ASC