The error pic got stripped. It was
"Database error: SQL logic error: {DELETE FROM ftsidx WHERE docid IN (SELECT
rowid FROM ftsdocs WHERE type='t' AND rid=0 AND idxed)}”
> On Jan 9, 2020, at 7:17 PM, Yongheng Chen <changoch...@gmail.com> wrote:
>
> Hi,
>
> We found an assertion failed in sqlite. Here’s the POC:
> —
> CREATE TABLE v0 ( v1 INT CHECK( datetime ( ( NULL ) ,( '1995-09-01' ) ,(
> 'GERMANY' ) ,( 'MED P' ) ,( 'abc' ) ,( 'Y' ) ,( '13' ) ,( 'MED BAG' ) ,(
> '199419' ) ,( 'LG CASEaaaaaaaaaaaa' ) ,( '1995-09-01' ) ,( 'SM BOX' ) ,( '' )
> ,( 'a' ) ,( 'c' ) ,( 'LG PACK' ) ,( 'GERMANY' ) ,( 'DELIVER IN PERSON' ) ,(
> 'EUROPE' ) ,( 'abc' ) ,( 'MED BAG' ) ,( 'integrity-check' ) ,( 'PROMO%%' ) ,(
> 'integrity-check' ) ,( 'abc' ) ,( '30' ) ,( '%%BRASS' ) ,( 'forest%%' ) ,(
> 'AIR' ) ,( 'LG PACK' ) ,( 'LG PACK' ) ,( 'LG CASEaaaaaaaaaaaa' ) ,( 'GERMANY'
> ) ,( 'MED PACK' ) ,( 'AIR' ) ,( 'MED PACK' ) ,( '23' ) ,( 'test' ) ,( '31' )
> ,( 'Brand#34' ) ,( 'PROMO%%' ) ,( '1995-03-15' ) ,( 'PROMO%%' ) ,( 'X' ) ,(
> '**%s**' ) ,( 'forest%%' ) ,( 10 ) ,( NULL ) , v1 ) = v1 ) ) ;
> INSERT INTO v0 ( v1 ) VALUES ( 10 ) ,( 9 ) ,( 10 ) ,(
> 'bbbbbbbbaaaaaaaaaaaaaaaaaaaabbbbbbbbaaaaaaaaaaaaaaaaaaaa' ) ,( '18' ) ,(
> 10.100000 ) ,( 0 ) ,( 0 ) ,( 10 ) ,( 10 ) ,( 'SM PACK' ) ;
> —-
>
> This exists in the debug built of latest chunk.
>
> We tried reporting it by opening a ticket. But I met a the following problem
> when submitting it:
>
> <PastedGraphic-2.png>
>
> Yongheng & Rui
_______________________________________________
sqlite-users mailing list
sqlite-users@mailinglists.sqlite.org
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
