[
https://issues.apache.org/jira/browse/IGNITE-18562?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Pavel Tupitsyn updated IGNITE-18562:
------------------------------------
Description:
The following test generates invalid SQL:
{code:c#}
[Test]
public void TestOrderByMultiple()
{
var query = PocoAllColumnsSqlView.AsQueryable()
.OrderBy(x => new { x.Key, x.Int8, x.Int16 })
.Select(x => new { x.Str, x.Decimal });
var res = query.ToList();
Assert.AreEqual("x", res[0].Str);
Assert.AreEqual(1.1m, res[0].Decimal);
StringAssert.Contains(
"select _T0.STR, _T0.DECIMAL " +
"from PUBLIC.TBL_ALL_COLUMNS_SQL as _T0 " +
"order by _T0.KEY asc, _T0.INT8 asc, _T0.INT16 asc",
query.ToString());
}
{code}
was:
{code:c#}
[Test]
[Ignore("IGNITE-18562")]
public void TestOrderByMultiple()
{
var query = PocoAllColumnsSqlView.AsQueryable()
.OrderBy(x => new { x.Key, x.Int8, x.Int16 })
.Select(x => new { x.Str, x.Decimal });
var res = query.ToList();
Assert.AreEqual("x", res[0].Str);
Assert.AreEqual(1.1m, res[0].Decimal);
StringAssert.Contains(
"select _T0.STR, _T0.DECIMAL " +
"from PUBLIC.TBL_ALL_COLUMNS_SQL as _T0 " +
"order by _T0.KEY asc, _T0.INT8 asc, _T0.INT16 asc",
query.ToString());
}
{code}
> .NET: Thin 3.0: LINQ: Order by multiple columns generates invalid SQL
> ---------------------------------------------------------------------
>
> Key: IGNITE-18562
> URL: https://issues.apache.org/jira/browse/IGNITE-18562
> Project: Ignite
> Issue Type: Bug
> Components: platforms, thin client
> Reporter: Pavel Tupitsyn
> Assignee: Pavel Tupitsyn
> Priority: Major
> Labels: .NET, LINQ, ignite-3
> Fix For: 3.0.0-beta2
>
>
> The following test generates invalid SQL:
> {code:c#}
> [Test]
> public void TestOrderByMultiple()
> {
> var query = PocoAllColumnsSqlView.AsQueryable()
> .OrderBy(x => new { x.Key, x.Int8, x.Int16 })
> .Select(x => new { x.Str, x.Decimal });
> var res = query.ToList();
> Assert.AreEqual("x", res[0].Str);
> Assert.AreEqual(1.1m, res[0].Decimal);
> StringAssert.Contains(
> "select _T0.STR, _T0.DECIMAL " +
> "from PUBLIC.TBL_ALL_COLUMNS_SQL as _T0 " +
> "order by _T0.KEY asc, _T0.INT8 asc, _T0.INT16 asc",
> query.ToString());
> }
> {code}
--
This message was sent by Atlassian Jira
(v8.20.10#820010)
