各位大大:
我想在HANA上运行下面这个语句:
with tem_test as(
select * from dummy)
select * from tem_test;
分别在几个不同的HANA系统上运行,发现一个问题,有的系统可以运行成功,有些不行,报以下错误:
Could not execute 'with tem_test as( select * from dummy) select * from tem_test' in 81 ms 968 µs .
SAP DBTech JDBC: [259]: invalid table name: Could not find table/view TEM_TEST in schema XXXXX.
非常奇怪,请问有大牛知道原因吗?
Thanks in advance.
收起