Re: [sqlite] strange behaviour on sqlite shell output…

2017-04-17 Thread aotto
Am 17.04.2017 um 10:34 schrieb aotto: ……… This is the isolated test case this shows the BUG #include "stdio.h" int main ( int argc, char **argv ) { // code int i=3; int w=11; // → ?? int nArg=4; char *rowSep="\n"; char *azArg[4] = {NULL,NULL,

Re: [sqlite] strange behaviour on sqlite shell output…

2017-04-17 Thread aotto
Am 17.04.2017 um 10:26 schrieb aotto: Am 15.04.2017 um 09:49 schrieb aotto: select Reporter, Partner, Year, PartnerCode from [EXEC-BtH0] where Reporter = 'AGO' Hi, I add the following code in shell.c if( w<0 ){ utf8_printf(p->out,"%*.*s%s",-w

Re: [sqlite] strange behaviour on sqlite shell output…

2017-04-17 Thread aotto
Am 15.04.2017 um 09:49 schrieb aotto: select Reporter, Partner, Year, PartnerCode from [EXEC-BtH0] where Reporter = 'AGO' Hi, I add the following code in shell.c if( w<0 ){ utf8_printf(p->out,"%*.*s%s",-w,-w, azArg[i] ? azArg[i] : p-&

[sqlite] strange behaviour on sqlite shell output…

2017-04-15 Thread aotto
Hi…i have written a VTAB extension and using SHELL to view the results… + valgrind --leak-check=full --quiet gen/cltdb -column -echo -header gen/.my1 'select Reporter, Partner, Year, PartnerCode from [EXEC-BtH0] where Reporter = '\''AGO'\'' and select Reporter, Partner, Year, PartnerCode from [

[sqlite] need help to implement a VTAB on a already sorted table

2017-03-31 Thread aotto
Hi… I'm new to this mailing-list because I have a problem to define a "VIRTUAL TABLE" sqlite3 extension. I already have a working implementation with close empty *xBestIndex and *xFilter. 1) My data is already in a sorted list with ONE or MORE primary index columns 2) Currently the VTAB is al