python748 / alternate-java-bridge-library

Automatically exported from code.google.com/p/alternate-java-bridge-library
Apache License 2.0
0 stars 0 forks source link

SimplSQL rowid issue #12

Closed GoogleCodeExporter closed 8 years ago

GoogleCodeExporter commented 8 years ago
What steps will reproduce the problem?
1. add multiple tables to a database
2. insert 5 items into table 1
3. insert 5 items into table 2
4. insert 5 items into table 3
5. for table 2, the 5 items are entered with row id's 6 - 10 and for table 3 
row id's 11 - 15.  All tables should have 5 records with rowids 1 - 5 on each 
table.

What is the expected output? What do you see instead?
each table when adding information should start with rowid = 1

What version of the product are you using? On what operating system?
Latest Jar from 3/14, Windows 7 64 bit

Please provide any additional information below.

Original issue reported on code.google.com by bric...@gmail.com on 16 Mar 2012 at 1:29

GoogleCodeExporter commented 8 years ago
Some more information on this...I downloaded SQL editor so i could view the 
database.  It is actually reporting that on all 3 tables the 5 values are row 
ids 1 - 5.  So it looks like sql lite is storing the data correctly and maybe 
SimpleSQL is recording it wrong in its own records?  I dont know...its also 
possible SQL editor will display them as 1 - 5 regardless, treating the null 
items as nothing.

Original comment by bric...@gmail.com on 18 Mar 2012 at 2:48

GoogleCodeExporter commented 8 years ago
Are you still getting this? I created a test project, added two tables, and 
added several rows to each, and they each started at 1. Closing this for now.

Original comment by IMPINC...@gmail.com on 31 Mar 2012 at 6:04