This email is to report a bug in MonetDB V4.8.2 for windows.

My name is Rómulo Gonçalves, number 0536601.


When I try to create a table with multiply primary key with the following code (SQL99) :

CREATE TABLE URLS (
       ID_URL int,
       ID_Division int,
       PRIMARY KEY (ID_URL, ID_Division)
);

ALTER Table URLs ADD foreign key(ID_Division) references URL_Division(ID_Division);

I receive the following error:

"[MonetDB][ODBC Driver 1.0]! Could not find referenced primary key in table urls"

Then I tried with the following code:

CREATE TABLE URLS (
ID_URL int,
ID_Division int,
primary key(ID_URL),
primary key(ID_Division)
);

And no error happen when I create the table. Here is the bug.

The MonetDB accept that we insert more than one key and then it accepts the first (in this case ID_URL) as a primary key.

But there is another bug. I can not create relational tables because I need to have a multiply primary key, in this case one tuplo (ID_URL,ID-Division) and for this I need to have the possibility to do like the following example:

CREATE TABLE URLS (
       ID_URL int,
       ID_Division int,
       PRIMARY KEY (ID_URL, ID_Division) -> MonetDB not accept this way to define multiple primary key.
);

Maybe the report is not a perfect report because is the first time that I report bugs of one System. I hope that you understand the two bugs of MonetDB that I found, if there is something that you do not understand, please contact me.

Greets, Rómulo....