[#MDL-14785] pgsql does not support bound parameters in comments

Moodle

MDL-14679

pgsql does not support bound parameters in comments

Created: 12/May/08 01:12 AM Updated: 16/May/08 02:42 PM

Component/s:

Database SQL/XMLDB

Affects Version/s:

2.0

Fix Version/s:

2.0

Participants:	Eloy Lafuente (stronk7) and Petr Škoda
Security Level:	None

Description

« Hide

throws some silly "$1 syntax error" in query

workaround:
* remove all [?$:] and quote
* report upstream and wait for fix (not likely)
* write bound query emulation function - yuck

All

Comments

Change History

Version Control

Sort Order:

Ascending order - Click to sort in descending order

[ Permlink | « Hide ]

Petr Škoda - 12/May/08 04:53 AM

I might have better solution, going to hack $DB->execute() so that it detects comments and emulates bound queries..

[ Permlink | « Hide ]

Petr Škoda - 13/May/08 07:09 AM

solved in patch

[ Permlink | « Hide ]

Eloy Lafuente (stronk7) - 16/May/08 07:07 AM

I guess this was fixed by avoiding bounds in DDL stuff correct? As we discussed in chat (long execute.... named function). Or not?

[ Permlink | « Hide ]

Petr Škoda - 16/May/08 02:42 PM

bound parameters avoided in ddllib