Hi, Luke,
It's possible you'll want to enlist a friend who has some familiarity with
databases and utilities. to help you out, since the data you're after may
not be stored into a single table (like a spreadsheet). I don't know
enough about your needs and your experience to say.
That being
On 01/27/2015 06:48 PM, boscowitch wrote:
and the in an sqlite shell (SQLite version 3.8.8.1 2015-01-20 16:51:25)
I get following for a select with snippet:
EXAMPLE OUTPUT:
sqlite select docid,*,snippet(test) from test where german match a;
1|[1] a b c|1] ba/b b c
2|[{[_.,:;[1] a b c|1] ba/b
Luke, I'm willing to help out. Is this a one time conversion or do you need
to do it on an ongoing basis?
On Mon, Jan 26, 2015 at 2:26 PM, Luke Niewiadomski
lniewiadom...@thezerobase.com wrote:
I am looking to translate *.sqlite3 files into *.csv, or similar format.
Would you be willing to
Yeah, -ID 4 was just a desperate experiment for a hack with longer data
in the search to see if it would lead the snippet function to start
grabbing the data from the start (or at least one word/char more).
The offsets beeing wrong and therefore the b... was kinda expected of
me, but in case it
Hello since it this bug report (+ a dirty-fix) it might be useful for
both users and devs.
that's why I send a copy to both mailing lists!
I hope I don't bother the diligent devs who read all of both list, sry
to them, and thx for sqlite btw. ;)!
recently I wanted to use the snippet function in
One more find. Tested on 64-bit x86 Linux box, version 3.8.8.1.
printf create table t0(\211 DEFAULT(0=0)NOT/**/NULL);REPLACE into t0
select''; test.sql
./sqlite_asan test.sql
This does not crash under normal conditions, but both ASAN and
Valgrind claim an out-of-bound read, so they are probably
printf create table t0(\211 DEFAULT(0=0)NOT/**/NULL);REPLACE into t0
select''; test.sql
Argh, line breaks. You can just grab this:
wget http://lcamtuf.coredump.cx/afl/vulns/sqlite-oob-read.sql
/mz
___
sqlite-users mailing list
I am looking to translate *.sqlite3 files into *.csv, or similar format. Would
you be willing to point me in the right direction? I appreciate any help on
this. I am not technically apt enough to figure this out on my own.
Thank you!
-Luke Niewiadomski
My main reason for questioning the inconsistency in returned column
names between the three following cases is that SQL standards and other
SQL databases seem to all return short column names, not prefix.column
name in the three below scenarios. Having SQLite behave differently than
everyone else
On 26 Jan 2015, at 7:26pm, Luke Niewiadomski lniewiadom...@thezerobase.com
wrote:
I am looking to translate *.sqlite3 files into *.csv, or similar format.
Would you be willing to point me in the right direction? I appreciate any
help on this. I am not technically apt enough to figure
On 1/27/15, Michal Zalewski lcam...@coredump.cx wrote:
One more find. Tested on 64-bit x86 Linux box, version 3.8.8.1.
printf create table t0(\211 DEFAULT(0=0)NOT/**/NULL);REPLACE into t0
select''; test.sql
./sqlite_asan test.sql
Thanks. Fix is here:
On Mon, 26 Jan 2015 19:26:49 +
Luke Niewiadomski lniewiadom...@thezerobase.com wrote:
I am looking to translate *.sqlite3 files into *.csv, or similar
format. Would you be willing to point me in the right direction? I
appreciate any help on this.
for T in $(sqlite3 -noheader
12 matches
Mail list logo