Reference AC issue #90

His first query runs okay but query 2 fails.  Is it because he did not CREATE TYPE public.t_test AS.... first?

Database: Postgres. Find below steps that lead me to the error. Below you can find lincense details. 


Step 1: Create type and a function that use argument with created type. No errors. 
[cid:image001.png@01D49394.201C3770][cid:image002.png@01D49394.201C3770] 

Step 2: Error when open created funtion in funtion editor and try to compile it: 
[cid:image003.png@01D49394.201C3770] 

License Key: D501A8ABC1254C278E261CD1FF33DF9562AC8D5E1F120CFE**************** 

Product: Aqua Data Studio 
Version: 19.0.0 
Build #: 55797 
Build Date: 2018-Apr-24 08:26:49 AM 

Operating Environment: Windows 10 (10.0, amd64) / Cp1250 / pl / PL / Oracle Corporation 1.8.0_102-b14 
Memory: Max=7 635 730 432; Total=688 914 432; Free=308 034 640; CPUs=4 

In-Window Graphics Capabilities 
Graphics Vendor: Intel 
OpenGL Renderer: Intel(R) HD Graphics 520 
OpenGL Version: 4.5.0 - Build 23.20.16.4973 
Double-Buffering: Enabled 
Anti-Aliasing: Enabled 
Anti-Aliasing Sample Count: 16 
Hardware Acceleration: Enabled 
Color Bits: Red: 8 Green: 8 Blue: 8 Alpha: 8 
Depth Bits: 16 
Accumulation Buffer Bits: Red: 0 Green: 0 Blue: 0 
Initialization Time: 1319 ms 


Offscreen Graphics Capabilities 
Graphics Vendor: Brian Paul 
OpenGL Renderer: Mesa OffScreen 
OpenGL Version: 2.1 Mesa 7.8.2 
Double-Buffering: Disabled 
Anti-Aliasing: Disabled 
Anti-Aliasing Sample Count: 0 
Hardware Acceleration: Disabled 
Color Bits: Red: 8 Green: 8 Blue: 8 Alpha: 8 
Depth Bits: 16 
Accumulation Buffer Bits: Red: 16 Green: 16 Blue: 16 
Initialization Time: 78 ms 
Hardware PBuffer Available: No 
Using PBuffer: No 
Using Ram Buffer: Yes 
Offscreen Rendering: Enabled 
Offscreen Buffer Size: 800x600 

No, the type was created. The problem is with function editor. When you copy "create or replace function" statement from function editor and run it in query analyser, it is executed with no errors.

When I try to compile it in function editor (even when I open existing in database function), I always receive error: "Function with this signature does not exist" which is an Aqua error, not a server error.
This behaviour of function editor takes place for that functions which have arguments of custom created type. This does not happen if function argument is type of date, timestamp, int, etc.
Try do following steps:
1. Create type (in query analyser)
2. Create function (in query analyser)
3. Open (already from database) created in previous step function in function editor. Try to compile it. Now you should receive the error.

It is not enough to remove quotes. I had to remove schema name also. See attachments Fail and Success.

Proposed by you solution will work only for UDT defined in schema “public” with lowercase name. If UDT is defined in other schema (needs to specify schema name) or name is no lower case (needs to specify quotes) then proposed by you fix will not work. However better that solution than nothing 😊.