casa-mp-base

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