| For instance, this
"modelname" VARCHAR(100) CONSTRAINT NOT_NULL__dbupdater__modelname NOT NULL,
should be
"modelname" VARCHAR(100) _dbupdater.modelname NOT NULL, and this
ALTER TABLE "_DBUPDATER" ADD CONSTRAINT "PRIMARY_KEY__dbupdater_modelname" PRIMARY KEY ("MODELNAME") NOT DEFERRABLE INITIALLY IMMEDIATE;
should be
ALTER TABLE "_DBUPDATER" PRIMARY KEY ("MODELNAME") NOT DEFERRABLE INITIALLY IMMEDIATE;
There are spurious additions of CONSTRAINT NOT_NULL_ and ADD CONSTRAINT PRIMARY_KEY_ to the SQL.
I forgot to mention my environment
Yosemite 10.10.3 Eclipse 4.4.2 FrontBase Wonder and WOLips in sync with the master branches. Em 01/05/2015, à(s) 23:17, Chuck Hill < email@hidden> escreveu:
I am not seeing anything wrong there.
On 2015-05-01, 7:11 PM, "Ângelo Andrade Cirino" wrote:
I’ve been using migrations for a long time, but today I had a problem that left me completely in the dark. See the SQL being generated:
SET TRANSACTION ISOLATION LEVEL SERIALIZABLE, LOCKING PESSIMISTIC;
CREATE TABLE "_dbupdater" (
"lockowner" VARCHAR(100),
"modelname" VARCHAR(100) CONSTRAINT NOT_NULL__dbupdater__modelname NOT NULL,
"updatelock" INTEGER CONSTRAINT NOT_NULL__dbupdater__updatelock NOT NULL,
"version" INTEGER CONSTRAINT NOT_NULL__dbupdater__version NOT NULL
);
ALTER TABLE "_DBUPDATER" ADD CONSTRAINT "PRIMARY_KEY__dbupdater_modelname" PRIMARY KEY ("MODELNAME") NOT DEFERRABLE INITIALLY IMMEDIATE;
COMMIT;
Is it possible that there is a bug in EOSynchronizationFactory?
Angelo
Ângelo Andrade Cirino
email@hidden
"O homem sensato se adapta ao mundo. O insensato insiste em tentar adaptar o mundo a ele. Todo o progresso depende, portanto, do homem insensato"
Sir George Benard Shaw
"The reasonable man adapts himself to the world: the unreasonable one persists in trying to adapt the world to himself. Therefore all progress depends on the unreasonable man."
Sir George Benard Shaw
Ângelo Andrade Cirino email@hidden"O homem sensato se adapta ao mundo. O insensato insiste em tentar adaptar o mundo a ele. Todo o progresso depende, portanto, do homem insensato" Sir George Benard Shaw
"The reasonable man adapts himself to the world: the unreasonable one persists in trying to adapt the world to himself. Therefore all progress depends on the unreasonable man."
Sir George Benard Shaw
|