[HIVE-26229] HPLSQL

• Type: Bug
• Status: Open
• Priority: Major
• Resolution: Unresolved
• Component/s: hpl/sql

Environment

development environment, we used the HPL\SQL version of 

• 
  HPL/SQL 0.3.31 - September 11, 2017 which download from http://www.hplsql.org/download

  I have attached all the scripts, you can reference them. If you need any support from me, please free feel to let me know, thx

Language

sql

• Assignee: Dmitry Tolpeko
• Reporter: Johnson
• Due: 20/May/22
• Created: 16/May/22 07:41
• Updated: 17/May/22 01:50

Description

Hello dear experts,

          I met a block about the Dynamic SQL in hpl\sql.  It can't use this method to generate the correct string:

          DECLARE cur_col_list CURSOR FOR 
                ' SELECT col_name,col_type FROM ' || v_src_tb || 
                ' WHERE tb_name = ' || '''' || v_tb_name || '''' ;

         the result as below(missed single quotes on both side of sta_wop_md_op_topic_option :    

         

         but the correct result should be like this:   

         SELECT col_name,col_type
         FROM landing.meta
         WHERE tb_name = 'sta_wop_md_op_topic_option' ;