下一个代码工作:
REPLACE PROCEDURE prd2.SP_temp_not_working()
begin
declare V_REPORT_DATE int;
CREATE MULTISET VOLATILE TABLE VT_C,
NO FALLBACK,
NO LOG
(
REPORT_DATE DATE FORMAT 'YY/MM/DD' NOT NULL
)
UNIQUE PRIMARY INDEX( REPORT_DATE )
ON COMMIT PRESERVE ROWS;
l1:
FOR RD AS RD_CURS CURSOR FOR
SELECT 1 from VT_C
DO
SET V_REPORT_DATE =1 ;
end for l1;
end;
但这不管用
REPLACE PROCEDURE prd2.SP_temp_working()
begin
declare V_REPORT_DATE int;
CREATE MULTISET VOLATILE TABLE VT_C,
NO FALLBACK,
NO LOG
(
REPORT_DATE DATE FORMAT 'YY/MM/DD' NOT NULL
)
UNIQUE PRIMARY INDEX( REPORT_DATE )
ON COMMIT PRESERVE ROWS;
l1:
FOR RD AS RD_CURS CURSOR FOR
SELECT 1 -- from VT_C
DO
SET V_REPORT_DATE =1 ;
end for l1;
结束;
VT_C
循环TD内的表引发这样的错误:
这里怎么了?
数据库版本:Teradata 15.10.07.08
尝试了ANSI和默认会话模式-相同错误
升级版。我找到了可能的解决方案,手动创建易失性表,然后创建过程时只会出现警告。发生了什么事