MMBase

BasicSqlHandler a bit too stupid when it comes to datetime fields.

Details

  • Type: Bug Bug
  • Status: Resolved Resolved
  • Priority: Major Major
  • Resolution: Fixed
  • Affects Version/s: 1.8.4
  • Fix Version/s: 1.8.5
  • Component/s: Core
  • Description:
    Hide
    No conversion between numbers and dates is done. Which can easily result in wrong queries. Especially if e.g. you updated a field from long to date.

    In the code you may want to use a date, but if the database still has longs, comparision must be fed a long, not a date.

    Inversely, if you're code is still in longs, it should autoconvert to dates, if the database wants those.

    Show
    No conversion between numbers and dates is done. Which can easily result in wrong queries. Especially if e.g. you updated a field from long to date. In the code you may want to use a date, but if the database still has longs, comparision must be fed a long, not a date. Inversely, if you're code is still in longs, it should autoconvert to dates, if the database wants those.

People

Dates

  • Created:
    2007-08-06 17:36
    Updated:
    2007-08-09 15:37
    Resolved:
    2007-08-08 11:34
Atlassian JIRA (v4.1#519) | Report a problem | Request a feature | Contact administrators
Powered by a free Atlassian JIRA open source license for MMBase Foundation. Try JIRA - bug tracking software for your team.