Bugs item #1964587, was opened at 2008-05-15 15:29
Message generated for change (Comment added) made by stmane
You can respond by visiting:
https://sourceforge.net/tracker/?func=detail&atid=482468&aid=1964587&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: Mapi
Group: (zombie: Clients 1.22)
>Status: Open
Resolution: Fixed
>Priority: 6
Private: No
Submitted By: Fabian (mr-meltdown)
Assigned to: Sjoerd Mullender (sjoerd)
Summary: mclient doesn't dump multi-colum unique constraint correctly
Initial Comment:
sql>create table test_property(subject integer, p1 integer, p2 integer,
unique(subject, p1), unique(subject, p2));
sql>\d test_property
CREATE TABLE "sys"."test_property" (
"subject" int,
"p1" int,
"p2" int,
CONSTRAINT "test_property_subject_p2_unique" UNIQUE ("subject"),
CONSTRAINT "test_property_subject_p1_unique" UNIQUE ("subject", "p2",
"p1")
);
Note that the two unique constraints are not dumped correctly, as one is dumped
to be on "subject" alone, the other on "subject", "p2" and "p1". It is a
dumping problem, as the same code works fine with JdbcClient:
(pegasus:~) fabian% JdbcClient -dAnton
Welcome to the MonetDB interactive JDBC terminal!
Database: MonetDB v5.5.0, 'Anton'
Driver: MonetDB Native Driver v1.7 (Canephora_p2 20080319 based on MCL v1.2)
Type \q to quit, \h for a list of available commands
auto commit mode: on
monetdb-> create table test_property(subject integer, p1 integer, p2 integer,
monetdb=( unique(subject, p1), unique(subject, p2));
Operation successful
monetdb-> \d test_property
CREATE TABLE "sys"."test_property" (
"subject" int,
"p1" int,
"p2" int,
CONSTRAINT "test_property_subject_p1_unique" UNIQUE ("subject", "p1"),
CONSTRAINT "test_property_subject_p2_unique" UNIQUE ("subject", "p2")
);
monetdb->
----------------------------------------------------------------------
>Comment By: Stefan Manegold (stmane)
Date: 2008-05-27 18:07
Message:
Logged In: YES
user_id=572415
Originator: NO
re-opened as test fails --- possibly only requiring a stable output
approval ...
http://monetdb.cwi.nl/testing/projects/monetdb/Stable/sql/.mTests4103/GNU.64.64.d-Fedora8/src_test_BugTracker/multi-column-constraint.SF-1964587.out.00.html
----------------------------------------------------------------------
Comment By: Sjoerd Mullender (sjoerd)
Date: 2008-05-15 18:11
Message:
Logged In: YES
user_id=43607
Originator: NO
I forgot to mention: there is also a test: src/test/BugTracker
multi-column-constraint.SF-1964587
----------------------------------------------------------------------
Comment By: Sjoerd Mullender (sjoerd)
Date: 2008-05-15 16:19
Message:
Logged In: YES
user_id=43607
Originator: NO
Fixed in CVS (stable branch--propagation will follow).
----------------------------------------------------------------------
You can respond by visiting:
https://sourceforge.net/tracker/?func=detail&atid=482468&aid=1964587&group_id=56967
-------------------------------------------------------------------------
This SF.net email is sponsored by: Microsoft
Defy all challenges. Microsoft(R) Visual Studio 2008.
http://clk.atdmt.com/MRT/go/vse0120000070mrt/direct/01/
_______________________________________________
Monetdb-bugs mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/monetdb-bugs
