Skip to Content
0
Former Member
Apr 20, 2015 at 06:13 AM

Cannot create temporary table having identity column

421 Views

Hi experts,


I saw the above error msg while running the following statement:


create local temporary column table #tmp_table (c1 int GENERATED by default AS IDENTITY (start with 1 increment by 1), c2 int)


Could not execute 'create local temporary column table #tmp_table(c1 int GENERATED by default AS IDENTITY (start with ...'

SAP DBTech JDBC: [7]: feature not supported: cannot create temporary table having identity column: C1: line 1 col 48 (at pos 47)

I understand we can support normal column table creation with identity column, but don't know why cannot support temporary column tables with identity column. Is there any configuration that can enable it for temporary column table? Or what can I do to support it indirectly, like writing a trigger to support it or something else?

If not, then is there any future plan for this feature?

Regards,

Hubery