Joe Wilson <[EMAIL PROTECTED]> wrote:
> Just for kicks, what happens on both platforms when you issue:
>
> select genre, length(genre), hex(genre), filename
> from objects where media_type=1;
>
Make that:
select genre, typeof(genre), length(genre), hex(genre), filename
from objects
What is the OS you're using and what kind of media is it?
Hard drive or USB key or ???
--- Shilpa Sheoran <[EMAIL PROTECTED]> wrote:
> It seems that rc = fsync(fd); is failing in function
> static int full_fsync(int fd, int fullSync, int dataOnly) in file os_unix.c
> {
> #else /* if
Just for kicks, what happens on both platforms when you issue:
select genre, length(genre), hex(genre), filename
from objects where media_type=1;
as well as:
select count(*) from objects where genre LIKE '%POP%';
> I have a bizarre problem. Here is an example of something I tried in
>
It seems that rc = fsync(fd); is failing in function
static int full_fsync(int fd, int fullSync, int dataOnly) in file os_unix.c
{
#else /* if !defined(F_FULLSYNC) */
if( dataOnly ){
rc = fdatasync(fd);
}else{
//*this call is failing
rc =
Nothing you've mentioned is out of the ordinary. I would expect the
same behavior on both platforms.
Can you post the complete schema, and the exact query that exhibits the
problem? (And perhaps a couple of insert statements into the objects table).
Without this I don't think anyone can recreate
Hi,
I have a bizarre problem. Here is an example of something I tried in
sqlite3 3.3.8:
sqlite> select genre,filename from objects where media_type=1;
query abbreviated...
Msica independiente|0056_People Get Ready1_test1.wma
POP|0057_The Mighty Ship1_test1.wma
POP|0058_The Mighty
Ok, thanks for that quick response!
ppcinfo
-Original Message-
From: Igor Tandetnik [mailto:[EMAIL PROTECTED]
Sent: Tuesday, May 22, 2007 4:18 PM
To: SQLite
Subject: [sqlite] Re: How to retrieve results in a array?
Dave Furey <[EMAIL PROTECTED]> wrote:
> I've got a C routine that
Dave Furey <[EMAIL PROTECTED]> wrote:
I've got a C routine that queries for integer data, and I'm currently
stepping through each row to fill an integer array. Is there a more
convenient way of doing this? For example, is there a special sqlite3
call I can make that will fill up an integer array
I've got a C routine that queries for integer data, and I'm currently
stepping through each row to fill an integer array. Is there a more
convenient way of doing this? For example, is there a special sqlite3 call I
can make that will fill up an integer array directly with me having to step
through
At 18:09 20/05/2007, you wrote:
>In a previous post drh mentioned:
>
> You need an R-Tree index to do something like this. The
> public-domain version of SQLite only supports B-Tree indices.
>
> (http://www.mail-archive.com/sqlite-users%40sqlite.org/msg24643.html)
>
>Does this imply that there
hi,
i can see the source file structure has been changed from 65 files before to
only 2 files now.
and this change bring me a problem when i try to integrate sqlite with other
platforms.
in my sqlite integration, i have to put my porting layer os_xxx into a
seperate 'cpp' file and to include
Ok, I reviewed the sources (utf.c) and I'd say that it's still
incorrect. Actually, it doesn't test for surrogates at all, the
problem I was experiencing was caused by the fact that SQLite reads
unallocated memory when there's an unpaired surrogate present as the
last character of string - see
Scott McDonald wrote:
Jef Driesen wrote:
I have some questions on the usage of sqlite3_reset (or
sqlite3_finalize) after sqlite3_step.
In the legacy interface I use sqlite3_reset after sqlite3_step to obtain
a more specific error code for SQLITE_ERROR (to be able to detect schema
errors and
13 matches
Mail list logo