[sqlite] fixing time-warp

I found some posts in the past describing fixing time-warps using tags. How does this process get initiated? I found two while trying to export to .git sqlite> SELECT l.*, ep.mtime, ec.mtime FROM plink l LEFT JOIN event ep ON pid = ep.objid LEFT JOIN event ec ON cid = ec.objid WHERE ep.mtime >

Re: [sqlite] fixing time-warp

Richard Hipp <d...@sqlite.org> wrote: > On Mon, Nov 3, 2014 at 8:13 PM, E. Timothy Uy <t...@loqu8.com> wrote: > > > I found some posts in the past describing fixing time-warps using tags. > How > > does this process get initiated? I found two while trying to expor

Re: [sqlite] fixing time-warp

Ok, I now see that you intentionally left 2 time-warps in place. It would be helpful to make that as a note for exporting to git. It is also confusing that the tags are there showing that they were fixed. On Mon, Nov 3, 2014 at 5:44 PM, E. Timothy Uy <t...@loqu8.com> wrote: > Dea

Re: [sqlite] fixing time-warp

Guess my photo got blocked - https://www.sqlite.org/src/timeline?c=2010-09-28+20:26:44 shows the time-warp but also the tag messages fixing them (which I guess you later unfixed in the db). On Mon, Nov 3, 2014 at 5:46 PM, E. Timothy Uy <t...@loqu8.com> wrote: > Ok, I now see

Re: [sqlite] fixing time-warp

Is that a philosophical question? :) On Mon, Nov 3, 2014 at 5:52 PM, Richard Hipp <d...@sqlite.org> wrote: > On Mon, Nov 3, 2014 at 8:46 PM, E. Timothy Uy <t...@loqu8.com> wrote: > > > Ok, I now see that you intentionally left 2 time-warps in place. It would > > be

Re: [sqlite] fixing time-warp

- they are all held in high regard. > 1. Why is it a good idea for you, E. Timothy Uy, to dump the SQLite code > repo into a Git repo? What does this achieve, that keeping it in Fossil > does not? > Like fossil, I use SQLite code as part of a larger project. This larger project is using

Re: [sqlite] fixing time-warp

v 4, 2014 at 10:07 PM, E. Timothy Uy <t...@loqu8.com> wrote: > I am not behind http://repo.or.cz/w/sqlite.git - though Kyle (the one > behind it) has some good ideas that would be nice to get into fossil. But > he doesn't care to try to get them into fossil. I do. Please don't > mis

Re: [sqlite] fixing time-warp

Thank you, that is helpful information. On Tue, Nov 4, 2014 at 11:52 PM, Stephan Beal <sgb...@googlemail.com> wrote: > On Wed, Nov 5, 2014 at 7:07 AM, E. Timothy Uy <t...@loqu8.com> wrote: > > > The problem is ultimately not time-warps. DRH can confirm - the problem

[sqlite] default ignore-glob for sqlite

Hi, I noticed that the ignore-glob for sqlite is empty. Is it just because fossil does not transfer this information? What should I be using? Thank you, Tim ___ sqlite-users mailing list sqlite-users@sqlite.org

Re: [sqlite] default ignore-glob for sqlite

Thank you Jan. On Thu, Nov 6, 2014 at 7:46 AM, Jan Nijtmans <jan.nijtm...@gmail.com> wrote: > 2014-11-06 1:14 GMT+01:00 E. Timothy Uy <t...@loqu8.com>: > > Hi, I noticed that the ignore-glob for sqlite is empty. Is it just > because > > fossil does not transfer t

[sqlite] compiling for WP81

Hi, I am attempting to compile for WP81 using build-all-msvc.bat. However, when I initialize with vcvarsphoneall, I end up with /debug /out:mkkeywordhash.exe "/LIBPATH:F:\Program Files (x86)\Microsoft Visual Studio 12.0\VC\lib" "/LIBPATH:C:\Program Files (x86)\Windows Phone Silverlight

Re: [sqlite] compiling for WP81

Seems that when making mkkeywordhash.exe, it should be using the x86 lib paths. On Thu, Nov 20, 2014 at 12:45 AM, E. Timothy Uy <t...@loqu8.com> wrote: > Hi, I am attempting to compile for WP81 using build-all-msvc.bat. However, > when I initialize with vcvarsphoneall, I end up wit

Re: [sqlite] compiling for WP81

It seem the problem was that I was calling vcvarsphoneall first. Though I am surprised the winrt build worked fine. On Thu, Nov 20, 2014 at 11:15 AM, Joe Mistachkin <sql...@mistachkin.com> wrote: > > E. Timothy Uy wrote: > > > >> Seems that when making mkkeywordh

