Thanks for the fix.
> On Dec 9, 2019, at 9:43 AM, Richard Hipp wrote:
>
> On 12/8/19, Yongheng Chen wrote:
>>
>> We found one crash bug in sqlite,
>
> Simplified test case:
>
> CREATE TABLE t1(a);
> CREATE VIEW v2(b) AS WITH t3 AS (SELECT b FROM v2) VALUES(1);
> ALTER TABLE t1 RENAME TO t4;
On 12/8/19, Yongheng Chen wrote:
>
> We found one crash bug in sqlite,
Simplified test case:
CREATE TABLE t1(a);
CREATE VIEW v2(b) AS WITH t3 AS (SELECT b FROM v2) VALUES(1);
ALTER TABLE t1 RENAME TO t4;
Notice how the definition of the V2 view refers to itself. The ALTER
TABLE command was
3.30.1 x86_64 Linux
Same problem here.
___
sqlite-users mailing list
sqlite-users@mailinglists.sqlite.org
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
On 08 Dec 2019, at 21:55, Simon Slavin wrote:
> On 8 Dec 2019, at 7:51pm, Yongheng Chen wrote:
>
>> The bug exists in "SQLite version 3.31.0 2019-12-08 00:06:39” and before.
>
> SQLite version 3.28.0 2019-04-15 14:49:49
> Enter ".help" for usage hints.
> Connected to a transient in-memory
simon@178 sqlite-tools-osx-x86-3300100 % ./sqlite3
SQLite version 3.30.1 2019-10-10 20:19:45
Enter ".help" for usage hints.
Connected to a transient in-memory database.
Use ".open FILENAME" to reopen on a persistent database.
sqlite> CREATE TABLE v0 ( v1 ) ;
sqlite> CREATE TABLE v2 ( v3 ) ;
Yongheng Chen, on Sunday, December 8, 2019 02:51 PM, wrote...
>
> Hi,
>
> We found one crash bug in sqlite, which causes a dead loop and then OOM.
>
> CREATE TABLE v0 ( v1 ) ;
> CREATE TABLE v2 ( v3 ) ;
> CREATE VIEW v4 AS WITH x AS ( SELECT x () OVER( ) FROM v4 ) SELECT v3 AS x
> FROM v2 ;
I haven’t tested many versions. But the most up-to-date master branch and the
release version has this bug.
> On Dec 8, 2019, at 4:55 PM, Simon Slavin wrote:
>
> On 8 Dec 2019, at 7:51pm, Yongheng Chen wrote:
>
>> The bug exists in "SQLite version 3.31.0 2019-12-08 00:06:39” and before.
>
On 8 Dec 2019, at 7:51pm, Yongheng Chen wrote:
> The bug exists in "SQLite version 3.31.0 2019-12-08 00:06:39” and before.
SQLite version 3.28.0 2019-04-15 14:49:49
Enter ".help" for usage hints.
Connected to a transient in-memory database.
Use ".open FILENAME" to reopen on a persistent
Hi,
We found one crash bug in sqlite, which causes a dead loop and then OOM.
CREATE TABLE v0 ( v1 ) ;
CREATE TABLE v2 ( v3 ) ;
CREATE VIEW v4 AS WITH x AS ( SELECT x () OVER( ) FROM v4 ) SELECT v3 AS x FROM
v2 ;
DROP TRIGGER IF EXISTS x ;
ALTER TABLE v2 RENAME TO t3;
The bug exists
9 matches
Mail list logo