public inbox for cygwin@cygwin.com
 help / color / mirror / Atom feed
* sqlite3: no such module: fts5
@ 2020-07-06  5:03 Morten Kjærulff
  2020-07-07 14:59 ` Morten Kjærulff
  2020-07-08  8:32 ` Jan Nijtmans
  0 siblings, 2 replies; 3+ messages in thread
From: Morten Kjærulff @ 2020-07-06  5:03 UTC (permalink / raw)
  To: cygwin

Hi,

I am (ok, almost) sure that I have created a fts5 db before, how did I?

$ echo "create virtual table t using fts5(t)"|sqlite3 t.db
Error: near line 1: no such module: fts5

$ sqlite3 --version
3.30.0 2019-10-04 15:03:17
c20a35336432025445f9f7e289d0cc3e4003fb17f45a4ce74c6269c407c6e09f

/Morten

^ permalink raw reply	[flat|nested] 3+ messages in thread

* Re: sqlite3: no such module: fts5
  2020-07-06  5:03 sqlite3: no such module: fts5 Morten Kjærulff
@ 2020-07-07 14:59 ` Morten Kjærulff
  2020-07-08  8:32 ` Jan Nijtmans
  1 sibling, 0 replies; 3+ messages in thread
From: Morten Kjærulff @ 2020-07-07 14:59 UTC (permalink / raw)
  To: cygwin

On Mon, Jul 6, 2020 at 7:03 AM Morten Kjærulff wrote:
>
> Hi,
>
> I am (ok, almost) sure that I have created a fts5 db before, how did I?
>
> $ echo "create virtual table t using fts5(t)"|sqlite3 t.db
> Error: near line 1: no such module: fts5
>
> $ sqlite3 --version
> 3.30.0 2019-10-04 15:03:17
> c20a35336432025445f9f7e289d0cc3e4003fb17f45a4ce74c6269c407c6e09f

Can anyone confirm that fts5 should / should not work by default?
Is there something wrong with my installation or has something
changed? I have a db I created last year and when trying to work with
that one, I also get the error.
/Morten

^ permalink raw reply	[flat|nested] 3+ messages in thread

* Re: sqlite3: no such module: fts5
  2020-07-06  5:03 sqlite3: no such module: fts5 Morten Kjærulff
  2020-07-07 14:59 ` Morten Kjærulff
@ 2020-07-08  8:32 ` Jan Nijtmans
  1 sibling, 0 replies; 3+ messages in thread
From: Jan Nijtmans @ 2020-07-08  8:32 UTC (permalink / raw)
  To: Morten Kjærulff; +Cc: cygwin

Op ma 6 jul. 2020 om 07:05 schreef Morten Kjærulff via Cygwin:
>
> Hi,
>
> I am (ok, almost) sure that I have created a fts5 db before, how did I?
>
> $ echo "create virtual table t using fts5(t)"|sqlite3 t.db
> Error: near line 1: no such module: fts5
>
> $ sqlite3 --version
> 3.30.0 2019-10-04 15:03:17
> c20a35336432025445f9f7e289d0cc3e4003fb17f45a4ce74c6269c407c6e09f

Hi Morten, thank you for bringing this to my attention.

Indeed, it looks like in the build somehow the ENABLE_FTS5 option was left out.
I'll correct this for the (upcoming) 3.32.3 version.

Thanks!
          Jan Nijtmans

^ permalink raw reply	[flat|nested] 3+ messages in thread

end of thread, other threads:[~2020-07-08  8:32 UTC | newest]

Thread overview: 3+ messages (download: mbox.gz / follow: Atom feed)
-- links below jump to the message on this page --
2020-07-06  5:03 sqlite3: no such module: fts5 Morten Kjærulff
2020-07-07 14:59 ` Morten Kjærulff
2020-07-08  8:32 ` Jan Nijtmans

This is a public inbox, see mirroring instructions
for how to clone and mirror all data and code used for this inbox;
as well as URLs for read-only IMAP folder(s) and NNTP newsgroup(s).