Simon,
don't know what exactly wrong in your particular case, but I'd suggest
setting debugger breakpoints everywhere in your x-handlers and notice the
moment after which calls are ceased (or you get a error code).
Max
On Fri, Oct 4, 2013 at 6:07 PM, Simon wrote:
> Hi t
On Sat, Aug 31, 2013 at 10:14 PM, Richard Hipp wrote:
> On Sat, Aug 31, 2013 at 2:03 PM, Max Vlasov wrote:
>
>> Hi,
>>
>> I noticed that opening places.sqlite of my installation of Firefox
>> can't be made for example with sqlite 3.6.10, it says that
ation so maybe after
several years of upgrading firefox made my particular db semi-valid or
something. It's not big deal, just curious, probably ff uses some
features making sqlite 3 format incompatible with 3.6.* versions
Max
___
sqlite-users ma
On Wed, Aug 28, 2013 at 5:11 PM, Igor Tandetnik wrote:
> On 8/28/2013 8:57 AM, Max Vlasov wrote:
> See the recent discussion at
>
> http://comments.gmane.org/gmane.comp.db.sqlite.general/83005
>
> It's not about trailing spaces, but about whether Title in GROUP BY resol
ut the correct way, seems like 3.8 is right (technically
the strings are different), but I just wonder why all this time this
seems like existed and never noticed. On the other side, mysql of a
some old version also showed a single result
Max
___
sqlite-
not related to sqlite is less pain.
> 2.) object is not destroyed together with connection
>
The same, you're free to use the table just as pointers storage
Max
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bi
or inserting an object
Insert into MyObjectStorage.[objects] (Name, Ptr) VALUES ('obj1',
'0x12345678')
This code will query the pointer
select Ptr from MyObjectStorage.[objects] where Name='obj1'
The only convention rule here will be the name of the atta
On Tue, Jul 23, 2013 at 10:09 PM, Petite Abeille
wrote:
>
> On Jul 23, 2013, at 9:52 AM, Max Vlasov wrote:
>
> > Basically it's several tables implementing Object-Propery-Value metaphor
>
> Hurray! The Entity–attribute–value (EAV) anti-pattern!
>
>
pattern,
On Tue, Jul 23, 2013 at 1:38 PM, Dan Kennedy wrote:
> On 07/23/2013 02:52 PM, Max Vlasov wrote:
>
>> So
>> par adoxically probably the best type for universal field container is
>> REAL
>> (or NUMERIC) since it will accept data of any type, but has advantage
show
1, 2, 10, something
that's what I wanted (except for "something" being exception)
if I change create to
CREATE TABLE testtable (id integer primary key, value);
then the order will be
1, 10, 2, something.
(undesired result)
Max
_
ontainer is REAL
(or NUMERIC) since it will accept data of any type, but has advantage of
best sorting if reals or integers are involved.
Is this correct or I am missing something?
Thanks,
Max
___
sqlite-users mailing list
sqlite-users@sqlite.org
http:/
very conservative in guessing what
can be used around in the future, while file-mapping routines assumes wider
ranges around. Sure, after both queries if I don't reset the cache, the
repeated query is almost instant.
Max
On Mon, Apr 8, 2013 at 4:31 PM, Richard Hipp wrote:
> On Mon, Apr 8, 2013 at
other
expects pointer to the data, the complexity of understanding will grow. Or
is there a simple way to disable xFetch/xUnfetch on the VFS level?
Max
On Mon, Apr 8, 2013 at 3:33 PM, Richard Hipp wrote:
> On Mon, Apr 8, 2013 at 6:12 AM, Max Vlasov wrote:
>
> > But I also noticed
n it should not expect this from client
that uses vfs
Max
On Mon, Apr 8, 2013 at 1:56 PM, Dan Kennedy wrote:
> On 04/08/2013 04:40 PM, Max Vlasov wrote:
>
>> On Mon, Apr 8, 2013 at 1:23 PM, Dan Kennedy
>> wrote:
>>
>>
>>> Right. But a VFS is not obliged to sup
probably sqlite tries to call it anyway.
- If return SQLITE_Error from xFetch, xUnfetch, I get sqlite logic error.
Max
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
On Sun, Apr 7, 2013 at 2:12 PM, Max Vlasov wrote:
>
>
>
> On Thu, Apr 4, 2013 at 4:02 PM, Richard Hipp wrote:
>
>> We would like to encourage people to try out the new code and
>> report both success and failure.
>>
>
>
> Not particulary about this d
e, he or she would find a forum topic "Memory mapped file
performance" where the first contributor to answers is Igor Tandetnik and
we knows that Igor gave very valuable answers also on this list, so he
(having good knowledge about both win32 and sqlite) could al
don't know what's wrong with the link, I'm clicking the one from gmail
thread and it works. Other way is to google [Unresponsive system under some
file-mapping related conditions] and the first result is the thread link
Max
On Sun, Apr 7, 2013 at 2:25 PM, Jean-Christophe Descham
On Thu, Apr 4, 2013 at 4:02 PM, Richard Hipp wrote:
> By making use of memory-mapped I/O, the current trunk of SQLite (which will
> eventually become version 3.7.17 after much more refinement and testing)
> can be as much as twice as fast, on some platforms and under some
> workloads. We would l
On Tue, Jan 22, 2013 at 12:33 PM, Dominique Pellé wrote:
> Max Vlasov wrote:
>
> > Hi,
> >
> > I found with the web search that this error (out of memory for PRAGMA
> > integrity_check) appeared in the wild and there were some fixes related
> to
> > it
Thanks, Dominique
I will try asap, but looking at the arithmetics
25 (The length of "Page ? is never used")
*
800 (maximum I could get)
= 20,000 (limit mentioned in the ticket )
looks like this is a winner :)
Max
> Hi Max
>
> It looks perhaps like the bug that was fi
On Mon, Jan 21, 2013 at 9:30 PM, Klaas V wrote:
> Max wrote he's using an encrypted VFS. Perhaps the problem disappears when
> he decodes the file?
>
I tried to do the same for the decrypted file and on another computer, with
much more memory. The same result. Probably I I can
check was made with the latest version (3.7.15.2). I got the same error
(out of memory) for max values larger than 800, for example PRAGMA
integrity_check(801). If I provide the number below or equal to 800, the
result is only the (truncated) list of "Page .. is never used". What could
go
ors" so
this was ok for Google to accept slashed version as the main one.
Max
On Sun, Jul 8, 2012 at 8:38 PM, Keith Medcalf wrote:
> > Is everything ok with amalgamation link for sqlite 3.7.13?
> > www.sqlite.org/download.html/sqlite-amalgamation-3071300.zip
>
> Link s
OK
Connection: close
Date: Sun, 08 Jul 2012 16:26:13 +
Last-Modified: Thu, 14 Jun 2012 17:02:52 +
Content-type: text/html
Content-length: 14439
plain html, no redirection
Max
___
sqlite-users mailing list
sqlite-users@sqlite.org
http
ticed the slowness, I did VACUUM that
took almost a half an hour alone because the db contained other
persistent data including big indexes. I think handling free list
alone (for example allowing sort them only with a pragma) would help
in cases like mine but unfortunately will add more confus
looks like not only. Even if your
data is sequential, but the free_list is fragmented, then you would
probably get fragmented internal data. Is it possible to automatically
sort free_list from time to time? Or maybe some other solution if this
would cost too much?
Thanks
the db was
reopened with a special trick on Windows forcing it to clear cache for this
file
Max
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
erform your first reading forcing this column order and not touching
definition at the same time. Since any index is just another b-tree but
most of the time smaller you will end up reading a smaller part of file.
Although there's a price to pay, yo
alue**)
and never explains the second parameter. I think a short description could
be useful
Max
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
fails. The value for this particular moment is 100 so it's probably some
data change related to this 'substr' part when it's used first time due to
'where' success.
The version of sqlite 3.7.10
So is there reliable way to find
On Fri, Mar 9, 2012 at 12:04 PM, Max Vlasov wrote:
> So looks on the way from 3.6.10 to 3.7.10 something was really fixed
> related to this issue, but seems like not everything.
>
>
Don't know whether this is serious or a problem at all, but I spent some
time with such queries
On Fri, Mar 9, 2012 at 12:04 PM, Max Vlasov wrote:
> 3.6.10 -
> ... actualrndid never gets higher than 900 (wrong)
>
Sorry, correction, never gets lower than 900
Max
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:808
TABLE [TestTable] (
[Id] INTEGER PRIMARY KEY AUTOINCREMENT
)
Let's fill it with numbers from 1 to 1000. For example by repeating
INSERT INTO TestTable (id) values ((Select max(id) from TestTable) + 1)
The following query is the problem one
Select
id,
MinId,
MaxId,
abs(random() % (
On Tue, Mar 6, 2012 at 9:55 PM, Roger Binns wrote:
> -BEGIN PGP SIGNED MESSAGE-
> Hash: SHA1
>
> On 06/03/12 01:56, Max Vlasov wrote:
> > I don't see a problem here.
>
> ... For example the user could use the app for 3 hours and perform what
> they
>
On Tue, Mar 6, 2012 at 4:00 PM, Dan Kennedy wrote:
> On 03/06/2012 06:45 PM, Max Vlasov wrote:
>
>>
>>>
>> It's an interesting suggestion, thanks. I just thought that using xSync I
>> even can only implement my own db change counter. In any case the questio
On Tue, Mar 6, 2012 at 2:37 PM, Dan Kennedy wrote:
> On 03/06/2012 02:41 PM, Max Vlasov wrote:
>
>> But for correct work this vfs should rely on the
>> fact that file change counter will stay the same until the final write to
>> the first sector.
>>
>
>
On Tue, Mar 6, 2012 at 12:22 PM, Roger Binns wrote:
> -BEGIN PGP SIGNED MESSAGE-
> Hash: SHA1
>
> On 05/03/12 23:41, Max Vlasov wrote:
> > One of the recent thought I had was implementing time machine vfs. So
> > on the developer level he opens the db e
some conflict with existing sqlite cache is possible. So can
vfs in this case work in sync with sqlite or it's too complicated?
Thanks,
Max
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
son
it could not open the db, but didn't detect it so allowed database controls
and objects accept queries.
Max
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
s narrowing.
Affinity section mentioned the goal of more compatibility, but without
numerical literal being treated exactly like numerical fields the
compatibility looks a little bit limited. I can live with that , but I
think the datatype doc page can also mention this difference.
Max
__
On Fri, Feb 10, 2012 at 4:53 PM, Richard Hipp wrote:
> On Fri, Feb 10, 2012 at 6:11 AM, Max Vlasov wrote:
>
> > Hi,
> > working with sqlite and mysql, noticed that they're different in regard
> of
> > mixed types.
> > Select '24' < 25
> &g
ty, numeric values on the
right-hand side of the comparisons are converted to text before the
comparison occurs.
Shouldn't the first be fixed to end with "...then TEXT affinity is applied
to other operand"?
Max
___
sqlite-users mailing
y caching. The following slowness is
the result of the internal fragmentation
- You have successive unix_time, but when it goes beyond 32-bit limit your
software wraps around 32-bit value instead of going 64 bit.
Max
___
sqlite-users mailing list
sqli
ing, i.e as a recommendation to rebuild checksum db
(although don't know whether the vfs can report some existing error). The
same effect can be if the chk file is missing.
Max
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
On Mon, Jan 23, 2012 at 5:36 PM, Richard Hipp wrote:
> On Mon, Jan 23, 2012 at 8:06 AM, Max Vlasov wrote:
> >
> > it there an easy way (without manual statements parsing) to get the list
> of
> > modules used in all (if any) virtual tables statements of the schema? ...
Hi,
it there an easy way (without manual statements parsing) to get the list of
modules used in all (if any) virtual tables statements of the schema? For
any opened db I wanted to automatically enable found modules (if I
recognize them) and warn if there are unsupported ones.
Thanks,
Max
On Fri, Jan 20, 2012 at 10:05 PM, John Elrick wrote:
> The change which results in a slow down occurred between 3.7.5.0 and
> 3.7.6.0.
>
>
What about EXPLAIN difference? Or just outputs of this prefix from both
versions?
Max
___
sqlite-u
Dan look at the difference in the
vdbe code, they could notice something
Max
On Fri, Jan 20, 2012 at 1:17 AM, John Elrick wrote:
> One more useful comparison. The following query is prepared and step is
> called with these results:
>
>
__
;
It's the same api that returns values for
SELECT * FROM table;
Only for Count(*) you result is one row and one column
Max
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
On Wed, Jan 18, 2012 at 4:47 PM, Richard Hipp wrote:
> On Tue, Jan 17, 2012 at 9:11 AM, Max Vlasov wrote:
>
> > Hi,
> > I'm using static linking with Delphi and a new function required binding
> in
> > 3.7.10 - msize (__msize).
> > ...
>
> Try using
SQLITE_OS_WIN
# define HAVE_MALLOC_USABLE_SIZE 1
# define malloc_usable_size _msize
#endif
.with
#if defined(HAVE_MALLOC_USABLE_SIZE) && SQLITE_OS_WIN
# define malloc_usable_size _msize
#endif
isn't it a proper fix for HAVE_MALLOC_USABLE_SIZE to work on windows? I
compiled, it doesn'
On Tue, Jan 17, 2012 at 6:11 PM, Max Vlasov wrote:
> Hi,
> I'm using static linking with Delphi and a new function required binding
> in 3.7.10 - msize (__msize). The problem here is that there's no official
> way to query the size of a memory block in Delphi memory manag
mple by keeping my own
list of blocks and their sizes) or is there some other solution
(enabled/disable some define)?
Thanks,
Max
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
e very strange and he had
to implement a sophisticated stack analysis for many real world examples
Max
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
ws cache, not sqlite), the time is about 7-11 seconds.
But I think a test db with test data would be more useful for
understanding. Can you upload it?
Max
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
On Sun, Jan 15, 2012 at 3:35 AM, John Elrick wrote:
> On Fri, Jan 13, 2012 at 5:13 PM, Max Vlasov wrote:
>
> 5,008 calls to
>
> UPDATE RESPONSES SET
> RESPONSE_NAME = :RESPONSE_NAME,
> prelisted_value = :prelisted_value
> WHERE RESPONSE_OID = :RESPONSE_OID
>
> 3.
least on some of the current platform (linux, can you confirm?).
Probably the page size is a parameter that also should be adjusted for
optimal performance. I suppose it can be different for different ssd
models, but it's just a guess.
Max
___
On Sat, Jan 14, 2012 at 11:52 PM, Simon Slavin wrote:
>
> On 14 Jan 2012, at 7:24pm, Max Vlasov wrote:
>
> > On Sat, Jan 14, 2012 at 6:12 AM, Simon Slavin
> wrote:
> >
> >> Fast. Fasty fast. Speed is high. INSERT, UPDATE, and DELETE all
> >> signific
000 inserts should create a 1GB base and the time with general hd was
above 15 minutes, maybe even half an hour. So I'm very interested to see
was there any progress with overall ssd performance.
Thanks,
Max
___
sqlite-users mailing list
sqlite-users@
ne of the places that allocated
heavily with some queries, but I can't recall right now.
Max
On Sat, Jan 14, 2012 at 1:49 AM, John Elrick wrote:
> Richard and all,
>
> On January 6, I wrote a posting (Problems encountered while upgrading
> Sqlite from 3.6.7 to 3.7.9) concerning
On Fri, Jan 13, 2012 at 3:02 PM, Dan Kennedy wrote:
> On 01/13/2012 03:31 PM, Max Vlasov wrote:
>
>> As I see sqlite can accept the schema of a virtual table
>> (Sqlite3_declare_vtab) only in the context of xCreate or xConnect. But if
>> I
>> want to refresh not onl
clipboard has changed and I want the new select to contain
not only new rows, but also new columns (if this new contents is different
to the previous one).
Thanks,
Max
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman
ome other tricks with sqlite_master here
Thanks,
Max
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
On Tue, Dec 6, 2011 at 9:49 PM, Dan Kennedy wrote:
> On 12/06/2011 03:28 PM, Max Vlasov wrote:
>
>> Hi,
>> Noticed a strange regression after 3.7.7 (in 3.7.8 and inherited in 3.7.9)
>>
>>
> There is a candidate fix for this in fossil now.
>
>
Dan, thank
SrcWord
LIMIT
1))
Sqlite versions before 3.7.7 (inclusive) returns results (2 rows). 3.7.8
and above shows empty result set
Thanks,
Max Vlasov
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
If you're on windows and
ready to test your conversion with my tool, consider writing to me
directly
Max
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
On Thu, Aug 25, 2011 at 9:34 AM, Max Vlasov wrote:
>
> Also theoretically it is possible to use virtual tables for this. So
> when your virtual query implementation accepts list in some way ('23,
> 14, 1, 7, 9') and returns the table when querying
>
I tried to implemen
st in some way ('23,
14, 1, 7, 9') and returns the table when querying
Max
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
tion. there
it was comma-delimited, but it's not that important, I'm sure you can change
it to any other symbol in your data
Max
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
honestly I've already very impressed :)
Max
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
ement your own
virtual file system for your files. But just curious, do you really want to
give your users an "official" way to manipulate sqlite files manually? I
know that many advanced users know what sqlite really is and try to do some
back-up by hands, but they also shoul
'd rather ask Richard
or Dan writing their resolution here about either behavior is by design or
the issue is acknowledged and (maybe) will be fixed.
Max
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/l
al treatment and not used effectively. This still has to be
explained. But if your requirements to your base allows you to add extra
field, I think you can use it, just support autoincrement feature some other
way.
Max
___
sqlite-users mailing list
sql
id>100
explain query plan > SEARCH TABLE abctable USING COVERING INDEX idxabid (a=?
AND b=?) (~3 rows)
I assume the optimizer could use the following "plan"
... COVERING INDEX idxabid (a=? AND b=? AND rowid>?)
but it didn't.
Maybe for a reason...
Max
reads few data (3k actually for 100,000 records) to show empty result
Another variant
CREATE INDEX idxabid ON abctable (a, b, id)
SELECT * FROM abctable WHERE a=10 and b=20 and id > 100
Sqlite reads much (1,7MB)
Checked with 3.7.6.2,
I suppose the latt
created index or still the one that was created
during the lifetime of your program?
Max
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
e data will contain many records and sqlite should read
the index that is internally fragmented due to the reasons explain
above.
Max
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
with kind='info' and computer = 'KRAFTWAY' in your database.
So sqlite really uses the index for locating your records. But the
problem is also that your db is very fragmented so sqlite when reading
the index actually reads different parts of this file and it makes the
windows cache sys
ds, second: 1 second.
>
What about Read Bytes? How much did sqlite.exe actually read during the run?
Max
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
one selects the column for the latter) for
every process so if Grigory shares this info with us, this will be
very useful.
Max
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
query.
This also can give a hint about the software that possibly reads the
file all the this time.
Max
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
ent
So you probably have to look in a different layer
Max
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
u didn't write any before, believe
be, it's very easy. If you go this way I recommend keeping compatibility at
least with MySql in this case (so either "position" or "locate" with the
corresponding parameters). This will give you theoretical possibility to
export you st
On Sat, Jun 25, 2011 at 11:26 AM, Cecil Westerhof wrote:
> With LIMIT you can get the first N records of a SELECT. Is it also possible
> to get the last N records?
>
>
Use ORDER BY ... DESC. Sure, if you have a large dataset, it'd better
x27;s reasonable to switch completely to memory temporary storage?
(PRAGMA temp_store=2;). In best scenario no disk will be involved until
sqlite will be merging two b-trees for your "create table as"
Max
___
sqlite-users mailing list
sqlite-users@s
, sqlite probably does these temporary tables creation.
I noticed that fewer reads/writes will be with the following variant
SELECT * FROM (SELECT n1, n2 FROM table1 Where n1 < n2)
UNION
SELECT * FROM (SELECT n2, n1 FROM table1 Where n2 < n1)
since this one decreases the size
Glad to be of service, and thanks for the quick turn around.
On 11-06-10 02:35 PM, Dan Kennedy wrote:
> On 06/11/2011 12:08 AM, Max wrote:
>> CREATE TABLE TestTable (
>>id integer primary key,
>>name varchar,
>>source_id integer not null,
rote:
> On 06/10/2011 10:33 PM, Max wrote:
>> I just grabbed a 3.7.6.3 binary from the sqlite page. The second schema
>> still fails to throw a constraint error.
> Hopefully fixed here:
>
> http://www.sqlite.org/src/info/442d8d8bfe
>
> Grab the zip
I just grabbed a 3.7.6.3 binary from the sqlite page. The second schema
still fails to throw a constraint error.
On 11-06-10 11:22 AM, Pavel Ivanov wrote:
> IIRC, there was a bug in enforcement compound foreign keys where one
> of columns is primary key and it was fixed. So if you take the lates
Hello,
Please consider this (working) schema and this test data, on sqlite 3.7.4:
CREATE TABLE TestTable (
id integer primary key,
name varchar,
source_id integer not null,
parent_id integer,
foreign key(parent_id) references TestTable(id)
);
PRAGMA foreign_keys=1;
INSERT INT
ed to act as independent entities without faults But what about the
last comment (about POSIX.1-2001). Does it mean some distros could not
support it?
Max
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
On Thu, Jun 9, 2011 at 6:21 PM, Pavel Ivanov wrote:
>
>
> So if you ever want to use dlopen() you should be really really
> careful to avoid loading the same library several times (even if the
> same library have different file names).
>
>
Pavel, thanks for the hint and
On Tue, Jun 7, 2011 at 9:22 PM, Martin Gadbois wrote:
> On Tue, Jun 7, 2011 at 12:52 PM, Jay A. Kreibich wrote:
>
> > On Tue, Jun 07, 2011 at 07:47:25PM +0400, Max Vlasov scratched on the
> wall:
> > > Hi,
> > >
> > > I'm trying to use sqlite wi
ndup(n) in mallocWithAlarm gives SIGSEGV
error.
- If I map sqlite3_initialize to init, the same happen with the first call
to sqlite3_mutex_enter call.
The library is build with
gcc -g -c -fPIC sqlite3.c
gcc -shared -Wl,-init=sqlite3_initialize -o customsqlite.so sqlite3.o
What am I missing here?
Th
On Tue, Mar 29, 2011 at 8:17 PM, Ralf Junker wrote:
> On 29.03.2011 15:17, Max Vlasov wrote:
>
> > Thanks, this forced me to search more on the topic. I use Delphi and it
> > appears that all Borland compilers has their own floating-point exception
> > handling chain an
On Tue, Mar 29, 2011 at 3:56 PM, Richard Hipp wrote:
> On Tue, Mar 29, 2011 at 4:48 AM, Max Vlasov wrote:
>
> > Hi,
> >
> > I sometimes use repeated digits as test data, for example 123456789
> > repeated
> > multiply times and recently some of my co
the result of this query in my case is 'unknown error' and no data shown.
Can it be considered a bug? The worst part of this error is that one needs
very deep investigation especially for long queries to understand what is
going on.
Thanks,
Max
___
On Tue, Mar 22, 2011 at 2:25 PM, Dan Kennedy wrote:
> On 03/22/2011 04:26 PM, Max Vlasov wrote:
> > Hi,
> >
> > recently I finally started experimenting with virtual tables and there's
> at
> > least one thing I can not understand.
> >
> > As I see
ike
CREATE TABLE IF NOT EXISTS [newTable] AS SELECT * FROM DataToPopulate
DataToPopulate can be a table from the db or temporary table created for
example when the program starts.
Max Vlasov
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
101 - 200 of 482 matches
Mail list logo