Re: Bug in foreign keys

2003-01-10 Thread Rafal Jank
bout this. > > Best regards, > > Heikki Tuuri > Innobase Oy > --- > InnoDB - transactions, hot backup, and foreign key support for MySQL > See http://www.innodb.com, download MySQL-Max from http://www.mysql.com > > sql q

Re: Bug in foreign keys

2003-01-10 Thread Heikki Tuuri
port for MySQL See http://www.innodb.com, download MySQL-Max from http://www.mysql.com sql query ................. Subject: Re: Bug in foreign keys From: Rafal Jank Date: Fri, 10 Jan 2003 11:10:35 +0100 On Thu,

Re: Bug in foreign keys

2003-01-10 Thread Rafal Jank
NULL, > -> `zaplac_r` char(1) default NULL, > -> `wplaczal_r` char(1) default NULL, > -> PRIMARY KEY (`id_r`), > -> KEY `nip_h_index` (`nip_h`,`nrpok_p`) > -> ) TYPE=InnoDB; > Query OK, 0 rows affected (0.01 sec) > > mysql&g

Re: Bug in foreign keys

2003-01-10 Thread Rafal Jank
On Thu, 09 Jan 2003 23:04:37 +0100 "Stefan Hinz, iConnect (Berlin)" <[EMAIL PROTECTED]> wrote: > Rafal, > > > alter table rezerwacje add foreign key (nip_h,nrpok_p) references > > pokoje(nip_h,nrpok_p); > > > ERROR 1005: Can't create table './test/#sql-932_4.frm' (errno: 150) > > Most probably,

Re: Bug in foreign keys

2003-01-09 Thread Stefan Hinz, iConnect \(Berlin\)
- Stefan Hinz <[EMAIL PROTECTED]> Geschäftsführer / CEO iConnect GmbH <http://iConnect.de> Heesestr. 6, 12169 Berlin (Germany) Tel: +49 30 7970948-0 Fax: +49 30 7970948-3 - Original Message - From: "Rafal Jank" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]&g

Re: Bug in foreign keys

2003-01-09 Thread Heikki Tuuri
r` char(1) default NULL, -> PRIMARY KEY (`id_r`), -> KEY `nip_h_index` (`nip_h`,`nrpok_p`) -> ) TYPE=InnoDB; Query OK, 0 rows affected (0.01 sec) mysql> mysql> alter table rezerwacje add foreign key (nip_h,nrpok_p) references -> pokoje(nip_h,nrpok_p); Query OK, 0 ro

Re: Bug in foreign keys

2003-01-09 Thread Heikki Tuuri
Rafal, - Original Message - From: "Rafal Jank" <[EMAIL PROTECTED]> Newsgroups: mailing.database.mysql Sent: Thursday, January 09, 2003 6:18 PM Subject: Bug in foreign keys > Hi! > I have two tables: > CREATE TABLE `pokoje` ( > `nrpok_p` char(10) NOT NULL de

Re: Bug in foreign keys

2003-01-09 Thread Rafal Jank
> At 16:11 +0100 1/9/03, Rafal Jank wrote: > >Hi! > >I have two tables: > >CREATE TABLE `pokoje` ( > > `nrpok_p` char(10) NOT NULL default '', > > `nip_h` int(10) NOT NULL default '0', > > `lozka_p` char(2) default NULL, > > `tv_p` char(1) default NULL, > > `lazienka_p` char(1) default N

Re: Bug in foreign keys

2003-01-09 Thread Paul DuBois
At 16:11 +0100 1/9/03, Rafal Jank wrote: Hi! I have two tables: CREATE TABLE `pokoje` ( `nrpok_p` char(10) NOT NULL default '', `nip_h` int(10) NOT NULL default '0', `lozka_p` char(2) default NULL, `tv_p` char(1) default NULL, `lazienka_p` char(1) default NULL, `cena_p` int(10) default

Bug in foreign keys

2003-01-09 Thread Rafal Jank
Hi! I have two tables: CREATE TABLE `pokoje` ( `nrpok_p` char(10) NOT NULL default '', `nip_h` int(10) NOT NULL default '0', `lozka_p` char(2) default NULL, `tv_p` char(1) default NULL, `lazienka_p` char(1) default NULL, `cena_p` int(10) default NULL, `zaliczka_p` int(10) default NULL