Re: Very weird migrations behavior
Re: Very weird migrations behavior
- Subject: Re: Very weird migrations behavior
- From: Chuck Hill <email@hidden>
- Date: Sat, 02 May 2015 02:41:36 +0000
- Thread-topic: Very weird migrations behavior
|
Using a very, very old Wonder I see this
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 "unique_model" UNIQUE("modelname") DEFERRABLE INITIALLY DEFERRED
I don’t see the primary key constant getting added.
Chuck
[2015-05-01 19:27:45,930] <main> ERXJDBCUtilities – Executing
On 2015-05-01, 7:25 PM, "Ângelo Andrade Cirino" wrote:
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
|
_______________________________________________
Do not post admin requests to the list. They will be ignored.
Webobjects-dev mailing list (email@hidden)
Help/Unsubscribe/Update your Subscription:
This email sent to email@hidden