Using alasql 0.3.9 in browser (Firefox, Chrome).
The code below prints out the contents of the table, but no value is assigned to aid:
alasql.promise( 'CREATE INDEXEDDB DATABASE IF NOT EXISTS geo2;'+
'ATTACH INDEXEDDB DATABASE geo2;'+
'USE geo2;'+
'DROP TABLE IF EXISTS autoinctab;'+
'CREATE TABLE IF NOT EXISTS autoinctab (aid INT AUTOINCREMENT, aname STRING);'+
'INSERT INTO autoinctab (aname) VALUES ("bar1"),("bar2");')
.then ( function() {
alasql.promise('SELECT * FROM autoinctab')
.then ( function(res) { console.log("res:"+JSON.stringify(res)); } )
.catch( function(err) { console.log("err:"+err); } )
})
.catch( function(err) { console.log(err); })
Result:
res:[{"aname":"bar1"},{"aname":"bar2"}]
I was expecting something like this:
res:[{"aid":0,"aname":"bar1"},{"aid":1,"aname":"bar2"}]
Using alasql 0.3.9 in browser (Firefox, Chrome).
The code below prints out the contents of the table, but no value is assigned to aid:
Result:
res:[{"aname":"bar1"},{"aname":"bar2"}]
I was expecting something like this:
res:[{"aid":0,"aname":"bar1"},{"aid":1,"aname":"bar2"}]