Overloaded postgres routine missing schema qualification on parameter cast in 3.9.0

[dleary]

If a postgres function is overloaded with a schema specific parameter type in one signature, the generated invocation sql is missing a schema qualifier. E.g. given:

create schema foo;
create type foo.bartype as enum ('one', 'two');

create function foo.function(arg1 int) returns text
as $$
begin
  return cast(arg1 as text);
end;
$$ language plpgsql;

create function foo.function(arg1 foo.bartype) returns text
as $$
begin
  return cast(arg1 as text);
end;
$$ language plpgsql;

Invoking the second signature generates something along the lines:
select "function" from "foo"."function"("arg1" := cast($1::"fb"."bartype" as bartype)
But the type named in the cast needs to be qualified relative to schema foo.
Worked ok in 3.8.6.

[lukaseder]

Thank you very much for reporting. I wonder why the second (outer) cast is added, the first one (inner) ought to be sufficient

[dleary]

Agreed. The workaround I've used is to rename the second function. Without the overloading the generated sql is fine. Haven't captured the good sql, however.

[lukaseder]

With jOOQ 3.18, I cannot reproduce this anymore. The logged SQL is:

14:53:57,562 DEBUG [LoggerListener                ] - Executing query          : select "function" from "foo"."function"("arg1" := cast(? as int)) -- SQL rendered with a free trial version of jOOQ 3.18.0-SNAPSHOT
14:53:57,564 DEBUG [LoggerListener                ] - -> with bind values      : select "function" from "foo"."function"("arg1" := cast(1 as int))
14:53:57,608 DEBUG [LoggerListener                ] - Fetched result           : +--------+
14:53:57,608 DEBUG [LoggerListener                ] -                          : |function|
14:53:57,608 DEBUG [LoggerListener                ] -                          : +--------+
14:53:57,609 DEBUG [LoggerListener                ] -                          : |1       |
14:53:57,609 DEBUG [LoggerListener                ] -                          : +--------+
14:53:57,609 DEBUG [LoggerListener                ] - Fetched row(s)           : 1
14:53:58,133 DEBUG [LoggerListener                ] - Executing query          : select "function" from "foo"."function"("arg1" := cast(cast(? as "foo"."bartype") as "foo"."bartype")) -- SQL rendered with a free trial version of jOOQ 3.18.0-SNAPSHOT
14:53:58,135 DEBUG [LoggerListener                ] - -> with bind values      : select "function" from "foo"."function"("arg1" := cast(cast('one' as "foo"."bartype") as "foo"."bartype"))
14:53:58,138 DEBUG [LoggerListener                ] - Fetched result           : +--------+
14:53:58,138 DEBUG [LoggerListener                ] -                          : |function|
14:53:58,138 DEBUG [LoggerListener                ] -                          : +--------+
14:53:58,138 DEBUG [LoggerListener                ] -                          : |one     |
14:53:58,138 DEBUG [LoggerListener                ] -                          : +--------+
14:53:58,138 DEBUG [LoggerListener                ] - Fetched row(s)           : 1

I remember having fixed related issues recently. It's also integration tested now.