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

Artifact f06e8c9d7b4326051f6894fae7f87dfbacae4616a58df73a74f15bb0f3661387:

Ticket change [f06e8c9d] - New ticket [17db54d7] Unexpected error in DELETE with existing trigger. by mrigger 2019-08-14 19:47:19.
0000: 44 20 32 30 31 39 2d 30 38 2d 31 34 54 31 39 3a  D 2019-08-14T19:
0010: 34 37 3a 31 39 2e 35 35 31 0a 4a 20 66 6f 75 6e  47:19.551.J foun
0020: 64 69 6e 20 33 2e 32 39 2e 30 0a 4a 20 69 63 6f  din 3.29.0.J ico
0030: 6d 6d 65 6e 74 20 43 6f 6e 73 69 64 65 72 5c 73  mment Consider\s
0040: 74 68 65 5c 73 66 6f 6c 6c 6f 77 69 6e 67 5c 73  the\sfollowing\s
0050: 65 78 61 6d 70 6c 65 3a 5c 72 5c 6e 5c 72 5c 6e  example:\r\n\r\n
0060: 3c 70 72 65 3e 5c 72 5c 6e 43 52 45 41 54 45 5c  <pre>\r\nCREATE\
0070: 73 54 41 42 4c 45 5c 73 74 30 28 63 30 29 3b 5c  sTABLE\st0(c0);\
0080: 72 5c 6e 43 52 45 41 54 45 5c 73 54 52 49 47 47  r\nCREATE\sTRIGG
0090: 45 52 5c 73 74 72 30 5c 73 41 46 54 45 52 5c 73  ER\str0\sAFTER\s
00a0: 44 45 4c 45 54 45 5c 73 4f 4e 5c 73 74 30 5c 73  DELETE\sON\st0\s
00b0: 57 48 45 4e 5c 73 63 30 5c 73 42 45 47 49 4e 5c  WHEN\sc0\sBEGIN\
00c0: 73 44 45 4c 45 54 45 5c 73 46 52 4f 4d 5c 73 74  sDELETE\sFROM\st
00d0: 30 3b 5c 73 45 4e 44 3b 5c 72 5c 6e 44 45 4c 45  0;\sEND;\r\nDELE
00e0: 54 45 5c 73 46 52 4f 4d 5c 73 74 30 3b 5c 73 2d  TE\sFROM\st0;\s-
00f0: 2d 5c 73 75 6e 65 78 70 65 63 74 65 64 3a 5c 73  -\sunexpected:\s
0100: 6e 6f 5c 73 73 75 63 68 5c 73 63 6f 6c 75 6d 6e  no\ssuch\scolumn
0110: 3a 5c 73 63 30 5c 72 5c 6e 3c 2f 70 72 65 3e 5c  :\sc0\r\n</pre>\
0120: 72 5c 6e 5c 72 5c 6e 54 68 65 5c 73 65 72 72 6f  r\n\r\nThe\serro
0130: 72 5c 73 74 68 61 74 5c 73 6e 6f 5c 73 63 6f 6c  r\sthat\sno\scol
0140: 75 6d 6e 5c 73 63 30 5c 73 65 78 69 73 74 73 5c  umn\sc0\sexists\
0150: 73 69 73 5c 73 73 75 72 70 72 69 73 69 6e 67 2c  sis\ssurprising,
0160: 5c 73 73 69 6e 63 65 5c 73 69 74 5c 73 68 61 73  \ssince\sit\shas
0170: 5c 73 6e 6f 74 5c 73 62 65 65 6e 5c 73 64 65 6c  \snot\sbeen\sdel
0180: 65 74 65 64 2e 0a 4a 20 6c 6f 67 69 6e 20 6d 72  eted..J login mr
0190: 69 67 67 65 72 0a 4a 20 6d 69 6d 65 74 79 70 65  igger.J mimetype
01a0: 20 74 65 78 74 2f 78 2d 66 6f 73 73 69 6c 2d 77   text/x-fossil-w
01b0: 69 6b 69 0a 4a 20 73 65 76 65 72 69 74 79 20 43  iki.J severity C
01c0: 72 69 74 69 63 61 6c 0a 4a 20 73 74 61 74 75 73  ritical.J status
01d0: 20 4f 70 65 6e 0a 4a 20 74 69 74 6c 65 20 55 6e   Open.J title Un
01e0: 65 78 70 65 63 74 65 64 5c 73 65 72 72 6f 72 5c  expected\serror\
01f0: 73 69 6e 5c 73 44 45 4c 45 54 45 5c 73 77 69 74  sin\sDELETE\swit
0200: 68 5c 73 65 78 69 73 74 69 6e 67 5c 73 74 72 69  h\sexisting\stri
0210: 67 67 65 72 0a 4a 20 74 79 70 65 20 43 6f 64 65  gger.J type Code
0220: 5f 44 65 66 65 63 74 0a 4b 20 31 37 64 62 35 34  _Defect.K 17db54
0230: 64 37 34 34 30 32 38 31 66 32 63 32 34 38 34 38  d7440281f2c24848
0240: 66 34 35 37 31 66 38 33 61 62 39 66 63 61 31 31  f4571f83ab9fca11
0250: 39 37 0a 55 20 6d 72 69 67 67 65 72 0a 5a 20 35  97.U mrigger.Z 5
0260: 36 66 39 39 65 64 35 66 62 38 64 62 39 35 66 66  6f99ed5fb8db95ff
0270: 63 66 34 34 35 34 61 66 66 35 38 33 64 36 65 0a  cf4454aff583d6e.