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

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

            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);
        }