WARNING: using non-UTF SQLite2 engine
LIB version: 2.8.17
DB version: 3.3.15
==== local callback ====
#cols = 5
col0: type
col1: name
col2: tbl_name
col3: rootpage
col4: sql
data0: table
data1: TEST
data2: TEST
data3: 2
data4: CREATE TABLE TEST(id, firstname, lastname)
==== get_table ====
id|firstname|lastname|
1|Christian|Werner|
2|John|Doe|
3|Duffy|Duck|
4|Mickey|Mouse|
5|Speedy|Gonzales|
==== get_table w/ args ====
type|name|tbl_name|rootpage|sql|
table|TEST|TEST|2|CREATE TABLE TEST(id, firstname, lastname)|
==== call regular function ====
function:
arg[0]=Christian
#cols = 1
col0: myregfunc(TEST.firstname)
data0: christian
function:
arg[0]=John
data0: john
function:
arg[0]=Duffy
data0: duffy
function:
arg[0]=Mickey
data0: mickey
function:
arg[0]=Speedy
data0: speedy
==== call aggregate function ====
step:
step:
step:
step:
step:
last_step
#cols = 1
col0: myaggfunc(TEST.firstname)
data0: Christian John Duffy Mickey Speedy 
==== compile/step interface ====
AUTH: 21,null,null,null,null
AUTH: 20,TEST,id,main,null
AUTH: 20,TEST,firstname,main,null
AUTH: 20,TEST,lastname,main,null
---- STMT #1 ----
TRACE: select * from TEST;
#cols = 3
col0: id
col1: firstname
col2: lastname
coltype0: integer
coltype1: text
coltype2: text
data0: 1
data1: Christian
data2: Werner
data0: 2
data1: John
data2: Doe
data0: 3
data1: Duffy
data2: Duck
data0: 4
data1: Mickey
data2: Mouse
data0: 5
data1: Speedy
data2: Gonzales
AUTH: 9,TEST,null,main,null
AUTH: 20,TEST,id,main,null
---- STMT #2 ----
TRACE:  delete from TEST where id = 5;
AUTH: 18,TEST,null,main,null
---- STMT #3 ----
TRACE:  insert into TEST values(5, 'Speedy', 'Gonzales');
AUTH: 21,null,null,null,null
AUTH: 20,TEST,id,main,null
AUTH: 20,TEST,firstname,main,null
AUTH: 20,TEST,lastname,main,null
setting progress handler
---- STMT #4 ----
TRACE:  select * from TEST
PROGRESS
PROGRESS
PROGRESS
#cols = 3
col0: id
col1: firstname
col2: lastname
coltype0: integer
coltype1: text
coltype2: text
data0: 1
data1: Christian
data2: Werner
PROGRESS
data0: 2
data1: John
data2: Doe
PROGRESS
data0: 3
data1: Duffy
data2: Duck
PROGRESS
data0: 4
data1: Mickey
data2: Mouse
PROGRESS
data0: 5
data1: Speedy
data2: Gonzales
An exception is expected from now on.
==== local callback ====
error: SQLite.Exception: database already closed
cleaning up ...
error: SQLite.Exception: database already closed
done.