|
|
|
1-10 of 133
< Previous ... Next >
|
Running a query against a data table results in an error:
DataTable dataTable = new DataTable();
dataTable.Columns.Add("ID", typeof(int));
dataTable.Columns.Add("Name", typeof(string));
dataTable....
id# 14823 | Planned Release: 0.9.4.0 Beta | Last Updated: May 18 at 6:52 PM
by terrajobst
Review the API to find applications for generic methods that could simplify the source code, e.g.
T QueryReader.GetValue<T>(int)
void DataContextMetadataContext.Comparers.Register<T>(IComparable)
v...
id# 10755 | Planned Release: 0.9.4.0 Beta | Last Updated: Dec 15 2007 at 7:01 PM
by terrajobst
The result of this query is strange. If the "* 2.0" part is removed one can see 9 rows (which is the correct result). With the multiplication the result are 81 rows (which is wrong). The reason for...
id# 14418 | Planned Release: 0.9.4.0 Beta | Last Updated: Dec 15 2007 at 7:01 PM
by terrajobst
WITH D AS (
SELECT o.OrderDate,
od.Quantity * od.UnitPrice * (1 - od.Discount) AS Price
FROM Orders o,
[Order Details] od
WHERE od.OrderID = o.OrderID
)
SELECT *
FROM D AS D1
FULL JOIN ...
id# 14417 | Planned Release: 0.9.4.0 Beta | Last Updated: Dec 15 2007 at 6:56 PM
by terrajobst
This query should cause the error message below. If uncommenting the
UNION ALL the error messages appears.
The ORDER BY clause is invalid in derived tables, subqueries, and common table expression...
id# 14413 | Planned Release: 0.9.4.0 Beta | Last Updated: Dec 15 2007 at 6:53 PM
by terrajobst
WITH test AS (
SELECT TOP 1
e.FirstName AS test,
e.LastName AS f,
e.Extension
FROM Employees e
ORDER BY 1
)
SELECT t.f
FROM test t
System.ArgumentException: IComparer (or the ICompara...
id# 14412 | Planned Release: 0.9.4.0 Beta | Last Updated: Dec 15 2007 at 6:53 PM
by terrajobst
For example, this query crashes:
WITH Employees AS (
SELECT t.TerritoryDescription,
EXISTS (
SELECT *
FROM EmployeeTerritories et
WHERE et.TerritoryID = t.TerritoryID
) AS HasAs...
id# 14411 | Planned Release: 0.9.4.0 Beta | Last Updated: Dec 15 2007 at 6:53 PM
by terrajobst
WITH D AS (
SELECT e.EmployeeID,
e.FirstName + ' ' + e.LastName AS FullName,
TRIM(t.TerritoryDescription) AS Territory,
TRIM(r.RegionDescription) AS Region
FROM Employees e
INNER JOI...
id# 14416 | Planned Release: 0.9.4.0 Beta | Last Updated: Dec 15 2007 at 6:53 PM
by terrajobst
This query should compile but does not due to a bug in the lexer. 10.Equals("Text") should be parsed as PropertyExpression but the lexer tokenizes 10.Equals as a number.
SELECT *
FROM Employees e
W...
id# 14415 | Planned Release: 0.9.4.0 Beta | Last Updated: Dec 15 2007 at 6:53 PM
by terrajobst
This query causes an infinite loop:
WITH MyEmployees AS (
SELECT TOP 5 WITH TIES
D.FullName,
D.Region,
D.Country
FROM (
SELECT e.Fir...
id# 14414 | Planned Release: 0.9.4.0 Beta | Last Updated: Dec 15 2007 at 6:53 PM
by terrajobst
|
|
1-10 of 133
< Previous 1 2 3 4 5 6 7 8 9 10 ... Next >
|
|
|
|
|
|
|
|
