DROP SEQUENCE, ALTER SEQUENCE and FbBatchExecution
--------------------------------------------------
Key: DNET-317
URL: http://tracker.firebirdsql.org/browse/DNET-317
Project: .NET Data provider
Issue Type: Bug
Components: ADO.NET Provider
Affects Versions: 2.5.2
Reporter: Robert Kindl
Assignee: Jiri Cincura
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.
--
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators:
http://tracker.firebirdsql.org/secure/Administrators.jspa
-
For more information on JIRA, see: http://www.atlassian.com/software/jira
------------------------------------------------------------------------------
_______________________________________________
Firebird-net-provider mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
