Re: queryId constant squashing does not support prepared statements
От | Sami Imseih |
---|---|
Тема | Re: queryId constant squashing does not support prepared statements |
Дата | |
Msg-id | CAA5RZ0s_Zm-Y=d_Pjvpy+BVo7e1BEwvdOSU1bcdpoVSqxq_f=Q@mail.gmail.com обсуждение исходный текст |
Ответ на | Re: queryId constant squashing does not support prepared statements (Dmitry Dolgov <9erthalion6@gmail.com>) |
Ответы |
Re: queryId constant squashing does not support prepared statements
|
Список | pgsql-hackers |
> > Without properly accounting for the boundaries of the list of expressions, i.e., > > the start and end positions of '(' and ')' or '[' and ']' and normalizing the > > expressions in between, it will be very difficult for the normalization to > > behave sanely. > > I don't think having the end location in this case would help -- when it > comes to ParseFuncOrColumn, looks like for coerce functions it just > replaces the original FuncCall with the argument expression. Meaning > that when jumbling we have only the coerce argument expression (Const), > which ends before the closing brace, not the parent expression. If we are picking up the start and end points from gram.c and we add these positions to A_Expr or A_ArrayExpr and then make them available to ArrayExpr, then we know the exact boundary of the IN list. Even if a function call is simplified down to a constant, it will not really matter because we are going to normalize between the original opening and closing parentheses of the IN list. (Actually, we can even track the actual textual starting and end point of a List as well) Attached ( not in patch form ) is the idea for this. ``` postgres=# select where 1 in (1, int4(1)); -- (1 row) postgres=# select where 1 in (1, int4($1::int)) \bind 1 postgres-# ; -- (1 row) postgres=# select toplevel, query, calls from pg_stat_statements; toplevel | query | calls ----------+------------------------------------+------- t | select where $1 in ($2 /*, ... */) | 2 (1 row) ``` What do you think? -- Sami Imseih
Вложения
В списке pgsql-hackers по дате отправления: