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.

Activity

Ascending order - Click to sort in descending order
Repository Revision Date User Message
MMBase SVN #24962 Mon Aug 06 17:36:48 CEST 2007 michiel See also MMB-1496
Files Changed
MODIFY /mmbase/trunk/applications/email/src/org/mmbase/applications/email/EmailBuilder.java
Michiel Meeuwissen made changes - 2007-08-08 11:34
Field Original Value New Value
Status Open [ 1 ] Resolved [ 5 ]
Fix Version/s 1.8.5 [ 10145 ]
Fix Version/s 1.9.0 [ 10119 ]
Resolution Fixed [ 1 ]
Repository Revision Date User Message
MMBase SVN #25017 Wed Aug 08 11:38:28 CEST 2007 michiel MMB-1496
Files Changed
MODIFY /mmbase/trunk/src/org/mmbase/storage/search/implementation/database/BasicSqlHandler.java
MODIFY /mmbase/trunk/src/org/mmbase/storage/search/implementation/BasicStepField.java
MODIFY /mmbase/branches/MMBase-1_8/src/org/mmbase/storage/search/implementation/database/BasicSqlHandler.java
MODIFY /mmbase/branches/MMBase-1_8/src/org/mmbase/storage/search/implementation/BasicStepField.java
Repository Revision Date User Message
MMBase SVN #25020 Wed Aug 08 11:51:51 CEST 2007 michiel MMB-1496
Files Changed
MODIFY /mmbase/trunk/src/org/mmbase/storage/search/implementation/database/BasicSqlHandler.java
MODIFY /mmbase/branches/MMBase-1_8/src/org/mmbase/storage/search/implementation/database/BasicSqlHandler.java
MODIFY /mmbase/branches/MMBase-1_8/src/org/mmbase/storage/search/implementation/BasicStepField.java
Michiel Meeuwissen made changes - 2007-08-09 15:37
Assignee MMBase Project Leader [ mmbaseleader ] Michiel Meeuwissen [ mihxil ]

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.