Deveel.Data.SelectIntoTests.OneColumnIntoOneVariable C# (CSharp) Method

        public void OneColumnIntoOneVariable()
        {
            var query = (SqlQueryExpression) SqlExpression.Parse("SELECT a FROM test_table");
            AdminQuery.SelectInto(query, "b");

            var variable = AdminQuery.Context.FindVariable("b");

            Assert.IsNotNull(variable);
            Assert.IsInstanceOf<NumericType>(variable.Type);
            Assert.IsFalse(variable.Evaluate(AdminQuery).IsNull);
            Assert.IsInstanceOf<SqlNumber>(variable.Evaluate(AdminQuery).Value);

            var number = (SqlNumber) variable.Evaluate(AdminQuery).Value;
            Assert.AreEqual(new SqlNumber(13), number);
        }