Assertion `memIsValid(pCtx->argv[i])' failed.

classic Classic list List threaded Threaded
2 messages Options
Reply | Threaded
Open this post in threaded view
|

Assertion `memIsValid(pCtx->argv[i])' failed.

Yongheng Chen
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:



Yongheng & Rui
_______________________________________________
sqlite-users mailing list
[hidden email]
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
Reply | Threaded
Open this post in threaded view
|

Re: Assertion `memIsValid(pCtx->argv[i])' failed.

Yongheng Chen
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 <[hidden email]> 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
[hidden email]
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users