0022005: Database log for postgres/oracle not showing parameter substitution - MantisBT

ID	Project	Category	View Status	Date Submitted	Last Update

0022005	mantisbt	sql	public	2016-12-04 14:13	2017-02-01 22:47

Reporter	cproensa	Assigned To	cproensa
Priority	normal	Severity	minor	Reproducibility	have not tried
Status	closed	Resolution	fixed
Product Version	1.3.0
Target Version	1.3.6	Fixed in Version	1.3.6

Summary	0022005: Database log for postgres/oracle not showing parameter substitution
Description	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 oracle: SELECT * from mantis_user_table WHERE id=:0 and access_level=:1
Tags	No tags attached.

MantisBT: master-1.3.x 0a88ed48 2016-12-03 15:07 cproensa 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		Affected Issues 0022005
	mod - core/database_api.php		Diff File

dregad 2016-12-05 04:49 developer ~0054673	https://github.com/mantisbt/mantisbt/pull/970