Formatting Error with Temporary Functions

[dmill166]

Issue is with use of temporary function in SQL scripts. I illustrate the problem below. You can see that in the formatted result, there is now a space between foo_bar and the left parentheses (. This is no longer treated as a function and the function itself is no longer applied. I also provide a corrected output where after formatting, the temporary function foo_bar has the ( immediately beside it (meaning the function will now be applied).

Which SQL and options did you provide as input?

CREATE TEMPORARY FUNCTION foo_bar AS 'FooBar' USING jar 'hdfs://localhost:9000/user/hive/FooBar.jar';

SELECT    foo_bar ('fwfrgwre12a3') fun_res ;

Expected Output

CREATE TEMPORARY FUNCTION foo_bar AS 'FooBar' USING jar 'hdfs://localhost:9000/user/hive/FooBar.jar';

SELECT
    foo_bar('fwfrgwre12a3') fun_res;

Actual Output

CREATE TEMPORARY FUNCTION foo_bar AS 'FooBar' USING jar 'hdfs://localhost:9000/user/hive/FooBar.jar';

SELECT
    foo_bar ('fwfrgwre12a3') fun_res;

Usage

• How are you calling / using the library?
  • Right-click, then use "Format Document" option
• What SQL language(s) does this apply to?
  • Specific example was a .hql extension, but multiple SQL variants support Temporary Functions, so this should be widely implemented
• Which SQL Formatter version are you using?
  • Prettier SQL VSCode v1.6.0

[dmill166]

Perusing the README, I did see that there is a successor to this extension, SQL Formatter VS Code (currently on v4.1.1).

I want to clarify that this issue ALSO exists there (would appreciate a fix in either/both locs :) ).

[nene]

Thanks for reporting.

This is duplicate of #444. It's a known problem with all user-defined functions (not just temporary ones).