Re: [sqlite] building 3.4.1
Can you post the output for the failed tests? i.e.: footest-13.1... Expected: [10] Got: [0] --- Victor Secarin <[EMAIL PROTECTED]> wrote: > Hello, everyone. I just started to look at the software and I have two > questions: > > Question 1: > > > > Building sqlite-3.4.1, as obtained from the cvs, on Fedora 5, 64 bits, > > with gcc 4.1.1, over glibc-2.4-11, and tcl/tcl-devel 8.4.13-1.1, > > followed by "make fulltest", I get the following three failed tests: > > > > lock4-1.3 malloc2-1.1.31.5 malloc2.1.5 > > > > > > Building the same with the Intel compiler icc 9.1.051, I get 8 failures > > as follows: > > > > bind-4.4 bind-4.5 expr-2.26 malloc2.1.5 printf-13.6 utf16-bind-4.4 > > utf16-bind-4.5 utf16-expr-2.26 > > > > > > How do I find out which matter and which do not? > > Is there a mechanism whereby I can check these without bothering people? > > Is the testing machinery documented anywhere? > > Am I supposed to use the library if I have failed tests? Take the Internet to Go: Yahoo!Go puts the Internet in your pocket: mail, news, photos & more. http://mobile.yahoo.com/go?refer=1GNXIC - To unsubscribe, send email to [EMAIL PROTECTED] -
Re: [sqlite] How to set up sqlite3 with Dev C++
Sqlite3.h is not the source, it is the header file to be used by ypur application. Stephen Sutherland wrote: never mind. It seems I have it. It seems I had to include the source - the sqlite3.h file Stephen Sutherland <[EMAIL PROTECTED]> wrote: by dynamic link library. i'm gusiness you are talking about the sqlite3.dll. What is hte procedure to link it ? it seems to me that as long as I have an include to , I need to have that file on my PC somewhere. Stephen John Stanton wrote: You don't have to include the Sqlite source to use DevC0++. Just include the link library. Stephen Sutherland wrote: Hi; I'm pretty much a newbie. I'm just about finishing a PC a game with Dev C++. I decided to use sqlite3 to load content from XML repository (for user write access) into the database and then sort and pull out the appropriate information as needed. However, I am trying to figure out SET UP sqlite3 with Dev C++ - so that I can start coding. Currently, I am trying to run the quick start program which includes The compiler doesn't find sqlite3.h I don't want to include the source code. I was hoping there was some way that I could somehow simply linke the sqlite3.dll and sqlite3.def so that I could code for my specific needs. Or do I have to include the source to get it working. Thanks in advance Stev - Yahoo! oneSearch: Finally, mobile search that gives answers, not web links. - To unsubscribe, send email to [EMAIL PROTECTED] - - Yahoo! oneSearch: Finally, mobile search that gives answers, not web links. - Pinpoint customers who are looking for what you sell. - To unsubscribe, send email to [EMAIL PROTECTED] -
Re: [sqlite] How to set up sqlite3 with Dev C++
Stephen Sutherland wrote: never mind. It seems I have it. It seems I had to include the source - the sqlite3.h file Stephen Sutherland <[EMAIL PROTECTED]> wrote: by dynamic link library. i'm gusiness you are talking about the sqlite3.dll. What is hte procedure to link it ? it seems to me that as long as I have an include to , I need to have that file on my PC somewhere. Stephen John Stanton wrote: You don't have to include the Sqlite source to use DevC0++. Just include the link library. Stephen Sutherland wrote: Hi; I'm pretty much a newbie. I'm just about finishing a PC a game with Dev C++. I decided to use sqlite3 to load content from XML repository (for user write access) into the database and then sort and pull out the appropriate information as needed. However, I am trying to figure out SET UP sqlite3 with Dev C++ - so that I can start coding. Currently, I am trying to run the quick start program which includes The compiler doesn't find sqlite3.h I don't want to include the source code. I was hoping there was some way that I could somehow simply linke the sqlite3.dll and sqlite3.def so that I could code for my specific needs. Or do I have to include the source to get it working. Thanks in advance Stev - Yahoo! oneSearch: Finally, mobile search that gives answers, not web links. - To unsubscribe, send email to [EMAIL PROTECTED] - - Yahoo! oneSearch: Finally, mobile search that gives answers, not web links. - Pinpoint customers who are looking for what you sell. - To unsubscribe, send email to [EMAIL PROTECTED] -
Re: [sqlite] How to set up sqlite3 with Dev C++
If you are using the Sqlite API you need sqlite3.h. Put it in your regular "include" directory and Dev C++ will find it. Stephen Sutherland wrote: by dynamic link library. i'm gusiness you are talking about the sqlite3.dll. What is hte procedure to link it ? it seems to me that as long as I have an include to , I need to have that file on my PC somewhere. Stephen John Stanton <[EMAIL PROTECTED]> wrote: You don't have to include the Sqlite source to use DevC0++. Just include the link library. Stephen Sutherland wrote: Hi; I'm pretty much a newbie. I'm just about finishing a PC a game with Dev C++. I decided to use sqlite3 to load content from XML repository (for user write access) into the database and then sort and pull out the appropriate information as needed. However, I am trying to figure out SET UP sqlite3 with Dev C++ - so that I can start coding. Currently, I am trying to run the quick start program which includes The compiler doesn't find sqlite3.h I don't want to include the source code. I was hoping there was some way that I could somehow simply linke the sqlite3.dll and sqlite3.def so that I could code for my specific needs. Or do I have to include the source to get it working. Thanks in advance Stev - Yahoo! oneSearch: Finally, mobile search that gives answers, not web links. - To unsubscribe, send email to [EMAIL PROTECTED] - - Yahoo! oneSearch: Finally, mobile search that gives answers, not web links. - To unsubscribe, send email to [EMAIL PROTECTED] -
Re: [sqlite] Problem with SQLite FastCGI module "malformed database schema"
Maybe the php wrapper is not closing sqlite connections correctly (or at all). See if you can get the stack traces of all threads in the php process 162 via pstack, lsstack or by attaching gdb to it at runtime. > COMMAND PID USER FD TYPE DEVICE SIZE/OFF NODE NAME > php 162 root5uVREG0,0 613376 338233 > /usr/local/db/databasefile.db > php 162 root6uVREG0,0 0 92290 / > (/dev/wd0a) > php 162 root7uVREG0,0 613376 338233 > /usr/local/db/databasefile.db > php 162 root8uVREG0,0 0 92318 / > (/dev/wd0a) > php 162 root9uVREG0,0 613376 338233 > /usr/local/db/databasefile.db > php 162 root 10uVREG0,0 0 92319 / > (/dev/wd0a) > php 162 root 11uVREG0,0 613376 338233 > /usr/local/db/databasefile.db > php 162 root 12uVREG0,0 0 92317 / > (/dev/wd0a) Need a vacation? Get great deals to amazing places on Yahoo! Travel. http://travel.yahoo.com/ - To unsubscribe, send email to [EMAIL PROTECTED] -
Re: [sqlite] Problem with SQLite FastCGI module "malformed database schema"
On Thu, Jul 26, 2007 at 04:26:41PM -0700, [EMAIL PROTECTED] wrote: > If it works and then later stops working, it's much more likely that > you're having a problem with some file descriptor that is not closed > properly (on the temp db most likely). > If it dies after let's say a week, you can check after a few days using > lsof if the process is keeping files open in /tmp After several days (no error until today) I made a check using lsof, and I've found something looking a bit suspicious (a fragment of lsof-output below) - what do you think about it? The www-service wasn't used by anybody when I used lsof. COMMAND PID USER FD TYPE DEVICE SIZE/OFF NODE NAME php 162 root5uVREG0,0 613376 338233 /usr/local/db/databasefile.db php 162 root6uVREG0,0 0 92290 / (/dev/wd0a) php 162 root7uVREG0,0 613376 338233 /usr/local/db/databasefile.db php 162 root8uVREG0,0 0 92318 / (/dev/wd0a) php 162 root9uVREG0,0 613376 338233 /usr/local/db/databasefile.db php 162 root 10uVREG0,0 0 92319 / (/dev/wd0a) php 162 root 11uVREG0,0 613376 338233 /usr/local/db/databasefile.db php 162 root 12uVREG0,0 0 92317 / (/dev/wd0a) php 162 root 13uVREG0,0 613376 338233 /usr/local/db/databasefile.db php 162 root 14uVREG0,0 0 92321 / (/dev/wd0a) php 162 root 15uVREG0,0 613376 338233 /usr/local/db/databasefile.db php 162 root 16uVREG0,0 0 92331 / (/dev/wd0a) php 162 root 17uVREG0,0 613376 338233 /usr/local/db/databasefile.db php 162 root 18uVREG0,0 0 91348 / (/dev/wd0a) php 162 root 19uVREG0,0 613376 338233 /usr/local/db/databasefile.db php 162 root 20uVREG0,0 0 92328 / (/dev/wd0a) php 162 root 21uVREG0,0 613376 338233 /usr/local/db/databasefile.db php 162 root 22uVREG0,0 0 92332 / (/dev/wd0a) php 162 root 23uVREG0,0 613376 338233 /usr/local/db/databasefile.db php 162 root 24uVREG0,0 0 92322 / (/dev/wd0a) php 162 root 25uVREG0,0 613376 338233 /usr/local/db/databasefile.db php 162 root 26uVREG0,0 0 92334 / (/dev/wd0a) php 162 root 27uVREG0,0 613376 338233 /usr/local/db/databasefile.db php 162 root 28uVREG0,0 0 92333 / (/dev/wd0a) php 162 root 29uVREG0,0 613376 338233 /usr/local/db/databasefile.db php 162 root 30uVREG0,0 0 92198 / (/dev/wd0a) php 162 root 31uVREG0,0 613376 338233 /usr/local/db/databasefile.db php 162 root 32uVREG0,0 0 92337 / (/dev/wd0a) php 162 root 33uVREG0,0 613376 338233 /usr/local/db/databasefile.db php 162 root 34uVREG0,0 0 92336 / (/dev/wd0a) php 162 root 35uVREG0,0 613376 338233 /usr/local/db/databasefile.db php 162 root 36uVREG0,0 0 92267 / (/dev/wd0a) php 162 root 37uVREG0,0 613376 338233 /usr/local/db/databasefile.db php 162 root 38uVREG0,0 0 92349 / (/dev/wd0a) php 162 root 39uVREG0,0 613376 338233 /usr/local/db/databasefile.db php 162 root 40uVREG0,0 0 92350 / (/dev/wd0a) php 165 root cwd VDIR0,0512 317929 / (/dev/wd0a) php 165 root txt VREG0,01122496 319019 / (/dev/wd0a) -- pozdrawiam / regards Zbigniew Baniewski - To unsubscribe, send email to [EMAIL PROTECTED] -
[sqlite] building 3.4.1
Hello, everyone. I just started to look at the software and I have two questions: Question 1: Building sqlite-3.4.1, as obtained from the cvs, on Fedora 5, 64 bits, with gcc 4.1.1, over glibc-2.4-11, and tcl/tcl-devel 8.4.13-1.1, followed by "make fulltest", I get the following three failed tests: lock4-1.3 malloc2-1.1.31.5 malloc2.1.5 Building the same with the Intel compiler icc 9.1.051, I get 8 failures as follows: bind-4.4 bind-4.5 expr-2.26 malloc2.1.5 printf-13.6 utf16-bind-4.4 utf16-bind-4.5 utf16-expr-2.26 How do I find out which matter and which do not? Is there a mechanism whereby I can check these without bothering people? Is the testing machinery documented anywhere? Am I supposed to use the library if I have failed tests? Question 2: Is 3.4.1 supposed to build on RedHat Enterprise 3? That has tcl and tcl-devel 8.3.5-92.7. The libsqlite3 builds but the second, tcl-specific library does not compile; it seems the only error is "Tcl_WideInt undeclared". So then the tests cannot be run. Any guidance gratefully appreciated. Please advise, and thank you, Victor Secarin --- This e-mail, including any attached files, may contain confidential and privileged information for the sole use of the intended recipient. Any review, use, distribution, or disclosure by others is strictly prohibited. If you are not the intended recipient (or authorized to receive information for the intended recipient), please contact the sender by reply e-mail and delete all copies of this message. - To unsubscribe, send email to [EMAIL PROTECTED] -
[sqlite] Query Help
Hi, I Have a problem with the following query executed on sqlite SELECT CUSTOMER, PRODUCT, [RANK] FROM (SELECT CUSTOMER, PRODUCT, [SUM_SALES], (SELECT COUNT(T2.SUM_SALES) FROM (SELECT CUSTOMER, PRODUCT, (SUM(SALES)) AS [SUM_SALES] FROM Test1MX1000Multi AS T1 GROUP BY CUSTOMER, PRODUCT) AS [T2] WHERE T1.CUSTOMER = T2.CUSTOMER AND T2.SUM_SALES > T1.SUM_SALES) AS [RANK] FROM (SELECT CUSTOMER, PRODUCT, (SUM(SALES)) AS [SUM_SALES] FROM Test1MX1000Multi AS T1 GROUP BY CUSTOMER, PRODUCT) AS [T1]) AS [TEMP] WHERERANK <= 4 ORDER BY CUSTOMER, RANK i get: misuse of aggregate: (SUM(SALES)). this query is cool under sql server any ideas? tnx
[sqlite] Re: autoincrement and fts2?
>> > In fts tables all columns other than rowid are of type TEXT. It >> > doesn't matter what you put in the type, they will be of type TEXT. >> > The rowid is the standard SQLite rowid, so it does provide an INTEGER >> > PRIMARY KEY AUTOINCREMENT column. >> Scott, thanks for your reply. However, it seems that by default, the >> magic ROWID column is of the eternally-unique variety; rather, it is >> of the currently-unique variety: > As it currently stands, fts2 (and fts1, if you ever do a delete) is > broken if you use VACUUM. Hi, Scott... Thanks for your reply, but, I must not be getting something here... What does VACUUM have to do with this? Is the bit I'm missing that currently-unique ROWID's are eternally-unique if you never VACUUM? If this is the case, however, fixing FTS2 so it works with VACUUM won't (I believe) actually solve my problem, will it? How would I go about creating a column in an FTS2 table such that each INSERT puts an eternally-unique value in that cell, and these values never, ever get reused for the life of the table? Thanks again, - a - To unsubscribe, send email to [EMAIL PROTECTED] -
[sqlite] extension-functions.tgz for sqlite3 3.4.1 ?
Hi, I wanted to get a LOG10() function in sqlite3, and I found the extension-functions.tgz file in http://sqlite.org/contrib I am using the all-in-one sqlite3.h/c version of sqlite3, and the extension-functions files don't seem to fit at all. For example, it wants to call a function called sqlite3CreateFunc(), which seems to have been renamed to sqlite3_create_function() Should I even bother trying to hack these files into shape, or has sqlite3 changed so much that these files will only serve to introduce bugs? Does anyone use this contribution? Does anyone use it with a recent sqlite3 release? thanks Paul - To unsubscribe, send email to [EMAIL PROTECTED] -
Re: [sqlite] In-Memory Database: Delete rows on a Table increases the memory usage.
Lokesh Babu uttered: Hello Folks, When I perform the DELETE operation on a Table using In-Memory Database (":memory:"), the memory usage increases. I tried using PRAGMA auto_vacuum=1; /* result - nothing works */ Even I tried using VACUUM table_name; /* this too isn't work */ if I perform DROP the table operation, memory usage works. Deleting the rows doesn't work. Anybody please help me in resolving this. Memory usage goes up because SQLite must temporarily store copies of the old pages that store the deleted rows, in order to allow a future rollback if required. Once a commit is done, the old pages are free'd, but by that time the memory footprint has already increased. Not many libc implementations release heap memory back to the OS once it's allocated. Thanks in advance, Lokee -- /"\ \ /ASCII RIBBON CAMPAIGN - AGAINST HTML MAIL X - AGAINST MS ATTACHMENTS / \ - To unsubscribe, send email to [EMAIL PROTECTED] -
[sqlite] Re: How to use step function in bidirection (Next and Previous) ?
Hai Handsome <[EMAIL PROTECTED]> wrote: How to use step function in bidirection (Next and Previous) ? I write the database application that use SQLite v3.4.1 and I place two buttons "Next" and "Previous" for go forward and go backward of row. I found SQLite has only "sqlite3_step(stmt)" function that can do only go forward in "Next" button, but i not found the function for backward. There is none. SQLite only allows forward enumeration. Save ROWIDs of rows already visited, retrieve contents of each such row with a separate query. Igor Tandetnik - To unsubscribe, send email to [EMAIL PROTECTED] -
[sqlite] How to use step function in bidirection (Next and Previous) ?
How to use step function in bidirection (Next and Previous) ? I write the database application that use SQLite v3.4.1 and I place two buttons "Next" and "Previous" for go forward and go backward of row. I found SQLite has only "sqlite3_step(stmt)" function that can do only go forward in "Next" button, but i not found the function for backward. In access database it can do bidirection by specified the dynamic cursor instead of forward only cursor, but in SQLite i don't know how to do like that. so If you know how to go backward row please help me ? Thank you.