Axel Busch wrote: > I'm running sap db 7.3.0.15 on Windows 2000. > I created a table like this: > > CREATE TABLE tab_test ( > test_id INTEGER NOT NULL DEFAULT SERIAL (10000), > text VARCHAR(255) NOT NULL DEFAULT '-', > PRIMARY KEY(test_id) > ); > > And inserted Data like that: > INSERT INTO tab_test VALUES(DEFAULT,'blib') > OK > > all fine, as expected. > But after a reboot I can not insert data anymore like that > because: > > INSERT INTO tab_test VALUES(DEFAULT,'blib') > Native error: 200 > Text: [SAP AG][SQLOD32 DLL][SAP DB]Integrity > constraint violation;200 POS(1) Duplicate key. > > Wow. Does sapdb reset the SERIAL fields after reboot?
This is a known bug, fixed with some release > 7.3.0.15. Use the newest kernel version and the serials will behave as expected. Elke SAP Labs Berlin _______________________________________________ sapdb.general mailing list [EMAIL PROTECTED] http://listserv.sap.com/mailman/listinfo/sapdb.general
