Bug in fsdir

Previous Topic Next Topic
 
classic Classic list List threaded Threaded
5 messages Options
Reply | Threaded
Open this post in threaded view
|

Bug in fsdir

Jake
The following query causes a crash in fsdirNext on Windows 10.

SQLite version 3.22.0 2018-01-22 18:45:57
Enter ".help" for usage hints.
Connected to a transient in-memory database.
Use ".open FILENAME" to reopen on a persistent database.
sqlite> SELECT name FROM fsdir('.') JOIN (VALUES(1),(2));
.
./sqlite3.exe
./sqlite3_analyzer.exe
./sqldiff.exe
.

Adding an ORDER BY clause seems to provide workaround for this particular
case.

Regards

Jake
_______________________________________________
sqlite-users mailing list
[hidden email]
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
Reply | Threaded
Open this post in threaded view
|

Re: Bug in fsdir

Kees Nuyt
On Thu, 15 Mar 2018 15:55:05 +1100, Jake Thaw
<[hidden email]> wrote:

>The following query causes a crash in fsdirNext on Windows 10.
>
>SQLite version 3.22.0 2018-01-22 18:45:57
>Enter ".help" for usage hints.
>Connected to a transient in-memory database.
>Use ".open FILENAME" to reopen on a persistent database.
>sqlite> SELECT name FROM fsdir('.') JOIN (VALUES(1),(2));
>.
>./sqlite3.exe
>./sqlite3_analyzer.exe
>./sqldiff.exe
>.
>
>Adding an ORDER BY clause seems to provide workaround for this particular
>case.
>

Fixed by Richard Hipp on trunk:
https://www.sqlite.org/src/timeline 

--
Regards,
Kees Nuyt
_______________________________________________
sqlite-users mailing list
[hidden email]
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
Reply | Threaded
Open this post in threaded view
|

Re: Bug in fsdir

Richard Hipp-3
On 3/15/18, Kees Nuyt <[hidden email]> wrote:
> On Thu, 15 Mar 2018 15:55:05 +1100, Jake Thaw
> <[hidden email]> wrote:
>
>>The following query causes a crash in fsdirNext on Windows 10.
>
> Fixed by Richard Hipp on trunk:
> https://www.sqlite.org/src/timeline

Credit where credit is due.  Joe found and fixed the problem.  All I
did was merge it.

--
D. Richard Hipp
[hidden email]
_______________________________________________
sqlite-users mailing list
[hidden email]
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
Reply | Threaded
Open this post in threaded view
|

Re: EXTERNAL: Re: Bug in fsdir

Edwards, Mark C.
I put the amalgamated 3.22.0 release into my production code.  Windows 10 is the customer execution platform. Do I need to update?
___________________________________________
Mark C Edwards
Chief Scientist, C2 Systems Engineering & Integration
779 Monika Ct
Chubbuck, ID 83202
[hidden email]
Mobile: 208-241-7982



-----Original Message-----
From: sqlite-users [mailto:[hidden email]] On Behalf Of Richard Hipp
Sent: Thursday, March 15, 2018 10:38 AM
To: SQLite mailing list <[hidden email]>
Subject: EXTERNAL: Re: [sqlite] Bug in fsdir

On 3/15/18, Kees Nuyt <[hidden email]> wrote:
> On Thu, 15 Mar 2018 15:55:05 +1100, Jake Thaw <[hidden email]>
> wrote:
>
>>The following query causes a crash in fsdirNext on Windows 10.
>
> Fixed by Richard Hipp on trunk:
> https://www.sqlite.org/src/timeline

Credit where credit is due.  Joe found and fixed the problem.  All I did was merge it.

--
D. Richard Hipp
[hidden email]
_______________________________________________
sqlite-users mailing list
[hidden email]
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
_______________________________________________
sqlite-users mailing list
[hidden email]
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
Reply | Threaded
Open this post in threaded view
|

Re: EXTERNAL: Re: Bug in fsdir

Richard Hipp-3
On 3/15/18, Edwards, Mark C. <[hidden email]> wrote:
> I put the amalgamated 3.22.0 release into my production code.  Windows 10 is
> the customer execution platform. Do I need to update?

Probably not.  A complete list of bugs fixed so far for 3.23.0 can be
seen in the draft release notes at
https://www.sqlite.org/draft/releaselog/3_23_0.html

On the other hand, if you want to run with the latest pre-release
snapshot (downloaded from the https://www.sqlite.org/download.html
page) that would be great.  We always appreciate beta testing.  Let us
know if you encounter any problems.  Note that I ran a complete TH3
test overnight last night (on linux) with no issues reported.  That's
197,490,286 tests.  The snapshot is table.

--
D. Richard Hipp
[hidden email]
_______________________________________________
sqlite-users mailing list
[hidden email]
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users