0
Vote

Incorrect query results when self-joining CTE

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 | Release: 0.9.4.0 Beta | Updated: Dec 15 2007 at 6:01 PM by | Created: Dec 15 2007 at 6:00 PM by

0
Vote

Full outer join with CTE causes NullReference

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 | Release: 0.9.4.0 Beta | Updated: Dec 15 2007 at 5:56 PM by | Created: Dec 15 2007 at 5:50 PM by

0
Vote

Group by in CTE causes ArgumentException

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 | Release: 0.9.4.0 Beta | Updated: Dec 15 2007 at 5:53 PM by | Created: Dec 15 2007 at 5:45 PM by

0
Vote

Scanner incorrectly reads a decimal separator

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 | Release: 0.9.4.0 Beta | Updated: Dec 15 2007 at 5:53 PM by | Created: Dec 15 2007 at 5:43 PM by

0
Vote

Infinite loop

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 | Release: 0.9.4.0 Beta | Updated: Dec 15 2007 at 5:53 PM by | Created: Dec 15 2007 at 5:40 PM by

0
Vote

Missing error message

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 | Release: 0.9.4.0 Beta | Updated: Dec 15 2007 at 5:53 PM by | Created: Dec 15 2007 at 5:39 PM by

0
Vote

Order by in CTE causes ArgumentException

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 | Release: 0.9.4.0 Beta | Updated: Dec 15 2007 at 5:53 PM by | Created: Dec 15 2007 at 5:35 PM by

0
Vote

Exists in SELECT that is contained in a CTE causes crash

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 | Release: 0.9.4.0 Beta | Updated: Dec 15 2007 at 5:53 PM by | Created: Dec 15 2007 at 5:33 PM by

0
Vote

Review API for applications of generic methods

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 | Release: 0.9.4.0 Beta | Updated: Dec 15 2007 at 6:01 PM by | Created: Jun 4 2007 at 4:31 PM by

2
Vote

Security Exception

When I try to use NQuery in my local server it works fine but when I upload it to my hosting provider then it doesn't work and it show the Error Message below: Note: I created a web site with VB l...

Id #10537 | Release: 0.9.4.0 Beta | Updated: Nov 4 2007 at 6:56 PM by | Created: May 24 2007 at 4:59 AM by piseth