Re: [sqlite] compiling for WP81

that you are no longer dependent on vcvarsphoneall.bat. On Thu, Nov 20, 2014 at 12:03 PM, E. Timothy Uy <t...@loqu8.com> wrote: > It seem the problem was that I was calling vcvarsphoneall first. Though I > am surprised the winrt build worked fine. > > On Thu, Nov 20, 2014 at 11:15

Re: [sqlite] default ignore-glob for sqlite

Jan, I added to your list .target_source lemon.obj libsqlite3.lib mkkeywordhash.obj sqlite3.def sqlite3.dll sqlite3.exp sqlite3.lib On Thu, Nov 6, 2014 at 9:25 AM, E. Timothy Uy <t...@loqu8.com> wrote: > Thank you Jan. > > On Thu, Nov 6, 2014 at 7:46 AM, Jan Nijtmans <jan.

[sqlite] visx for regular old windows

Does the visx for regular old windows actually work? After installing it I don't see anything in VS2013. ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] visx for regular old windows

gs may improve in > VS 2015. Perhaps we can find out from the CTP release? > > Sent from my iPod > > > On Feb 11, 2015, at 4:13 PM, E. Timothy Uy <t...@loqu8.com> wrote: > > > > Does the visx for regular old windows actually work

[sqlite] recommended way to attach SQLite.Interop.dll

Hi, when I add the nuget package for System.Data.SQLite, I don't see the interop.dll. However, it is in the nuget packages folder. Am I supposed to manually link to this? Concerned about missing things if we update the nuget. Ideally it should show up automagically. (maybe I missed something)

[sqlite] CEROD in System.Data.SQLite

I'm working on switching our custom build of System.Data.SQLite from our custom build and am having problems opening a CEROD database. Going back over our code, I see that I wrote in Open(): // TU: Need to split out "cerod" prepend to filename before expandfilename string

Re: [sqlite] CEROD in System.Data.SQLite

I have confirmed that the unencrypted version works fine. Perhaps this is the issue, that it is trying to ExpandFilename on a string that is prepended by ":cerod:". On Wed, Feb 11, 2015 at 7:37 PM, E. Timothy Uy <t...@loqu8.com> wrote: > I'm working on switchi

Re: [sqlite] CEROD in System.Data.SQLite

ey(opts, "ToFullPath", DefaultToFullPath.ToString())); fileName = ExpandFileName(fileName, toFullPath); } } Maybe I can temporarily shunt it using "toFullPath". On Thu, Feb 12, 2015 at 3:43 AM, E. Timothy Uy <t...@loqu8.com> wrote: > I have confirmed

Re: [sqlite] CEROD in System.Data.SQLite

I tried conn = new SQLiteConnection(String.Format("Data Source={0};ToFullPath=False", ":memory:")); but unfortunately still no love On Thu, Feb 12, 2015 at 3:45 AM, E. Timothy Uy <t...@loqu8.com> wrote: > http://system.data.sqlite.org/index.html/artifact/9a6

[sqlite] SQLite using internally by Windows 10

Congratulations. On Thu, Apr 30, 2015 at 8:24 PM, Richard Hipp wrote: > https://twitter.com/john_lam/status/593837681945092096 > > -- > D. Richard Hipp > drh at sqlite.org > ___ > sqlite-users mailing list > sqlite-users at mailinglists.sqlite.org >

[sqlite] unable to use function MATCH in requested context

Hi, as a sanity check, did something change in the use of MATCH with JOINs? I used to do SELECT ... FROM Entries e INNER JOIN Combos c ON e.Entries MATCH c.combo INNER JOIN Entries_content ec ON ec.docid = e.docid but now I get "unable to use function MATCH in the requested context". I can pull

Re: [sqlite] unable to use function MATCH in requested context

In fact, it does not work in a nested query - the issue is actually multiple inner joins. When I LEFT JOIN the rest of the tables, it works fine. This must have been a change in the last year or so. On Tue, Dec 31, 2013 at 3:15 PM, E. Timothy Uy <t...@loqu8.com> wrote: > Hi, as a san

[sqlite] unable to use function MATCH in the requested context

This is a class of problems I started seeing around 3.8.x. Any insights would be much appreciated. Sometimes it happens when there are more than a few INNER JOINS, others, in the case, happen when I ORDER BY the virtual table's docid. I feel like this used to work. SQLite version 3.8.2 2013-12-06

[sqlite] order of = in join

