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 [EXEC-BtH0] where
Reporter = 'AGO' and Partner = 'AUT'
Reporter Partner Year PartnerCode
---------- ---------- ---------- ----------------
AGO AUT 2000 EO EU WE €O $H
AGO AUT 2001 EO EU WE €O $H
AGO AUT 2002 EO EU WE €O $H
AGO AUT 2003 EO EU WE €O $H
AGO AUT 2004 EO EU WE €O $H
AGO AUT 2005 EO EU WE €O $H
AGO AUT 2006 EO EU WE €O $H
AGO AUT 2007 EO EU WE €O $H
AGO AUT 2008 EO EU WE €O $H
AGO AUT 2009 EO EU WE €O $H
AGO AUT 2010 EO EU WE €O $H
AGO AUT 2011 EO EU WE €O $H
AGO AUT 2012 EO EU WE €O $H
AGO AUT 2013 EO EU WE €O $H
AGO AUT 2014 EO EU WE €O $H
AGO AUT 2015 EO EU WE €O $H
→ I have problem with the "PartnerCode" column… with the € sign… for
DETAIL "where"
(where Reporter = '\''AGO'\'' and Partner = '\''AUT'\''') everything
looks fine… "EO EU WE €O $H"
with LESS DETAIL "where"
+ valgrind --leak-check=full --quiet gen/cltdb -column -echo -header
gen/.my1 'select Reporter, Partner, Year, PartnerCode from [EXEC-BtH0]
where Reporter = '\''AGO'\'''
select Reporter, Partner, Year, PartnerCode from [EXEC-BtH0] where
Reporter = 'AGO'
Reporter Partner Year PartnerCode
---------- ---------- ---------- -----------
AGO ABW 2000 CA $H
AGO ABW 2001 CA $H
AGO ABW 2002 CA $H
...
AGO AUS 2009 OC FR E5 $H
AGO AUS 2010 OC FR E5 $H
AGO AUS 2011 OC FR E5 $H
AGO AUS 2012 OC FR E5 $H
AGO AUS 2013 OC FR E5 $H
AGO AUS 2014 OC FR E5 $H
AGO AUS 2015 OC FR E5 $H
AGO AUT 2000 EO EU WE 342202
AGO AUT 2001 EO EU WE 342202
AGO AUT 2002 EO EU WE 342202
AGO AUT 2003 EO EU WE 342202
AGO AUT 2004 EO EU WE 342202
AGO AUT 2005 EO EU WE 342202
AGO AUT 2006 EO EU WE 342202
AGO AUT 2007 EO EU WE 342202
AGO AUT 2008 EO EU WE 342202
AGO AUT 2009 EO EU WE 342202
AGO AUT 2010 EO EU WE 342202
AGO AUT 2011 EO EU WE 342202
AGO AUT 2012 EO EU WE 342202
AGO AUT 2013 EO EU WE 342202
AGO AUT 2014 EO EU WE 342202
AGO AUT 2015 EO EU WE 342202
AGO AZE 2000 AS ZW $h
AGO AZE 2001 AS ZW $h
> i get strange numbers…"342202"
→ valgrind leakcheck says…everything is fine.
my compile command is…
ccache gcc -DNUM2 -c -o gen/shell.o -ggdb -Wall -Wextra -Isqlite
-Ilibmsgque -Igen -I../libclt/build -D_HAVE_SQLITE_CONFIG_H -DDEBUG=1
-DHAVE_READLINE=1 \
-Wno-extra -Wno-unused-value -Wno-unused-but-set-variable
-Wno-unused-function \
shell.c
bin/Header.bash cltraw.c 1>gen/cltraw.h
ccache gcc -DNUM1 -c -o gen/cltdb.o -ggdb -Wall -Wextra -Isqlite
-Ilibmsgque -Igen -I../libclt/build -D_HAVE_SQLITE_CONFIG_H -DDEBUG=1
-Wno-unused-function cltdb.c
ccache gcc -DNUM1 -c -o gen/cltraw.o -ggdb -Wall -Wextra -Isqlite
-Ilibmsgque -Igen -I../libclt/build -D_HAVE_SQLITE_CONFIG_H -DDEBUG=1
-Wno-unused-function cltraw.c
ccache gcc -o gen/cltdb -ggdb -lreadline -lncurses gen/shell.o
gen/cltdb.o gen/cltraw.o ../libclt/build/libclt.a
libmsgque/.libs/libmsgque.a
ccache gcc -DNUM3 -std=gnu99 -c -o gen/abrain.o -ggdb -Wall -Wextra
-Isqlite -Ilibmsgque -Igen -I../libclt/build -D_HAVE_SQLITE_CONFIG_H
-DDEBUG=1 -DMQ_IGNORE_EXTERN \
-Wno-ignored-qualifiers -Wno-unused-parameter \
abrain.c
ccache gcc -o gen/msqdb -ggdb gen/abrain.o gen/cltdb.o gen/cltraw.o
../libclt/build/libclt.a libmsgque/.libs/libmsgque.a
make[1]: Leaving directory '/home/dev1usr/WorldBank/clt/db'
thanks for your support !!
_______________________________________________
sqlite-users mailing list
[email protected]
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
