Re: [sqlite] CEROD in System.Data.SQLite
http://system.data.sqlite.org/index.html/artifact/9a65aebbcf2379f3 Hmm, yes, I think that this is the issue. Need to have handling of the :cerod:pwd: tag near if (!fullUri) { if (isMemory) fileName = MemoryFileName; else { #if PLATFORM_COMPACTFRAMEWORK if (fileName.StartsWith(./) || fileName.StartsWith(.\\)) fileName = Path.GetDirectoryName(System.Reflection.Assembly.GetCallingAssembly().GetName().CodeBase) + fileName.Substring(1); #endif bool toFullPath = SQLiteConvert.ToBoolean(FindKey(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 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 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 pattern = (:.*:)(.*); Match m = Regex.Match(fileName, pattern); if (m.Groups.Count == 3) { string prefix = m.Groups[1].ToString(); string cleanFileName = m.Groups[2].ToString(); cleanFileName = ExpandFileName(cleanFileName); fileName = prefix + cleanFileName; } else { fileName = ExpandFileName(fileName); } Maybe something similar is needed? ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
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 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 pattern = (:.*:)(.*); Match m = Regex.Match(fileName, pattern); if (m.Groups.Count == 3) { string prefix = m.Groups[1].ToString(); string cleanFileName = m.Groups[2].ToString(); cleanFileName = ExpandFileName(cleanFileName); fileName = prefix + cleanFileName; } else { fileName = ExpandFileName(fileName); } Maybe something similar is needed? ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
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/9a65aebbcf2379f3 Hmm, yes, I think that this is the issue. Need to have handling of the :cerod:pwd: tag near if (!fullUri) { if (isMemory) fileName = MemoryFileName; else { #if PLATFORM_COMPACTFRAMEWORK if (fileName.StartsWith(./) || fileName.StartsWith(.\\)) fileName = Path.GetDirectoryName(System.Reflection.Assembly.GetCallingAssembly().GetName().CodeBase) + fileName.Substring(1); #endif bool toFullPath = SQLiteConvert.ToBoolean(FindKey(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 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 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 pattern = (:.*:)(.*); Match m = Regex.Match(fileName, pattern); if (m.Groups.Count == 3) { string prefix = m.Groups[1].ToString(); string cleanFileName = m.Groups[2].ToString(); cleanFileName = ExpandFileName(cleanFileName); fileName = prefix + cleanFileName; } else { fileName = ExpandFileName(fileName); } Maybe something similar is needed? ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
[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
[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 pattern = (:.*:)(.*); Match m = Regex.Match(fileName, pattern); if (m.Groups.Count == 3) { string prefix = m.Groups[1].ToString(); string cleanFileName = m.Groups[2].ToString(); cleanFileName = ExpandFileName(cleanFileName); fileName = prefix + cleanFileName; } else { fileName = ExpandFileName(fileName); } Maybe something similar is needed? ___ 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
Ok, I don't see it. But that is good to know (about MSBuild) On Wed, Feb 11, 2015 at 4:22 PM, Joe Mistachkin sql...@mistachkin.com wrote: I've been told that MSBuild will use it but that VS will not show/see it. However, after learning this I didn't verify. Things 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? 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 ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
[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-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
[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 Kits\8.1\lib\x86 mkkeywordhash.obj LINK : fatal error LNK1104: cannot open file 'kernel32.lib' NMAKE : fatal error U1077: 'F:\Program Files (x86)\Microsoft Visual Studio 12.0\VC\bin\cl.EXE' : return code '0x2' Stop. Failed to build Debug sqlite3.dll for platform x86_arm. Any tips on how I should do this? Should I even be using build-all-msvc.bat? ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
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 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 Kits\8.1\lib\x86 mkkeywordhash.obj LINK : fatal error LNK1104: cannot open file 'kernel32.lib' NMAKE : fatal error U1077: 'F:\Program Files (x86)\Microsoft Visual Studio 12.0\VC\bin\cl.EXE' : return code '0x2' Stop. Failed to build Debug sqlite3.dll for platform x86_arm. Any tips on how I should do this? Should I even be using build-all-msvc.bat? ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
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 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 with Please try the following commands from a Visual Studio 2013 Command Prompt: SET PLATFORMS=x86 x86_arm SET NMAKE_ARGS=FOR_WINRT=1 USE_WP81_OPTS=1 CALL tool\build-all-msvc.bat C:\path\to\output\dir -- Joe Mistachkin ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
Re: [sqlite] compiling for WP81
I found the issue. I call vcvarsphoneall.bat and then vcvarsall.bat again in order to reset everything. But WindowsPhoneKitDir does not get unset, this triggers build-all-msvc.bat to cal vcvarsphoneall once again. Probably that segment needs to be removed from build-all-msvc.bat since it seems 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 AM, Joe Mistachkin sql...@mistachkin.com wrote: E. Timothy Uy wrote: 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 with Please try the following commands from a Visual Studio 2013 Command Prompt: SET PLATFORMS=x86 x86_arm SET NMAKE_ARGS=FOR_WINRT=1 USE_WP81_OPTS=1 CALL tool\build-all-msvc.bat C:\path\to\output\dir -- Joe Mistachkin ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
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.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 this information? What should I be using? I'm using the ignore-glob versioned setting below. Regards, Jan Nijtmans $ cat .fossil-settings/ignore-glob tsrc/* *.db Makefile config.h config.log config.status keywordhash.h lemon lemon.exe lempar.c libsqlite3.la libtclsqlite3.la libtool mkkeywordhash mkkeywordhash.exe opcodes.c opcodes.h parse.c parse.h parse.h.temp parse.out parse.y shell.c sqlite3 sqlite3.c sqlite3.exe sqlite3.h sqlite3.lo sqlite3.o sqlite3.pc sqlite3ext.h tclsqlite.lo tclsqlite.o testfixture testfixture.exe ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
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 this information? What should I be using? I'm using the ignore-glob versioned setting below. Regards, Jan Nijtmans $ cat .fossil-settings/ignore-glob tsrc/* *.db Makefile config.h config.log config.status keywordhash.h lemon lemon.exe lempar.c libsqlite3.la libtclsqlite3.la libtool mkkeywordhash mkkeywordhash.exe opcodes.c opcodes.h parse.c parse.h parse.h.temp parse.out parse.y shell.c sqlite3 sqlite3.c sqlite3.exe sqlite3.h sqlite3.lo sqlite3.o sqlite3.pc sqlite3ext.h tclsqlite.lo tclsqlite.o testfixture testfixture.exe ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
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 is actually inside fossil and sqlite.fossil. Very early on in sqlite.fossil there are entries in the plink table where the parent id (pid) is greater than the commit id (cid). There are over a thousand of these. Those IDs are _transient_, not part of the historical record. The child ID comes before parent ID behaviour also appears on completely benign repos (i've seen it before in my own while testing libfossil). If I had more brain cells, I could perhaps invent a way to efficiently use the plink table to generate the proper export list where parents always come before children regardless of mtime. i've also attempted something similar in libfossil, but haven't been successful. The RIDs cannot be used to figure it out, and neither can mtime. The only 100% reliable way i know of traversing the history is to read each manifest, as the P-cards give us that piece of context we need to know the ordering. -- - stephan beal http://wanderinghorse.net/home/stephan/ http://gplus.to/sgbeal Freedom is sloppy. But since tyranny's the only guaranteed byproduct of those who insist on a perfect world, freedom will have to do. -- Bigby Wolf ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
[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 http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
Re: [sqlite] fixing time-warp
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 misinterpret the answers below as any kind of disrespect for DRH, SQLite or fossil - 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 Git. I would like to reference all third-party code as Git submodules - this is already done for components that are SVN-based. Previously I had an untracked folder holding fossil repositories and I briefly considered some kind of macro or script to fossil clone - but I like how Git submodules also keep track of the particular commit that is used by the master repo. 2. Why is it a good idea for our BDFL, D. Richard Hipp, to modify the SQLite repo to make it easier for you to dump it into a Git repo? Keep in mind that the costs here are not just his time, but also the loss of a test case. I don't think DRH needs modify the repo to make it easier to help _me_ dump it into a Git repo. In fact, (see #3), I no longer think the time-warps should be fixed at all. However, I do want to point out that 1. There are two existing tags that fix the two time-warps. However, these have been un-fixed without deleting the fixing tags. This is confusing. Maybe the tags should be deleted? Or maybe there are two more tags somewhere that unfix the fixes? b. SQLite is the crown jewel example of the beauty of fossil. Fossil offers fossil export --git repo.fossil | git fast-import. Why should this break for SQLite? It shouldn't. c. It is a matter of perception. If SQLite is good example of fossil, putting your code into fossil means never getting it out again. That is scary. I don’t think you can convince anyone that #2 is a good idea, but I’m curious about why #1 is a good idea. Bonus persuasion point 3: Why not persuade the Git people to modify their tool to cope with time warps? Isn’t their major value proposition w.r.t the other open source DVCSes that Git is more powerful and flexible? Here we see Fossil doing something Git cannot or will not do, and it’s not a matter of mission scope, as with the bug tracker or wiki features of Fossil. The problem is ultimately not time-warps. DRH can confirm - the problem is actually inside fossil and sqlite.fossil. Very early on in sqlite.fossil there are entries in the plink table where the parent id (pid) is greater than the commit id (cid). There are over a thousand of these. I suspect that because of this, the --git export function sorts the commits by mtime instead of by objid. But ideally the export function should sort by objid with pid always less than cid. When sorting by mtime, time-warps cause the scenario where a commit is exported which refers to a parent which has not been mentioned. This is what causes the Git fast-import function to choke. The interim fix is to use a tag to change the time, then export. If I had more brain cells, I could perhaps invent a way to efficiently use the plink table to generate the proper export list where parents always come before children regardless of mtime. Respectfully, Tim ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
Re: [sqlite] fixing time-warp
As I walked away to do the dishes, these verses from Matthew suddenly came to mind: The LORD said unto my Lord, Sit thou on my right hand, till I make thine enemies thy footstool? If David then call him Lord, how is he his son? I think I'll just be quiet now. Blessings, Tim On Tue, Nov 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 misinterpret the answers below as any kind of disrespect for DRH, SQLite or fossil - 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 Git. I would like to reference all third-party code as Git submodules - this is already done for components that are SVN-based. Previously I had an untracked folder holding fossil repositories and I briefly considered some kind of macro or script to fossil clone - but I like how Git submodules also keep track of the particular commit that is used by the master repo. 2. Why is it a good idea for our BDFL, D. Richard Hipp, to modify the SQLite repo to make it easier for you to dump it into a Git repo? Keep in mind that the costs here are not just his time, but also the loss of a test case. I don't think DRH needs modify the repo to make it easier to help _me_ dump it into a Git repo. In fact, (see #3), I no longer think the time-warps should be fixed at all. However, I do want to point out that 1. There are two existing tags that fix the two time-warps. However, these have been un-fixed without deleting the fixing tags. This is confusing. Maybe the tags should be deleted? Or maybe there are two more tags somewhere that unfix the fixes? b. SQLite is the crown jewel example of the beauty of fossil. Fossil offers fossil export --git repo.fossil | git fast-import. Why should this break for SQLite? It shouldn't. c. It is a matter of perception. If SQLite is good example of fossil, putting your code into fossil means never getting it out again. That is scary. I don’t think you can convince anyone that #2 is a good idea, but I’m curious about why #1 is a good idea. Bonus persuasion point 3: Why not persuade the Git people to modify their tool to cope with time warps? Isn’t their major value proposition w.r.t the other open source DVCSes that Git is more powerful and flexible? Here we see Fossil doing something Git cannot or will not do, and it’s not a matter of mission scope, as with the bug tracker or wiki features of Fossil. The problem is ultimately not time-warps. DRH can confirm - the problem is actually inside fossil and sqlite.fossil. Very early on in sqlite.fossil there are entries in the plink table where the parent id (pid) is greater than the commit id (cid). There are over a thousand of these. I suspect that because of this, the --git export function sorts the commits by mtime instead of by objid. But ideally the export function should sort by objid with pid always less than cid. When sorting by mtime, time-warps cause the scenario where a commit is exported which refers to a parent which has not been mentioned. This is what causes the Git fast-import function to choke. The interim fix is to use a tag to change the time, then export. If I had more brain cells, I could perhaps invent a way to efficiently use the plink table to generate the proper export list where parents always come before children regardless of mtime. Respectfully, Tim ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
[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 ec.mtime LIMIT 10; 35460|35462|1|2455469.2683|2455469.46484954|2455469.2683 35450|35453|1|2455468.35189815|2455468.80332176|2455468.35189815 Respectfully, Tim ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
Re: [sqlite] fixing time-warp
Dear Richard, It is strange, but if you look at the timeline image I sent (second email), your time-warp tag changes are clearly there but did not stick on objid 35450 and 35460. I just manually did mine on this end (following your same times) and it is now ok, though I feel a bit dirty changing commit times! Leaving the time-warp in place will affect git export. Also, the other barrier that blocks git export of the current sqlite version is that in the fossil export.c, the pid needs to be filtered by type='ci' as one of the parents is type='g' (tag). I have that in some notes in http://www.fossil-scm.org/index.html/tktview?name=4013b0a81a db_prepare(q3, SELECT pid FROM plink WHERE cid=%d AND isprim AND pid IN (SELECT objid FROM event WHERE type='ci'), ckinId ); Respectfully, Tim On Mon, Nov 3, 2014 at 5:37 PM, 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 export to .git The test_timewarps webpage will show them all to you. Example: http://www.sqlite.org/src/test_timewarps In the example above, most of the timewarps have been fixed. To fix them, simple edit check-ins and change their time. I intentionally left one timewarp in SQLite unfixed. See the https://www.sqlite.org/src/timeline?p=3f30f00a384d23d=3f30f00a384d235 timeline. I left this one as a test case for ensuring that Fossil can display timewarps correctly. 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 ec.mtime LIMIT 10; 35460|35462|1|2455469.2683|2455469.46484954|2455469.2683 35450|35453|1|2455468.35189815|2455468.80332176|2455468.35189815 Respectfully, Tim ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users -- D. Richard Hipp d...@sqlite.org ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
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: Dear Richard, It is strange, but if you look at the timeline image I sent (second email), your time-warp tag changes are clearly there but did not stick on objid 35450 and 35460. I just manually did mine on this end (following your same times) and it is now ok, though I feel a bit dirty changing commit times! Leaving the time-warp in place will affect git export. Also, the other barrier that blocks git export of the current sqlite version is that in the fossil export.c, the pid needs to be filtered by type='ci' as one of the parents is type='g' (tag). I have that in some notes in http://www.fossil-scm.org/index.html/tktview?name=4013b0a81a db_prepare(q3, SELECT pid FROM plink WHERE cid=%d AND isprim AND pid IN (SELECT objid FROM event WHERE type='ci'), ckinId ); Respectfully, Tim On Mon, Nov 3, 2014 at 5:37 PM, 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 export to .git The test_timewarps webpage will show them all to you. Example: http://www.sqlite.org/src/test_timewarps In the example above, most of the timewarps have been fixed. To fix them, simple edit check-ins and change their time. I intentionally left one timewarp in SQLite unfixed. See the https://www.sqlite.org/src/timeline?p=3f30f00a384d23d=3f30f00a384d235 timeline. I left this one as a test case for ensuring that Fossil can display timewarps correctly. 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 ec.mtime LIMIT 10; 35460|35462|1|2455469.2683|2455469.46484954|2455469.2683 35450|35453|1|2455468.35189815|2455468.80332176|2455468.35189815 Respectfully, Tim ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users -- D. Richard Hipp d...@sqlite.org ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
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 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: Dear Richard, It is strange, but if you look at the timeline image I sent (second email), your time-warp tag changes are clearly there but did not stick on objid 35450 and 35460. I just manually did mine on this end (following your same times) and it is now ok, though I feel a bit dirty changing commit times! Leaving the time-warp in place will affect git export. Also, the other barrier that blocks git export of the current sqlite version is that in the fossil export.c, the pid needs to be filtered by type='ci' as one of the parents is type='g' (tag). I have that in some notes in http://www.fossil-scm.org/index.html/tktview?name=4013b0a81a db_prepare(q3, SELECT pid FROM plink WHERE cid=%d AND isprim AND pid IN (SELECT objid FROM event WHERE type='ci'), ckinId ); Respectfully, Tim On Mon, Nov 3, 2014 at 5:37 PM, 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 export to .git The test_timewarps webpage will show them all to you. Example: http://www.sqlite.org/src/test_timewarps In the example above, most of the timewarps have been fixed. To fix them, simple edit check-ins and change their time. I intentionally left one timewarp in SQLite unfixed. See the https://www.sqlite.org/src/timeline?p=3f30f00a384d23d=3f30f00a384d235 timeline. I left this one as a test case for ensuring that Fossil can display timewarps correctly. 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 ec.mtime LIMIT 10; 35460|35462|1|2455469.2683|2455469.46484954|2455469.2683 35450|35453|1|2455468.35189815|2455468.80332176|2455468.35189815 Respectfully, Tim ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users -- D. Richard Hipp d...@sqlite.org ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
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 helpful to make that as a note for exporting to git. Why would I want to export the SQLite history to Git? -- D. Richard Hipp d...@sqlite.org ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
[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 list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
Re: [sqlite] activate statement count with sqlite3_interrupt
Isn't the interrupt in play until all active statements have been stopped? Including statements that are added after the interrupt is called? I just want to make sure it is safe to call the next statement. Any new SQL statements that are started after the sqlite3_interrupt() call and before 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: 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? You could use http://www.sqlite.org/c3ref/stmt_busy.html Why do you think you need to know that? What does your application do differently if the active statement count is zero versus if it is not? -- D. Richard Hipp d...@sqlite.org ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
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 have been stopped? Including statements that are added after the interrupt is called? I just want to make sure it is safe to call the next statement. Any new SQL statements that are started after the sqlite3_interrupt() call and before 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: 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? You could use http://www.sqlite.org/c3ref/stmt_busy.html Why do you think you need to know that? What does your application do differently if the active statement count is zero versus if it is not? -- D. Richard Hipp d...@sqlite.org ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
[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 = m.term #2 - t.term = f.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 t.term = f.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 = m.term Here the Terms_content table is big, maybe 300k rows, while the Favorites table is small, 100 rows. Query #1 takes 300 ms, and query #2 takes 30 ms. ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
[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 rsm...@rsweb.co.za 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? The worst kind :) ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
[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 14:53:30 Enter .help for instructions Enter SQL statements terminated with a ; sqlite CREATE VIRTUAL TABLE Terms USING fts3 (term) ... ; sqlite INSERT INTO Terms VALUES ('hello tim'); sqlite INSERT INTO Terms VALUES ('goodbye tim'); sqlite CREATE TEMP TABLE Combos (combo); sqlite INSERT INTO Combos VALUES ('hello'); sqlite SELECT * FROM Terms t INNER JOIN Combos c ON t.term MATCH c.combo; hello tim|hello sqlite SELECT * FROM Terms t INNER JOIN Combos c ON t.term MATCH c.combo ORDER BY t.docid; Error: unable to use function MATCH in the requested context sqlite I know ordering by t.docid is probably redundant, but it is an example of the issue I'm encountering. This is an issue in 3.8.0 also. The last time it worked was 3.7.17 SQLite version 3.7.17 2013-05-20 00:56:22 Enter .help for instructions Enter SQL statements terminated with a ; sqlite CREATE VIRTUAL TABLE Terms USING fts3 (term) ... ; sqlite INSERT INTO Terms VALUES ('hello tim'); sqlite INSERT INTO Terms VALUES ('goodbye tim'); sqlite CREATE TEMP TABLE Combos (combo); sqlite INSERT INTO Combos VALUES ('hello'); sqlite SELECT * FROM Terms t INNER JOIN Combos c ON t.term MATCH c.combo; hello tim|hello sqlite SELECT * FROM Terms t INNER JOIN Combos c ON t.term MATCH c.combo ORDER BY t.docid; hello tim|hello sqlite ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
[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 it off in a nested query with the MATCH by itself, but I feel like this totally used to work. Here Entries is an FTS3 table and Entries_content is associated content. Thank you in advance. Respectfully Tim ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
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 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 it off in a nested query with the MATCH by itself, but I feel like this totally used to work. Here Entries is an FTS3 table and Entries_content is associated content. Thank you in advance. Respectfully Tim ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
[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 I can do something or is my only option sending a command? ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
[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) : see declaration of 'Db' The problem appears to be that struct Db does not have inTrans, which it definitely doesn't. Before I dig too deep, has anyone else seen this? I wonder if it should actually be something other than pDb-inTrans... maybe p-inTrans? Cheers, Tim ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
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(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) : see declaration of 'Db' The problem appears to be that struct Db does not have inTrans, which it definitely doesn't. Before I dig too deep, has anyone else seen this? I wonder if it should actually be something other than pDb-inTrans... maybe p-inTrans? Cheers, Tim ___ 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 Max() value. Is there a way of doing this without writing any additional functions? Thanks, Tim ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
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 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 Max() value. Is there a way of doing this without writing any additional functions? Thanks, Tim ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
[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] 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 http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
[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 ___raise_securityfailure MSVCRT.lib(gs_report.obj) : error LNK2019: unresolved external symbol _IsProcessorFeaturePresent@4 referenced in function ___report_gsfailure MSVCRT.lib(crtexe.obj) : error LNK2019: unresolved external symbol __imp__EncodePointer@4 referenced in function _pre_c_init MSVCRT.lib(atonexit.obj) : error LNK2001: unresolved external symbol __imp__EncodePointer@4 MSVCRT.lib(gs_support.obj) : error LNK2019: unresolved external symbol __imp__QueryPerformanceCounter@4 referenced in function ___security_init_cookie MSVCRT.lib(gs_support.obj) : error LNK2019: unresolved external symbol __imp__GetCurrentProcessId@0 referenced in function ___security_init_cookie MSVCRT.lib(gs_support.obj) : error LNK2019: unresolved external symbol __imp__GetCurrentThreadId@0 referenced in function ___security_init_cookie MSVCRT.lib(gs_support.obj) : error LNK2019: unresolved external symbol __imp__GetSystemTimeAsFileTime@4 referenced in function ___security_init_cookie MSVCRT.lib(atonexit.obj) : error LNK2019: unresolved external symbol __imp__DecodePointer@4 referenced in function __onexit mkkeywordhash.exe : fatal error LNK1120: 8 unresolved externals NMAKE : fatal error U1077: 'C:\Program Files (x86)\Microsoft Visual Studio 11.0\VC\bin\cl.exe' : return code '0x2' Stop. ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
Re: [sqlite] compiling tools for winrt
Thanks Dimiter. I ended up making this change in Makefile.msc 165 165 !IFNDEF NSDKLIBPATH 166 -NSDKLIBPATH = $(WINDOWSSDKDIR)\lib 166 +NSDKLIBPATH = $(WINDOWSSDKDIR)\Lib\win8\um\x86 167 167 !ENDIF On Wed, Jan 9, 2013 at 4:07 PM, Dimiter 'malkia' Stanev mal...@gmail.comwrote: This looks like general compile problem. The imported functions below are found in kernel32.dll (kernel32.lib import library). But I'm not sure whether under WinRT kernel32.dll is still used (it might be). If you can either add kernel32.lib to your link flags, or with 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 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 ___raise_securityfailure MSVCRT.lib(gs_report.obj) : error LNK2019: unresolved external symbol _IsProcessorFeaturePresent@4 referenced in function ___report_gsfailure MSVCRT.lib(crtexe.obj) : error LNK2019: unresolved external symbol __imp__EncodePointer@4 referenced in function _pre_c_init MSVCRT.lib(atonexit.obj) : error LNK2001: unresolved external symbol __imp__EncodePointer@4 MSVCRT.lib(gs_support.obj) : error LNK2019: unresolved external symbol __imp__**QueryPerformanceCounter@4 referenced in function ___security_init_cookie MSVCRT.lib(gs_support.obj) : error LNK2019: unresolved external symbol __imp__GetCurrentProcessId@0 referenced in function ___security_init_cookie MSVCRT.lib(gs_support.obj) : error LNK2019: unresolved external symbol __imp__GetCurrentThreadId@0 referenced in function ___security_init_cookie MSVCRT.lib(gs_support.obj) : error LNK2019: unresolved external symbol __imp__**GetSystemTimeAsFileTime@4 referenced in function ___security_init_cookie MSVCRT.lib(atonexit.obj) : error LNK2019: unresolved external symbol __imp__DecodePointer@4 referenced in function __onexit mkkeywordhash.exe : fatal error LNK1120: 8 unresolved externals NMAKE : fatal error U1077: 'C:\Program Files (x86)\Microsoft Visual Studio 11.0\VC\bin\cl.exe' : return code '0x2' Stop. __**_ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-**bin/mailman/listinfo/sqlite-**usershttp://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
[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? ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
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. Timothy Uy t...@loqu8.com wrote: 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? What version of SQL are you both running ? Give us the result of SELECT sqlite_version() on both computers. If you copy the database from the HFS+ partition to the one you're booted from, does it still show as corrupt ? Simon. ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
[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 mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
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 clem...@ladisch.dewrote: Don Goyette wrote: With 60*60*24 seconds per day, the number of days since the Unix epoch is: sqlite select strftime('%s', '2012-05-22') / (60*60*24); 15482 The timestamp in the tables I'm reading is not in the format of '2012-05-22'. Sorry, my explanations were not clear enough. This is not yet the conversion; here I just determined the number of days between the Unix epoch and your example timestamp. That was used to derive the actual conversion formula that you wanted: (excel_timestamp - 25569) * (60*60*24) And this was just a check of the formula, using your example timestamp: select datetime((41051.395834 - 25569) * (60*60*24), 'unixepoch'); 2012-05-22 09:30:00 Regards, Clemens ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
[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 Data_content, or do I have to generate another set (or search Data_content directly). Thanks. Respectfully, Tim ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
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. Timothy Uy t...@loqu8.com wrote: 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 Data_content, or do I have to generate another set (or search Data_content directly). FTS4 indices are only used with the MATCH operator. And you cannot create an index on a virtual table. So you'll either want to translate your IN into a MATCH or else search the Data_content table directly. Thanks. Respectfully, Tim ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users -- D. Richard Hipp d...@sqlite.org ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
[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 http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
Re: [sqlite] IN operator hits
I apologize and thank Paul for his answer. In fact, what I really meant to ask was how to get the original hit values for a MATCH operation when using FTS4 with a Porter tokenizer. I'm not sure what I was thinking in asking this question - please disregard it. On Mon, Sep 17, 2012 at 4:28 PM, 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? I suggest you describe the problem you are trying to solve, rather than your proposed half-of-a-solution. -- Igor Tandetnik ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
[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-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
[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 temp table with the joined data and then drop and replace alpha. How inefficient is the former method? Is it ok? In this case, alpha is about 100k rows and beta might be several million. The 'term' is indexed. Will the database really be doing a select in beta for every single line in alpha? Respectfully, Tim ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
Re: [sqlite] classic update join question
Dear Igor, Are you saying that UPDATE alpha SET frequency = (SELECT frequency FROM beta WHERE beta.term = alpha.term) is just as efficient as it gets and equivalent to an update using join (in other dbs)? That would helpful to know. I do kind of imagine some kind of black magic... ;) On Wed, 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 in sqlite, but we can UPDATE alpha SET frequency = (SELECT frequency FROM beta WHERE beta.term = alpha.term) Will the database really be doing a select in beta for every single line in alpha? Yes - same as when implementing a join. How do you think a join is performed - black magic? -- Igor Tandetnik __**_ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-**bin/mailman/listinfo/sqlite-**usershttp://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
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 itandet...@mvps.org wrote: On 9/5/2012 4:20 PM, Rob Richardson wrote: Well, I think you want a where clause on your main UPDATE query. What you wrote will set the frequency of every record in the alpha table to the value from the beta table, for every record in the beta table that matches an alpha record. (It's late, I'm tired and that's incoherent. I hope you followed it.) If you have 1000 records in the two tables that match each other, every record in the alpha table will be updated 1000 times. No, that's not true. Every record in alpha will be updated exactly once. -- Igor Tandetnik __**_ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-**bin/mailman/listinfo/sqlite-**usershttp://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
[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-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
[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. Respectfully, Tim ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
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, Tim On Fri, Jun 29, 2012 at 9:50 PM, Darren Duncan dar...@darrenduncan.netwrote: Forgive me if I seem dense, but from http://www.sqlite.org/src4/** doc/trunk/www/index.wikihttp://www.sqlite.org/src4/doc/trunk/www/index.wikiand elsewhere on sqlite.org, though I can see individual source files, I don't see any place to get the whole SQLite 4 source at once, either as a tarball or version control instructions. So where do we go to actually download and play with it? -- Darren Duncan __**_ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-**bin/mailman/listinfo/sqlite-**usershttp://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users ___ 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 rob.my...@ziften.com 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 based and which one is one based. Right now, porting an app from SQLite3 to SQLite4 is mostly a global search/replace of sqlite3-sqlite4. (Maybe a little more than thathttp://www.sqlite.org/src4/doc/trunk/www/porting.wikibut not much.) Changing the index base for sqlite4_bind would really complicate matters. Recommend you not use sqlite4_bind() directly, but rather us named parameters (ex: @one, :two, $three) with sqlite4_bind_parameter_index(): sqlite4_bind_int(pStmt, sqlite4_bind_parameter_index(pStmt, $three), 3); That way, you never have to worry about miscounting the ? parameters in your query and being off-by-one in your bindings. Rob On 6/28/2012 10:57 AM, Simon Slavin wrote: First, the important bit: SQLite4 is an alternative, not a replacement, for SQLite3. SQLite3 is not going away. Now the URL: http://www.sqlite.org/src4/**doc/trunk/www/design.wiki http://www.sqlite.org/src4/doc/trunk/www/design.wiki Just thought some people might enjoy reading and thinking about it. Simon. __**_ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-**bin/mailman/listinfo/sqlite-**users http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users __**_ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-**bin/mailman/listinfo/sqlite-**users http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users -- D. Richard Hipp d...@sqlite.org ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
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 languages) as well as encrypted and/or compressed databases. Respectfully, Tim On Tue, Jun 26, 2012 at 12:10 AM, Roger Binns rog...@rogerbinns.com wrote: -BEGIN PGP SIGNED MESSAGE- Hash: SHA1 On 25/06/12 23:38, Andrew Rondeau wrote: Because my time is valuable; I'm still baffled why you think adding one source file to your project is a huge undertaking, but somehow getting a community going, debating how you want things, fiddling around, testing, waiting for releases to packaged differently etc is not. For example, if I make a Mac application, I can target the SQLites shipped with Mac. Problem solved, my valuable time can go to something else. Except the version of SQLite differs between MacOS releases so you have to code and test against different revisions of the SQLite library. Or you include one file statically into your app and it is the only one you have to test against. And it can be the same version as you use on other platforms lessening the development and testing even more. Of course you don't have to listen to the several people who have repeatedly been telling you that what you wanted is the most time consuming and most brittle way of doing things. However you will note that so far there have been zero people clamouring to form some sort of community for what you stated. Good luck! Roger -BEGIN PGP SIGNATURE- Version: GnuPG v1.4.11 (GNU/Linux) iEYEARECAAYFAk/pYE8ACgkQmOOfHg372QTEOwCg4IU49+Y/emng7oJY6Qu8vOka BiUAoLt1o0uZW/tjxWah0jyi0MkgfFer =idVg -END PGP SIGNATURE- ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
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 andrew.rond...@gmail.comwrote: The answer of just add sqlite.c to your project is great when you're making something in C. The entire world does not use C, nor is C (or C++) always the best option for a particular project. Timothy Uy's offer actually makes a lot of sense if you're using something other then C or C++. For example, I just can't ship a .Net .exe that uses x-copy deployment, and runs on Linux/Mac (via Mono) unless I invest about 40-80 hours digging deep into how System.Data.SQLite.dll is built. On Tue, Jun 26, 2012 at 9:10 AM, Simon Slavin slav...@bigfraud.org wrote: On 26 Jun 2012, at 4:55pm, bi...@aol.com wrote: Thank you everyone who took the time to comment on my Windows DLL question. I'm also glad I'm not the only one who sees the problem with not having the version in the resource block. This really would have helped when Chrome and Firefox updated to a new version of SQLite and all my code stopped working. This is the reason you will see so many posts here telling you to build SQLite into your application instead of using a DLL. Then you are not subject to the choices of any other person with code on your users' computers. SQLite purposely issued a compact and simple amalgamation version of the source code especially to make this fast and simple. Simon. ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
[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
[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 last, it works too. If I add more characters, it doesn't work. Seems like it is an encoding issue, and I wonder if it isn't because ICU is using UTF-16 internally. This is a 1/31000 problem but aggravating nonetheless. If I don't use tokenize=icu it works. The error is SQLITE_ERROR: SQL logic error or missing database. Respectfully, Tim ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
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 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 last, it works too. If I add more characters, it doesn't work. Seems like it is an encoding issue, and I wonder if it isn't because ICU is using UTF-16 internally. This is a 1/31000 problem but aggravating nonetheless. If I don't use tokenize=icu it works. The error is SQLITE_ERROR: SQL logic error or missing database. Respectfully, Tim ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
Re: [sqlite] Odd insertion error FTS4 + ICU
Thanks for writing back Dan. Using charCodeAt() in Javascript, I have the following for 一日耶羅波安出: 19968 26085 32822 32645 27874 23433 20986 I tried entering subsets of the data: 一日耶羅波安出 - Error: SQL logic error or missing database -- target 一日耶羅波安 - Ok 日耶羅波安出 - Ok 耶羅波安出 - Ok 一日耶羅波安出x - Error: SQL logic error or missing database 一日耶羅波安x出 - Error: SQL logic error or missing database 一日耶羅波x安出 - Error: SQL logic error or missing database 一日耶羅x波安出 - Ok 一日耶x羅波安出 - Ok 一日x耶羅波安出 - Ok 一x日耶羅波安出 - Ok x一日耶羅波安出 - Ok I'm a bit concerned that this might be an indicator for a deeper issue. Running Ubuntu 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, E. Timothy Uyt...@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 getting an error inserting the following into my virtual table: 一日耶羅波安出 Can you post the list of codepoints in this text? Or the hex of the utf-16 or utf-8 encoding of the same? ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
Re: [sqlite] Odd insertion error FTS4 + ICU
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 the tokenizer out of whack or maybe the fts4aux table. 一 19968 %E4%B8%80 日 26085 %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 一日耶羅波安出: 19968 26085 32822 32645 27874 23433 20986 I tried entering subsets of the data: 一日耶羅波安出 - Error: SQL logic error or missing database -- target 一日耶羅波安 - Ok 日耶羅波安出 - Ok 耶羅波安出 - Ok 一日耶羅波安出x - Error: SQL logic error or missing database 一日耶羅波安x出 - Error: SQL logic error or missing database 一日耶羅波x安出 - Error: SQL logic error or missing database 一日耶羅x波安出 - Ok 一日耶x羅波安出 - Ok 一日x耶羅波安出 - Ok 一x日耶羅波安出 - Ok x一日耶羅波安出 - Ok I'm a bit concerned that this might be an indicator for a deeper issue. Running Ubuntu Linux x64. Respectfully, Tim On Mon, Jun 18, 2012 at 12:29 PM, Dan Kennedy danielk1...@gmail.comwrote: 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, E. Timothy Uyt...@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 getting an error inserting the following into my virtual table: 一日耶羅波安出 Can you post the list of codepoints in this text? Or the hex of the utf-16 or utf-8 encoding of the same? ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
Re: [sqlite] Odd insertion error FTS4 + ICU
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_IS_UTF8 earlier and this did not help. On Mon, Jun 18, 2012 at 2:06 PM, Dan Kennedy danielk1...@gmail.com wrote: 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 the tokenizer out of whack or maybe the fts4aux table. Can you try with this: http://www.sqlite.org/src/info/892b74116a Thanks. ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
Re: [sqlite] Odd insertion error FTS4 + ICU
Dear Dan, With the change from U8_NEXT to U16_NEXT, I am able to insert 一日耶羅波安出. I was also able to insert the rest of the data set (about 31000 more rows containing both traditional and simplified Chinese). Is this an ICU error? Seems like everything should be using U8_ in the tokenizer. Thank 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_IS_UTF8 earlier and this did not help. On Mon, Jun 18, 2012 at 2:06 PM, Dan Kennedy danielk1...@gmail.comwrote: 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 the tokenizer out of whack or maybe the fts4aux table. Can you try with this: http://www.sqlite.org/src/info/892b74116a Thanks. ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
[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 anyone runs into this the bleeding edge is available here: http://git.savannah.gnu.org/gitweb/?p=config.git;a=tree Respectfully, Tim ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users