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 protected]<mailto:[email protected]>> 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 protected]<mailto:[email protected]>
"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 protected]<mailto:[email protected]>
"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 protected])
Help/Unsubscribe/Update your Subscription:
https://lists.apple.com/mailman/options/webobjects-dev/archive%40mail-archive.com
This email sent to [email protected]
