id	summary	reporter	owner	description	type	status	component	version	severity	resolution	keywords	cc	stage	has_patch	needs_docs	needs_tests	needs_better_patch	easy	ui_ux
24584	Test failures with MySQL >= 5.6.4 and MySQLdb < 1.2.5	Jon Dufresne	nobody	"This combination does not support database microsecond precision. Mircosecond precision was added to MySQL in version 5.6.4, but due to a bug in older MySQLdb, is still not always available. See https://github.com/farcepest/MySQLdb1/issues/24.

Before any changes, with this combination, when saving the date `2008-12-31 23:59:59.999999` the database result is rounded to `2009-01-01 00:00:00`. However, (to my understanding) Django expects the date to be truncated, not rounded.

Additionally, MySQL INTERVAL would promote a datetime without microseconds to a datetime with microseconds if the INTERVAL was a float or contained microseconds. Older MySQLdb was unable to properly parse the result to a Python datetime.

FWIW, I ran into this using the system libraries of a default Fedora 21 install. Fedora 21 ships with following versions:

community-mysql-server-5.6.23-1.fc21.x86_64
MySQL-python-1.2.3-13.fc21.x86_64

Individuals can workaround this by using virtualenv to install a newer MySQLdb or mysqlclient.

The following tests fail before any changes:

{{{
======================================================================
FAIL: test_mixed_type_annotation_date_interval (annotations.tests.NonAggregateAnnotationTestCase)
----------------------------------------------------------------------
Traceback (most recent call last):
  File ""/home/jon/devel/django/tests/annotations/tests.py"", line 147, in test_mixed_type_annotation_date_interval
    self.assertEqual(t.expires, expires)
AssertionError: None != datetime.datetime(2015, 3, 20, 15, 0)

======================================================================
FAIL: test_get_next_prev_by_field (model_regress.tests.ModelTests)
----------------------------------------------------------------------
Traceback (most recent call last):
  File ""/home/jon/devel/django/tests/model_regress/tests.py"", line 178, in test_get_next_prev_by_field
    e.get_previous_by_when().when, datetime.datetime(2000, 1, 1, 6, 1, 1)
AssertionError: datetime.datetime(2000, 1, 1, 12, 0, 20) != datetime.datetime(2000, 1, 1, 6, 1, 1)

======================================================================
FAIL: test_mixed_comparisons1 (expressions.tests.FTimeDeltaTests)
----------------------------------------------------------------------
Traceback (most recent call last):
  File ""/home/jon/devel/django/django/test/testcases.py"", line 1023, in skip_wrapper
    return test_func(*args, **kwargs)
  File ""/home/jon/devel/django/tests/expressions/tests.py"", line 765, in test_mixed_comparisons1
    self.assertEqual(test_set, self.expnames[:i + 1])
AssertionError: Lists differ: [] != [u'e0']

Second list contains 1 additional elements.
First extra element 0:
e0

- []
+ [u'e0']

======================================================================
FAIL: test_extra_method_select_argument_with_dashes_and_values (basic.tests.ModelTest)
----------------------------------------------------------------------
Traceback (most recent call last):
  File ""/home/jon/devel/django/tests/basic/tests.py"", line 304, in test_extra_method_select_argument_with_dashes_and_values
    [[('dashed-value', 1), ('headline', 'Article 11')], [('dashed-value', 1), ('headline', 'Article 12')]])
AssertionError: Lists differ: [[(u'dashed-value', 1L), (u'he... != [[(u'dashed-value', 1), (u'hea...

Second list contains 1 additional elements.
First extra element 1:
[(u'dashed-value', 1), (u'headline', u'Article 12')]

- [[(u'dashed-value', 1L), (u'headline', u'Article 11')]]
?                      -                                ^

+ [[(u'dashed-value', 1), (u'headline', u'Article 11')],
?                                                      ^

+  [(u'dashed-value', 1), (u'headline', u'Article 12')]]

======================================================================
FAIL: test_year_lookup_edge_case (basic.tests.ModelTest)
----------------------------------------------------------------------
Traceback (most recent call last):
  File ""/home/jon/devel/django/tests/basic/tests.py"", line 236, in test_year_lookup_edge_case
    [""<Article: Article 11>"", ""<Article: Article 12>""])
  File ""/home/jon/devel/django/django/test/testcases.py"", line 901, in assertQuerysetEqual
    return self.assertEqual(list(items), values, msg=msg)
AssertionError: Lists differ: ['<Article: Article 11>'] != [u'<Article: Article 11>', u'<...

Second list contains 1 additional elements.
First extra element 1:
<Article: Article 12>

- ['<Article: Article 11>']
+ [u'<Article: Article 11>', u'<Article: Article 12>']

----------------------------------------------------------------------
}}}

PR to follow.
"	Bug	closed	Database layer (models, ORM)	dev	Normal	fixed			Ready for checkin	1	0	0	0	0	0