/ Hex Artifact Content
Login
SQLite training in Houston TX on 2019-11-05 (details)
Part of the 2019 Tcl Conference

Artifact dd9f8d3e0ee32e7e375831cb49806a84e4ebcea3773e7f8b16f27afe900d8d77:

Ticket change [dd9f8d3e] - Closed ticket [17db54d7]: Unexpected error in DELETE with existing trigger plus 6 other changes by dan 2019-08-14 19:55:58.
0000: 44 20 32 30 31 39 2d 30 38 2d 31 34 54 31 39 3a  D 2019-08-14T19:
0010: 35 35 3a 35 38 2e 34 32 38 0a 4a 20 69 63 6f 6d  55:58.428.J icom
0020: 6d 65 6e 74 20 5c 72 5c 6e 54 68 69 73 5c 73 73  ment \r\nThis\ss
0030: 65 65 6d 73 5c 73 74 6f 5c 73 62 65 5c 73 77 6f  eems\sto\sbe\swo
0040: 72 6b 69 6e 67 5c 73 61 73 5c 73 64 65 73 69 67  rking\sas\sdesig
0050: 6e 65 64 2e 5c 73 54 68 65 5c 73 22 6e 6f 5c 73  ned.\sThe\s"no\s
0060: 73 75 63 68 5c 73 63 6f 6c 75 6d 6e 22 5c 73 65  such\scolumn"\se
0070: 72 72 6f 72 5c 73 72 65 66 65 72 73 5c 73 74 6f  rror\srefers\sto
0080: 5c 73 74 68 65 5c 73 22 63 30 22 5c 73 69 6e 5c  \sthe\s"c0"\sin\
0090: 73 74 68 65 5c 73 74 72 69 67 67 65 72 2e 5c 73  sthe\strigger.\s
00a0: 49 6e 5c 73 74 68 69 73 5c 73 63 6f 6e 74 65 78  In\sthis\scontex
00b0: 74 5c 73 22 6f 6c 64 2e 63 30 22 5c 73 77 6f 75  t\s"old.c0"\swou
00c0: 6c 64 5c 73 77 6f 72 6b 2c 5c 73 62 75 74 5c 73  ld\swork,\sbut\s
00d0: 74 68 65 72 65 5c 73 69 73 5c 73 6e 6f 5c 73 63  there\sis\sno\sc
00e0: 6f 6c 75 6d 6e 5c 73 74 68 61 74 5c 73 63 61 6e  olumn\sthat\scan
00f0: 5c 73 62 65 5c 73 72 65 66 65 72 72 65 64 5c 73  \sbe\sreferred\s
0100: 74 6f 5c 73 61 73 5c 73 6a 75 73 74 5c 73 22 63  to\sas\sjust\s"c
0110: 30 22 2e 5c 72 5c 6e 5c 72 5c 6e 54 68 65 5c 73  0".\r\n\r\nThe\s
0120: 65 72 72 6f 72 5c 73 6f 63 63 75 72 73 5c 73 77  error\soccurs\sw
0130: 68 65 6e 5c 73 74 68 65 5c 73 44 45 4c 45 54 45  hen\sthe\sDELETE
0140: 5c 73 69 73 5c 73 70 72 65 70 61 72 65 64 2c 5c  \sis\sprepared,\
0150: 73 6e 6f 74 5c 73 77 68 65 6e 5c 73 74 68 65 5c  snot\swhen\sthe\
0160: 73 74 72 69 67 67 65 72 5c 73 69 73 5c 73 63 72  strigger\sis\scr
0170: 65 61 74 65 64 2c 5c 73 61 73 5c 73 53 51 4c 69  eated,\sas\sSQLi
0180: 74 65 5c 73 64 6f 65 73 5c 73 6e 6f 74 5c 73 72  te\sdoes\snot\sr
0190: 65 73 6f 6c 76 65 5c 73 63 6f 6c 75 6d 6e 5c 73  esolve\scolumn\s
01a0: 6f 72 5c 73 74 61 62 6c 65 5c 73 72 65 66 65 72  or\stable\srefer
01b0: 65 6e 63 65 73 5c 73 77 68 65 6e 5c 73 74 72 69  ences\swhen\stri
01c0: 67 67 65 72 73 5c 73 61 6e 64 5c 73 76 69 65 77  ggers\sand\sview
01d0: 73 5c 73 61 72 65 5c 73 63 72 65 61 74 65 64 2c  s\sare\screated,
01e0: 5c 73 6f 6e 6c 79 5c 73 77 68 65 6e 5c 73 74 68  \sonly\swhen\sth
01f0: 65 79 5c 73 61 72 65 5c 73 75 73 65 64 2e 5c 73  ey\sare\sused.\s
0200: 54 68 69 73 5c 73 63 61 6e 5c 73 62 65 5c 73 73  This\scan\sbe\ss
0210: 75 72 70 72 69 73 69 6e 67 2e 0a 4a 20 6c 6f 67  urprising..J log
0220: 69 6e 20 64 61 6e 0a 4a 20 6d 69 6d 65 74 79 70  in dan.J mimetyp
0230: 65 20 74 65 78 74 2f 78 2d 66 6f 73 73 69 6c 2d  e text/x-fossil-
0240: 77 69 6b 69 0a 4a 20 70 72 69 6f 72 69 74 79 20  wiki.J priority 
0250: 49 6d 6d 65 64 69 61 74 65 0a 4a 20 72 65 73 6f  Immediate.J reso
0260: 6c 75 74 69 6f 6e 20 4e 6f 74 5f 41 5f 42 75 67  lution Not_A_Bug
0270: 0a 4a 20 73 74 61 74 75 73 20 43 6c 6f 73 65 64  .J status Closed
0280: 0a 4a 20 73 75 62 73 79 73 74 65 6d 20 55 6e 6b  .J subsystem Unk
0290: 6e 6f 77 6e 0a 4b 20 31 37 64 62 35 34 64 37 34  nown.K 17db54d74
02a0: 34 30 32 38 31 66 32 63 32 34 38 34 38 66 34 35  40281f2c24848f45
02b0: 37 31 66 38 33 61 62 39 66 63 61 31 31 39 37 0a  71f83ab9fca1197.
02c0: 55 20 64 61 6e 0a 5a 20 62 66 38 66 34 38 30 36  U dan.Z bf8f4806
02d0: 61 32 31 33 30 32 32 64 33 33 64 62 61 66 65 64  a213022d33dbafed
02e0: 65 66 62 63 37 35 63 39 0a                       efbc75c9.