You signed in with another tab or window. Reload to refresh your session.You signed out in another tab or window. Reload to refresh your session.You switched accounts on another tab or window. Reload to refresh your session.Dismiss alert
Using DROP SEQUENCE statement in batch script and executing it with FbBatchExecution results in exception
"The type of the SQL statement could not be determinated."
According to FB documentation:
DROP SEQUENCE is fully equivalent to DROP GENERATOR and is the recommended syntax from Firebird 2.0 onward.
Obviously something like is ommited in FbBatchExecution.cs
if (StringParser.StartsWith(sqlStatement, "DROP SEQUENCE", true))
{
return SqlStatementType.DropSequence;
}
ALTER SEQUENCE is similar case - it replaced SET GENERATOR syntax.
Submitted by: Robert Kindl (rkindl)
Relate to DNET329
Using DROP SEQUENCE statement in batch script and executing it with FbBatchExecution results in exception
"The type of the SQL statement could not be determinated."
According to FB documentation:
DROP SEQUENCE is fully equivalent to DROP GENERATOR and is the recommended syntax from Firebird 2.0 onward.
Obviously something like is ommited in FbBatchExecution.cs
if (StringParser.StartsWith(sqlStatement, "DROP SEQUENCE", true))
{
return SqlStatementType.DropSequence;
}
ALTER SEQUENCE is similar case - it replaced SET GENERATOR syntax.
Commits: ffe5278
The text was updated successfully, but these errors were encountered: