Deveel.Data.SelectRoutineTests.SelectAllFromProcedure C# (CSharp) Method

        public void SelectAllFromProcedure()
        {
            const string sql = "SELECT * FROM proc1";

            var query = (SqlQueryExpression) SqlExpression.Parse(sql);

            Assert.IsNotNull(query);

            var result = AdminQuery.Select(query);

            Row row = null;

            Assert.IsNotNull(result);
            Assert.DoesNotThrow(() => row = result.Fetch(FetchDirection.Next, -1));

            Assert.IsNotNull(row);

            var type = row.GetValue("type");

            Assert.IsFalse(Field.IsNullField(type));
            Assert.AreEqual("procedure", type.Value.ToString());
        }