View Issue Details
ID | Project | Category | View Status | Date Submitted | Last Update |
---|---|---|---|---|---|
0009053 | VALENTINA STUDIO | Tool - SQL Editor | public | 2022-01-07 13:58 | 2022-06-27 12:02 |
Reporter | siqsuruq | Assigned To | Ruslan Zasukhin | ||
Priority | normal | Severity | minor | Reproducibility | have not tried |
Status | resolved | Resolution | fixed | ||
Platform | ALL | OS | ALL | OS Version | ALL |
Product Version | 11.4.x | ||||
Fixed in Version | 12.4.x | ||||
Summary | 0009053: PLTCL | ||||
Description | Hello, Im trying to create FUNCTION: CREATE FUNCTION tcl_max(integer, integer) RETURNS integer AS $$ if {$1 > $2} {return $1} return $2 $$ LANGUAGE pltcl STRICT; And it gives me error: Kernel error: ОШИБКА: в сообщении Bind передано неверное число параметров (2, а подготовленный оператор "" требует 0) | ||||
Tags | No tags attached. | ||||
Working with DB: | postgreSQL Server | ||||
Version of your DB: | 13 | ||||
Yes, it looks like $-quoted string is not processed correctly and parameters in it are detected. Please try to uncheck the "Use Parameters" option on the right panel in the SQL Editor. Screenshot 2022-01-07 at 20.35.31.png (36,006 bytes) |
|
Sergey, as I understand $1 $2 should not be considered as bind-parameters IF 1) this is postgreSQL 2) we are inside of CREATE FUNCTION body right? |
|
12.4.4 | |
Date Modified | Username | Field | Change |
---|---|---|---|
2022-01-07 13:58 | siqsuruq | New Issue | |
2022-01-07 18:35 | Sergey Pashkov | Status | new => confirmed |
2022-01-07 18:38 | Sergey Pashkov | Note Added: 0011755 | |
2022-01-07 18:38 | Sergey Pashkov | File Added: Screenshot 2022-01-07 at 20.35.31.png | |
2022-06-24 11:50 | Ruslan Zasukhin | Note Added: 0011840 | |
2022-06-27 12:02 | Ruslan Zasukhin | Assigned To | => Ruslan Zasukhin |
2022-06-27 12:02 | Ruslan Zasukhin | Status | confirmed => resolved |
2022-06-27 12:02 | Ruslan Zasukhin | Resolution | open => fixed |
2022-06-27 12:02 | Ruslan Zasukhin | Fixed in Version | => 12.4.x |
2022-06-27 12:02 | Ruslan Zasukhin | Note Added: 0011845 |