cate
what the object is. What is the word for that programming methodology that
existed since the beginning when there were no threads and everything was
single-task?
Roman
From: sqlite-users on behalf of
Richard Hipp
Sent: Tuesday, January 28, 2020 6:18
Perhaps "server" is not the right emphasis? Maybe it is the client? Thus,
"clientless"? This means that each SQlite session serves itself.
Self-sufficient.
Roman
From: sqlite-users on behalf of
Richard Hipp
Sent: Monday, January 27, 2020
network
access with replication. I have not tried it and do not know what is involved.
Roman
From: sqlite-users on behalf of
Richard Hipp
Sent: Saturday, January 11, 2020 8:59 PM
To: SQLite mailing list
Subject: Re: [sqlite] Test failures on GPFS
CAUTION
A side note about VACUUM:
If I remember correctly, tables which do not have INTEGER PRIMARY KEY will have
their rowid column reassigned. Be careful if you are using rowid.
Roman
From: sqlite-users on behalf of
Simon Slavin
Sent: Thursday, December 5, 2019 2
LoM as the cause
of the problem?
Roman
From: sqlite-users [sqlite-users-boun...@mailinglists.sqlite.org] on behalf of
Simon Slavin [slav...@bigfraud.org]
Sent: Thursday, November 07, 2019 7:28 PM
To: SQLite mailing list
Subject: Re: [sqlite] database is
lly delete entire content of a table if lock is
mismanaged? I am trying to figure out of this is a disk related issue. Or some
other issue.
Roman
___
sqlite-users mailing list
sqlite-users@mailinglists.sqlite.org
http://mailinglists.sqlite.org/cgi-b
opped
connections...
The problem is thus in distilling the basic feature set such mySQLite should
have. This is what SQLite developers did for SQLite.
Roman
From: sqlite-users [sqlite-users-boun...@mailinglists.sqlite.org] on behalf of
Graham Holden [sql
Transaction delays apply to read as well. SQLite places a lock while reading
too, to ensure the database is intact during read. Otherwise tables will half
half complete rows.
Read "begin transaction", difference between immediate and exclusive
transactions.
Roman
Sent from my T
at.
If GPFS is loaded by other jobs (from other users, not even sqlite users) the
wait times will increase.
Roman
Sent from my T-Mobile 4G LTE Device
Original message
From: Simon Slavin
Date: 10/16/19 12:51 AM (GMT-05:00)
To: SQLite mailing list
Subject: Re: [sqlit
It's ok that you don't believe in it, but the last statement, you know is not
true. I have been in this list since 2003 or so, and constantly there is one
or two request to Dr. Hipp and the owners, per month, to add "stuff" to it.
Or, things like, "I would love to have SQLite do...", etc. Fir
uty. Learn to see it!
Roman
From: sqlite-users [sqlite-users-boun...@mailinglists.sqlite.org] on behalf of
Jose Isaias Cabrera [jic...@outlook.com]
Sent: Thursday, October 10, 2019 4:03 PM
To: SQLite mailing list
Subject: [sqlite] SQLite plus the works (
I had to deal with a similar conversion.
I think the answer to why date() does not take other formats is simple: SQLite
is minimalistic. This string processing can be done outside SQLite library.
Minimalism of SQLite is one of the criteria for what gets implemented. It has
few mathematical oper
Maybe this for this scenario:
You have in-memory database, used mostly for reading and you want to save its
copy to disk when update on in-memory is performed?
Otherwise, what is copied and what is to write in "copy on write"?
From: sqlite-users [sqlit
I like the idea of FLoM-based VFS !!
I am not sure I am up to actually doing it, but this should be as good a
locking mechanism as any other.
Thank you, Keith.
Roman
From: sqlite-users [sqlite-users-boun...@mailinglists.sqlite.org] on behalf of
Keith
ashes will
remain. unix-none just disables file lock requests, which are the cause of the
overhead. Is this correct?
Roman
From: sqlite-users [sqlite-users-boun...@mailinglists.sqlite.org] on behalf of
Keith Medcalf [kmedc...@dessus.com]
Sent: Friday, Se
synchronization
instead of me programming client/server.
Thank you,
Roman
From: sqlite-users [sqlite-users-boun...@mailinglists.sqlite.org] on behalf of
Keith Medcalf [kmedc...@dessus.com]
Sent: Friday, September 27, 2019 11:12 PM
To: SQLite mailing list
in item 2 of the link you mention.
I was not aware of the various synch option. I will study them.
Thank you,
Roman
From: sqlite-users [sqlite-users-boun...@mailinglists.sqlite.org] on behalf of
Simon Slavin [slav...@bigfraud.org]
Sent: Friday, September
light mySQL, mySQLite?
Roman
From: sqlite-users [sqlite-users-boun...@mailinglists.sqlite.org] on behalf of
Simon Slavin [slav...@bigfraud.org]
Sent: Wednesday, September 25, 2019 12:58 AM
To: SQLite mailing list
Subject: Re: [sqlite] Safe to use SQLite o
Oh, Thank you Barry.
I am glad it is not a bug. Bug is in my head.
Thank you,
Roman
From: sqlite-users [sqlite-users-boun...@mailinglists.sqlite.org] on behalf of
Barry [smith.bar...@gmail.com]
Sent: Tuesday, June 18, 2019 7:59 PM
To: SQLite mailing
to output the same list of
refVolumes. But it does not:
SELECT DISTINCT refVolume FROM cosSquared
WHERE (refVolume, CAST(10*cosSquared AS INT)) = (SELECT refVolume, 9 FROM
cosSquared);
refVolume
--
2
What am I doing wrong? I am using version 3.16.
Thank you for your help,
Roman
Thank you, Adrian. I think this is reason changes() exist.
Roman
Sent from my T-Mobile 4G LTE Device
Original message
From: Adrian Ho
Date: 6/15/19 12:25 AM (GMT-05:00)
To: sqlite-users@mailinglists.sqlite.org
Subject: Re: [sqlite] select within transaction
On 15/6/19 2
Thank you! I did not know (or forgot) about ".bail on"
Roman
From: sqlite-users [sqlite-users-boun...@mailinglists.sqlite.org] on behalf of
David Raymond [david.raym...@tomtom.com]
Sent: Friday, June 14, 2019 3:05 PM
To: SQLite mailing list
S
.
Is this what changes() is for?
Thank you,
Roman
___
sqlite-users mailing list
sqlite-users@mailinglists.sqlite.org
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
Good morning!
when trying to compile sqlite from Snapshop of the complete (raw) source tree
for SQLite version 3.27.2 and definingSQLITE_OMIT_VIEW and SQLITE_OMIT_TRIGGER
then compilation fails with the following messages:
###
sqlite3.c:19044:20: warning: 'sqlite3FixExprList' used but nev
twice: by (constant - 5) then by 5.
Thank you,
Roman
From: sqlite-users [sqlite-users-boun...@mailinglists.sqlite.org] on behalf of
Keith Medcalf [kmedc...@dessus.com]
Sent: Thursday, December 13, 2018 6:06 PM
To: SQLite mailing list
Subject: Re: [s
ing on the sign of the constant, it will always succeed as I need.
But UPDATE has no ordering mechanism because it makes no sense to have one.
Does it mean I am doing it incorrectly? How to do I update? Bracketing with
BEGIN .. COMMIT did not help.
Thank yo
Hypothesis can never be proven. It can only be rejected with data contradicting
it at hand.
"..the quickest way ..." implies someone else corrects you.
From: sqlite-users [sqlite-users-boun...@mailinglists.sqlite.org] on behalf of
Don V Nielsen [donvnie
Thank you for the clarification.
On Wed, Oct 31, 2018 at 6:03 PM Richard Hipp wrote:
> On 10/31/18, Roman Ivasyshyn wrote:
> >
> > I faced with an issue of creating int array with the same name without
> > closing connection.
>
> That is not allowed. But you can use
with sqlite3_create_module_v2 function and drop table, before
second call, makes no effect on that module.
Please advice if it’s expected behavior and it there any workarounds on
that?
Regards,
Roman Ivasyshyn
___
sqlite-users mailing list
sqlite
has
unique index -- the only requirement for foreign keys to work.
Roman
From: sqlite-users [sqlite-users-boun...@mailinglists.sqlite.org] on behalf of
Keith Medcalf [kmedc...@dessus.com]
Sent: Thursday, October 25, 2018 1:03 AM
To: SQLite mailing list
The statements work. Insertion fails.
Roman
From: sqlite-users [sqlite-users-boun...@mailinglists.sqlite.org] on behalf of
David Yip [dw...@peach-bun.com]
Sent: Thursday, October 25, 2018 12:37 AM
To: SQLite mailing list
Subject: Re: [sqlite] nested
Dear SQLIters,
I am trying to set up what I would call "nested foreign keys":
create grandParent( id PRIMARY KEY)
create parent (id PRIMARY KEY REFERENCES grandParent(id))
___
sqlite-users mailing list
sqlite-users@mailinglists.sqlite.org
http://mailin
ot allowed?
Thank you,
Roman
___
sqlite-users mailing list
sqlite-users@mailinglists.sqlite.org
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
cascade on delete, as
I think it should. So it seems that "replace" is implemented as "delete then
insert" rather than "update". Is that normal and expected? Am I doing something
wrong?
Thank you,
Roman
___
sqlite-u
with differing values
On 2018/10/11 9:53 PM, Roman Fleysher wrote:
> It is hard for me to tell which is index, which is value and so forth in your
> example, but how about this single select:
>
> SELECT DISTINCT key, value FROM theTable;
>
> This lists all distinct key-value
key, value HAVING count() > 1;
This lists all key-value pairs with more than one value for the key.
Roman
From: sqlite-users [sqlite-users-boun...@mailinglists.sqlite.org] on behalf of
David Raymond [david.raym...@tomtom.com]
Sent: Thursday, October
a value with the exact
same value inside the database ( executed with the sqlite c++ api without usage
of prepared parameters)
Kind regards
Roman Stiefsohn
___
sqlite-users mailing list
sqlite-users@mailinglists.sqlite.org
http://mailinglists.sqlite.org
Thank you for pointing the 24 hours. I did not notice the day change.
Now, I have no idea how this can happen. I will investigate more.
Roman
From: Graham Holden [sql...@aldurslair.com]
Sent: Tuesday, May 15, 2018 3:39 PM
To: Roman Fleysher
Cc: General
finishing (at
16:44:11). Time of start of 2283 looks correct, agrees with my watch, because I
started this job manually.
Roman
___
sqlite-users mailing list
sqlite-users@mailinglists.sqlite.org
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
Why does SQLite have to follow what PostgreSQL does? I thought SQLite is the
leader.
Roman
Sent from my T-Mobile 4G LTE Device
Original message
From: Richard Hipp
Date: 5/9/18 5:48 AM (GMT-05:00)
To: SQLite mailing list
Subject: Re: [sqlite] 3.24 draft - upsert
On 5/9
condition that if x is removed from one list, it must
be removed from the other. This is easy to add for ones who understand how it
works.
Roman
From: sqlite-users [sqlite-users-boun...@mailinglists.sqlite.org] on behalf of
E.Pasma [pasm...@concepts.nl]
Sent
Subject: Re: [sqlite] probably recursive?
Ah my bad, I misunderstood the initial condition. nX is a function of X. My
statements were only true if nX=X. Well, sorry about the noise.
> On 2 May 2018, at 8:20 am, Roman Fleysher
> wrote:
>
> Dear Barry,
>
> The statement about
either because the points were never on the list or were eliminated.
Roman
From: sqlite-users [sqlite-users-boun...@mailinglists.sqlite.org] on behalf of
Barry Smith [smith.bar...@gmail.com]
Sent: Tuesday, May 01, 2018 6:12 PM
To: SQLite mailing list
Pairs (x,y) do not repeat.
Actual x and y are positive integers, but I do not see how being positive can
be relevant. Integer is important for sorting/comparison.
Roman
From: sqlite-users [sqlite-users-boun...@mailinglists.sqlite.org] on behalf of
Agree. Thank you.
Roman
From: sqlite-users [sqlite-users-boun...@mailinglists.sqlite.org] on behalf of
Simon Slavin [slav...@bigfraud.org]
Sent: Tuesday, May 01, 2018 12:50 PM
To: SQLite mailing list
Subject: Re: [sqlite] probably recursive?
On 1 May
)
GROUP BY x HAVING count(x) < 25)
)
SELECT x, y FROM deleteList;
Roman
From: sqlite-users [sqlite-users-boun...@mailinglists.sqlite.org] on behalf of
David Raymond [david.raym...@tomtom.com]
Sent: Tuesday, May 01, 2018 10:27
At the end, number of dots on all vertical lines must be more
than nX and number of dots on all horizontal lines must be more than nY.
Could this be achieved with SQLite?
Roman
___
sqlite-users mailing list
sqlite-users@mailinglists.sqlit
of the SQL statement.
Roman
From: sqlite-users [sqlite-users-boun...@mailinglists.sqlite.org] on behalf of
petern [peter.nichvolo...@gmail.com]
Sent: Thursday, April 05, 2018 3:25 AM
To: SQLite mailing list
Subject: Re: [sqlite] exit status of command sh
ot;ww; \n.exit" | sqlite3
Error: near line 1: near "ww": syntax error
echo $?
1
echo -e "ww" | sqlite3
Error: near line 1: near "ww": syntax error
echo $?
0
Thank you,
Roman
___
sqlite-users mailing list
s
You are right, Igor. Clear case of XY problem. I will remove trigger.
Roman
Sent from my T-Mobile 4G LTE Device
Original message
From: Igor Tandetnik
Date: 1/26/18 9:03 PM (GMT-05:00)
To: sqlite-users@mailinglists.sqlite.org
Subject: Re: [sqlite] primary key in another
yes, I can use a view.
forEachRow also records what failed. Updating a view requires a trigger, but I
can compose one with the view.
Thank you for suggestion!
Roman
From: sqlite-users [sqlite-users-boun...@mailinglists.sqlite.org] on behalf of
No, I can not compute inside forEachRow. ForEachRow is now universal, can be
applied to any table. If I modify SELECT inside it to fit specific purpose,
forEachRow will use universality.
Roman
From: sqlite-users [sqlite-users-boun
I think I effectively did as you suggested using triggers. I insert NULL into
the ID column to create a row. This triggers the trigger to run update on the
table to populate the columns based on the just created ID. Is this what you
suggested?
Roman
n parallel batches if it can) and apply
the command given to it with its arguments. Image processing is then a sequence
of these "forEach" commands.
Roman
From: sqlite-users [sqlite-users-boun...@mailinglists.sqlite.org] on behalf o
ay parallel execution
is done (sometimes sent to a compute cluster grid engine for queueing.)
This makes no sense from the database point of view: No reason to hold
redundant data with such a simple algorithm to generate it.
Roman
From: s
.
Is that a right solution?
Roman
From: sqlite-users [sqlite-users-boun...@mailinglists.sqlite.org] on behalf of
Roman Fleysher [roman.fleys...@einstein.yu.edu]
Sent: Friday, January 26, 2018 4:43 PM
To: General Discussion of SQLite Database
Subjec
insert a row into the table, id is already auto generated by
SQLite. I want the filename to be auto generated too. This idea looks strange
to me because then I do not have to insert anything, everything will be auto
filled:
INSERT INTO A;
INSERT INTO A;
will insert first two rows.
Roman
) and because of
the experience you gained by conclusion of the project, I am rather certain you
will be able to obtain additional funding to continue and refine the answer to
the newer version of SQLite available then. The future is in your hands!
Roman
pes, but each value still has a
type. And this is a very very big advantage of SQLite.
Perhaps longer term is "flexibly strongly typed". Perhaps because "typed"
implies "strongly" (what is a weak type?), strongly is redundant.
Roman
Original message ---
Dear SQLiters,
Vacuuming seems to belong to a different thread, but let me say that it is not
always warranted. Vacuuming may change/reassign ROWIDs. If you have two
databases (backup and production?) that used to be linked via such a key, it
will break.
Roman
. A TEMP trigger is
allowed to query or modify any table in any ATTACH-ed database.
I need to be able to specify db2.t in the body of the trigger. But this is not
allowed, right? Then how could it work? I mean it does not. Should it work?
Roman
From
to use INSTEAD OF trigger. Is that the right way? Or I
have to create a temp table that maps old linkID to new linkID, somehow.
Roman
___
sqlite-users mailing list
sqlite-users@mailinglists.sqlite.org
http://mailinglists.sqlite.org/cgi-bin/mailman
Thank you, Richard.
Roman
From: sqlite-users [sqlite-users-boun...@mailinglists.sqlite.org] on behalf of
Richard Hipp [d...@sqlite.org]
Sent: Thursday, August 03, 2017 3:38 PM
To: SQLite mailing list
Subject: Re: [sqlite] command shell .timeout
On 8/3
meouts to avoid this.
(By the way, PRAGMA busy_timeout = milliseconds; prints new timeout to screen.
I would expect printing only if new value is not provided.)
Thank you
Roman
___
sqlite-users mailing list
sqlite-users@mailinglists.sqlite.org
http://mai
link them. Perhaps I
will use ALTER TABLE mechanism.
Roman
From: sqlite-users [sqlite-users-boun...@mailinglists.sqlite.org] on behalf of
Keith Medcalf [kmedc...@dessus.com]
Sent: Monday, July 24, 2017 6:58 PM
To: SQLite mailing list
Subject: Re: [sqlite
I am sorry, I did not ask the question correctly. I omitted "... link two
tables, using foreign key...".
I now see last sentence on http://sqlite.org/lang_createtable.html which states
that it is not possible.
Roman
From: sqlite-users [sq
Dear SQLiters,
Is it possible to link two tables using rowid, the implicit column? I tried and
it did not work, so I presume the answer to my question is "no".
Thank you,
Roman
___
sqlite-users mailing list
sqlite-users@mailinglists.sqlit
Thank you, David. Now it totally makes sense to me. I realize this is SQL not
SQLite question.
Thank you,
Roman
From: sqlite-users [sqlite-users-boun...@mailinglists.sqlite.org] on behalf of
David Raymond [david.raym...@tomtom.com]
Sent: Wednesday
Oh, now i understand. Thank you, Simon.
Roman
Original message
From: Simon Slavin
Date: 5/16/17 5:35 PM (GMT-05:00)
To: SQLite mailing list
Subject: Re: [sqlite] SAVEPOINT with multiple databases
On 16 May 2017, at 10:09pm, Roman Fleysher
wrote:
> I think I came
the
transaction stack as any other, INSERT/UPDATE/DELETE?
Thank you,
Roman
___
sqlite-users mailing list
sqlite-users@mailinglists.sqlite.org
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
My apology, I can not read. http://sqlite.org/lang_createtrigger.html clearly
states that CTE is not supported in triggers.
Roman
From: sqlite-users [sqlite-users-boun...@mailinglists.sqlite.org] on behalf of
Roman Fleysher [roman.fleys
on 3.16.22.
Thank you,
Roman
___
sqlite-users mailing list
sqlite-users@mailinglists.sqlite.org
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
No. I was not aware of these tools. Are any of them good? Maintained?
I am mostly using sqlite3 shell from bash scripts. Do you know if some of them
are suitable replacements?
Is this off the topic of the original question?
Thank you,
Roman
From
SQLite access is.
GFS2 and GPFS supposedly solve file synchronization issue (by sharing disk
inodes rather than files ). I never tested this (we have GPFS) and do not know
about other file systems.
Roman
From: sqlite-users [sqlite-users-boun
My mistake: I do not update DB. I rename (unix mv) the DB.
Roman
From: sqlite-users [sqlite-users-boun...@mailinglists.sqlite.org] on behalf of
Roman Fleysher [roman.fleys...@einstein.yu.edu]
Sent: Thursday, February 16, 2017 12:33 AM
To: General
using sqlite3 version 3.8.11 (also command shell). I seem
to be able to replicate that.
Roman
___
sqlite-users mailing list
sqlite-users@mailinglists.sqlite.org
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
to sqlite. Or
From sqlite, use extension to run commands for each row.
Both have issues.
Roman
Original message
From: Richard Hipp
Date: 1/11/17 7:23 PM (GMT-05:00)
To: SQLite mailing list
Subject: Re: [sqlite] extension to run bash
On 1/11/17, Bob Friesenhahn wrote
ables for
analysis.
Thank you,
Roman
From: sqlite-users [sqlite-users-boun...@mailinglists.sqlite.org] on behalf of
Richard Hipp [d...@sqlite.org]
Sent: Wednesday, January 11, 2017 4:44 PM
To: SQLite mailing list
Subject: Re: [sqlite] extension to run
Yes, Richard, this is exactly what I mean.
Roman
From: sqlite-users [sqlite-users-boun...@mailinglists.sqlite.org] on behalf of
Richard Hipp [d...@sqlite.org]
Sent: Wednesday, January 11, 2017 4:34 PM
To: SQLite mailing list
Subject: Re: [sqlite
Thank you,
Roman
___
sqlite-users mailing list
sqlite-users@mailinglists.sqlite.org
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
Can't you count how many rows there are and then sort by the variable of
interest, limiting output to half the count, all within SQL?
Roman
Sent from my T-Mobile 4G LTE Device
Original message
From: Ronald Gombach
Date: 11/21/16 7:12 AM (GMT-05:00)
To: sqlite-
Thank you! Worked!
Roman
From: sqlite-users-boun...@mailinglists.sqlite.org
[sqlite-users-boun...@mailinglists.sqlite.org] on behalf of R Smith
[rsm...@rsweb.co.za]
Sent: Tuesday, July 05, 2016 3:13 PM
To: sqlite-users@mailinglists.sqlite.org
Subject: Re
Dear SQLiters,
I made a mistake and inserted a new line char, "\n" in the middle of a text. I
now would like to replace it with nothing. Something like:
replace(columnName, '\n','')
But this will interpret "\n" literally, as two sym
e timeline of unfolding disruptive innovation.
SQLite was and is a disruptive innovation. SQLite is not a toy.
Thank you for making it.
Roman
From: sqlite-users-bounces at mailinglists.sqlite.org [sqlite-users-bounces at
mailinglists.sqlite.org] on
Thank you. I did not notice loss of fractional seconds. I now see in the manual
that datetime() is equivalent to strftime('%Y-%m-%d %H:%M:%S', ...), with
capital "S" rather than lower "f" at the end that I expected.
Roman
ateTime IS
datetime(AcquisitionDateTime))
when I insert '2015-08-10T17:19:37.670' or '2015-08-10 17:19:37.670' fails.
Why? How to do it properly?
Thank you,
Roman
I just downloaded and tested using 3.8.11.1. It and 3.8.8.3 have the same
behavior -- do not disable.
Roman
From: sqlite-users-bounces at mailinglists.sqlite.org [sqlite-users-bounces at
mailinglists.sqlite.org] on behalf of Richard Hipp [d
Thank you Richard!
Roman
From: sqlite-users-bounces at mailinglists.sqlite.org [sqlite-users-bounces at
mailinglists.sqlite.org] on behalf of Richard Hipp [d...@sqlite.org]
Sent: Thursday, September 10, 2015 7:50 PM
To: General Discussion of SQLite
27;yes';
INSERT INTO subject (rowid) SELECT rowid FROM input;
Error: NOT NULL constraint failed: subject.gender
I am using SQLite 3.8.11.1. Am I misusing the PRAGMA?
Thank you,
Roman
OK, Thank you.
Meanwhile (again) I check that PRAGMA integrity_check='yes' did not disable
TEXT NOT NULL. Is that a bug in 3.8.8.3?
Roman
From: sqlite-users-bounces at mailinglists.sqlite.org [sqlite-users-bounces at
mailinglists.sqlite.org]
Thank you, Simon.
Meanwhile, I tested if PRAGMA integrity_check checks column constraints. You
can bump up 90% of being sure it does not to 100%. It does not. Is there a way
to do it, other than export the data out and try to re-insert it?
Roman
From
n. Is that expected?
Thank you,
Roman
From: sqlite-users-bounces at mailinglists.sqlite.org [sqlite-users-bounces at
mailinglists.sqlite.org] on behalf of Simon Slavin [slav...@bigfraud.org]
Sent: Thursday, September 10, 2015 6:39 PM
To: General Discussion
Dear SQLiters,
PRAGMA integrity_check is described to check UNIQUE and NOT NULL constraints.
Does it check other CHECK constraints specified in the column definition?
Thank you,
Roman
data.
I was elated when I implemented first equation. This is like stored procedure.
Roman
From: sqlite-users-bounces at mailinglists.sqlite.org [sqlite-users-bounces at
mailinglists.sqlite.org] on behalf of R.Smith [rsm...@rsweb.co.za]
Sent: Wednesday
, if it exists. Obviously, software may also impement other
algorithms developed by other people, not directly the software developers. I
would expect the "main" SQLite publication to mention them.
Roman
From: sqlite-users-
grateful to all SQLiters for making SQLite
available.
Roman
From: sqlite-users-bounces at mailinglists.sqlite.org [sqlite-users-bounces at
mailinglists.sqlite.org] on behalf of Richard Hipp [d...@sqlite.org]
Sent: Monday, July 13, 2015 11:54 AM
To: General
.
Thank you,
Roman
CAST() modification that you
propose should actually be the correct SQL code that I should adopt permanetly.
We like implicit conversions, but as C++ is more strict than C with regard to
casting, should it be my better practice to always explicitly cast?
Thank you,
Roman
using 5 year old version of sqlite that we have on
our system.
How will i know the patch/new version is available? By checking ticket link?
Thank you,
Roman
Sent from my T-Mobile 4G LTE Device
Original message
From: Richard Hipp
Date: 05/19/2015 3:37 PM (GMT-05:00)
To
;,'17','Male');
INSERT INTO "demographics" VALUES('0017','1989-12-15','25','18','Male');
INSERT INTO "demographics" VALUES('0018','1991-12-18','23','16','Male');
INSERT INTO "demographics" VALUES('0019','1989-04-24','26','20','Male');
INSERT INTO "demographics" VALUES('0020','1965-10-15','49','20','Male');
INSERT INTO "demographics" VALUES('0021','1980-01-03','35','15','Female');
INSERT INTO "demographics" VALUES('0022','1979-01-05','36','11','Male');
INSERT INTO "demographics" VALUES('0023','1990-10-28','24','16','Male');
INSERT INTO "demographics" VALUES('0024','1983-10-13','31','14','Male');
INSERT INTO "demographics" VALUES('0025','1991-07-10','23','14','Male');
INSERT INTO "demographics" VALUES('0026','1991-04-28','24','18','Male');
INSERT INTO "demographics" VALUES('0027','1988-07-05','26','18.5','Male');
INSERT INTO "demographics" VALUES('0028','1987-04-22','28','21','Male');
INSERT INTO "demographics" VALUES('0029','1988-08-04','26','18','Male');
INSERT INTO "demographics" VALUES('0030','1967-12-13','47','16','Male');
INSERT INTO "demographics" VALUES('0031','1983-11-05','31','16','Male');
-- Offending statement:
PRAGMA foreign_keys=ON;
INSERT OR IGNORE INTO subject(subjectID, dob, gender)
SELECT subjectID, dob, gender FROM demographics;
PRAGMA integrity_check;
-- Roman
1 - 100 of 151 matches
Mail list logo
