CREATE FUNCTION "test_fun"

 (property_rate bigint, squerefeet bigint)

RETURNS bigint

LANGUAGE SQL

CONTAINS SQL

DETERMINISTIC

SQL SECURITY DEFINER

COLLATION INVOKER

INLINE TYPE 1

RETURN property_rate * squerefeet;

 

GO

CREATE FUNCTION "test_function" (

        "func" CHARACTER(1) CHARACTER SET LATIN,

        "a" INTEGER,

        "b" INTEGER)

    RETURNS INTEGER

    LANGUAGE SQL

    CONTAINS SQL

    DETERMINISTIC

    CALLED ON NULL INPUT

    SQL SECURITY DEFINER

    COLLATION INVOKER

    INLINE TYPE 1

    RETURN CASE

    WHEN func = 'A'

    THEN A + B

    WHEN func = 'S'

    THEN A - B

    WHEN func = 'M'

    THEN A * B

    ELSE A / B

END;

GO

com.teradata.jdbc.jdbc_4.util.JDBCException: [Teradata JDBC Driver] [TeraJDBC 13.00.00.06] [Error 1244] [SQLState HY000] Column index value 0 is outside the valid range of 1 through 10

at com.teradata.jdbc.jdbc_4.util.ErrorFactory.makeDriverJDBCException(ErrorFactory.java:90)

at com.teradata.jdbc.jdbc_4.util.ErrorFactory.makeDriverJDBCException(ErrorFactory.java:70)

at com.teradata.jdbc.jdbc_4.util.ErrorFactory.makeDriverJDBCException(ErrorFactory.java:98)

at com.teradata.jdbc.jdbc_4.ResultSetRow.getValue(ResultSetRow.java:53)

at com.teradata.jdbc.jdbc_4.ResultSet.getObject(ResultSet.java:183)

at com.teradata.jdbc.jdbc_3.ifjdbc_4.TeraLocalResultSet.getObject(TeraLocalResultSet.java:697)

at com.teradata.jdbc.jdbc_3.ifjdbc_4.TeraLocalResultSet.getString(TeraLocalResultSet.java:235)

at \\...\\ .\\हिñçêČάй語简�?한\\.x⣪⣪ꊲꏯ goto.d(Unknown Source)

at \\...\\ .\\हिñçêČάй語简�?한\\.x⣪⣪ꊲꏯ goto.n(Unknown Source)

at \\...\\ .\\हिñçêČάй語简�?한\\.Yꐰᢞᢜᢂ native volatile.a(Unknown Source)

at \\...\\ .\\हिñçêČάй語简�?한\\.Yꐰᢞᢜᢂ native volatile.a(Unknown Source)

at \\...\\ .\\हिñçêČάй語简�?한\\.wꑫᚲ⢼⡩.a(Unknown Source)

at \\...\\ .\\हिñçêČάй語简�?한\\.dꍜꊀͧꇾ new.a(Unknown Source)

at com.aquafold.datastudio.mainframe.ActionHandler.actionPerformed(Unknown Source)

at javax.swing.AbstractButton.fireActionPerformed(Unknown Source)

at javax.swing.AbstractButton$Handler.actionPerformed(Unknown Source)

at javax.swing.DefaultButtonModel.fireActionPerformed(Unknown Source)

at javax.swing.DefaultButtonModel.setPressed(Unknown Source)

at javax.swing.AbstractButton.doClick(Unknown Source)

at com.jidesoft.plaf.vsnet.VsnetMenuItemUI.doClick(Unknown Source)

at com.jidesoft.plaf.vsnet.VsnetMenuItemUI$MouseInputHandler.mouseReleased(Unknown Source)

at java.awt.Component.processMouseEvent(Unknown Source)

at javax.swing.JComponent.processMouseEvent(Unknown Source)

at java.awt.Component.processEvent(Unknown Source)

at java.awt.Container.processEvent(Unknown Source)

at java.awt.Component.dispatchEventImpl(Unknown Source)

at java.awt.Container.dispatchEventImpl(Unknown Source)

at java.awt.Component.dispatchEvent(Unknown Source)

at java.awt.LightweightDispatcher.retargetMouseEvent(Unknown Source)

at java.awt.LightweightDispatcher.processMouseEvent(Unknown Source)

at java.awt.LightweightDispatcher.dispatchEvent(Unknown Source)

at java.awt.Container.dispatchEventImpl(Unknown Source)

at java.awt.Window.dispatchEventImpl(Unknown Source)

at java.awt.Component.dispatchEvent(Unknown Source)

at java.awt.EventQueue.dispatchEventImpl(Unknown Source)

at java.awt.EventQueue.access$200(Unknown Source)

at java.awt.EventQueue$3.run(Unknown Source)

at java.awt.EventQueue$3.run(Unknown Source)

at java.security.AccessController.doPrivileged(Native Method)

at java.security.ProtectionDomain$1.doIntersectionPrivilege(Unknown Source)

at java.security.ProtectionDomain$1.doIntersectionPrivilege(Unknown Source)

at java.awt.EventQueue$4.run(Unknown Source)

at java.awt.EventQueue$4.run(Unknown Source)

at java.security.AccessController.doPrivileged(Native Method)

at java.security.ProtectionDomain$1.doIntersectionPrivilege(Unknown Source)

at java.awt.EventQueue.dispatchEvent(Unknown Source)

at java.awt.EventDispatchThread.pumpOneEventForFilters(Unknown Source)

at java.awt.EventDispatchThread.pumpEventsForFilter(Unknown Source)

at java.awt.EventDispatchThread.pumpEventsForHierarchy(Unknown Source)

at java.awt.EventDispatchThread.pumpEvents(Unknown Source)

at java.awt.EventDispatchThread.pumpEvents(Unknown Source)

at java.awt.EventDispatchThread.run(Unknown Source)

 

java.lang.NullPointerException

at \\...\\ .\\हिñçêČάй語简�?한\\.Nꀃꆥꏖ᠙ this volatile.a(Unknown Source)

at \\...\\ .\\हिñçêČάй語简�?한\\.Wꎔꊰꑩᝂ 1.a(Unknown Source)

at \\...\\ .\\हिñçêČάй語简�?한\\.Dꂑ⡝ꌧ͑.a(Unknown Source)

at \\...\\ .\\हिñçêČάй語简�?한\\.y⡪ꏜ̂ꉟ enum.run(Unknown Source)

Also same jdbc exception is displayed when we try to open Alter function/drop function window
Please refer attached screenshot(userdefinedfunction.png)