use random temp table names to avoid conflicts #124

New Issue

allan · 2024-08-22T08:06:39Z

allan commented

2024-08-22 08:06:39 +00:00

MPRINT(POSTDATA.MPE_TARGETLOADER.BITEMPORAL_DATALOADER): proc sql;

MPRINT(POSTDATA.MPE_TARGETLOADER.BITEMPORAL_DATALOADER): create table EN_OD."##BITEMP_TERM"n as select * from work.bitemp0_append;

ERROR: The OLEDB table ##BITEMP_TERM has been opened for OUTPUT. This table already exists, or there is a name conflict with an existing object. This table will not be replaced. This engine does not support the REPLACE option.

MPRINT(POSTDATA.MPE_TARGETLOADER.BITEMPORAL_DATALOADER): proc sql; MPRINT(POSTDATA.MPE_TARGETLOADER.BITEMPORAL_DATALOADER): create table EN_OD."##BITEMP_TERM"n as select * from work.bitemp0_append; ERROR: The OLEDB table ##BITEMP_TERM has been opened for OUTPUT. This table already exists, or there is a name conflict with an existing object. This table will not be replaced. This engine does not support the REPLACE option.

allan commented

2024-08-27 10:42:36 +00:00

At the same time, bump core to implement this fix: https://github.com/sasjs/core/pull/376

allan referenced this issue from a commit

2024-08-31 14:19:07 +00:00

fix: bumping core for passthrough fix, #124

allan referenced this issue from a commit

2024-08-31 14:19:07 +00:00

fix: using temporary names for temporary tables

allan closed this issue

2024-08-31 14:23:49 +00:00

gitea-actions referenced this issue from a commit