[sqlite] Efficient hash lookup table emulation with SQLite - how?

Hi, I'm trying to solve efficiently the following task with SQlite: * There is a trace file which contains a big number of some objects. Each object has a number of fields which constitute its primary key (PK). * The objects are loaded into a table which has a number of PK columns (mapped from

Re: [sqlite] Seems like a bug in the parser

t's OK to have an aggregated function in the select list for non-grouped column. This is correct many-to-one mapping. -- Alexei Alexandrov - To unsubscribe, send email to [EMAIL PROTECTED] -

Re: [sqlite] Seems like a bug in the parser

if you give them this query. -- Alexei Alexandrov - To unsubscribe, send email to [EMAIL PROTECTED] -

[sqlite] Seems like a bug in the parser

llowing query should not be accepted: select a from qqq group by b; but it is. -- Alexei Alexandrov - To unsubscribe, send email to [EMAIL PROTECTED] -

Re: [sqlite] sqlite3_column_text question

Still I can't understand why sqlite3_column_text returns (unsigned char *), but sqlite3_bind_text takes (const char *). What am I missing? On 6/30/06, Alexei Alexandrov <[EMAIL PROTECTED]> wrote: > > Perhaps because it is returning UTF8 and that needs to be unsigned, not signed?

Re: [sqlite] sqlite3_column_text question

Perhaps because it is returning UTF8 and that needs to be unsigned, not signed? Hmm, why sqlite3_bind_text takes const char * then? -- Alexei Alexandrov

[sqlite] sqlite3_column_text question

Why does it return *unsigned* char *? Just const char * would seem more natural - now I need to cast it on Windows. Also from the docs it's not clear who owns the memory returned. I assume that SQLite owns it until sqlite3_step is called. -- Alexei Alexandrov

Re: [sqlite] Which is most appropriate encoding ?

, while still be able to enable the stuff for other OSes as soon as there is a need for it. -- Alexei Alexandrov

[sqlite] The fastest way to change the data of a table?

-based simple databases (FoxPro, Codebase), but it seems to me that I'm just missing something very basic about SQLite features. Yes?? -- Alexei Alexandrov

Re: Re[2]: [sqlite] Unaligned access in SQLite on Itanium

is not portable. Please don't hesitate to ask for clarifications if something is not clear here - I really want to follow it up ASAP. -- Alexei Alexandrov

Re: [sqlite] Unaligned access in SQLite on Itanium

se this will lead to huge memory footprint overhead - every element - even 1 byte-long will take 16 bytes in memory. This is not an option. -- Alexei Alexandrov

Re: [sqlite] Unaligned access in SQLite on Itanium

is fix in the next SQLite release? Should I submit a ticket for this? I will provide Linux ia64/x86_64 testing from my side. -- Alexei Alexandrov

Re: [sqlite] Unaligned access in SQLite on Itanium

> Perhaps a better fix is this: > > struct Mem { >i64 i; >double r; >char *z; >int n; >u16 flags; >u8 type; >u8 enc; >void (*xDel)(void *); >union { > long double notUsed1; > char zShort[NBFS]; >}; > }; > > The compiler would then (hopefully)

Re: [sqlite] SQLite: which platforms are supported?

o change the on-disk format. This is why I'm checking it out early in the game. So far, it seems to be OK. Thanks to you for that. P.S. As kind of access to additional hardware have you ever heard about HP testdrive machines? You can take a look at it here: http://www.testdrive.hp.com/accounts/register.shtml -- Alexei Alexandrov

Re: [sqlite] Unaligned access in SQLite on Itanium

PROTECTED] <[EMAIL PROTECTED]> wrote: > "Alexei Alexandrov" <[EMAIL PROTECTED]> wrote: > > Hi, > > > > I don't know whether it's been already reported or not, so anyway. > > There are places in SQLite where unaligned access exception is > > genera

[sqlite] Re: Unaligned access in SQLite on Itanium

it is not related. On 3/25/06, Alexei Alexandrov <[EMAIL PROTECTED]> wrote: > Hi, > > I don't know whether it's been already reported or not, so anyway. > There are places in SQLite where unaligned access exception is > generated on Itanium. The unaligned access means that someone tri

[sqlite] Unaligned access in SQLite on Itanium

signal ulimit -c unlimited After that unaligned access will cause SIGBUS and core dump will be generated. P.P.S. Unaligned access can lead to serious performance degradations and on some OSes (HP-UX) there isn't default unaligned access handler so it will just crash. -- Alexei Alexandrov

[sqlite] SQLite tests failures on Linux IA64

] Got: [] types3-1.3... Expected: [wideInt integer] Got: [int integer] Is it expected? -- Alexei Alexandrov

[sqlite] Warnings during compilation on Linux ia64

t; n = (int)azResult[0]; --- > n = (size_t)azResult[0]; -- Alexei Alexandrov

[sqlite] SQLite: which platforms are supported?

there are any showstoppers or serious problems that we can face with if we try to use SQLite on those platforms. I appreciate your help, colleagues. Thanks a lot! -- Alexei Alexandrov