S02012
Error Code
S02012
Error Message
Not support to create temporary table whose name has already been used.
RefId:S02012
Probable Causes
For versions prior to 2.00.10, the name of temporary table defined using with
as
in a SQL statement cannot be the same as the name of other
variables.
Note: This error was fixed since version 2.00.10.
For example, duplicate table name "t1" exists in the following script.
t1 = 1
t2 = table(1..3 as id)
with t1 as (select * from t2) select * from t1
Solutions
Check whether duplicate variable name exists and rename the temporary table.