Bug in UNION?

Hello, Try this: mysql> CREATE TABLE a ( id int NOT NULL PRIMARY KEY, des varchar(20) default NULL ); Query OK, 0 rows affected (0.00 sec) mysql> INSERT INTO a VALUES (1,'pepe'),(2,'juan'),(3,'mariano'); Query OK, 3 rows affected (0.00 sec) Registros: 3 Duplicados: 0 Peligros: 0 mysql> se

RE: Foreign Keys and InnoDb in MySQL

Hello, In Case 1, you need to change: "index i_Tb (customerId, carId)" => "index i_Tb (carId, customerId)" or add "index i_carId (carId)" In Case 2, you need : "foreign key (customerId) references customerTb (customerId)" => "foreign key (customerId) references customerTb (cust

Is this a bug in TIMESTAMP?

Hi everybody! I have found following 'bug' in type TIMESTAMP: Welcome to the MySQL monitor. Commands end with ; or \g. Your MySQL connection id is 1279 to server version: 3.23.48-Max-log Type 'help;' or '\h' for help. Type '\c' to clear the buffer. mysql> Create a table with

RE: Is The MySQL Mailing List On Crack?

Yes, I'm getting duplicate messages too. -Mensaje original- De: Jeremy Zawodny [mailto:[EMAIL PROTECTED]] Enviado el: miércoles, 13 de febrero de 2002 2:15 Para: [EMAIL PROTECTED] Asunto: Is The MySQL Mailing List On Crack? I'm getting duplicate messages separated by several hours. Am

where is mysqldumpslow?

>From the manual (section 4.9.5 'The Slow Query Log'): "The slow query log can be used to find queries that take a long time to execute and are thus candidates for optimisation. With a large log, that can become a difficult task. You can pipe the slow query log through the mysqldumpslow command t

RE: What is wrong?

| 4| C| 0 | 5.6 | | 6 | F| 12.3 | NULL | NULL | NULL | NULL | NULL | NULL | 0 | ++--+---+--+--+--+--+--+---+ + It isn't wrong. But with "SUM" function... Jose Ceferino Ortega -Mensaje original- De: Fochtman, Michael [mailto:[EMAIL PROTECTED]]

What is wrong?

I have 2 tables: CREATE TABLE `a` ( `id` varchar(12) NOT NULL default '', `tipo` char(1) default NULL, `valor` double default NULL, PRIMARY KEY (`id`) ) TYPE=InnoDB; CREATE TABLE `b` ( `idA` varchar(12) NOT NULL default '', `idB` varchar(12) NOT NULL default '', `cantidad` int(10) unsigned

RE: Bug in UNIQUE?

NULL is always not equal NULL in SQL, and if this UNIQUE index isn't NOT NULL, then this behavior is right. -Mensaje original- De: Dan Nelson [mailto:[EMAIL PROTECTED]] Enviado el: viernes, 01 de febrero de 2002 6:00 Para: Carsten Gehling CC: Jude Insley; [EMAIL PROTECTED]; Paul DuBois A

RE: UNIQUE in InnoDB

Hi Heikki, I have proven this in MySQL 3.23.47 and I have found a problem with "CHECK TABLE", that reports "error - corrupted table" if there are several NULL's in a UNIQUE index. Happy end of year to all!, José Ceferino Ortega -Mensaje original- Hi! I will change InnoDB so that it all

UNIQUE in InnoDB

I have found a "problem" with UNIQUE in InnoDB. Example: mysql> CREATE TABLE b ( -> idB int(11) NOT NULL auto_increment, -> valor int(11) default NULL, -> PRIMARY KEY (idB), -> UNIQUE KEY valor (valor) -> ) TYPE=MyISAM; Query OK, 0 rows affected (0.00 sec) mysql> IN

RE: redaht 7.1 / AMD K6-2: 4.0 rpm error (illegal instruction)

I have the same problem with RedHat 7.1 (fully updated) and a Pentium. Any answer/solution? -Mensaje original- De: Jean-Luc Fontaine [mailto:[EMAIL PROTECTED]] Enviado el: miercoles, 17 de octubre de 2001 9:33 Para: [EMAIL PROTECTED] Asunto: redaht 7.1 / AMD K6-2: 4.0 rpm error (illegal i