Re: [sqlite] Possibly pointless assert

2017-03-23 Thread Scott Robison
On Thu, Mar 23, 2017 at 11:05 AM, Dan Kennedy wrote: > On 03/23/2017 11:46 PM, Scott Robison wrote: >> >> Note: I'm on Windows 10 and reproduced this with the amalgamation >> downloaded today from >> http://sqlite.com/2017/sqlite-amalgamation-317.zip >> >> Step 1: Using

Re: [sqlite] Possibly pointless assert

2017-03-23 Thread Dan Kennedy
On 03/23/2017 11:46 PM, Scott Robison wrote: On Thu, Mar 23, 2017 at 10:17 AM, Scott Robison wrote: On Thu, Mar 23, 2017 at 9:21 AM, Dan Kennedy wrote: How did you trip the assert()? i.e. what is the database schema and query that cause it to

Re: [sqlite] Possibly pointless assert

2017-03-23 Thread Scott Robison
On Thu, Mar 23, 2017 at 10:17 AM, Scott Robison wrote: > On Thu, Mar 23, 2017 at 9:21 AM, Dan Kennedy wrote: >> How did you trip the assert()? i.e. what is the database schema and query >> that cause it to fail? > > In trying to track down issues

Re: [sqlite] Possibly pointless assert

2017-03-23 Thread Scott Robison
On Thu, Mar 23, 2017 at 9:21 AM, Dan Kennedy wrote: > On 03/23/2017 04:45 AM, Scott Robison wrote: >> >> Take a look at >> http://www.sqlite.org/cgi/src/artifact/3ed64afc49c0a222?ln=2214,2233 >> (especially the assert within). >> >> I may not be understanding something, but

Re: [sqlite] Possibly pointless assert

2017-03-23 Thread Dan Kennedy
On 03/23/2017 04:45 AM, Scott Robison wrote: Take a look at http://www.sqlite.org/cgi/src/artifact/3ed64afc49c0a222?ln=2214,2233 (especially the assert within). I may not be understanding something, but that assert seems pointless to me. The assert() says that if the buffer pointed to by

[sqlite] Possibly pointless assert

2017-03-22 Thread Scott Robison
Take a look at http://www.sqlite.org/cgi/src/artifact/3ed64afc49c0a222?ln=2214,2233 (especially the assert within). I may not be understanding something, but that assert seems pointless to me. The point of the loop is to check all the columns in an index to see if they are all binary collated.