View Issue Details

IDProjectCategoryView StatusLast Update
0022005mantisbtsqlpublic2017-02-01 22:47
Assigned Tocproensa 
PrioritynormalSeverityminorReproducibilityhave not tried
Status closedResolutionfixed 
Product Version1.3.0 
Target Version1.3.6Fixed in Version1.3.6 
Summary0022005: Database log for postgres/oracle not showing parameter substitution

When showing queries in database log, or by showing them in page, the parameters are not replaced by their binded values.
This functionality only happens with mysql.

Example, this query in mysql is printed in log as:
SELECT * from mantis_user_table WHERE id=1 and access_level=90

while, postgres:
SELECT * from mantis_user_table WHERE id=$1 and access_level=$2

SELECT * from mantis_user_table WHERE id=:0 and access_level=:1

TagsNo tags attached.


related to 0022018 closedcproensa Database log does not show boolean parameters correctly 


Related Changesets

MantisBT: master-1.3.x 0a88ed48

2016-12-03 20:07:26


Committer: dregad Details Diff
Improve parameter substitution for database log

For showing the database query log, only mysql style parameters "?" were
supported. Other like postgres "$nnn" or oracle ":xxx" were not treated.

Change the token substitution to allow other token types to be replaced
with the parameter value for log output.

Fixes: 0022005
mod - core/database_api.php Diff File

Issue History

Date Modified Username Field Change
2016-12-04 14:13 cproensa New Issue
2016-12-04 14:17 cproensa Assigned To => cproensa
2016-12-04 14:17 cproensa Status new => assigned
2016-12-04 14:27 cproensa Description Updated View Revisions
2016-12-05 04:49 dregad Target Version => 1.3.5
2016-12-05 04:49 dregad Summary Database log for postgres not showing parameter substitution => Database log for postgres/oracle not showing parameter substitution
2016-12-05 04:49 dregad Note Added: 0054673
2016-12-30 16:24 atrol Target Version 1.3.5 => 1.3.6
2017-01-06 17:38 dregad Changeset attached => MantisBT master-1.3.x 0a88ed48
2017-01-06 17:38 dregad Assigned To cproensa => dregad
2017-01-06 17:38 dregad Status assigned => resolved
2017-01-06 17:38 dregad Resolution open => fixed
2017-01-06 17:38 dregad Fixed in Version => 1.3.6
2017-01-06 17:42 dregad Assigned To dregad => cproensa
2017-01-06 17:43 dregad Relationship added related to 0022018
2017-01-06 17:45 dregad Product Version 1.3.4 => 1.3.0
2017-02-01 22:47 vboctor Status resolved => closed