On Wed, 2007-11-28 at 21:28 +0800, Halton Huo wrote: > Hi Jamie, > > As title, when I have such file, the result for t-s-t and t-s (with > option -d) will be shorten. > > Test case > =========== > Suppose my watch dir is set to $HOME/Documents/test/symbols, and have > bunch of test case in that. > > $cd /export/home/halton/Documents/test/symbols > $ls > 1`2.txt 1=2.txt 1,2.txt 1?2.txt 1)2.txt 1}2.txt 1\2.txt 1+2.txt > 1^2.txt 1>2.txt 1;2.txt 1'2.txt 1[2.txt [EMAIL PROTECTED] 1&2.txt > 1~2.txt 1_2.txt 1:2.txt 1"2.txt 1]2.txt 1$2.txt 1#2.txt > 1<2.txt 1-2.txt 1!2.txt 1(2.txt 1{2.txt 1*2.txt 1%2.txt > $tracker-search -s Text -d 1 > /export/home/halton/Documents/test/symbols/1+2.txt : Text, text/plain, > /export/home/halton/Documents/test/symbols/1%2.txt : Text, text/plain, > /export/home/halton/Documents/test/symbols/1#2.txt : Text, text/plain, > /export/home/halton/Documents/test/symbols/1&2.txt : Text, text/plain, > /export/home/halton/Documents/test/symbols/1\2.txt : Text, text/plain, > /export/home/halton/Documents/test/symbols/1*2.txt : Text, text/plain, > /export/home/halton/Documents/test/symbols/1$2.txt : Text, text/plain, > /export/home/halton/Documents/test/symbols/[EMAIL PROTECTED] : Text, > text/plain, > /export/home/halton/Documents/test/symbols/1}2.txt : Text, text/plain, > /export/home/halton/Documents/test/symbols/1{2.txt : Text, text/plain, > /export/home/halton/Documents/test/symbols/1]2.txt : Text, text/plain, > /export/home/halton/Documents/test/symbols/1[2.txt : Text, text/plain, > /export/home/halton/Documents/test/symbols/1)2.txt : Text, text/plain, > /export/home/halton/Documents/test/symbols/1(2.txt : Text, text/plain, > /export/home/halton/Documents/test/symbols/1"2.txt : Text, text/plain, > > My analysing > ============ > After debugging, found file 1'2.txt is save as in file-meta.db > 3384|8|/export/home/halton/Documents/test/symbols|1''2.txt|1|text/plain| > 0|5||||||||||||||1|1|0|0|0|-1|1196235455|0|0| > > The saving will cause line 3246 in tracker-db-sqlite.c fail > > g_file_test (res[0][0], G_FILE_TEST_EXISTS) > > So problem is sqlite saving one sigle quote as two sigle quote in the > database. > > Is it a know sqlite issue? Or a bug for tracker?
I believe Laurent added a call to escape params passed to sqlite in line 4463 in tracker-db-sqlite.c - this no doubts escapes the single quote. Im not sure we need that call (Laurent?) as the params are passed to a prepared query so should not need escaping? jamie _______________________________________________ tracker-list mailing list tracker-list@gnome.org http://mail.gnome.org/mailman/listinfo/tracker-list