This is with a Sun Ultra 80, running Solaris 10 update 7 with Sun Studio
12 update 1.
drkir...@smudge:[~/sqlite-3.6.17] $ echo $CC
/opt/sunstudio12.1/bin/cc
drkir...@smudge:[~/sqlite-3.6.17] $ echo $CXX
/opt/sunstudio12.1/bin/CC
There is an issue where the configure script checks for readline
Hey,
I am running sqlite-3.6.16. I am getting segmentation fault and so trying
to run sqlite with gdb. But I am getting following error-
/sqlite-3.6.16/sqlite3": not in executable format: File format not recognized
I saw the make file. I think it's compiled with debugging option(-g).
what to do?
On 15 Aug 2009, at 3:57pm, Andrew Gatt wrote:
> Simon Slavin wrote:
>> On 15 Aug 2009, at 3:12pm, Andrew Gatt wrote:
>>
>>> but by my scheme you can't be sure if the list_1 table exists in
>>> database2,
>>
>> Add a column to your 'lists' tables which says which database they're
>> part of. So e
Simon Slavin wrote:
> On 15 Aug 2009, at 3:12pm, Andrew Gatt wrote:
>
>
>> but by my scheme you can't be sure if the list_1 table exists in
>> database2,
>>
>
> Add a column to your 'lists' tables which says which database they're
> part of. So every row of the database will have the sam
Roger Andersson wrote:
>
> I have multiple databases, both have a table called "lists" inside this
> table is the names of other tables in the database that make up the lists.
> Each individual list is made up of the tables that have the same name in
> each database (the list is split between diffe
On 15 Aug 2009, at 3:12pm, Andrew Gatt wrote:
> but by my scheme you can't be sure if the list_1 table exists in
> database2,
Add a column to your 'lists' tables which says which database they're
part of. So every row of the database will have the same value.
Simon.
_
Maybe something like
select db1.* from database1.lists db1 union select db2.* from
database2.lists db2;
and
select db1.* from database1.list_2 db1 union all select db2.* from
database2.list_2 db2;
/Roger
-Ursprungligt meddelande-
Från: sqlite-users-boun...@sqlite.org
[mailto:sqlite-users
Hi all,
I have multiple databases, both have a table called "lists" inside this
table is the names of other tables in the database that make up the
lists. Each individual list is made up of the tables that have the same
name in each database (the list is split between different storage
devices in
Dan, updating to sqlite3.dll version 3.6.17 did fix the problem.
Also, I should clarify what I meant by having the query syntax doc on the
sqlite web site. It is indeed on the web site, but I spent a lot of time
yesterday trying to find a document just like it and couldn't. It just needs
to be i
Dan, thank you for the additional information, it's most helpful. I'll let
you know what I find out.
BTW, any reason that doc is not on the SQLite Web site? It would help a lot
of people understand the old and new query syntax better.
Craig
> >
> > Did an FTS3 update change how many negation
On Aug 15, 2009, at 6:45 AM, udd...@cs.ucr.edu wrote:
> Hey,
> I am running sqlite-3.6.16. I am getting segmentation fault and so
> trying
> to run sqlite with gdb. But I am getting following error-
>
> /sqlite-3.6.16/sqlite3": not in executable format: File format not
> recognized
Could be
Hey,
I am running sqlite-3.6.16. I am getting segmentation fault and so trying
to run sqlite with gdb. But I am getting following error-
/sqlite-3.6.16/sqlite3": not in executable format: File format not recognized
what to do?
___
sqlite-users mailing
http://code.openark.org/blog/mysql/sql-pie-chart
An interesting project. The author seems to have way more fun with SQL
than anyone should. But my first thought was... I wonder if this can be
ported to sqlite?
Dennis Jenkins
Network Security Architect
iStream Financial Services
262-
On 15 Aug 2009, at 9:58am, Sebastian Arcus wrote:
> I've just noticed another interesting thing. A read operation after a
> write on same table (like a SELECT statement after an INSERT) works
> perfectly fine - instantly. Which is bizarre, as I would have
> expected a
> write to keep a much lon
Roger Binns wrote:
>
> Sebastian Arcus wrote:
>
>> Hi and thanks for the suggestion. I did as you advised and ran 'vmstat
>> 1' in a terminal. Very little activity - maybe 20-40kb every 6-7 seconds
>> on the bo - pretty much nothing on bi. Also, zeros all around on so/si.
>>
>
> That rul
Roger Binns wrote:
>
> Sebastian Arcus wrote:
>
>> Hi and thanks for the suggestion. I did as you advised and ran 'vmstat
>> 1' in a terminal. Very little activity - maybe 20-40kb every 6-7 seconds
>> on the bo - pretty much nothing on bi. Also, zeros all around on so/si.
>>
>
> That rul
On 15/08/2009 4:48 PM, Jim Showalter wrote:
> It doesn't collect those statistics automatically, as part of query
> plan optimization?
You may like to consider looking at
"6.0 Choosing between multiple indices" in
http://www.sqlite.org/optoverview.html
HTH,
John
17 matches
Mail list logo