#1 - f.term = t.term SELECT m.term AS term, m.definition AS definition FROM (SELECT t.term, e.definition FROM Terms_content t INNER JOIN Favorites f ON f.term = t.term LEFT JOIN TermEntries te ON te.termid = t.docid LEFT JOIN Entries e ON e.docid = te.entryid) AS m LEFT JOIN Favorites f ON f.term

[sqlite] too many SQL variables

Just for my edification, what is the limit on the number of SQL parameters? Today I hit "too may SQL variables" with about 1400... ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] too many SQL variables

Hehe, you know it. On Thu, Jan 30, 2014 at 11:51 AM, RSmith wrote: > > Just for my edification, what is the limit on the number of SQL >> parameters? >> Today I hit "too may SQL variables" with about 1400... >> Just for our edification, which kind of statement was that? >>

[sqlite] activate statement count with sqlite3_interrupt

Hi, I am considering using sqlite3_interrupt to interrupt a long query - but the documentation states that the order will stand until the activate statement count is zero. How do I know that the activate statement count is zero? ___ sqlite-users mailing

Re: [sqlite] activate statement count with sqlite3_interrupt

efore the running statements reaches zero are interrupted as if they had been running prior to the sqlite3_interrupt() call." On Mon, Apr 7, 2014 at 11:52 AM, Richard Hipp <d...@sqlite.org> wrote: > On Mon, Apr 7, 2014 at 2:47 PM, E. Timothy Uy <t...@loqu8.com> wrote: > &g

Re: [sqlite] activate statement count with sqlite3_interrupt

In this case I have a text box where the user types in search results. I want to cancel all pending searches the moment they start typing something else. On Mon, Apr 7, 2014 at 12:04 PM, E. Timothy Uy <t...@loqu8.com> wrote: > Isn't the interrupt in play until all active statements

[sqlite] associating a ticket in the UI to a check-in

Is there a way to associate a ticket in the UI to a check-in or am I too late? Thanks, Tim ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] associating a ticket in the UI to a check-in

Never mind, I just needed brackets. On Thu, Oct 18, 2012 at 8:07 PM, E. Timothy Uy <t...@loqu8.com> wrote: > Is there a way to associate a ticket in the UI to a check-in or am I too > late? > > Thanks, > Tim > ___ sqlite-users m

[sqlite] hfs+ on bootcamp -> database malformed?

I'm suddenly getting a "database disk image is malformed" on a customer after they had a bad HFS+ install. They are running Boot Camp on a Mac. I checked and the db is exactly the same on my machine and his, but he gets the error. Is anyone else seeing this?

Re: [sqlite] hfs+ on bootcamp -> database malformed?

No, I checked the hash of his version and mine, they are identical. It really is something strange on his machine. He claims that it stopped working after uninstalling HFS+. On Wed, Nov 21, 2012 at 12:02 PM, Simon Slavin <slav...@bigfraud.org> wrote: > > On 21 Nov 2012, at 6:32pm, E

[sqlite] compiling tools for winrt

Hi, in xcompiling tools for winrt I get the errors below. I suspect this because I am using the vcvars for cross compiling winrt. Is there a way to make this work? MSVCRT.lib(gs_report.obj) : error LNK2019: unresolved external symbol __imp__IsDebuggerPresent@0 referenced in function

Re: [sqlite] compiling tools for winrt

pragma > > #ifdef _MSC_VER > #pragma comment(lib, "kernel32.lib") > #endif > > > On 1/9/2013 3:04 PM, E. Timothy Uy wrote: > >> Hi, in xcompiling tools for winrt I get the errors below. I suspect this >> because I am using the vcvars for cross compiling w

[sqlite] compiling for WP8

Hi, I'm working on compiling for Windows Phone. Are there any helpful notes? In particular, I'm stalled at the missing 'rc' (resource compiler) in the WP8 developer command prompt. Thanks, tim ___ sqlite-users mailing list sqlite-users@sqlite.org

[sqlite] bind field name?

Hi, is it possible to bind a field name to a sqlite query? For example, WHERE @field1 > @param1 ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

[sqlite] the Nth 32-bit int in byte array in query

I'm using matchinfo(...,'s') to get the length of the longest subsequence of phrase matches from FTS4. I have 4 columns, so I end up with a byte array that is 16 bytes long. I would like to extract the value for the Nth column in query and sort by it. I would also be interested in getting the

Re: [sqlite] the Nth 32-bit int in byte array in query

