Re: BUG IN MYSQL

Sat, 03 Jan 2004 17:20:05 -0800

Miguel,

miguel solorzano wrote:

At 16:05 3/1/2004 -0700, Richard S. Huntrods wrote:

I've submitted this problem three times now, and been ignored all three times. 


Sorry for this inconvenience but I suggest you in the next time to
use the MySQL's forums for to report bugs instead of the general
list:

<http://www.mysql.com/doc/en/Bug_reports.html>MySQL Manual | 1.7.1.3 How to Report Bugs<http://www.mysql.com/doc/en/Bug_reports.html> or Problems

http://www.mysql.com/doc/en/Bug_reports.html


I guess bugs are simply not popular. Since the problem described below is 100% repeatable, I will now escallate it from "problem with delete/insert" to "BUG IN MYSQL". 


I tested with the latest release package 4.0.17 and verify that your
reported behavior is already fixed. I guess that this case is the
same as reported in the below bug report:

http://bugs.mysql.com/bug.php?id=1397

Thanks for the response. Ugo also replied with a link to the bug database. I checked it (just a moment ago), and found the same bug reported for 4.0.14.

I also checked this problem with my main database on a Solaris box (4.0.5a), and the problem did not occur.

I will upgrade to 4.0.17.

Thanks,

-Richard



Follows the results of your test case:

C:\mysql\bin>mysql -uroot test
Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 1 to server version: 4.0.17-nt

Type 'help;' or '\h' for help. Type '\c' to clear the buffer.

mysql> DROP TABLE IF EXISTS appraised;
Query OK, 0 rows affected (0.12 sec)

mysql> CREATE TABLE appraised (
    -> idNumber int(11) NOT NULL default '0',
    -> indexNo int(11) NOT NULL default '0',
    -> experience int(11) default NULL,
    -> lastused int(11) default NULL,
    -> competence int(11) default NULL,
    -> status int(11) default NULL,
    -> appraiser int(11) default NULL,
    -> comments text,
    -> PRIMARY KEY  (idNumber,indexNo)
    -> ) TYPE=MyISAM;
Query OK, 0 rows affected (0.37 sec)

mysql>
mysql>
mysql> PRINT;
--------------
PRINT
--------------

mysql> DELETE FROM appraised;
Query OK, 0 rows affected (0.01 sec)

mysql> INSERT INTO appraised VALUES (1,1,1,1,1,1,1,'aaa1');
Query OK, 1 row affected (0.01 sec)

mysql> SELECT * FROM appraised;
+----------+---------+------------+----------+------------+--------+-----------+----------+

| idNumber | indexNo | experience | lastused | competence | status | appraiser | comments |
+----------+---------+------------+----------+------------+--------+-----------+----------+

| 1 | 1 | 1 | 1 | 1 | 1 | 1 | aaa1 |
+----------+---------+------------+----------+------------+--------+-----------+----------+

1 row in set (0.00 sec)

mysql> DELETE FROM appraised;
Query OK, 1 row affected (0.01 sec)

C:\mysql\bin>mysqlcheck test
<cut>
test.appraised                                     OK

Thanks you for the bug report.

------------------------------------------------------------------------


---
Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.556 / Virus Database: 348 - Release Date: 26/12/2003




--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:    http://lists.mysql.com/[EMAIL PROTECTED]

Reply via email to