[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 th

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

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

[sqlite] Seems like a bug in the parser

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 si

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 ?

case, 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?

iciently in dbf-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

use __attribute__ ((aligned (16))) but it 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

16 bytes" because 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

ct this 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) in

Re: [sqlite] Unaligned access in SQLite on Itanium

e doesn't like it. I start SQLite shell, and it says immediately (or when I create a simple table): D:\src\3rd-parties\sqlitecomp\bin\windows-x32>sqlite3-test.exe test.db SQL error: malformed database schema Can't prepare statement: no such table: test Reproduced on Windows x86 and Linux ia64. -- Alexei Alexandrov

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

to 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 > &

Re: [sqlite] SQLite tests failures on Linux IA64

I use those that come with the distribution. Since it's one of the latest distros (Red Hat EL 4 Update 2), it's not that archaic: $ rpm -qa | grep tcl tcl-devel-8.4.7-2 tcl-8.4.7-2 On 3/25/06, [EMAIL PROTECTED] <[EMAIL PROTECTED]> wrote: > "Alexei Alexandrov" <

[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 me

[sqlite] Unaligned access in SQLite on Itanium

tl --unaligned=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

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

[sqlite] Warnings during compilation on Linux ia64

194c194 < 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

[sqlite] A minor patch for SQLite shell

extern int isatty(); - /* ** The following is the open SQLite database. We make a pointer ** to this database a static variable so that it can be accessed --- 54,59 -- Alexei Alexandrov