After kill mysql daemons and start again ....
mysql> select * from sist_adm;
+----+----------+-------------+-------------------------------+
| id | nombre | so | descripcion |
+----+----------+-------------+-------------------------------+
| 1 | master | AIX 4.2 | Equipo de comunicaciones |
| 2 | zeus | Solaris 2.6 | Sistema de pruebas. |
| 3 | donald | Solaris 2.6 | Sistema de desarrollo |
| 4 | apserver | Solaris 2.6 | Sistema standby de produccion |
+----+----------+-------------+-------------------------------+
4 rows in set (0.00 sec)
mysql> select * from sist_adm where id>1;
+----+----------+-------------+-------------------------------+
| id | nombre | so | descripcion |
+----+----------+-------------+-------------------------------+
| 2 | zeus | Solaris 2.6 | Sistema de pruebas. |
| 3 | donald | Solaris 2.6 | Sistema de desarrollo |
| 4 | apserver | Solaris 2.6 | Sistema standby de produccion |
+----+----------+-------------+-------------------------------+
2 rows in set (0.02 sec)
Thanks.
> -----Mensaje original-----
> De: Diego Zabaleta
> Enviado el: Jueves, 26 de Abril de 2001 06:11 p.m.
> Para: '[EMAIL PROTECTED]'; '[EMAIL PROTECTED]'
> Asunto: A bug ??
>
>
> Look these select statments .... ¿?.
>
> mysql> describe sist_adm;
> +-------------+-------------+------+-----+---------+----------------+
> | Field | Type | Null | Key | Default | Extra |
> +-------------+-------------+------+-----+---------+----------------+
> | id | int(11) | | PRI | NULL | auto_increment |
> | nombre | varchar(30) | YES | MUL | NULL | |
> | so | varchar(30) | YES | | NULL | |
> | descripcion | varchar(50) | YES | | NULL | |
> +-------------+-------------+------+-----+---------+----------------+
> 4 rows in set (0.00 sec)
>
> mysql> select * from sist_adm;
> +----+----------+-------------+-------------------------------+
> | id | nombre | so | descripcion |
> +----+----------+-------------+-------------------------------+
> | 1 | master | AIX 4.2 | Equipo de comunicaciones |
> | 2 | zeus | Solaris 2.6 | Sistema de pruebas. |
> | 3 | donald | Solaris 2.6 | Sistema de desarrollo |
> | 4 | apserver | Solaris 2.6 | Sistema standby de produccion |
> +----+----------+-------------+-------------------------------+
> 4 rows in set (0.00 sec)
>
> mysql> select * from sist_adm where id>1;
> Empty set (0.00 sec)
>
>
> Any idea ???.
>
> MySQL version : 3.23.36
> S.O : LINUX RED Hat 6.2
>
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php