Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

DROP SEQUENCE, ALTER SEQUENCE and FbBatchExecution [DNET317] #328

Closed
firebird-automations opened this issue May 24, 2010 · 3 comments
Closed

Comments

@firebird-automations
Copy link

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

@firebird-automations
Copy link
Author

Modified by: @cincuranet

Link: This issue relate to DNET329 [ DNET329 ]

@firebird-automations
Copy link
Author

Modified by: @cincuranet

status: Open [ 1 ] => Resolved [ 5 ]

resolution: Fixed [ 1 ]

Fix Version: 2.5.3 [ 10380 ]

@firebird-automations
Copy link
Author

Modified by: @cincuranet

Fix Version: 2.6 [ 10371 ]

Fix Version: 2.5.3 [ 10380 ] =>

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Projects
None yet
Development

No branches or pull requests

2 participants