Bugs item #2080219, was opened at 2008-08-28 16:38
Message generated for change (Tracker Item Submitted) made by Item Submitter
You can respond by visiting:
https://sourceforge.net/tracker/?func=detail&atid=482468&aid=2080219&group_id=56967
Please note that this message will contain a full copy of the comment thread,
including the initial issue submission, for this request,
not just the latest update.
Category: SQL/Core
Group: MonetDB5 5.6
Status: Open
Resolution: None
Priority: 5
Private: No
Submitted By: Qian Qiao (drizzlerain)
Assigned to: Niels Nes (nielsnes)
Summary: The conflict exist when the same tablename are in different
Initial Comment:
OS: RedHat Linux AS 4
GCC: 3.4.6
1. setup
create schema s1;
create schema s2;
drop table s1.A;
drop table s2.A;
create table s1.A(a varchar(10) NOT NULL UNIQUE);
create table s2.A(a varchar(10) NOT NULL);
set schema s2;
insert into A values('abc');
set schema s1;
insert into A values('abc');
2. result
select * from s1.A;
select * from s2.A;
+-----+
| a |
+=====+
| abc |
| abc |
+-----+
But after I update the sequence,then:
sql> drop table s1.A;
sql> drop table s2.A;
sql> create table s1.A(a varchar(10) NOT NULL UNIQUE);
sql> create table s2.A(a varchar(10) NOT NULL);
sql>
sql> set schema s1;
sql> insert into A values('abc');
Rows affected 1
sql> set schema s2;
sql> insert into A values('abc');
!SQLException:assert:INSERT INTO: UNIQUE constraint 'a.a_a_unique' violated
----------------------------------------------------------------------
You can respond by visiting:
https://sourceforge.net/tracker/?func=detail&atid=482468&aid=2080219&group_id=56967
-------------------------------------------------------------------------
This SF.Net email is sponsored by the Moblin Your Move Developer's challenge
Build the coolest Linux based applications with Moblin SDK & win great prizes
Grand prize is a trip for two to an Open Source event anywhere in the world
http://moblin-contest.org/redirect.php?banner_id=100&url=/
_______________________________________________
Monetdb-bugs mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/monetdb-bugs
