[
Date Prev][
Date Next][
Thread Prev][
Thread Next][
Date Index][
Thread Index]
[
List Home]
Re: [dtp-dev] SQL statements don't work well.
|
Hi Mr. hosokawa,
Thanks for reporting the problem, please open a bugzilla entry.
Regards,
Hung
"hosokawa"
<hosokawa@xxxxxxx
.nec.co.jp> To
Sent by: "DTP development mailing list"
dtp-dev-bounces@e <dtp-dev@xxxxxxxxxxx>
clipse.org cc
Subject
01/16/2007 07:15 [dtp-dev] SQL statements don't work
PM well.
Please respond to
DTP development
mailing list
<dtp-dev@eclipse.
org>
Hi,
On the SQL Editor, when I execute SQL statments like below, syntax error
occurs.
Executes SQL statements like:
CREATE TABLE test_table (
aaa INTEGER NOT NULL,
bbb CHAR NOT NULL
)
ALTER TABLE test_table ADD CONSTRAINT unq_bbb UNIQUE (bbb)
Error occurs like:
"Syntax error: Encountered "ALTER" at line 5, column 1."
Such a sequence, like CREATE TABLE and ALTER TABLE immediately, is not
admitted?
I checked they work well when CREATE TABLE statement and ALTER TABLE
statement
are executed separately like below exsample.
Executes just CREATE TABLE first:
CREATE TABLE test_table (
aaa INTEGER NOT NULL,
bbb CHAR NOT NULL
)
Executes ALTER TABLE next:
ALTER TABLE test_table ADD CONSTRAINT unq_bbb UNIQUE (bbb)
I gotta "Succeeded" message at each time.
Best regards,
Takehiro Hosokawa
VALWAY Technology Center, NEC Soft, Ltd.
_______________________________________________
dtp-dev mailing list
dtp-dev@xxxxxxxxxxx
https://dev.eclipse.org/mailman/listinfo/dtp-dev