[DBAL-139] Oracle's sequences with NOCACHE Created: 29/Jul/11 Updated: 08/Nov/12
|Reporter:||Augusto Ximenes de Souza||Assignee:||Benjamin Eberlei|
Today I tried to generate Oracle's sequences with "NOCACHE", but I checked that method "getCreateSequenceSQL" don't accept. Can we improvement this method to allow? Below an example of the sintaxe:
CREATE SEQUENCE seq_test START WITH 1 INCREMENT BY 1 NOCACHE
|Comment by Ivan Andric [ 22/Sep/12 ]|
If cache value is specified then syntax should contain CACHE keyword that follows the value and if value is not specified then it should go without CACHE keyword.
My Idea is to add cache attribute to Sequence object and then under the previous story, set cache to given value if value is greater than 1 and less than calculation by the given formula.
Some public function will return NOCACHE or CACHE n and that function could be called in getCreateSequenceSQL method from Sequence input parameter.
Anyone have a better idea or I can code this and request pull from my fork?
|Comment by Ramon Henrique Ornelas [ 08/Nov/12 ]|
Duplicate issue http://www.doctrine-project.org/jira/browse/DBAL-348