This Bugzilla instance is a read-only archive of historic NetBeans bug reports. To report a bug in NetBeans please follow the project's instructions for reporting issues.

Bug 175226 - wrong mysql output with 0000-00-00 value in date row
Summary: wrong mysql output with 0000-00-00 value in date row
Status: RESOLVED DUPLICATE of bug 159197
Alias: None
Product: db
Classification: Unclassified
Component: MySQL (show other bugs)
Version: 6.x
Hardware: All Windows XP
: P3 blocker (vote)
Assignee: Jiri Rechtacek
URL:
Keywords:
Depends on:
Blocks:
 
Reported: 2009-10-22 16:27 UTC by podolinek
Modified: 2009-10-22 19:11 UTC (History)
0 users

See Also:
Issue Type: DEFECT
Exception Reporter:

Attachments
Add an attachment (proposed patch, testcase, etc.)

Note You need to log in before you can comment on or make changes to this bug.
Description podolinek 2009-10-22 16:27:03 UTC 
Hi, I used this sql query on mysql 5.1.39:

SELECT c.cmp_name AS company, p.paid_at
FROM products AS p
INNER JOIN a2_cmp_core AS c ON c.cmp_ID = p.client_id

Problem is, that row paid_at has default value 0000-00-00 and it is not always diferent value. When I use that command
on mysql database, NB return me error:
Error code 0, SQL state S1009: Value '0000-00-00' can not be represented as java.sql.Date.
I think it is bug, because in mysql query browser or phpmyadmin it is correct done.
--
Ondrej Podolinsky
Comment 1 Jiri Rechtacek 2009-10-22 19:11:26 UTC 
Issue 159197 has some hint how solve it, hope it helps. Thank you for your report.

*** This issue has been marked as a duplicate of 159197 ***