I found the cause of my issue.
I have two columns as foreign key in child, which reference corresponding pair
in parent. But, I was setting up the references separately, not as a pair. And
it looked like it can not work.
It works because the pair of columns in parent is PRIMARY KEY and thus
No, it means that you did not specify the whatisness of grandParent, parent, or
child; and/or, you have not enabled foreign_keys.
https://sqlite.org/lang_createtable.html
https://sqlite.org/pragma.html#pragma_foreign_keys
NB: I have compiled the CLI with foreign key enforcement ON be default.
What do your inserts look like? This SQL will function as expected:
CREATE TABLE grandparent (id INTEGER PRIMARY KEY);
CREATE TABLE parent (id INTEGER PRIMARY KEY REFERENCES grandparent(id));
CREATE TABLE child (id INTEGER PRIMARY KEY REFERENCES parent(id));
INSERT INTO
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
These statements worked for me:
CREATE TABLE grandparent (id INTEGER PRIMARY KEY);
CREATE TABLE parent (id INTEGER PRIMARY KEY REFERENCES grandparent(id));
CREATE TABLE child (id INTEGER PRIMARY KEY REFERENCES parent(id));
The foreign key constraints work as you'd expect also.
What are you
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))
create child (id PRIMARY KEY REFERENCES parent(id))
SQLite complains. Does it mean that grand children are not allowed?
On 25 Oct 2018, at 12:16am, Philip Warner wrote:
> t leads to the question: have you ever seen one that works better than, say,
> "Don't be an arsehole/dick/evil"? In most jurisdictions sexual harassment,
> murder etc are already illegal...so repeating them in a CoE/C seems redundant.
The
On 25/10/2018 2:17 AM, Jens Alfke wrote:
Vague blanket statements like “Don’t be evil” or “Be excellent to each other”
don’t work (here or anywhere else.)
This is a good point. But it leads to the question: have you ever seen one that
works better than, say, "Don't be an
On 25/10/2018 9:11 AM, Richard Hipp wrote:
If you read the original CoC closely, you will find things that
required me to change it. We have:
18. Be a help in times of trouble
19. Console the sorrowing
31. Love your enemies
34. Be not proud
71. Make peace with your adversary
See, this is where I miss being able to non-intrusively add a heart emoji
to your post. Here it is anyway: ❤
Wout.
On Thu, Oct 25, 2018, 12:11 AM Richard Hipp wrote:
> On 10/24/18, Michael Falconer wrote:
> >
> > it's all gone...while my devout atheism is generally pleased my
> > somewhat
On 10/24/18, Michael Falconer wrote:
>
> it's all gone...while my devout atheism is generally pleased my
> somewhat annoying 'free will, free speech ' ethic has rust on it! Richard,
> it's your joint and it's such a good place, friendly and mostly respectful.
> My atheism was NOT offended in
Oh dear,
it's all gone...while my devout atheism is generally pleased my
somewhat annoying 'free will, free speech ' ethic has rust on it! Richard,
it's your joint and it's such a good place, friendly and mostly respectful.
My atheism was NOT offended in any way by all that God speak and I do
The one I usually see as being referred to as being "political" is the
Contributor Covenant -
https://www.contributor-covenant.org/version/1/4/code-of-conduct
From reading it, while it does have some specifics, it has all the
exact same problems you're highlighting "Don't be evil" has. Why?
Or a capture card.
On Wed, Oct 24, 2018, 21:28 Brian Chrzanowski Probably a virtual machine.
>
> On Wed, Oct 24, 2018, 2:27 PM R Smith wrote:
>
> >
> > On 2018/10/24 8:19 PM, Stephen Chrzanowski wrote:
> > > ..// without users consent. ... unlike...
> > >
> >
>
Probably a virtual machine.
On Wed, Oct 24, 2018, 2:27 PM R Smith wrote:
>
> On 2018/10/24 8:19 PM, Stephen Chrzanowski wrote:
> > ..// without users consent. ... unlike...
> >
> https://www.extremetech.com/wp-content/uploads/2016/08/Windows10-BSOD-640x353.jpg
>
> How did you take a screenshot
On 2018/10/24 8:19 PM, Stephen Chrzanowski wrote:
..// without users consent. ... unlike...
https://www.extremetech.com/wp-content/uploads/2016/08/Windows10-BSOD-640x353.jpg
How did you take a screenshot while Windows was hanging/recovering?
I call foul!
(Or is that a new Windows 10
I like this.
If I were to use this (And I don't expect I'll ever have to since I
typically write just for me) the only addition I'd make to this is about
the reporting.
From a users perspective, if the utility has something to report "home"
with (lets say crash reports), it'd have to be
Code Of Conduct, misplaced disposition on the individuals of
an organization rather than the results of their work on
intent.
I have had a simple statement with my open source software
downloads for years.
"Dandy Made Productions would like to assure individuals that
any applications downloaded
Richard,
thank you for your further explanation of your team's Code of Conduct.
After a bit of research on the Internet, everything makes sense.
Well done.
regs,
Kev
___
sqlite-users mailing list
sqlite-users@mailinglists.sqlite.org
> On Oct 22, 2018, at 10:04 PM, Paul wrote:
>
> If my opinion has any value, even though being atheist, I prefer this CoC 100
> times over
> the CoC that is being currently pushed onto the many open-source communities,
> that was
> created by some purple-headed feminist with political
On Wed, Oct 24, 2018 at 1:55 PM Jan Danielsson
wrote:
> > Lets not pretend the rules are from English origin please. --DD
>
>I don't think that was what Wout meant. Read "Ye Olde English" as
> "Aesthetically 'old'", not "use the original". Point was merely to give
> some visual clues to
On 2018-10-24 13:42, Dominique Devienne wrote:
> On Wed, Oct 24, 2018 at 1:10 PM Wout Mertens wrote:
>> [...] write the rules in Ye Olde English. [..]
>
> He was "Italian", and more likely to write in Latin, not English, old or
> new.
> The SQLite doc is English only because that's DRH native
On Wed, Oct 24, 2018 at 1:10 PM Wout Mertens wrote:
> [...] write the rules in Ye Olde English. [..]
>
He was "Italian", and more likely to write in Latin, not English, old or
new.
The SQLite doc is English only because that's DRH native tong (I assume).
Lets not pretend the rules are from
> On the other hand, I am open to suggestions on how to express
> those values in a way that modern twitter-ites can better understand
Probably via selfie, with a duckface, together with your evening meal in
the background.
On Mon, Oct 22, 2018 at 4:30 PM Richard Hipp wrote:
> On 10/22/18,
I think a lot of confusion could have been avoided by putting the text of
the CoC in a separate box, and for extra effect use a parchment paper
background, something like the Papyrus font and write the rules in Ye Olde
English.
Right now it looks as if the rules were written specifically for
I think the big problem with this CoC is that it triggers Poe's Law -
it's impossible to tell if it's serious or a joke without further
context. I know I spent a good 10 minutes trying to decide either way
when I first saw this thread a few days ago; now I know from the below
post that it's
On 10/24/18, Graham Hardman wrote:
>
> With my files built from the command prompt I ran the pragma
> compile_options and see that geopoly is listed as expected.
Are you sure? Can you double-check? Because I just looked at the
source code and it appears I mistakenly omitted ENABLE_GEOPOLY from
There is no datetime type in SQLite. You are storing ISO Text representations
so you should declare the column as TEXT.
An Index is only useable for a prefix of equality contstraints followed by ONE
inequality constraint.
From your index (model_id, confidence, ts) and your query constraints (
29 matches
Mail list logo
