public void InsensitiveSimpleCursor()
{
const string cursorName = "c";
var query = (SqlQueryExpression)SqlExpression.Parse("SELECT * FROM APP.test_table");
AdminQuery.DeclareCursor(cursorName, query);
var cursor = AdminQuery.Context.FindCursor(cursorName);
Assert.IsNotNull(cursor);
Assert.AreEqual(cursorName, cursor.CursorInfo.CursorName);
Assert.IsEmpty(cursor.CursorInfo.Parameters);
}
public void InsensitiveWithParams()
{
const string cursorName = "c";
var query = (SqlQueryExpression)SqlExpression.Parse("SELECT * FROM APP.test_table WHERE a = :a");
var parameters = new[] { new CursorParameter("a", PrimitiveTypes.Integer()) };
AdminQuery.DeclareCursor(cursorName, parameters, query);
var cursor = AdminQuery.Context.FindCursor(cursorName);
Assert.IsNotNull(cursor);
Assert.AreEqual(cursorName, cursor.CursorInfo.CursorName);
Assert.IsNotEmpty(cursor.CursorInfo.Parameters);
}
