Does Teiid Supports creation of auto-Increment Id?

[saurendra]

I am in the process of persisting data using Teiid designer tool. Due to the complexity of data in the form of content templates in xml format, I was created temp table and now putting data in the temp table first, for that I need to one column as auto-increment Id in the temp table. But I was not able to create auto-increment Id column, can anybody help me out....

[shawkins]

Temp tables do not yet support auto-increment.  That can be added though.  There should still be time to get it in 7.3.

Steve

[rareddy]

Here is another reference in our forms. http://community.jboss.org/message/534976#534976 If you are interested please log a JIRA for this feature here. https://jira.jboss.org/jira/browse/TEIID

[shawkins]

I logged and worked this under https://issues.jboss.org/browse/TEIID-1440.  So the NOT NULL contraint and the SERIAL auto increment type are in 7.3