search

terrajobst / nquery

NQuery is a relational query engine written in C#. It allows you to execute a SELECT query against .NET objects.
MIT License
72 stars 20 forks source link

Strange casting rules #23

Open terrajobst opened 9 years ago

terrajobst commented 9 years ago

Ported from CodePlex

SELECT (CAST(e.EmployeeID AS byte) * CAST(3 AS byte)).GetType() AS MyType
FROM Employees e

The expression is evaluated as:

(CAST(CAST(e.EmployeeID AS BYTE) AS INT64) * 3).GetType()

Strange casting rules...