strange behavior in mysql-server 5.1.49 and 5.1.51
strange behavior in mysql-server 5.1.49 and 5.1.51
am 28.10.2010 14:54:10 von Gregor Kling
Hello list,
I fight a strange behavior in mysql versions 5.1.49 and 5.1.51 -
maybe a fight against myself ;-)
The following query works exactly as assumed in version 5.1.41 with
the given testbed:
select * from test_nkomp_admin where host_id=6 and admin_id="yoda";
/* version 5.1.41 ubuntu 10.04 */
mysql> select * from test_nkomp_admin where host_id=6 and
admin_id="yoda" ;
+---------+----------+
| host_id | admin_id |
+---------+----------+
| 6 | yoda |
+---------+----------+
1 row in set (0.00 sec)
whereas in versions 5.1.49 (ubuntu 10.10) and 5.1.51 (package from
debian experimental,os ubuntu 10.10) the resultset is:
mysql> select * from test_nkomp_admin where host_id=6 and
admin_id="yoda" ;
Empty set (0.00 sec)
prove:
select * from test_nkomp_admin where host_id=6 ;
+---------+----------+
| host_id | admin_id |
+---------+----------+
| 6 | luke |
| 6 | yoda |
+---------+----------+
2 rows in set (0.00 sec)
Could anyone prove this behavior, or can give hint what the problem
might be ?
/* testbed */
drop table if exists test_nkomp_admin;
drop table if exists test_nkomp;
drop table if exists test_admin;
create table test_nkomp
(
host_id int unsigned auto_increment not null primary key
)engine=innodb;
create table test_admin
(
admin_id varchar(15) not null primary key
)engine=innodb;
create table test_nkomp_admin
(
host_id int unsigned,
admin_id varchar(15),
foreign key (host_id) references test_nkomp (host_id) on delete
cascade on update cascade,
foreign key (admin_id) references test_admin (admin_id) on delete
cascade on update cascade
)engine=innodb;
insert into test_nkomp (host_id) values (1),(2),(3),(4),(5),(6);
insert into test_admin (admin_id) values
('luke'),('yoda'),('anakin'),('leia'),('r2'),('obi'),('han') ;
insert into test_nkomp_admin (host_id,admin_id) values
(1,'luke'),(1,'yoda'),(1,'anakin'),(1,'leia'),(1,'r2'),(1,'o bi'),(1,'han');
insert into test_nkomp_admin (host_id,admin_id) values
(2,'luke'),(2,'yoda'),(2,'anakin'),(2,'leia'),(2,'r2'),(2,'o bi');
insert into test_nkomp_admin (host_id,admin_id) values
(3,'luke'),(3,'yoda'),(3,'anakin'),(3,'leia'),(3,'r2');
insert into test_nkomp_admin (host_id,admin_id) values
(4,'luke'),(4,'yoda'),(4,'anakin'),(4,'leia');
insert into test_nkomp_admin (host_id,admin_id) values
(5,'luke'),(5,'yoda'),(5,'anakin');
insert into test_nkomp_admin (host_id,admin_id) values
(6,'luke'),(6,'yoda');
cheers
gregor
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/mysql?unsub=gcdmg-mysql-2@m.gmane.org
RE: strange behavior in mysql-server 5.1.49 and 5.1.51
am 28.10.2010 15:34:32 von misiaQ
Works fine on 5.0.87 (rows returned as expected).
Confirmed on 5.1.51-log.
Most likely problem with VARCHAR behavior, because this one works fine:
select * from test_nkomp_admin where host_id=6 and trim(admin_id)='luke';
Regards,
m
-----Original Message-----
From: gregor kling [mailto:gregor.kling@dvz.fh-giessen.de]
Sent: Thursday, October 28, 2010 1:54 PM
To: mysql@lists.mysql.com
Subject: strange behavior in mysql-server 5.1.49 and 5.1.51
Hello list,
I fight a strange behavior in mysql versions 5.1.49 and 5.1.51 -
maybe a fight against myself ;-)
The following query works exactly as assumed in version 5.1.41 with
the given testbed:
select * from test_nkomp_admin where host_id=6 and admin_id="yoda";
/* version 5.1.41 ubuntu 10.04 */
mysql> select * from test_nkomp_admin where host_id=6 and
admin_id="yoda" ;
+---------+----------+
| host_id | admin_id |
+---------+----------+
| 6 | yoda |
+---------+----------+
1 row in set (0.00 sec)
whereas in versions 5.1.49 (ubuntu 10.10) and 5.1.51 (package from
debian experimental,os ubuntu 10.10) the resultset is:
mysql> select * from test_nkomp_admin where host_id=6 and
admin_id="yoda" ;
Empty set (0.00 sec)
prove:
select * from test_nkomp_admin where host_id=6 ;
+---------+----------+
| host_id | admin_id |
+---------+----------+
| 6 | luke |
| 6 | yoda |
+---------+----------+
2 rows in set (0.00 sec)
Could anyone prove this behavior, or can give hint what the problem
might be ?
/* testbed */
drop table if exists test_nkomp_admin;
drop table if exists test_nkomp;
drop table if exists test_admin;
create table test_nkomp
(
host_id int unsigned auto_increment not null primary key
)engine=innodb;
create table test_admin
(
admin_id varchar(15) not null primary key
)engine=innodb;
create table test_nkomp_admin
(
host_id int unsigned,
admin_id varchar(15),
foreign key (host_id) references test_nkomp (host_id) on delete
cascade on update cascade,
foreign key (admin_id) references test_admin (admin_id) on delete
cascade on update cascade
)engine=innodb;
insert into test_nkomp (host_id) values (1),(2),(3),(4),(5),(6);
insert into test_admin (admin_id) values
('luke'),('yoda'),('anakin'),('leia'),('r2'),('obi'),('han') ;
insert into test_nkomp_admin (host_id,admin_id) values
(1,'luke'),(1,'yoda'),(1,'anakin'),(1,'leia'),(1,'r2'),(1,'o bi'),(1,'han');
insert into test_nkomp_admin (host_id,admin_id) values
(2,'luke'),(2,'yoda'),(2,'anakin'),(2,'leia'),(2,'r2'),(2,'o bi');
insert into test_nkomp_admin (host_id,admin_id) values
(3,'luke'),(3,'yoda'),(3,'anakin'),(3,'leia'),(3,'r2');
insert into test_nkomp_admin (host_id,admin_id) values
(4,'luke'),(4,'yoda'),(4,'anakin'),(4,'leia');
insert into test_nkomp_admin (host_id,admin_id) values
(5,'luke'),(5,'yoda'),(5,'anakin');
insert into test_nkomp_admin (host_id,admin_id) values
(6,'luke'),(6,'yoda');
cheers
gregor
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/mysql?unsub=misiaq@poczta.fm
------------------------------------------------------------ ---
Pobierz slownik angielsko-polski na telefon!
Kliknij >>> http://linkint.pl/f2839
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/mysql?unsub=gcdmg-mysql-2@m.gmane.org
Re: strange behavior in mysql-server 5.1.49 and 5.1.51
am 28.10.2010 16:43:16 von Gregor Kling
On 10/28/2010 03:34 PM, misiaQ wrote:
> Works fine on 5.0.87 (rows returned as expected).
>
> Confirmed on 5.1.51-log.
>
> Most likely problem with VARCHAR behavior, because this one works fine:
> select * from test_nkomp_admin where host_id=6 and trim(admin_id)='luke';
>
The thing with the varchar was also my first guess, what could be wrong
after dumping the database.
So I tested it like this (just to be sure not having whitespaces in the
data):
mysql> select * into outfile "/tmp/out.txt" fields enclosed by "'" from
test_nkomp_admin where host_id=6;
Query OK, 2 rows affected (0.00 sec)
shell> cat /tmp/out.txt
'6' 'luke'
'6' 'yoda'
yes, this one works also for me.
And this one:
mysql> select * from test_nkomp_admin where host_id=6 and admin_id like
'luke%';
+---------+----------+
| host_id | admin_id |
+---------+----------+
| 6 | luke |
+---------+----------+
1 row in set (0.00 sec)
And this one:
mysql> select * from test_nkomp_admin where host_id=6 and admin_id like
'%luke';
+---------+----------+
| host_id | admin_id |
+---------+----------+
| 6 | luke |
+---------+----------+
1 row in set (0.00 sec)
But not this one:
mysql> select * from test_nkomp_admin where host_id=6 and admin_id like
'luke';
Empty set (0.00 sec)
So I guess, I should bag a bugreport ...
cheers
gregor
> Regards,
> m
>
> -----Original Message-----
> From: gregor kling [mailto:gregor.kling@dvz.fh-giessen.de]
> Sent: Thursday, October 28, 2010 1:54 PM
> To: mysql@lists.mysql.com
> Subject: strange behavior in mysql-server 5.1.49 and 5.1.51
>
> Hello list,
> I fight a strange behavior in mysql versions 5.1.49 and 5.1.51 -
> maybe a fight against myself ;-)
>
> The following query works exactly as assumed in version 5.1.41 with
> the given testbed:
> select * from test_nkomp_admin where host_id=6 and admin_id="yoda";
>
> /* version 5.1.41 ubuntu 10.04 */
> mysql> select * from test_nkomp_admin where host_id=6 and
> admin_id="yoda" ;
> +---------+----------+
> | host_id | admin_id |
> +---------+----------+
> | 6 | yoda |
> +---------+----------+
> 1 row in set (0.00 sec)
>
> whereas in versions 5.1.49 (ubuntu 10.10) and 5.1.51 (package from
> debian experimental,os ubuntu 10.10) the resultset is:
> mysql> select * from test_nkomp_admin where host_id=6 and
> admin_id="yoda" ;
> Empty set (0.00 sec)
>
> prove:
> select * from test_nkomp_admin where host_id=6 ;
> +---------+----------+
> | host_id | admin_id |
> +---------+----------+
> | 6 | luke |
> | 6 | yoda |
> +---------+----------+
> 2 rows in set (0.00 sec)
>
> Could anyone prove this behavior, or can give hint what the problem
> might be ?
>
>
> /* testbed */
> drop table if exists test_nkomp_admin;
> drop table if exists test_nkomp;
> drop table if exists test_admin;
>
> create table test_nkomp
> (
> host_id int unsigned auto_increment not null primary key
> )engine=innodb;
>
> create table test_admin
> (
> admin_id varchar(15) not null primary key
> )engine=innodb;
>
> create table test_nkomp_admin
> (
> host_id int unsigned,
> admin_id varchar(15),
> foreign key (host_id) references test_nkomp (host_id) on delete
> cascade on update cascade,
> foreign key (admin_id) references test_admin (admin_id) on delete
> cascade on update cascade
>
> )engine=innodb;
>
> insert into test_nkomp (host_id) values (1),(2),(3),(4),(5),(6);
>
> insert into test_admin (admin_id) values
> ('luke'),('yoda'),('anakin'),('leia'),('r2'),('obi'),('han') ;
>
> insert into test_nkomp_admin (host_id,admin_id) values
> (1,'luke'),(1,'yoda'),(1,'anakin'),(1,'leia'),(1,'r2'),(1,'o bi'),(1,'han');
>
> insert into test_nkomp_admin (host_id,admin_id) values
> (2,'luke'),(2,'yoda'),(2,'anakin'),(2,'leia'),(2,'r2'),(2,'o bi');
>
> insert into test_nkomp_admin (host_id,admin_id) values
> (3,'luke'),(3,'yoda'),(3,'anakin'),(3,'leia'),(3,'r2');
>
> insert into test_nkomp_admin (host_id,admin_id) values
> (4,'luke'),(4,'yoda'),(4,'anakin'),(4,'leia');
>
> insert into test_nkomp_admin (host_id,admin_id) values
> (5,'luke'),(5,'yoda'),(5,'anakin');
>
> insert into test_nkomp_admin (host_id,admin_id) values
> (6,'luke'),(6,'yoda');
>
> cheers
> gregor
>
>
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/mysql?unsub=gcdmg-mysql-2@m.gmane.org
RE: strange behavior in mysql-server 5.1.49 and 5.1.51
am 28.10.2010 17:18:25 von misiaQ
Some more testing performed and it seems like problem with foreign key
reference indexing, see below:
create table test_nkomp_admin2
(
host_id int unsigned,
admin_id varchar(15),
foreign key (host_id) references test_nkomp (host_id) on delete
cascade on update cascade
)engine=innodb;
create table test_nkomp_admin3
(
host_id int unsigned,
admin_id varchar(15)
)engine=myisam;
insert into test_nkomp_admin2 (host_id,admin_id) values
(1,'luke'),(1,'yoda'),(1,'anakin'),(1,'leia'),(1,'r2'),(1,'o bi'),(1,'han');
insert into test_nkomp_admin2 (host_id,admin_id) values
(2,'luke'),(2,'yoda'),(2,'anakin'),(2,'leia'),(2,'r2'),(2,'o bi');
insert into test_nkomp_admin2 (host_id,admin_id) values
(3,'luke'),(3,'yoda'),(3,'anakin'),(3,'leia'),(3,'r2');
insert into test_nkomp_admin2 (host_id,admin_id) values
(4,'luke'),(4,'yoda'),(4,'anakin'),(4,'leia');
insert into test_nkomp_admin2 (host_id,admin_id) values
(5,'luke'),(5,'yoda'),(5,'anakin');
insert into test_nkomp_admin2 (host_id,admin_id) values
(6,'luke'),(6,'yoda');
insert into test_nkomp_admin3 (host_id,admin_id) values
(1,'luke'),(1,'yoda'),(1,'anakin'),(1,'leia'),(1,'r2'),(1,'o bi'),(1,'han');
insert into test_nkomp_admin3 (host_id,admin_id) values
(2,'luke'),(2,'yoda'),(2,'anakin'),(2,'leia'),(2,'r2'),(2,'o bi');
insert into test_nkomp_admin3 (host_id,admin_id) values
(3,'luke'),(3,'yoda'),(3,'anakin'),(3,'leia'),(3,'r2');
insert into test_nkomp_admin3 (host_id,admin_id) values
(4,'luke'),(4,'yoda'),(4,'anakin'),(4,'leia');
insert into test_nkomp_admin3 (host_id,admin_id) values
(5,'luke'),(5,'yoda'),(5,'anakin');
insert into test_nkomp_admin3 (host_id,admin_id) values
(6,'luke'),(6,'yoda');
mysql> select * from test_nkomp_admin where host_id=6 and admin_id="yoda" ;
Empty set (0,00 sec)
mysql> select * from test_nkomp_admin2 where host_id=6 and admin_id="yoda" ;
+---------+----------+
| host_id | admin_id |
+---------+----------+
| 6 | yoda |
+---------+----------+
1 row in set (0,00 sec)
mysql> select * from test_nkomp_admin3 where host_id=6 and admin_id="yoda" ;
+---------+----------+
| host_id | admin_id |
+---------+----------+
| 6 | yoda |
+---------+----------+
1 row in set (0,00 sec)
Regards,
m
-----Original Message-----
From: gregor kling [mailto:gregor.kling@dvz.fh-giessen.de]
Sent: Thursday, October 28, 2010 1:54 PM
To: mysql@lists.mysql.com
Subject: strange behavior in mysql-server 5.1.49 and 5.1.51
Hello list,
I fight a strange behavior in mysql versions 5.1.49 and 5.1.51 -
maybe a fight against myself ;-)
The following query works exactly as assumed in version 5.1.41 with
the given testbed:
select * from test_nkomp_admin where host_id=6 and admin_id="yoda";
/* version 5.1.41 ubuntu 10.04 */
mysql> select * from test_nkomp_admin where host_id=6 and
admin_id="yoda" ;
+---------+----------+
| host_id | admin_id |
+---------+----------+
| 6 | yoda |
+---------+----------+
1 row in set (0.00 sec)
whereas in versions 5.1.49 (ubuntu 10.10) and 5.1.51 (package from
debian experimental,os ubuntu 10.10) the resultset is:
mysql> select * from test_nkomp_admin where host_id=6 and
admin_id="yoda" ;
Empty set (0.00 sec)
prove:
select * from test_nkomp_admin where host_id=6 ;
+---------+----------+
| host_id | admin_id |
+---------+----------+
| 6 | luke |
| 6 | yoda |
+---------+----------+
2 rows in set (0.00 sec)
Could anyone prove this behavior, or can give hint what the problem
might be ?
/* testbed */
drop table if exists test_nkomp_admin;
drop table if exists test_nkomp;
drop table if exists test_admin;
create table test_nkomp
(
host_id int unsigned auto_increment not null primary key
)engine=innodb;
create table test_admin
(
admin_id varchar(15) not null primary key
)engine=innodb;
create table test_nkomp_admin
(
host_id int unsigned,
admin_id varchar(15),
foreign key (host_id) references test_nkomp (host_id) on delete
cascade on update cascade,
foreign key (admin_id) references test_admin (admin_id) on delete
cascade on update cascade
)engine=innodb;
insert into test_nkomp (host_id) values (1),(2),(3),(4),(5),(6);
insert into test_admin (admin_id) values
('luke'),('yoda'),('anakin'),('leia'),('r2'),('obi'),('han') ;
insert into test_nkomp_admin (host_id,admin_id) values
(1,'luke'),(1,'yoda'),(1,'anakin'),(1,'leia'),(1,'r2'),(1,'o bi'),(1,'han');
insert into test_nkomp_admin (host_id,admin_id) values
(2,'luke'),(2,'yoda'),(2,'anakin'),(2,'leia'),(2,'r2'),(2,'o bi');
insert into test_nkomp_admin (host_id,admin_id) values
(3,'luke'),(3,'yoda'),(3,'anakin'),(3,'leia'),(3,'r2');
insert into test_nkomp_admin (host_id,admin_id) values
(4,'luke'),(4,'yoda'),(4,'anakin'),(4,'leia');
insert into test_nkomp_admin (host_id,admin_id) values
(5,'luke'),(5,'yoda'),(5,'anakin');
insert into test_nkomp_admin (host_id,admin_id) values
(6,'luke'),(6,'yoda');
cheers
gregor
------------------------------------------------------
Mieszkania, domy, dzialki - najlepsze oferty!
http://linkint.pl/f281e
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/mysql?unsub=gcdmg-mysql-2@m.gmane.org
Re: strange behavior in mysql-server 5.1.49 and 5.1.51
am 29.10.2010 08:27:41 von Gregor Kling
--------------ms060103060305090509060109
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: quoted-printable
Hello,
There must have been some changes in the default interpretation=20
respective to foreign key attributes....
If I add explicitly 'not null' to the columns host_id and admin_id=20
in test_nkomp_admin, it works like intended:
create table test_nkomp_admin
(
host_id int unsigned not null,
admin_id varchar(15) not null,
foreign key (host_id) references test_nkomp (host_id) on delete=20
cascade on update cascade,
foreign key (admin_id) references test_admin (admin_id) on delete=20
cascade on update cascade
)engine=3Dinnodb;
cheers
gregor
On 28.10.2010 17:18, misiaQ wrote:
> Some more testing performed and it seems like problem with foreign key
> reference indexing, see below:
>
> create table test_nkomp_admin2
> (
> host_id int unsigned,
> admin_id varchar(15),
> foreign key (host_id) references test_nkomp (host_id) on delete
> cascade on update cascade
>
> )engine=3Dinnodb;
>
> create table test_nkomp_admin3
> (
> host_id int unsigned,
> admin_id varchar(15)
>
> )engine=3Dmyisam;
>
>
> insert into test_nkomp_admin2 (host_id,admin_id) values
> (1,'luke'),(1,'yoda'),(1,'anakin'),(1,'leia'),(1,'r2'),(1,'o bi'),(1,'ha=
n');
> insert into test_nkomp_admin2 (host_id,admin_id) values
> (2,'luke'),(2,'yoda'),(2,'anakin'),(2,'leia'),(2,'r2'),(2,'o bi');
> insert into test_nkomp_admin2 (host_id,admin_id) values
> (3,'luke'),(3,'yoda'),(3,'anakin'),(3,'leia'),(3,'r2');
> insert into test_nkomp_admin2 (host_id,admin_id) values
> (4,'luke'),(4,'yoda'),(4,'anakin'),(4,'leia');
> insert into test_nkomp_admin2 (host_id,admin_id) values
> (5,'luke'),(5,'yoda'),(5,'anakin');
> insert into test_nkomp_admin2 (host_id,admin_id) values
> (6,'luke'),(6,'yoda');
> insert into test_nkomp_admin3 (host_id,admin_id) values
> (1,'luke'),(1,'yoda'),(1,'anakin'),(1,'leia'),(1,'r2'),(1,'o bi'),(1,'ha=
n');
> insert into test_nkomp_admin3 (host_id,admin_id) values
> (2,'luke'),(2,'yoda'),(2,'anakin'),(2,'leia'),(2,'r2'),(2,'o bi');
> insert into test_nkomp_admin3 (host_id,admin_id) values
> (3,'luke'),(3,'yoda'),(3,'anakin'),(3,'leia'),(3,'r2');
> insert into test_nkomp_admin3 (host_id,admin_id) values
> (4,'luke'),(4,'yoda'),(4,'anakin'),(4,'leia');
> insert into test_nkomp_admin3 (host_id,admin_id) values
> (5,'luke'),(5,'yoda'),(5,'anakin');
> insert into test_nkomp_admin3 (host_id,admin_id) values
> (6,'luke'),(6,'yoda');
>
> mysql> select * from test_nkomp_admin where host_id=3D6 and admin_id=3D=
"yoda" ;
> Empty set (0,00 sec)
>
> mysql> select * from test_nkomp_admin2 where host_id=3D6 and admin_id=3D=
"yoda" ;
> +---------+----------+
> | host_id | admin_id |
> +---------+----------+
> | 6 | yoda |
> +---------+----------+
> 1 row in set (0,00 sec)
>
> mysql> select * from test_nkomp_admin3 where host_id=3D6 and admin_id=3D=
"yoda" ;
> +---------+----------+
> | host_id | admin_id |
> +---------+----------+
> | 6 | yoda |
> +---------+----------+
> 1 row in set (0,00 sec)
>
> Regards,
> m
>
> -----Original Message-----
> From: gregor kling [mailto:gregor.kling@dvz.fh-giessen.de]
> Sent: Thursday, October 28, 2010 1:54 PM
> To: mysql@lists.mysql.com
> Subject: strange behavior in mysql-server 5.1.49 and 5.1.51
>
> Hello list,
> I fight a strange behavior in mysql versions 5.1.49 and 5.1.51 -
> maybe a fight against myself ;-)
>
> The following query works exactly as assumed in version 5.1.41 with
> the given testbed:
> select * from test_nkomp_admin where host_id=3D6 and admin_id=3D"yod=
a";
>
> /* version 5.1.41 ubuntu 10.04 */
> mysql> select * from test_nkomp_admin where host_id=3D6 and
> admin_id=3D"yoda" ;
> +---------+----------+
> | host_id | admin_id |
> +---------+----------+
> | 6 | yoda |
> +---------+----------+
> 1 row in set (0.00 sec)
>
> whereas in versions 5.1.49 (ubuntu 10.10) and 5.1.51 (package from
> debian experimental,os ubuntu 10.10) the resultset is:
> mysql> select * from test_nkomp_admin where host_id=3D6 and
> admin_id=3D"yoda" ;
> Empty set (0.00 sec)
>
> prove:
> select * from test_nkomp_admin where host_id=3D6 ;
> +---------+----------+
> | host_id | admin_id |
> +---------+----------+
> | 6 | luke |
> | 6 | yoda |
> +---------+----------+
> 2 rows in set (0.00 sec)
>
> Could anyone prove this behavior, or can give hint what the problem
> might be ?
>
>
> /* testbed */
> drop table if exists test_nkomp_admin;
> drop table if exists test_nkomp;
> drop table if exists test_admin;
>
> create table test_nkomp
> (
> host_id int unsigned auto_increment not null primary key
> )engine=3Dinnodb;
>
> create table test_admin
> (
> admin_id varchar(15) not null primary key
> )engine=3Dinnodb;
>
> create table test_nkomp_admin
> (
> host_id int unsigned,
> admin_id varchar(15),
> foreign key (host_id) references test_nkomp (host_id) on delete
> cascade on update cascade,
> foreign key (admin_id) references test_admin (admin_id) on delete
> cascade on update cascade
>
> )engine=3Dinnodb;
>
> insert into test_nkomp (host_id) values (1),(2),(3),(4),(5),(6);
>
> insert into test_admin (admin_id) values
> ('luke'),('yoda'),('anakin'),('leia'),('r2'),('obi'),('han') ;
>
> insert into test_nkomp_admin (host_id,admin_id) values
> (1,'luke'),(1,'yoda'),(1,'anakin'),(1,'leia'),(1,'r2'),(1,'o bi'),(1,'ha=
n');
>
> insert into test_nkomp_admin (host_id,admin_id) values
> (2,'luke'),(2,'yoda'),(2,'anakin'),(2,'leia'),(2,'r2'),(2,'o bi');
>
> insert into test_nkomp_admin (host_id,admin_id) values
> (3,'luke'),(3,'yoda'),(3,'anakin'),(3,'leia'),(3,'r2');
>
> insert into test_nkomp_admin (host_id,admin_id) values
> (4,'luke'),(4,'yoda'),(4,'anakin'),(4,'leia');
>
> insert into test_nkomp_admin (host_id,admin_id) values
> (5,'luke'),(5,'yoda'),(5,'anakin');
>
> insert into test_nkomp_admin (host_id,admin_id) values
> (6,'luke'),(6,'yoda');
>
> cheers
> gregor
>
>
> ------------------------------------------------------
> Mieszkania, domy, dzialki - najlepsze oferty!
> http://linkint.pl/f281e
>
>
--=20
Gregor Kling
Abteilung ITS, Sachgebiet DVZ
Fachhochschule Giessen
Tel: 0641/309-1292
E-Mail: gregor.kling@its.fh-giessen.de
--------------ms060103060305090509060109
Content-Type: application/pkcs7-signature; name="smime.p7s"
Content-Transfer-Encoding: base64
Content-Disposition: attachment; filename="smime.p7s"
Content-Description: S/MIME Cryptographic Signature
MIAGCSqGSIb3DQEHAqCAMIACAQExCzAJBgUrDgMCGgUAMIAGCSqGSIb3DQEH AQAAoIIT6DCC
BCEwggMJoAMCAQICAgDHMA0GCSqGSIb3DQEBBQUAMHExCzAJBgNVBAYTAkRF MRwwGgYDVQQK
ExNEZXV0c2NoZSBUZWxla29tIEFHMR8wHQYDVQQLExZULVRlbGVTZWMgVHJ1 c3QgQ2VudGVy
MSMwIQYDVQQDExpEZXV0c2NoZSBUZWxla29tIFJvb3QgQ0EgMjAeFw0wNjEy MTkxMDI5MDBa
Fw0xOTA2MzAyMzU5MDBaMFoxCzAJBgNVBAYTAkRFMRMwEQYDVQQKEwpERk4t VmVyZWluMRAw
DgYDVQQLEwdERk4tUEtJMSQwIgYDVQQDExtERk4tVmVyZWluIFBDQSBHbG9i YWwgLSBHMDEw
ggEiMA0GCSqGSIb3DQEBAQUAA4IBDwAwggEKAoIBAQDpm8NnhfkNrvWNVMOW UDU9YuluTO2U
1wBblSJ01CDrNI/W7MAxBAuZgeKmFNJSoCgjhIt0iQReW+DieMF4yxbLKDU5 ey2QRdDtoAB6
fL9KDhsAw4bpXCsxEXsM84IkQ4wcOItqaACa7txPeKvSxhObdq3u3ibo7wGv dA/BCaL2a869
080UME/15eOkyGKbghoDJzANAmVgTe3RCSMqljVYJ9N2xnG2kB3E7f81hn1v M7PbD8URwoqD
oZRdQWvY0hD1TP3KUazZve+Sg7va64sWVlZDz+HVEz2mHycwzUlU28kTNJpx dcVs6qcLmPkh
nSevPqM5OUhqjK3JmfvDEvK9AgMBAAGjgdkwgdYwcAYDVR0fBGkwZzBloGOg YYZfaHR0cDov
L3BraS50ZWxlc2VjLmRlL2NnaS1iaW4vc2VydmljZS9hZl9Eb3dubG9hZEFS TC5jcmw/LWNy
bF9mb3JtYXQ9WF81MDkmLWlzc3Vlcj1EVF9ST09UX0NBXzIwHQYDVR0OBBYE FEm3xs/oPR9/
6kR7Eyn38QpwPt5kMB8GA1UdIwQYMBaAFDHDeRu69VPXF+CJei0XbAqzK50z MA4GA1UdDwEB
/wQEAwIBBjASBgNVHRMBAf8ECDAGAQH/AgECMA0GCSqGSIb3DQEBBQUAA4IB AQA74Vp3wEgX
3KkY7IGvWonwvSiSpspZGBJw7Cjy565/lizn8l0ZMfYTK3S9vYCyufdnyTmi eTvhERHua3iR
M347XyYndVNljjNj7s9zw7CSI0khUHUjoR8Y4pSFPT8z6XcgjaK95qGFKUD2 P3MyWA0Ja6ba
hWzAP7uNZmRWJE6uDT8yNQFb6YyC2XJZT7GGhfF0hVblw/hc843uR7NTBXDn 5U2KaYMo4RMJ
hp5eyOpYHgwf+aTUWgRo/Sg+iwK2WLX2oSw3VwBnqyNojWOl75lrXP1LVvar QIc01BGSbOyH
xQoLBzNytG8MHVQs2FHHzL8w00Ny8TK/jM5JY6gA9/IcMIIFIzCCBAugAwIB AgIECgyxjDAN
BgkqhkiG9w0BAQUFADBaMQswCQYDVQQGEwJERTETMBEGA1UEChMKREZOLVZl cmVpbjEQMA4G
A1UECxMHREZOLVBLSTEkMCIGA1UEAxMbREZOLVZlcmVpbiBQQ0EgR2xvYmFs IC0gRzAxMB4X
DTA3MDMwNjA5MjcyNVoXDTE5MDMwNTAwMDAwMFowgZMxCzAJBgNVBAYTAkRF MSkwJwYDVQQK
EyBGYWNoaG9jaHNjaHVsZSBHaWVzc2VuLUZyaWVkYmVyZzEyMDAGA1UEAxMp RmFjaGhvY2hz
Y2h1bGUgR2llc3Nlbi1GcmllZGJlcmcgQ0EgLSBHMDIxJTAjBgkqhkiG9w0B CQEWFnBraS1n
aWZiQGZoLWdpZXNzZW4uZGUwggEiMA0GCSqGSIb3DQEBAQUAA4IBDwAwggEK AoIBAQCygDTi
dhueigLG6vjJ69H+k0+5MLR0vOKY+u4AP9e7/peyx+6M42+dB9ghmkbqVHw9 G9q89Dd5hpWy
wyJ7AAeOSyG4liWgD1jJFeEsIUYC9X/x95hnBlVT+TKJDLjYxlLl1OyMQc/1 22nG8j1ScjPZ
R5e4UkyDaUmFdtr66x3Ak3MEmWqYm7JqjGdl6xYQQzCIe5LWT50eTm1LBJpM jsDYsJ9doZBg
bmqAp0UYG9uixWadtKuLBfyCzknitSO0ddD03/MfSunNWLCEL52uaCFobTN8 jWJLdEZMN30W
jCM9II/Ych2XaI1J/18Nkd+BpZ2yaFivTjICEFosTzdAJNFrAgMBAAGjggG1 MIIBsTAPBgNV
HRMBAf8EBTADAQH/MAsGA1UdDwQEAwIBBjAdBgNVHQ4EFgQUNNRCwZOju1ds DHfufJUfRkOv
MNYwHwYDVR0jBBgwFoAUSbfGz+g9H3/qRHsTKffxCnA+3mQwIQYDVR0RBBow GIEWcGtpLWdp
ZmJAZmgtZ2llc3Nlbi5kZTCBiAYDVR0fBIGAMH4wPaA7oDmGN2h0dHA6Ly9j ZHAxLnBjYS5k
Zm4uZGUvZ2xvYmFsLXJvb3QtY2EvcHViL2NybC9jYWNybC5jcmwwPaA7oDmG N2h0dHA6Ly9j
ZHAyLnBjYS5kZm4uZGUvZ2xvYmFsLXJvb3QtY2EvcHViL2NybC9jYWNybC5j cmwwgaIGCCsG
AQUFBwEBBIGVMIGSMEcGCCsGAQUFBzAChjtodHRwOi8vY2RwMS5wY2EuZGZu LmRlL2dsb2Jh
bC1yb290LWNhL3B1Yi9jYWNlcnQvY2FjZXJ0LmNydDBHBggrBgEFBQcwAoY7 aHR0cDovL2Nk
cDIucGNhLmRmbi5kZS9nbG9iYWwtcm9vdC1jYS9wdWIvY2FjZXJ0L2NhY2Vy dC5jcnQwDQYJ
KoZIhvcNAQEFBQADggEBABzXcs18pyD/UGNoGaWOxOi6SPJrYY284sQgECHt MhHQRkBAsDdT
XwGcL9a+pvNui1l0MXWaoBro7HgPqggxzQqql6H1hjQljBLHG3aU4qiSuFjc 8ZOBU9sSC13k
ncdqRAKw+bOozj8loRiBHKGh9Oj1KbBlMHWzg01d17WXwAz6j40RWltTvJRH cUo2DW8tGqML
yizhH30zKPeemaiT1sBDN06X90VMLQNTmEQ/S/erfqJJaOq31r8w2iQW6IsC 0y7kWn5lQAAQ
niPDEpmtB8xdo4tOmqUiWlgC1kdTxKnyl7IqrJGjgPBji3L5JZ4ChhEneR6m L8edjrHPjd+X
nAUwggVKMIIEMqADAgECAgQPtsSKMA0GCSqGSIb3DQEBBQUAMIGTMQswCQYD VQQGEwJERTEp
MCcGA1UEChMgRmFjaGhvY2hzY2h1bGUgR2llc3Nlbi1GcmllZGJlcmcxMjAw BgNVBAMTKUZh
Y2hob2Noc2NodWxlIEdpZXNzZW4tRnJpZWRiZXJnIENBIC0gRzAyMSUwIwYJ KoZIhvcNAQkB
FhZwa2ktZ2lmYkBmaC1naWVzc2VuLmRlMB4XDTEwMDMxMDA3MTUwNloXDTEz MDMwOTA3MTUw
NlowXTELMAkGA1UEBhMCREUxKTAnBgNVBAoTIEZhY2hob2Noc2NodWxlIEdp ZXNzZW4tRnJp
ZWRiZXJnMQwwCgYDVQQLEwNJVFMxFTATBgNVBAMTDEdyZWdvciBLbGluZzCC ASIwDQYJKoZI
hvcNAQEBBQADggEPADCCAQoCggEBANTzpn14JWYlB939ADEo0yFkyyLFedzi nOukj+CRVMDy
Ue8WJaGUC5kp6I0ej6J2BirbRxyRGOK9Xo12ycD6wGUT7oPsQjzdi5OOSHm3 HNAFsBIiVPzu
Mnvgy0plm05BfaG3Rv45ZZU+FePkx/QgpXxSJAwFU5p/LQtppmgVpawwyjf/ 7QQ3xyRLtdi9
a4aCvYk6qYjTuC3dDF62YwtejNBVyx84KpgI2egKy8+hGWLgjDmn2ksjWiGU 8L5rFCocCOWv
ccps7cKCoeU/uwelSzVBiEihyrr/UX40kmywJDFOAvYCDxbFUhbdKL4S40Rz sC/kLEe4ZVco
PVkV+eqsMScCAwEAAaOCAdkwggHVMAkGA1UdEwQCMAAwCwYDVR0PBAQDAgXg MCkGA1UdJQQi
MCAGCCsGAQUFBwMCBggrBgEFBQcDBAYKKwYBBAGCNxQCAjAdBgNVHQ4EFgQU /ZNDzfTKH0jg
xorUIOx2P/Iajb8wHwYDVR0jBBgwFoAUNNRCwZOju1dsDHfufJUfRkOvMNYw KQYDVR0RBCIw
IIEeZ3JlZ29yLmtsaW5nQGl0cy5maC1naWVzc2VuLmRlMIGDBgNVHR8EfDB6 MDugOaA3hjVo
dHRwOi8vY2RwMS5wY2EuZGZuLmRlL2ZoLWdpZmItY2EvcHViL2NybC9nX2Nh Y3JsLmNybDA7
oDmgN4Y1aHR0cDovL2NkcDIucGNhLmRmbi5kZS9maC1naWZiLWNhL3B1Yi9j cmwvZ19jYWNy
bC5jcmwwgZ4GCCsGAQUFBwEBBIGRMIGOMEUGCCsGAQUFBzAChjlodHRwOi8v Y2RwMS5wY2Eu
ZGZuLmRlL2ZoLWdpZmItY2EvcHViL2NhY2VydC9nX2NhY2VydC5jcnQwRQYI KwYBBQUHMAKG
OWh0dHA6Ly9jZHAyLnBjYS5kZm4uZGUvZmgtZ2lmYi1jYS9wdWIvY2FjZXJ0 L2dfY2FjZXJ0
LmNydDANBgkqhkiG9w0BAQUFAAOCAQEAiqWlVTOLpaW+kAWC8CLjKok5sRG1 OVGYLhZ4JAHf
P3kZo17Kqxvru3AFDGeT/LM0vwfaHyFyPAhp61VhNlg0PE6RLjzsEX9czF9q uX+++/YI2YJb
pZEqdGfkIIKSTcXQyy7kaexA20aChp9loW+eG1zE3eQXC5A1UQ3Sr4UFNzhX lsbqIWhS0VZb
uMTn95PJxctkBAOKfZTg4qpYHpyPGWFZW0ryHJV08v5IncazYCKSFfc0nARM z95SnJD9lbCq
sgA23Z1CnEsmzi70Q2ex8Zr59HElVh4D2SA7EoUjriHKd4l17ioJbI9cC928 op0XxicuFOnf
TFrJrQgqBK2R0TCCBUowggQyoAMCAQICBA+2xIowDQYJKoZIhvcNAQEFBQAw gZMxCzAJBgNV
BAYTAkRFMSkwJwYDVQQKEyBGYWNoaG9jaHNjaHVsZSBHaWVzc2VuLUZyaWVk YmVyZzEyMDAG
A1UEAxMpRmFjaGhvY2hzY2h1bGUgR2llc3Nlbi1GcmllZGJlcmcgQ0EgLSBH MDIxJTAjBgkq
hkiG9w0BCQEWFnBraS1naWZiQGZoLWdpZXNzZW4uZGUwHhcNMTAwMzEwMDcx NTA2WhcNMTMw
MzA5MDcxNTA2WjBdMQswCQYDVQQGEwJERTEpMCcGA1UEChMgRmFjaGhvY2hz Y2h1bGUgR2ll
c3Nlbi1GcmllZGJlcmcxDDAKBgNVBAsTA0lUUzEVMBMGA1UEAxMMR3JlZ29y IEtsaW5nMIIB
IjANBgkqhkiG9w0BAQEFAAOCAQ8AMIIBCgKCAQEA1POmfXglZiUH3f0AMSjT IWTLIsV53OKc
66SP4JFUwPJR7xYloZQLmSnojR6PonYGKttHHJEY4r1ejXbJwPrAZRPug+xC PN2Lk45Iebcc
0AWwEiJU/O4ye+DLSmWbTkF9obdG/jlllT4V4+TH9CClfFIkDAVTmn8tC2mm aBWlrDDKN//t
BDfHJEu12L1rhoK9iTqpiNO4Ld0MXrZjC16M0FXLHzgqmAjZ6ArLz6EZYuCM OafaSyNaIZTw
vmsUKhwI5a9xymztwoKh5T+7B6VLNUGISKHKuv9RfjSSbLAkMU4C9gIPFsVS Ft0ovhLjRHOw
L+QsR7hlVyg9WRX56qwxJwIDAQABo4IB2TCCAdUwCQYDVR0TBAIwADALBgNV HQ8EBAMCBeAw
KQYDVR0lBCIwIAYIKwYBBQUHAwIGCCsGAQUFBwMEBgorBgEEAYI3FAICMB0G A1UdDgQWBBT9
k0PN9MofSODGitQg7HY/8hqNvzAfBgNVHSMEGDAWgBQ01ELBk6O7V2wMd+58 lR9GQ68w1jAp
BgNVHREEIjAggR5ncmVnb3Iua2xpbmdAaXRzLmZoLWdpZXNzZW4uZGUwgYMG A1UdHwR8MHow
O6A5oDeGNWh0dHA6Ly9jZHAxLnBjYS5kZm4uZGUvZmgtZ2lmYi1jYS9wdWIv Y3JsL2dfY2Fj
cmwuY3JsMDugOaA3hjVodHRwOi8vY2RwMi5wY2EuZGZuLmRlL2ZoLWdpZmIt Y2EvcHViL2Ny
bC9nX2NhY3JsLmNybDCBngYIKwYBBQUHAQEEgZEwgY4wRQYIKwYBBQUHMAKG OWh0dHA6Ly9j
ZHAxLnBjYS5kZm4uZGUvZmgtZ2lmYi1jYS9wdWIvY2FjZXJ0L2dfY2FjZXJ0 LmNydDBFBggr
BgEFBQcwAoY5aHR0cDovL2NkcDIucGNhLmRmbi5kZS9maC1naWZiLWNhL3B1 Yi9jYWNlcnQv
Z19jYWNlcnQuY3J0MA0GCSqGSIb3DQEBBQUAA4IBAQCKpaVVM4ulpb6QBYLw IuMqiTmxEbU5
UZguFngkAd8/eRmjXsqrG+u7cAUMZ5P8szS/B9ofIXI8CGnrVWE2WDQ8TpEu POwRf1zMX2q5
f7779gjZglulkSp0Z+QggpJNxdDLLuRp7EDbRoKGn2Whb54bXMTd5BcLkDVR DdKvhQU3OFeW
xuohaFLRVlu4xOf3k8nFy2QEA4p9lODiqlgenI8ZYVlbSvIclXTy/kidxrNg IpIV9zScBEzP
3lKckP2VsKqyADbdnUKcSybOLvRDZ7Hxmvn0cSVWHgPZIDsShSOuIcp3iXXu Kglsj1wL3byi
nRfGJy4U6d9MWsmtCCoErZHRMYID6DCCA+QCAQEwgZwwgZMxCzAJBgNVBAYT AkRFMSkwJwYD
VQQKEyBGYWNoaG9jaHNjaHVsZSBHaWVzc2VuLUZyaWVkYmVyZzEyMDAGA1UE AxMpRmFjaGhv
Y2hzY2h1bGUgR2llc3Nlbi1GcmllZGJlcmcgQ0EgLSBHMDIxJTAjBgkqhkiG 9w0BCQEWFnBr
aS1naWZiQGZoLWdpZXNzZW4uZGUCBA+2xIowCQYFKw4DAhoFAKCCAiAwGAYJ KoZIhvcNAQkD
MQsGCSqGSIb3DQEHATAcBgkqhkiG9w0BCQUxDxcNMTAxMDI5MDYyNzQyWjAj BgkqhkiG9w0B
CQQxFgQUMcFeK/YgciUfYDvsED2lCS096lkwXwYJKoZIhvcNAQkPMVIwUDAL BglghkgBZQME
AQIwCgYIKoZIhvcNAwcwDgYIKoZIhvcNAwICAgCAMA0GCCqGSIb3DQMCAgFA MAcGBSsOAwIH
MA0GCCqGSIb3DQMCAgEoMIGtBgkrBgEEAYI3EAQxgZ8wgZwwgZMxCzAJBgNV BAYTAkRFMSkw
JwYDVQQKEyBGYWNoaG9jaHNjaHVsZSBHaWVzc2VuLUZyaWVkYmVyZzEyMDAG A1UEAxMpRmFj
aGhvY2hzY2h1bGUgR2llc3Nlbi1GcmllZGJlcmcgQ0EgLSBHMDIxJTAjBgkq hkiG9w0BCQEW
FnBraS1naWZiQGZoLWdpZXNzZW4uZGUCBA+2xIowga8GCyqGSIb3DQEJEAIL MYGfoIGcMIGT
MQswCQYDVQQGEwJERTEpMCcGA1UEChMgRmFjaGhvY2hzY2h1bGUgR2llc3Nl bi1GcmllZGJl
cmcxMjAwBgNVBAMTKUZhY2hob2Noc2NodWxlIEdpZXNzZW4tRnJpZWRiZXJn IENBIC0gRzAy
MSUwIwYJKoZIhvcNAQkBFhZwa2ktZ2lmYkBmaC1naWVzc2VuLmRlAgQPtsSK MA0GCSqGSIb3
DQEBAQUABIIBALjlbd/WVLTxOe7ocA6esaJl9vT6j02hY3M1mIWZ1iAxdwTw 82ueKG6WcWrj
g5ZYtX9n2PP8yVFB8Cpb8jPtoPWhP1yL73sROZmIONT4hq7ToOdL1fFjOHBB PeVn0naZVgMM
eidQTKjFLWsZMo3w6MlOu+iBNEv7dvDXTrhxctvl4T8DIoIA0VcMvJLiSNsD hCiDh1qdLTf1
hwGlh6uUmOIC+pibX90Uk3w3dnNNGYBS0njz7wW9Mz7yhudwb6N5cKM5L1tD 72QQPTkcuY0L
rlTJKK1ttZOByMt/D57RFHr3F81mAWDS+uQOlTJtfCUD7goFnZ45O4y+lVga W3u7300AAAAA
AAA=
--------------ms060103060305090509060109--