Scratch that - I realized I could use substr. On Tue, May 14, 2013 at 11:57 PM, E. Timothy Uy <t...@loqu8.com> wrote: > I'm using matchinfo(...,'s') to get the length of the longest subsequence > of phrase matches from FTS4. I have 4 columns, so I end up with a byte > array t

[sqlite] pDb->inTrans

Hi, I'm getting the following error in the latest code (after merging with my own). sqlite3.c(145194) : error C2039: 'inTrans' : is not a member of 'Db' sqlite3.c(9976) : see declaration of 'Db' sqlite3.c(145234) : error C2039: 'inTrans' : is not a member of 'Db' sqlite3.c(9976) :

Re: [sqlite] pDb->inTrans

Sorry, please ignore this message. I spaced out and forgot to 'fossil up' after 'fossil sync'. On Wed, Sep 4, 2013 at 2:48 PM, E. Timothy Uy <t...@loqu8.com> wrote: > Hi, I'm getting the following error in the latest code (after merging with > my own). > > sqlite3.c(145

[sqlite] virtual table end of insert

In a virtual table, an insert of multiple rows calls xUpdate multiple times. How can I tell when the entire insert is complete? e.g., INSERT INTO myvirtualtable (token, rank) VALUES (..,..), (..,..),(..,..) will call xUpdate 3 times. But I would like to know when the whole thing is done so that

[sqlite] updating config.guess and config.sub

Hi, while compiling for Android, I ran into the issue where arm-linux-androideabi is not recognized as a host. Apparently there is an updated version of config.guess and config.sub (from AutoTools) that addresses this issue. Recommend an update of these two files in the next version. In case

[sqlite] Odd insertion error FTS4 + ICU

Hopefully someone has some insight on this. I am using FTS4 with tokenize=icu (and PRAGMA encoding="UTF-8"). I'm getting getting an error inserting the following into my virtual table: 一日耶羅波安出 If I add a byte to the front, lets say "|", it works. If I delete the first character, or delete the

Re: [sqlite] Odd insertion error FTS4 + ICU

I recompiled ICU using U_CHARSET_IS_UTF8 and the error persists. On Mon, Jun 18, 2012 at 11:45 AM, E. Timothy Uy <t...@loqu8.com> wrote: > Hopefully someone has some insight on this. I am using FTS4 with > tokenize=icu (and PRAGMA encoding="UTF-8"). I'm getting gettin

Re: [sqlite] Odd insertion error FTS4 + ICU

ntu Linux x64. Respectfully, Tim On Mon, Jun 18, 2012 at 12:29 PM, Dan Kennedy <danielk1...@gmail.com> wrote: > On 06/19/2012 02:11 AM, E. Timothy Uy wrote: > > I recompiled ICU using U_CHARSET_IS_UTF8 and the error persists. > > > > On Mon, Jun 18, 2012 at 11:45 AM

Re: [sqlite] Odd insertion error FTS4 + ICU

%E6%97%A5 耶 32822 %E8%80%B6 羅 32645 %E7%BE%85 波 27874 %E6%B3%A2 安 23433 %E5%AE%89 出 20986 %E5%87%BA On Mon, Jun 18, 2012 at 12:59 PM, E. Timothy Uy <t...@loqu8.com> wrote: > Thanks for writing back Dan. Using charCodeAt() in Javascript, I have the > following for 一日耶羅波安出: > > 199

Re: [sqlite] Odd insertion error FTS4 + ICU

gt; On 06/19/2012 03:39 AM, E. Timothy Uy wrote: > > If anyone can unravel this mystery, it would be much appreciated. For > now, > > I inserted a comma - 一日、耶羅波安出 and it works. I suspect it must be somehow > > that the sequence of bytes encodes another character, which throws

Re: [sqlite] Odd insertion error FTS4 + ICU

you much. Respectfully, Tim On Mon, Jun 18, 2012 at 2:20 PM, E. Timothy Uy <t...@loqu8.com> wrote: > I'll take a look right now. Though my first thought was if you change > U8_NEXT to U16_NEXT, wouldn't you have to change it everywhere else? I > recompiled ICU with U_CHARSET_

Re: [sqlite] I consider this a bug. Anyone else?

Bill, Andrew, PA Newsgroups et al., Would you be willing to invest in a subscription for a compiled, signed, non-Debug, Windows-deployed SQLite DLL with resource information? We would consider compiling and hosting the files for you. In addition, we could offer improved stemming (multiple

Re: [sqlite] I consider this a bug. Anyone else?

" 40-80 hours digging deep into how System.Data.SQLite.dll is built " Lol, I actually did this. On Tue, Jun 26, 2012 at 11:00 AM, Andrew Rondeau wrote: > The answer of "just add sqlite.c to your project" is great when you're > making something in C. The entire world

[sqlite] Okapi BM25

Hi, I'm interested in integrating the Okapi BM25 ranking procedure into my SQLite. Has anyone done this already? Respectfully, Tim ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] SQLite4 (don't scream)

