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
11393	query on decimal fields with long string representation of float causes exception	rclark	nobody	"When a querying a decimal field in mysql passing a string representation of a float with more than 6000 characters, an exception occurs. 

{{{
DjangoModel.objects.filter(num_field__gte=""1.000000000000000000000000000000000000000000....."")
}}}

_mysql_exceptions.Warning: Truncated incorrect DOUBLE value: '1.000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000'

As you add more characters mysql's performance seriously degrades."		closed	Uncategorized	1.0		wontfix			Unreviewed	0	0	0	0	0	0