3059281 - HANA hint is not propagated with Procedure Sqlscript

• You have created a HANA procedure and attached a hint at the end of the sqlscript creation like the below example :

              CREATE PROCEDURE
              PRD22.TEST(
              in ...
              in ...
              ...
              )
              language sqlscript sql security invoker       as begin

              SELECT ...

              FROM "schema"."table"

              GROUP BY ..
              <other_clauses>
              WITH HINT(NO_CS_JOIN)

               END;

• Calling the procedure directly in HANA Studio with input variables invokes the hint as expected

               CALL "PRD22"."TEST" ('', '', '', ?, ?)WITH HINT(NO_CS_JOIN)

• However when the procedure is triggered and executed from a front end application tool or as part of a report, the hint is not invoked and dumps in an error.

               e.g "[9] Memory Allocation failed."

• SAP HANA PLATFORM EDITION 1.0
• SAP HANA PLATFORM EDITION 2.0

[9] Memory Allocation failed, language sqlscript sql security invoker. , KBA , HAN-DB-ENG , SAP HANA DB Engines , Problem