[Bug 95174] SQL parser doesn't support catalog&schema in function name

[bugzilla-daemon]

https://bugs.documentfoundation.org/show_bug.cgi?id=95174

--- Comment #5 from Devansh Varshney <varshney.devansh...@gmail.com> ---
Created attachment 193287
  --> https://bugs.documentfoundation.org/attachment.cgi?id=193287&action=edit
Tables with Dummy data


I have already added dummy data for two tables (See the SS) 


I am getting the Error while creating these functions for the HSQLDB

CREATE FUNCTION PUBLIC.GET_NAME(P_ID INT) RETURNS VARCHAR(50)
BEGIN ATOMIC
  DECLARE V_NAME VARCHAR(50);
  SET V_NAME = (SELECT NAME FROM PUBLIC.TABLE1 WHERE ID = P_ID);
  RETURN V_NAME;
END;

CREATE FUNCTION PUBLIC.GET_CITY(P_ID INT) RETURNS VARCHAR(50)
BEGIN ATOMIC
  DECLARE V_CITY VARCHAR(50);
  SET V_CITY = (SELECT CITY FROM PUBLIC.TABLE2 WHERE ID = P_ID);
  RETURN V_CITY;
END;

-- 
You are receiving this mail because:
You are the assignee for the bug.