On 18 Apr 2013, at 10:38am, Bk wrote: > can some one tell me which of the tcl test script tests below two points of > SQLite ? > > 1) Variable-length records
If you're using the term 'variable length' because you're used to a different SQL engine, then there's a paradigm shift: almost all SQLite records are variable-length. SQLite does not support fixed-length text fields: all text fields can be of any length. It even uses variable numbers of bytes to encode integer values. So almost all testing you do of SQLite will be testing variable length fields. <http://www.sqlite.org/fileformat2.html#varint> > 2) Internal or temporary databases: load the data into an in-memory SQLite > database and use queries with joins and ORDER BY clauses to extract the data > in the form and order needed SQLite distinguishes between 'memory' and 'temporary'. The two things do different things. You can even have something which combines the two. This is how you do memory: <http://www.sqlite.org/inmemorydb.html> You create TEMPORARY TABLES using "CREATE TEMPORARY TABLE". Temporary tables are usually stored on disk. The only difference is that closing the database automatically deletes those tables. (Actually, I'm not sure how multiple connections to a temporary TABLE may or may not work.) There are numerous tests in the test suites which test memory and/or temporary features. If you run the whole test suite, you'll get them all. Simon. _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
