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

Summary: wrong mysql output with 0000-00-00 value in date row
Product: db Reporter: podolinek <podolinek>
Component: MySQLAssignee: Jiri Rechtacek <jrechtacek>
Status: RESOLVED DUPLICATE    
Severity: blocker    
Priority: P3    
Version: 6.x   
Hardware: All   
OS: Windows XP   
Issue Type: DEFECT Exception Reporter:

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 ***