BUG #5805: "not determine data type" for params in comments

Поиск
Список
Период
Сортировка
От Maxim Turchin
Тема BUG #5805: "not determine data type" for params in comments
Дата
Msg-id 201012291600.oBTG0xcP053988@wwwmaster.postgresql.org
обсуждение исходный текст
Ответы Re: BUG #5805: "not determine data type" for params in comments  (Robert Haas <robertmhaas@gmail.com>)
Список pgsql-bugs
The following bug has been logged online:

Bug reference:      5805
Logged by:          Maxim Turchin
Email address:      nehxby@gmail.com
PostgreSQL version: 8.4
Operating system:   Ubuntu Linux
Description:        "not determine data type" for params in comments
Details:

I use php PDO extention. If in prepared statement exists comments with
string like ":somestring", this string is parameter, and need to fill.

Example SQL:
select
  /* :some_old_param, */
  :someparam1,
  :someparam2
from sometable;

When i fill last 2 param, and not fill first old param (in comment!), i get
error "not determine data type of parameter $1".

postgresql log:

2010-12-29 17:43:10 EET ERROR:  could not determine data type of parameter
$1
2010-12-29 17:43:10 EET STATEMENT: select
  /* $1, */
  $2,
  $3
from sometable;

В списке pgsql-bugs по дате отправления:

Предыдущее
От: "yiranwang"
Дата:
Сообщение: BUG #5803: Not can backup
Следующее
От: "Kevin Grittner"
Дата:
Сообщение: Re: BUG #5803: Not can backup