Mailing List Archive: MythTV: Commits

Ticket #10314: Datatype programmatical bug in mythconverg database videometadata table

Index | Next | Previous | View Threaded

noreply at mythtv

Feb 6, 2012, 2:09 PM

Post #1 of 4 (46 views)
Permalink

Ticket #10314: Datatype programmatical bug in mythconverg database videometadata table

#10314: Datatype programmatical bug in mythconverg database videometadata table
--------------------------------------+------------------------------------
Reporter: hodosiszabolcs@… | Type: Bug Report - Crash
Status: new | Priority: critical
Milestone: unknown | Component: MythTV - General
Version: 0.24.1 | Severity: medium
Keywords: database | Ticket locked: 0
--------------------------------------+------------------------------------
Dear MythTV Developers,

Sadly I have to report a serious logical, design fault in the mythconverg
database's videometadata table's column "releasedate".

Somehow the software in rollback/default cases uses the DATE datatype
value '0000-00-00'.

I would like to warn you that 0000.00.00. is neither a valid date in
java.util.Date class, nor in MySQL, nor in SQL standard, nor in any
university where Database development is taugh.

I'm in a middle of a complex development for port.hu scraper for MythTV.

I wasted 3 hour of development work just because of your idiotism!

Please train your database coder.

I'm absolutely frustrated.

Sorry.

--
Ticket URL: <http://code.mythtv.org/trac/ticket/10314>
MythTV <http://code.mythtv.org/trac>
MythTV Media Center
_______________________________________________
mythtv-commits mailing list
mythtv-commits [at] mythtv
http://www.mythtv.org/mailman/listinfo/mythtv-commits

noreply at mythtv

Feb 6, 2012, 2:24 PM

Post #2 of 4 (41 views)
Permalink

Re: Ticket #10314: Datatype programmatical bug in mythconverg database videometadata table [In reply to]

#10314: Datatype programmatical bug in mythconverg database videometadata table
--------------------------------------+-------------------------
Reporter: hodosiszabolcs@… | Owner:
Type: Bug Report - Crash | Status: closed
Priority: trivial | Milestone: unknown
Component: MythTV - General | Version: 0.24.1
Severity: low | Resolution: Invalid
Keywords: database | Ticket locked: 0
--------------------------------------+-------------------------
Changes (by cpinkham):

* priority: critical => trivial
* status: new => closed
* resolution: => Invalid
* severity: medium => low

Comment:

MySQL uses '0000-00-00' as a special 'zero' value to allow storing a NULL
value in a Date field. It also allows a similar '00:00:00' in Time
fields, and other formats specified in the official MySQL docs at bottom
of the page at the link below.

http://dev.mysql.com/doc/refman/5.0/en/date-and-time-types.html

Closing ticket as invalid.

Not Sorry.

--
Ticket URL: <http://code.mythtv.org/trac/ticket/10314#comment:1>
MythTV <http://code.mythtv.org/trac>
MythTV Media Center
_______________________________________________
mythtv-commits mailing list
mythtv-commits [at] mythtv
http://www.mythtv.org/mailman/listinfo/mythtv-commits

noreply at mythtv

Feb 6, 2012, 2:48 PM

Post #3 of 4 (42 views)
Permalink

Re: Ticket #10314: Datatype programmatical bug in mythconverg database videometadata table [In reply to]

noreply at mythtv

Feb 6, 2012, 2:56 PM

Post #4 of 4 (42 views)
Permalink

Re: Ticket #10314: Datatype programmatical bug in mythconverg database videometadata table [In reply to]

#10314: Datatype programmatical bug in mythconverg database videometadata table
--------------------------------------+-------------------------
Reporter: hodosiszabolcs@… | Owner:
Type: Bug Report - General | Status: closed
Priority: trivial | Milestone: unknown
Component: MythTV - General | Version: 0.24.1
Severity: low | Resolution: Invalid
Keywords: database | Ticket locked: 0
--------------------------------------+-------------------------

Comment (by hodosiszabolcs@…):

Any custom hack like this breaks JDBC and such APIs exotic issues, which
is always a good idea to prevent with using valid values for marking NULLs
(if DBMS cannot support NULLs), like 0001-01-01 (as I saw in some cases),
or any date which is trivial unable to reach like 3000-01-01, but
0000-00-00 is always a pain.
Maybe the program language you are using is not sensible for such cases,
but would be wise to choose another value, or NULL value, if possible.

I'm trying to forward my mail to the developer of JDBC driver if I will
able to investigate them.

Reading the documentation you linked it I agree this is not a bug, and I'm
fine with closing of this ticket.

And sorry about my harsh voice in my previous message.

--
Ticket URL: <http://code.mythtv.org/trac/ticket/10314#comment:3>
MythTV <http://code.mythtv.org/trac>
MythTV Media Center
_______________________________________________
mythtv-commits mailing list
mythtv-commits [at] mythtv
http://www.mythtv.org/mailman/listinfo/mythtv-commits

Index | Next | Previous | View Threaded

Interested in having your list archived? Contact Gossamer Threads