View Issue Details
ID | Project | Category | View Status | Date Submitted | Last Update |
---|---|---|---|---|---|
0007190 | mantisbt | db oracle | public | 2006-06-12 04:54 | 2014-12-08 00:34 |
Reporter | mechantflou | Assigned To | dregad | ||
Priority | normal | Severity | crash | Reproducibility | always |
Status | closed | Resolution | fixed | ||
Target Version | 1.3.0-beta.1 | Fixed in Version | 1.3.0-beta.1 | ||
Summary | 0007190: error in filter_api with date filter | ||||
Description | this query doesn't work in oracle SELECT DISTINCT m_bug_tbl.id as id, FROM m_project_tbl, m_bug_tbl first, I've added a new function in database_api.php function db_prepare_date( $p_date)
then I've modified at the line 520 in filter_api.php With all change, date filter can work with oracle | ||||
Tags | No tags attached. | ||||
has duplicate | 0007191 | closed | ryandesign | error in filter_api with date filter |
related to | 0013227 | closed | dregad | Oracle DB support multiple issues |
The function above won't work for non-oci8 due to the quotes around $p_date in the return line. It would send back a string of '$p_date' instead of the value. This function would be better expressed as: function db_prepare_date( $p_date) { if ( $t_db_type == 'oci8' ) { |
|
Would you have a chance to test if problem still exists using oracle branch in 0013227 (https://github.com/dregad/mantisbt/commits/oracle), and submit a revised patch/pull request against that if it's the case ? |
|