That's kind of cool, but how about $twentyseven! > On Thu, Jun 28, 2012 at 12:57 PM, Robert Myers > wrote: > > > Aghhh (just kidding) > > > > One request for a change - make bind and column start with the same > index. > > I always have to look up which one is zero

Re: [sqlite] how to get SQLite 4 source?

Hi Darren, 1. Install Fossil - http://www.fossil-scm.org. 2. At a command prompt or console, 'fossil clone http://www.sqlite.org/src4sqlite4.fossil'. 3. (Not sure if this the "right" way) From here I usually 'mkdir sqlite4_src', 'cd sqlite_src', then 'fossil open ../sqlite4.fossil' Respectfully,

[sqlite] MATCH multiple

I recently switched a table to FTS4. Usually I query this table using the IN operator, e.g., SELECT * FROM Table WHERE term IN (a,b,c) If I want to use MATCH, is my only option SELECT * FROM Table WHERE term MATCH 'a or b or c' or is there an equivalent to IN? Much obliged.

[sqlite] ONLY phrase in FTS4

Hi, if I am using the Porter tokenizer in FTS4 and want an exact "stemmed" match, how would I proceed? For example, I am if I am looking for "completed missions" -> "complet mission", I don't want "American completed missions". Is it possible? ___

[sqlite] classic update join question

Hi sqlite-users, I have a column in table 'alpha' which I would like to populate with data from table 'beta'. As far as I know, we cannot do an UPDATE using JOIN in sqlite, but we can UPDATE alpha SET frequency = (SELECT frequency FROM beta WHERE beta.term = > alpha.term) or we can create a

Re: [sqlite] classic update join question

, Sep 5, 2012 at 12:24 PM, Igor Tandetnik <itandet...@mvps.org> wrote: > On 9/5/2012 12:38 PM, E. Timothy Uy wrote: > >> I have a column in table 'alpha' which I would like to populate with data >> from table 'beta'. As far as I know, we cannot do an UPDATE using JOIN

Re: [sqlite] classic update join question

Igor, what happens if there are multiple hits for SELECT frequency FROM beta WHERE beta.term = alpha.term (there aren't but, it is possible for there to be). Rob could be right in a sense. On Wed, Sep 5, 2012 at 1:28 PM, Igor Tandetnik wrote: > On 9/5/2012 4:20 PM, Rob

[sqlite] offset from matchinfo

Hi, it doesn't look like it is possible to get offset information from matchinfo. Is that right? It seems like matchinfo should be the uber set of data for matching. Sometimes early occurrence of a match may mean more significance. Thanks, Tim ___

[sqlite] IN operator hits

Is there a way to figure out which of the terms in an IN operator actually hit? Perhaps making a temp table is the only way. Any help is much appreciated. Respectfully, Tim ___ sqlite-users mailing list sqlite-users@sqlite.org

Re: [sqlite] IN operator hits

, Igor Tandetnik <itandet...@mvps.org> wrote: > E. Timothy Uy <t...@loqu8.com> wrote: > > Is there a way to figure out which of the terms in an IN operator > actually > > hit? > > I'm not sure I understand the question. What exactly are you trying to > achieve?

[sqlite] Does a search on an external content FTS table use the index of the underlying content?

Let's say I have a table Data_content(term TEXT UNIQUE) which has an indexed column 'term'. I then create an FTS4 table using CREATE VIRTUAL TABLE Data USING fts4 (content="Data_content", term); If I later search using SELECT * FROM Data WHERE term IN (...), does it use the indexes generated in

Re: [sqlite] Does a search on an external content FTS table use the index of the underlying content?

Thanks Richard. In the case of using a index modifying tokenizer like Porter, is there a way to know which of the MATCH terms it actually matched on or is that lost information? On Wed, Sep 19, 2012 at 3:44 AM, Richard Hipp <d...@sqlite.org> wrote: > On Wed, Sep 19, 2012 at 2:42 AM, E

Re: [sqlite] DELETE Query Assistance Please

If you are trying to purge a huge database and it is not live, another possibility is to attach a new blank database and SELECT into it. This way you don't have to waste time with VACUUM. On Mon, Sep 24, 2012 at 10:04 AM, Clemens Ladisch wrote: > Don Goyette wrote: > > > With