Johnson created HIVE-26229:
------------------------------
Summary: HPLSQL
Key: HIVE-26229
URL: https://issues.apache.org/jira/browse/HIVE-26229
Project: Hive
Issue Type: Bug
Components: 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
Reporter: Johnson
Attachments: DDL.sql, image-2022-05-16-15-27-44-455.png,
landing.SP_DynamicSQL.proc
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
{color:#FF0000}sta_wop_md_op_topic_option{color} :
!image-2022-05-16-15-27-44-455.png!
but the correct result should be like this:
SELECT col_name,col_type
FROM landing.meta
WHERE tb_name = {color:#FF0000}'sta_wop_md_op_topic_option'{color} ;
--
This message was sent by Atlassian Jira
(v8.20.7#820007)
