Many hyperlinks are disabled.
Use anonymous login to enable hyperlinks.
|Comment:||New test case that still hits an assertion fault, just to prove that the previous checkin merely made the problem more obscure and did not completely fix it.|
|Downloads:||Tarball | ZIP archive | SQL archive|
|Timelines:||family | ancestors | descendants | both | ticket-f09fcd17810f|
|Files:||files | file ages | folders|
|User & Date:||drh 2018-12-06 19:56:20|
|22:04||Fix the sqlite3ExprDup() routine so that it makes complete duplications of subqueries containing window functions. check-in: 94017454 user: drh tags: ticket-f09fcd17810f|
|19:56||New test case that still hits an assertion fault, just to prove that the previous checkin merely made the problem more obscure and did not completely fix it. check-in: a9a3b532 user: drh tags: ticket-f09fcd17810f|
|19:15||Simplify the query flattener so that it does not duplicate the WHERE clause of subquery that is being incorporated into the outer query - copies it directly. This is more efficient. And it also fixes the specific test case show for ticket [f09fcd17810f65f71789525] but it does not resolve the more general problem that sqlite3ExprDup() does not correctly duplicate expressions that contain subqueries with window functions. check-in: f1b18d44 user: drh tags: ticket-f09fcd17810f|
Changes to test/window1.test.