MySQL Bugs: #36668: Returned an E

Bug #36668	Returned an E_FAIL status
Submitted:	12 May 2008 14:52	Modified:	12 Jun 2008 18:27
Reporter:	Marcos Felipe Zara Zara	Email Updates:
Status:	No Feedback	Impact on me:	None
Category:	MySQL Server: InnoDB storage engine	Severity:	S3 (Non-critical)
Version:	5.0.45-community-nt	OS:	Windows (XP SP2)
Assigned to:		CPU Architecture:	Any

Description:
Hello,

Its happen 5 times.
I am a using VB6/ODBCConnector. On my application, when I run a select query in a especific line I got the error "Data Provider Return status E_FAIL".
The select is "Select nome, juros from clientes where codigo = 5"

If I run this select in MYSQL.EXE (mysql client for windows) Its return:

mysql> select nome , juros from clientes where codigo = 5 ;
+-------------------------+-----------------+
| nome                    | juros           |
+-------------------------+-----------------+
| MARIA DO CARMO FERRAZ   |  0.659844412E18 |
+-------------------------+-----------------+
1 row in set (0.00 sec)

If I run this select on my application I get the E_FAIL error.

But the value 0.65984412E18 is INVALID! I dont change the value for this row! It's corrupted. 

To solve this problem I run 
UPDATE CLIENTES SET juros = 0 where codigo = 5 ;

And All my problems is solve.
The select query works on my application.

Some days after, the problem occur again , in same row. 
But I dont change the value for this row.
And again I get the E_FAIL error on my aplication and appear a uknow value (0.689845E12) on column 'juros'.
Its sounds like the data in column is corrupting for a unknow reason.

Below, the structure for the table clientes:
mysql> desc clientes;
+----------------+---------------+------+-----+---------+-------+
| Field          | Type          | Null | Key | Default | Extra |
+----------------+---------------+------+-----+---------+-------+
| codigo         | int(11)       | NO   | PRI | 0       |       |
| codigoregistro | int(11)       | YES  |     | 0       |       |
| nome           | varchar(50)   | YES  |     | NULL    |       |
| nomecon        | varchar(50)   | YES  |     | NULL    |       |
| rgcon          | varchar(18)   | YES  |     | NULL    |       |
| cpfcon         | varchar(18)   | YES  |     | NULL    |       |
| endereco       | varchar(50)   | YES  |     | NULL    |       |
| bairro         | varchar(30)   | YES  |     | NULL    |       |
| cidade         | varchar(30)   | YES  |     | NULL    |       |
| cep            | varchar(20)   | YES  |     | NULL    |       |
| estado         | varchar(20)   | YES  |     | NULL    |       |
| rg             | varchar(18)   | YES  |     | NULL    |       |
| cpf            | varchar(18)   | YES  |     | NULL    |       |
| contato        | varchar(30)   | YES  |     | NULL    |       |
| telefone       | varchar(25)   | YES  |     | NULL    |       |
| ddd            | varchar(3)    | YES  |     | NULL    |       |
| fax            | varchar(15)   | YES  |     | NULL    |       |
| datcad         | varchar(15)   | YES  |     | NULL    |       |
| bloqueio       | int(11)       | YES  |     | 0       |       |
| convenio       | int(11)       | YES  |     | 0       |       |
| obs            | varchar(100)  | YES  |     | NULL    |       |
| datanasc       | varchar(15)   | YES  |     | NULL    |       |
| datnasccon     | varchar(15)   | YES  |     | NULL    |       |
| porcantec      | decimal(10,2) | YES  |     | 0.00    |       |
| email          | varchar(30)   | YES  |     | NULL    |       |
| juros          | decimal(10,2) | YES  |     | 0.00    |       |
| tipo           | varchar(25)   | YES  |     | NULL    |       |
| limite         | decimal(10,2) | NO   |     | 0.00    |       |
+----------------+---------------+------+-----+---------+-------+

How to repeat:
I dont have a minimal Idea... Its happen randomize.

Thank you for a problem report. Please, upload the error log (<hostname>.err file in the data subdirectory usually), compressed, to the report. What exact version of Connector/ODBC do you use?

Error File

Attachment: Servidor2003.err (text/plain), 8.00 KiB.

OKs I sent the error file (servidor2003.err)
I am using ODBC 3.51.12-win32

Thank you for the report.

There is "Version: '5.0.15-nt'" in the provided error log file, although you indicated 5.0.45 in the report. There are several bug reports related to DECIMAL column fixed since version 5.0.15. Please upgrade to current version 5.0.51a, try with it and inform us if problem still exists.

OKs. I have 2 clients running the same database(and having same problem).
In one, I will try to upgrade to current version 5.0.51a
and other I changed the field type from DECIMAL to DOUBLE ...

Let's see what's will happen.!

Thank you for the update.

Please upgrade MySQL server, not only clients. We will wait feedback from you.

No feedback was provided for this bug for over a month, so it is
being suspended automatically. If you are able to provide the
information that was originally requested, please do so and change
the status of the bug back to "Open".