Hi, I am porting sqlite to vxworks. I use the shell to issue some
simple SQL commands. I can create a table and then I can issue insert
SQL statements, but when I try to display the data I inserted (by using
select) I always get the first record and only the first record I
inserted. I can create a second table and try the same thing and the
same thing happens. It seems that all inserts after the first one are
getting lost.
I have had to change a number of things because of the file systems
differences. It took some work to get the files management working
(???), but obviously there is still some work there.
I am sure it is my doing but I am looking for some pointers as to what
area of the code I should be looking at. I have a bunch of debug
statements but I don't see any error or anything suspicious. It appears
that the data is being written to the files, but somehow it gets lost.
May be it is the record retrieval where the problem is.
Any help would be greatly appreciated,
Thanks,
Juan //
I tried to include the trace but exceeded the MAX message size limit.
So, here are just the commands. If anybody would like to see the trace,
please let me know.
/***********************************************************************
***********************/
>sqlite_shell_main("/tffs0/testdb")
sqlite_shell_main: database filename = /tffs0/testdb
SQLite version 2.8.13
Enter ".help" for instructions
process_input: Enter
sqlite>
sqlite>
sqlite>
sqlite>
sqlite> create table autos(year smallint, make varchar(32), model
varchar(32), i
d smallint);
sqlite> .. Debug stuff omitted !
sqlite> insert into autos values(1990, 'toyota', 'corolla', 100);
sqlite> .. Debug stuff omitted !
sqlite> insert into autos values(1986, 'nissan', 'sentra', 101);
sqlite> .. Debug stuff omitted !
sqlite> select * from autos;
sqlite_exec: Enter
sqliteOsReadLock: Enter
sqliteOsReadLock: increment nLock
sqliteOsReadLock: pLock->cnt (0x1eccc94) set to 1
sqlitepager_pagecount: Enter (file = /tffs0/testdb)
FETCH 1
sqlitepager_pagecount: Enter (file = /tffs0/testdb)
FETCH 3
1990|toyota|corolla|100
sqliteOsUnlock: pLock->cnt (0x1eccc94) set to 0
sqlite_exec: Done. rc = 0
