0009053: PLTCL - Valentina Database Mantis

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

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 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 2022-06-27 12:02 administrator ~0011845	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