View Issue Details

IDProjectCategoryView StatusLast Update
0009053VALENTINA STUDIOTool - SQL Editorpublic2022-06-27 12:02
Reportersiqsuruq Assigned ToRuslan Zasukhin  
PrioritynormalSeverityminorReproducibilityhave not tried
Status resolvedResolutionfixed 
PlatformALLOSALLOS VersionALL
Product Version11.4.x 
Fixed in Version12.4.x 
Summary0009053: PLTCL
DescriptionHello, 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)
TagsNo tags attached.
Working with DB:postgreSQL Server
Version of your DB:13

Activities

Sergey Pashkov

Sergey Pashkov

2022-01-07 18:38

developer   ~0011755

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)
Ruslan Zasukhin

Ruslan Zasukhin

2022-06-24 11:50

administrator   ~0011840

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?
Ruslan Zasukhin

Ruslan Zasukhin

2022-06-27 12:02

administrator   ~0011845

12.4.4

Issue History

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