Re: [sqlite] Bug: CTE name leaking through views

2019-05-24 Thread Stephen Hunt
I tried it out in trunk and it works for me as well. Thanks for your help! Steve On Wed, May 22, 2019 at 3:50 PM Richard Hipp wrote: > Thanks for the test case. This problem should now be fixed on trunk. > Please try it out and let us know if you encounter any additional > probglems. > > -- >

Re: [sqlite] Bug: CTE name leaking through views

2019-05-22 Thread Stephen Hunt
Hi Richard, I just realized I didn't include the mailing list in my previous response to you, so I'm doing that now with the contents of the SQL file I sent you previously. I've also included a copy of my original email in plaintext as the HTML formatted SQL queries got mangled when it was

Re: [sqlite] Bug: CTE name leaking through views

2019-05-22 Thread Richard Hipp
Thanks for the test case. This problem should now be fixed on trunk. Please try it out and let us know if you encounter any additional probglems. -- D. Richard Hipp d...@sqlite.org ___ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org

Re: [sqlite] Bug: CTE name leaking through views

2019-05-02 Thread Richard Hipp
This mailing list disallows attachments as a anti-spam measure. You can send attachments directly to me, if you like. On 5/1/19, Stephen Hunt wrote: > Hi, > > We use SQLite extensively here at Zaber and are quite pleased with it. > However, we recently added a view that incorrectly returns

[sqlite] Bug: CTE name leaking through views

2019-05-01 Thread Stephen Hunt
Hi, We use SQLite extensively here at Zaber and are quite pleased with it. However, we recently added a view that incorrectly returns incorrect/NULL data. It appears to be cause by CTE names leaking outside of the view and being confused with another CTE with the same name but only if both CTEs