Hi,
We tried debugging a little bit with the core dump, it crashes with a null
reference actually:
`
Program received signal SIGSEGV, Segmentation fault.
[----------------------------------registers-----------------------------------]
RAX: 0x74 ('t')
RBX: 0x782550 --> 0x76b088 --> 0x1
RCX: 0x61 ('a')
RDX: 0x0
RSI: 0x0
RDI: 0x782098 --> 0x31656c626174 ('table1')
RBP: 0x782548 --> 0x100000001
RSP: 0x7fffffffb6b0 --> 0x78d1b0 --> 0x78d1e8 --> 0x5080440000000096
RIP: 0x4b4237 (<selectExpander+407>: movzx ecx,BYTE PTR [rdx+rsi*1])
R8 : 0x77d0e8 --> 0x1
R9 : 0x0
R10: 0x77d0f8 --> 0x0
R11: 0x0
R12: 0x1
R13: 0x7fffffffc680 --> 0x76a9b8 --> 0x73c300 --> 0x7800000003
R14: 0x7fffffffc680 --> 0x76a9b8 --> 0x73c300 --> 0x7800000003
R15: 0x0
EFLAGS: 0x10246 (carry PARITY adjust ZERO sign trap INTERRUPT direction
overflow)
[-------------------------------------code-------------------------------------]
0x4b422d <selectExpander+397>: jne 0x4b4270 <selectExpander+464>
0x4b422f <selectExpander+399>: add rsi,0x1
0x4b4233 <selectExpander+403>: movzx eax,BYTE PTR [rdi+rsi*1]
=> 0x4b4237 <selectExpander+407>: movzx ecx,BYTE PTR [rdx+rsi*1]
`
We got the same result if we debug with address sanitizer, not an out of memory
error.
Thanks,
Ming Jia
> On Dec 27, 2019, at 2:56 PM, Keith Medcalf <[email protected]> wrote:
>
>
> On Friday, 27 December, 2019 12:50, Igor Korot <[email protected]> wrote:
>
>> On Fri, Dec 27, 2019 at 12:57 PM Bigthing Do <[email protected]> wrote:
>
>>> We met an accidental crash in sqlite with the following sample:
>
>>> CREATE VIEW table1 ( col1 , col2 ) AS WITH aaa AS ( SELECT * FROM table1 )
>>> SELECT col2 FROM table1 ORDER BY 1 ;
>>> WITH aaa AS ( SELECT * FROM table1 ) SELECT col1 , rank () OVER( ORDER BY
>>> col1 DESC ) FROM table1 ;
>
>> Could you please provide the schema for table1?
>
> table1 is a circular view ... that is table1 is a view that tries to select
> from table1 which is a view which selects from table1 which is a view which
> selects from table1 ... until eventually all memory and stack is consumed and
> sqlite crashes.
>
> --
> The fact that there's a Highway to Hell but only a Stairway to Heaven says a
> lot about anticipated traffic volume.
>
>
>
>
> _______________________________________________
> sqlite-users mailing list
> [email protected]
> http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
_______________________________________________
sqlite-users mailing list
[email protected]
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
