On 6-3-2016 14:47, Adriano dos Santos Fernandes wrote: > Em 06/03/2016 05:36, Mark Rotteveel escreveu: >> On 6-3-2016 03:45, Adriano dos Santos Fernandes wrote: >>> I see two bugs with your implementation. Both of these commands should >>> raise error: >>> >>> create or alter sequence s1; >> >> Why would this one need to raise an error? I think it would be fine that >> if it already exists, nothing is done, and if it doesn't exist it is >> created starting from zero. >> > > Because that is not CEATE OR ALTER, that is CREATE OR > DO-NOTHING-IF-EXIST and we do not have this command. > > It's explicitly designed to raise an error.
Why? Its use case is "create if not exists, otherwise everything is ok", which to me sounds perfectly reasonable. Mark -- Mark Rotteveel ------------------------------------------------------------------------------ Firebird-Devel mailing list, web interface at https://lists.sourceforge.net/lists/listinfo/firebird-devel
