Opened 6 years ago

Closed 6 years ago

#11393 closed (wontfix)

query on decimal fields with long string representation of float causes exception

Reported by: rclark Owned by: nobody
Component: Uncategorized Version: 1.0
Severity: Keywords:
Cc: Triage Stage: Unreviewed
Has patch: no Needs documentation: no
Needs tests: no Patch needs improvement: no
Easy pickings: UI/UX:

Description

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.

Change History (1)

comment:1 Changed 6 years ago by russellm

  • Needs documentation unset
  • Needs tests unset
  • Patch needs improvement unset
  • Resolution set to wontfix
  • Status changed from new to closed

"Doctor! It hurts when I do this"
"Then stop doing that!"

Erm... yeah. Ok. Good to know, but I don't think we're going to try and fix this one. The official position on this bug is going to be "ah... don't do that".

I am, however, slightly intrigued at the kind of use case that requires 6000+ significant figure of floating point representation...

Note: See TracTickets for help on using tickets.
Back to Top