This project has moved and is read-only. For the latest updates, please go here.
0

Closed

Overflow exception

description

SELECT (e.EmployeeID * (3000000000)).GetType() AS MyType
FROM Employees e

Query crashes with:

System.OverflowException: Value was either too large or too small for an Int32.
at System.Convert.ToInt32(Int64 value)
at System.Int64.System.IConvertible.ToInt32(IFormatProvider provider)
at System.Convert.ToInt32(Object value)
at NQuery.Compilation.ConstantExpression.get_AsInt32() in K:\NQuery\Trunk\Src\NQuery\AST\ConstantExpression.cs:line 60
at NQuery.Compilation.TextGenerator.VisitLiteralValue(LiteralExpression expression) in K:\NQuery\Trunk\Src\NQuery\AST\Visitors\TextGenerator.cs:line 56
at NQuery.Compilation.StandardVisitor.Visit(AstNode node) in K:\NQuery\Trunk\Src\NQuery\AST\Visitors\StandardVisitor.cs:line 18
at NQuery.Compilation.IdGenerator.VisitBinaryExpression(BinaryExpression expression) in K:\NQuery\Trunk\Src\NQuery\AST\Visitors\IdGenerator.cs:line 42
at NQuery.Compilation.StandardVisitor.Visit(AstNode node) in K:\NQuery\Trunk\Src\NQuery\AST\Visitors\StandardVisitor.cs:line 23
at NQuery.Compilation.IdGenerator.VisitMethodInvocationExpression(MethodInvocationExpression expression) in K:\NQuery\Trunk\Src\NQuery\AST\Visitors\IdGenerator.cs:line 195
at NQuery.Compilation.StandardVisitor.Visit(AstNode node) in K:\NQuery\Trunk\Src\NQuery\AST\Visitors\StandardVisitor.cs:line 50
at NQuery.Compilation.AstNode.GenerateId() in K:\NQuery\Trunk\Src\NQuery\AST\AstNode.cs:line 10
at NQuery.Compilation.RowBufferBuilder.VisitComputeScalar(ComputeScalarNode node) in K:\NQuery\Trunk\Src\NQuery\Compilation\RowBufferBuilder.cs:line 26
at NQuery.Runtime.ExecutionPlan.ExecutionPlanVisitor.Visit(ExecutionPlanNode node) in K:\NQuery\Trunk\Src\NQuery\Execution Plan\ExecutionPlanVisitor.cs:line 30
at NQuery.Runtime.ExecutionPlan.ExecutionPlanVisitor.VisitResult(ResultNode node) in K:\NQuery\Trunk\Src\NQuery\Execution Plan\ExecutionPlanVisitor.cs:line 60
at NQuery.Runtime.ExecutionPlan.ExecutionPlanVisitor.Visit(ExecutionPlanNode node) in K:\NQuery\Trunk\Src\NQuery\Execution Plan\ExecutionPlanVisitor.cs:line 14
at NQuery.Compilation.Compiler.DeprecatedCompileQuery(String queryText, Scope scope) in K:\NQuery\Trunk\Src\NQuery\Compilation\Compiler.cs:line 196
at NQuery.Compilation.Compiler.CompileQuery(String queryText, Scope scope, AlgebraNode& algebrizedQuery) in K:\NQuery\Trunk\Src\NQuery\Compilation\Compiler.cs:line 157
at NQuery.Query.Compile() in K:\NQuery\Trunk\Src\NQuery\Query.cs:line 98
at NQuery.Query.EnsureCompiled() in K:\NQuery\Trunk\Src\NQuery\Query.cs:line 84
at NQuery.Query.GetExecutionPlan() in K:\NQuery\Trunk\Src\NQuery\Query.cs:line 118
at NQuery.Gui.MainForm.ExplainQuery() in K:\NQuery\Trunk\Src\NQuery.Gui\MainForm.cs:line 156
at NQuery.Gui.MainForm.explainToolStripMenuItem_Click(Object sender, EventArgs e) in K:\NQuery\Trunk\Src\NQuery.Gui\MainForm.cs:line 661
at System.Windows.Forms.ToolStripItem.RaiseEvent(Object key, EventArgs e)
at System.Windows.Forms.ToolStripMenuItem.OnClick(EventArgs e)
at System.Windows.Forms.ToolStripItem.HandleClick(EventArgs e)
at System.Windows.Forms.ToolStripItem.FireEventInteractive(EventArgs e, ToolStripItemEventType met)
at System.Windows.Forms.ToolStripItem.FireEvent(EventArgs e, ToolStripItemEventType met)
at System.Windows.Forms.ToolStripMenuItem.ProcessCmdKey(Message& m, Keys keyData)
at System.Windows.Forms.ToolStripManager.ProcessShortcut(Message& m, Keys shortcut)
at System.Windows.Forms.ToolStripManager.ProcessCmdKey(Message& m, Keys keyData)
at System.Windows.Forms.ContainerControl.ProcessCmdKey(Message& msg, Keys keyData)
at System.Windows.Forms.Form.ProcessCmdKey(Message& msg, Keys keyData)
at NQuery.Gui.MainForm.ProcessCmdKey(Message& msg, Keys keyData) in K:\NQuery\Trunk\Src\NQuery.Gui\MainForm.cs:line 633
at System.Windows.Forms.Control.ProcessCmdKey(Message& msg, Keys keyData)
at System.Windows.Forms.Control.PreProcessMessage(Message& msg)
at System.Windows.Forms.Control.PreProcessControlMessageInternal(Control target, Message& msg)
at System.Windows.Forms.Application.ThreadContext.PreTranslateMessage(MSG& msg)
Closed Oct 31, 2014 at 7:31 AM by terrajobst

comments