On 27/08/2013 18:15, Dimitry Sibiryakov wrote:
> 27.08.2013 22:06, Adriano dos Santos Fernandes wrote:
>> Why do a future version will go against the SQL standard?
>    Does standard explicitly mention that identity's internal sequence must be 
> user-manipulatible? Does it say that in must be the same type of sequence as 
> "standalone" 
> ones?
No, but neither mention the contrary. But...

>    Say, Firebird one day decide to support cluster/cloud architecture and 
> keep values in 
> identity column globally unique. It will require an external source of 
> sequentional values.
>
It's clear a sequence. It even supports the parameters:

<common sequence generator option> ::=
<sequence generator start with option>
| <basic sequence generator option>

<basic sequence generator option> ::=
<sequence generator increment by option>
| <sequence generator maxvalue option>
| <sequence generator minvalue option>
| <sequence generator cycle option>


Adriano


------------------------------------------------------------------------------
Learn the latest--Visual Studio 2012, SharePoint 2013, SQL 2012, more!
Discover the easy way to master current and previous Microsoft technologies
and advance your career. Get an incredible 1,500+ hours of step-by-step
tutorial videos with LearnDevNow. Subscribe today and save!
http://pubads.g.doubleclick.net/gampad/clk?id=58040911&iu=/4140/ostg.clktrk
Firebird-Devel mailing list, web interface at 
https://lists.sourceforge.net/lists/listinfo/firebird-devel

Reply via email to