关于“contain not supported”的错误

Question

我运行下面的脚本：

store_code = ["AH0001","AH0003","AH0004","AH0005"]
typestr(store_code)
temp_store_tbl = table(store_code)

select * from shared_skx_tt6 where store_code in (exec * from temp_store_tbl)
select * from shared_skx_tt6 where store_code in (store_code)

出现错误：

Contain method not supported.

Answer 1

在DolphinDB中，变量名和字段名不能相同，因此需要重命名变量store_code。

应修改脚本：

store_code1 = ["AH0001","AH0003","AH0004","AH0005"]
typestr(store_code)
temp_store_tbl = table(store_code)

select * from shared_skx_tt6 where store_code in (exec * from temp_store_tbl)
select * from shared_skx_tt6 where store_code in (store_code1)