sqlite lets you violate foreign key constraints on insert.
so you then can't delete the row you added
which has absolutely no child data so it shouldn't be preventing you from deleting it.


  • 1
    @nowaho it's 3.36.0 sqlite3
  • 1
    @nowaho and i'll share the rest in a bit i'm annoyed by it lol
  • 1
    @nowaho barely motivated to finish working on the same goddamn shit heh
  • 1
    I think there is some kind of open option you have to pass for constraints to be checked.

    But I might misremember that
  • 1
    @nowaho, thanks for the clarification!
  • 1
    @nowaho does that explain why I can't delete a master row with no referencing data without getting a reference error ?

    Eg table 2 references table 1
    Table 2 has no rows
    I put a row in table 1
    I then try to delete that row
    Sqlite prevents me because of the fk
  • 1
    @nowaho but why is it preventing me from deleting a row not being referenced by anything ?
  • 1
    @nowaho when i remove the fk the row can be deleted
    Yeah sorry I'll post something better on it
    Last time they reached this version of sqlite I just had to work around and doublecheck myself
  • 1
    @nowaho did everyone like have a meeting and agree that noone would do anything real anymore ?
  • 1
    @nowaho because I missed the part where these garbage fags made their intentions to destroy the world clear or what kind of timetable in service of making the human race psychologically warped trash they defined.
  • 1
    @nowaho Ra Ra sis boom ba
  • 1
    @nowaho so what do you think we should be doing ?
    If you can't even take some crap job and some crap life without being cycled through this disgusting crap again and again ? Hmm ?

    The whole.point seems like everyone is just going to die without knowing how long it really takes and their vraY asses are making sure everyone is fucked the same way
  • 1
    @nowaho I want to hear your perspective
  • 1
    @nowaho while we do this same stupid crap again and the compilation of sqlite doesn't take very long I might add
  • 1
    @nowaho interesting
  • 0
    @nowaho so how's the hoo ha-ing ?
Add Comment