|
Replies:
5
-
Pages:
1
-
Last Post:
Jul 25, 2012 3:45 AM
by: Lukas
|
Threads:
[
Previous
|
Next
]
|
|
Posts:
31
Registered:
4/8/11
|
|
|
|
Error with MySQL - Value '0000-00-00 00:00:00' can not be represented ...
Posted:
Jun 17, 2012 1:13 PM
|
|
|
Hi,
First things first - many thanks for releasing a MySQL-compatible version! I've been hoping that this is will happen even since I started working with Toad for Eclipse.
I've been giving the MySQL integration a shot, and one hiccup that I've noticed is that on some tables when going to the 'Data' tab I will get an error dialog with the text
Value '0000-00-00 00:00:00' can not be represented as java.sql.Timestamp
I can't release the schema or the data, but the error might come from columns declared as
my_colum datetime default 0000-00-00 00:00:00
Robert
|
|
|
Posts:
558
Registered:
1/26/11
|
|
|
|
Re: Error with MySQL - Value '0000-00-00 00:00:00' can not be represented ...
Posted:
Jun 18, 2012 6:24 AM
in response to: Robert Munteanu
|
|
|
Hi Robert and thank you for being our longtime fan!
MySQL plugin is brand new in Toad Extension for Eclipse. I personally couldn't reproduce your particular problem (maybe I didn't try enough). But we know about issues in the Data tab that are complex and will need some debugging. So, stay with us and we will try to get it right till the next release.
Tomas
|
|
|
Posts:
558
Registered:
1/26/11
|
|
|
|
Re: Error with MySQL - Value '0000-00-00 00:00:00' can not be represented ...
Posted:
Jun 29, 2012 6:34 AM
in response to: Robert Munteanu
|
|
|
Hi Robert,
your issue will be solved as TEE-415.
Tomas
|
|
|
Posts:
558
Registered:
1/26/11
|
|
|
|
Re: Error with MySQL - Value '0000-00-00 00:00:00' can not be represented ...
Posted:
Jul 2, 2012 11:15 PM
in response to: Robert Munteanu
|
|
|
Robert,
this bug is fixed in 1.6.1 which is about to be released. We handled the exception and decided to represent that "zero" value as null (because it is used in MySQL as dummy value).
We are looking for further feedback from MySQL users!
Tomas
|
|
|
Posts:
31
Registered:
4/8/11
|
|
|
|
Re: Error with MySQL - Value '0000-00-00 00:00:00' can not be represented ...
Posted:
Jul 22, 2012 3:30 AM
in response to: Tomas
|
|
|
Hi Tomas,
I've given 1.6.1 a try and I still get the problem. Here are some minimal steps to reproduce.
1. Create a test database if needed
CREATE DATABASE test;
2. create a test table
CREATE TABLE bug_repro
(
id int(11),
date_added datetime DEFAULT "0000-00-00 00:00:00"
);
3. Insert sample data
insert into bug_repro(id) values (42);
4. Go to the data tab and try to visualise the table.
The date_added column is represented as {null}, but the error dialog still pops up.
Thanks,
Robert
|
|
|
Posts:
91
Registered:
3/4/11
|
|
|
|
Re: Error with MySQL - Value '0000-00-00 00:00:00' can not be represented ...
Posted:
Jul 25, 2012 3:45 AM
in response to: Robert Munteanu
|
 |
Answered |
|
|
Hi Robert,
The error has been already matched and the next version will contain the fix.
Thank you for your proper feedback!
Regards,
Lukas
|
|
|
|
Legend
|
|
MVP: 2501
+
pts
|
|
Guru: 2001
- 2500
pts
|
|
Expert: 751
- 2000
pts
|
|
Enthusiast: 31
- 750
pts
|
|
Novice: 0
- 30
pts
|
|
Moderators
|
|
Helpful answer
(5 pts)
|
|
Answered
(10 pts)
|
|
