I'm using Aurelius with ElevateDB and I found a minor problem. All identity fields that I created are starting with value 2 for the first record inserted on each table. That's not a big deal, but I would like to start with value 1.
To isolate my app from the problem I used the original script to create the table to manually create a table on ElevateDB Manager:
CREATE TABLE "TipoAtivo"
(
"Id" INTEGER GENERATED BY DEFAULT AS IDENTITY (START WITH 1, INCREMENT BY 1) NOT NULL,
"Nome" VARCHAR(10) COLLATE "UNI" NOT NULL,
"Descricao" VARCHAR(50) COLLATE "UNI" NOT NULL,
CONSTRAINT "PK_TipoAtivo" PRIMARY KEY ("Id")
)
When I use ElevateDB Manager to insert a new record, this new record returns the value 2 for id column, I tried to just change the text START WITH 1 to START WITH 0 and recreate the table and insert a first record again and I got value 1 for the first record.
Is possible to change this initial value to 0?
I tried to use Sequence mapping, but this didn't work.
Thanks
Hello,
I believe this is an issue with ElevateDB and you should ask them for a fix?
If the SQL statement says "START WITH 1", it should start with 1, not 2.
You're right, I'll ask them.
Thank you.