You signed in with another tab or window. Reload to refresh your session.You signed out in another tab or window. Reload to refresh your session.You switched accounts on another tab or window. Reload to refresh your session.Dismiss alert
$sqlt->add_procedure(
name => 'accounting_ready',
parameters => [
{ argmode => 'in', name => '_o', type => 'order' },
],
extra => {
returns => { type => 'table( invoice boolean, usage boolean )' },
definitions => [
{ language => 'sql' },
{ quote => "\$\$\n", body => <<' FUNC' =~ s!^\t!!grm =~ s!;\n!;/**/\n!grs }
SELECT true, true
FROM "order" o
WHERE o.id = _o.id
FUNC
]});
Result (Actual: red, expected: green):
-CREATE FUNCTION "accounting_ready" (in _o order)+CREATE FUNCTION "accounting_ready" (in _o "order")
RETURNS table( invoice boolean, usage boolean )
LANGUAGE sql
AS $$
SELECT true, true
FROM "order" o
WHERE o.id = _o.id
$$
;
Here order is a table in the database
current workaround:
$sqlt->add_procedure(
name => 'accounting_ready',
parameters => [
- { argmode => 'in', name => '_o', type => 'order' },+ { argmode => 'in', name => '_o', type => '"order"' },
],
extra => {
returns => { type => 'table( invoice boolean, usage boolean )' },
definitions => [
{ language => 'sql' },
{ quote => "\$\$\n", body => <<' FUNC' =~ s!^\t!!grm =~ s!;\n!;/**/\n!grs }
SELECT true, true
FROM "order" o
WHERE o.id = _o.id
FUNC
]});
The text was updated successfully, but these errors were encountered:
How to reproduce:
Result (Actual: red, expected: green):
Here
order
is a table in the databasecurrent workaround:
The text was updated successfully, but these errors were encountered: