Re: Indexed database API autoIncrement

On Oct 23, 2011, at 3:04 PM, Jonas Sicking <jonas@sicking.cc> wrote:

> On Sun, Oct 23, 2011 at 4:20 AM, Futomi Hatano <info@html5.jp> wrote:
>> Hello everyone,
>> 
>> I'm not a W3C member, can I send a mail to the list?
> 
> Absolutely! This is a public list intended for just that!
> 
>> I've tried to use Indexed database API using IE10 PP3 and Chrome 16 dev.
>> I found a different behavior between the two.
>> I set autoIncrement to true when I created a Object Store as below.
>> 
>> var store = db.createObjectStore(store_name, { keyPath: 'id', autoIncrement: true });
>> 
>> Then, I added some records.
>> 
>> IE10 PP3 set the key value of the first recored to 0, while Chrome 16 set it to 1.
>> Which is correct?
>> I couldn't find the definition about this in the spec.
>> The first value of autoIncrement should be defined in the spec,
>> or the spec should allow us to set the first value of autoIncrement, I think.
>> 
>> Sorry in advance if the discussion has already been done.
>> Thank you for your time.
> 
> Good catch! This definitely needs to be specified in the spec.
> 
> I have a weak preference for using 1. This has a smaller risk of
> triggering edge cases in the client code since it's always truthy.
> I.e. if someone tries to detect the presence of an id, they won't fail
> due to the id being 0.

I agree -- this is also the behavior in all DBMS I've worked with. There's time for MS to update their implementation. All around win.

Received on Sunday, 23 October 2011 22:19:25 UTC