SQLite
Hex Artifact Content
Not logged in

Artifact 1a2239c22b250eb18478453909139428f57de1214441c1136f526b0e34710be5:

Wiki page [Bug Reports] by drh 2017-07-01 23:08:17.
0000: 44 20 32 30 31 37 2d 30 37 2d 30 31 54 32 33 3a  D 2017-07-01T23:
0010: 30 38 3a 31 37 2e 37 35 38 0a 4c 20 42 75 67 5c  08:17.758.L Bug\
0020: 73 52 65 70 6f 72 74 73 0a 50 20 63 63 39 30 39  sReports.P cc909
0030: 33 30 38 31 30 63 65 37 38 62 62 39 39 66 63 64  30810ce78bb99fcd
0040: 62 64 39 35 62 37 61 31 39 34 33 65 37 37 36 32  bd95b7a1943e7762
0050: 31 37 65 0a 55 20 64 72 68 0a 57 20 32 32 31 32  17e.U drh.W 2212
0060: 0a 3c 68 32 3e 48 6f 77 20 54 6f 20 52 65 70 6f  .<h2>How To Repo
0070: 72 74 20 42 75 67 73 20 41 67 61 69 6e 73 74 20  rt Bugs Against 
0080: 53 51 4c 69 74 65 3c 2f 68 32 3e 0d 0a 0d 0a 57  SQLite</h2>....W
0090: 65 20 75 73 65 64 20 74 6f 20 61 6c 6c 6f 77 20  e used to allow 
00a0: 61 6e 6f 6e 79 6d 6f 75 73 20 75 73 65 72 73 20  anonymous users 
00b0: 74 6f 20 65 6e 74 65 72 20 6e 65 77 20 62 75 67  to enter new bug
00c0: 20 72 65 70 6f 72 74 73 0d 0a 64 69 72 65 63 74   reports..direct
00d0: 6c 79 20 69 6e 74 6f 20 6f 75 72 20 62 75 67 20  ly into our bug 
00e0: 74 72 61 63 6b 69 6e 67 20 73 79 73 74 65 6d 2e  tracking system.
00f0: 20 20 48 6f 77 65 76 65 72 2c 20 6f 75 72 20 65    However, our e
0100: 78 70 65 72 69 65 6e 63 65 0d 0a 77 69 74 68 20  xperience..with 
0110: 74 68 69 73 20 70 72 6f 63 65 64 75 72 65 20 77  this procedure w
0120: 61 73 20 75 6e 73 61 74 69 73 66 61 63 74 6f 72  as unsatisfactor
0130: 79 2e 20 20 4d 6f 73 74 20 6f 66 20 74 68 65 20  y.  Most of the 
0140: 62 75 67 20 72 65 70 6f 72 74 73 0d 0a 77 65 20  bug reports..we 
0150: 72 65 63 65 69 76 65 64 20 77 65 72 65 20 6f 66  received were of
0160: 20 6c 6f 77 20 71 75 61 6c 69 74 79 2e 20 20 4d   low quality.  M
0170: 61 6e 79 20 70 72 6f 62 6c 65 6d 73 20 74 75 72  any problems tur
0180: 6e 65 64 20 6f 75 74 20 74 6f 20 62 65 20 0d 0a  ned out to be ..
0190: 70 72 6f 62 6c 65 6d 73 20 69 6e 20 74 68 65 20  problems in the 
01a0: 61 70 70 6c 69 63 61 74 69 6f 6e 20 6f 72 20 69  application or i
01b0: 6e 20 74 68 65 20 70 72 6f 67 72 61 6d 6d 65 72  n the programmer
01c0: 27 73 20 6d 65 6e 74 61 6c 20 6d 6f 64 65 6c 0d  's mental model.
01d0: 0a 6f 66 20 68 6f 77 20 53 51 4c 69 74 65 20 77  .of how SQLite w
01e0: 6f 72 6b 73 2e 0d 0a 4f 74 68 65 72 20 22 62 75  orks...Other "bu
01f0: 67 20 72 65 70 6f 72 74 73 22 20 77 65 72 65 20  g reports" were 
0200: 74 68 69 6e 6c 79 20 76 65 69 6c 65 64 20 73 75  thinly veiled su
0210: 70 70 6f 72 74 20 72 65 71 75 65 73 74 73 2e 0d  pport requests..
0220: 0a 53 74 69 6c 6c 20 6f 74 68 65 72 20 72 65 70  .Still other rep
0230: 6f 72 74 73 20 61 72 65 20 73 6f 20 70 6f 6f 72  orts are so poor
0240: 6c 79 20 77 72 69 74 74 65 6e 20 74 68 61 74 20  ly written that 
0250: 77 65 20 63 6f 75 6c 64 20 6e 6f 74 20 66 69 67  we could not fig
0260: 75 72 65 0d 0a 6f 75 74 20 77 68 61 74 20 74 68  ure..out what th
0270: 65 20 70 72 6f 62 6c 65 6d 20 69 73 2e 20 20 54  e problem is.  T
0280: 68 65 72 65 20 77 65 72 65 20 61 6c 73 6f 20 6e  here were also n
0290: 75 6d 65 72 6f 75 73 20 64 75 70 6c 69 63 61 74  umerous duplicat
02a0: 65 73 2e 0d 0a 0d 0a 49 64 65 61 6c 6c 79 2c 20  es.....Ideally, 
02b0: 6f 75 72 20 62 75 67 20 64 61 74 61 62 61 73 65  our bug database
02c0: 20 73 68 6f 75 6c 64 20 62 65 20 75 73 61 62 6c   should be usabl
02d0: 65 20 61 73 20 61 6e 20 68 69 73 74 6f 72 69 63  e as an historic
02e0: 61 6c 20 72 65 66 65 72 65 6e 63 65 0d 0a 74 6f  al reference..to
02f0: 20 74 72 61 63 6b 20 72 65 61 6c 20 70 72 6f 62   track real prob
0300: 6c 65 6d 73 20 77 69 74 68 20 53 51 4c 69 74 65  lems with SQLite
0310: 20 61 6e 64 20 74 6f 20 66 61 63 69 6c 69 74 61   and to facilita
0320: 74 65 20 73 74 75 64 69 65 73 20 6f 66 0d 0a 62  te studies of..b
0330: 75 67 20 64 65 6e 73 69 74 79 20 61 6e 64 20 73  ug density and s
0340: 6f 66 74 77 61 72 65 20 71 75 61 6c 69 74 79 2e  oftware quality.
0350: 20 20 42 75 74 20 74 68 65 20 68 69 67 68 20 76    But the high v
0360: 6f 6c 75 6d 65 20 6f 66 20 22 6e 6f 69 73 65 22  olume of "noise"
0370: 0d 0a 72 65 70 6f 72 74 73 20 69 6e 68 69 62 69  ..reports inhibi
0380: 74 73 20 74 68 61 74 20 67 6f 61 6c 2e 0d 0a 0d  ts that goal....
0390: 0a 49 6e 20 65 66 66 6f 72 74 20 74 6f 20 72 65  .In effort to re
03a0: 64 75 63 65 20 74 68 65 20 6c 65 76 65 6c 20 6f  duce the level o
03b0: 66 20 62 61 63 6b 67 72 6f 75 6e 64 20 6e 6f 69  f background noi
03c0: 73 65 2c 20 77 65 20 61 72 65 20 6e 6f 77 20 61  se, we are now a
03d0: 73 6b 69 6e 67 0d 0a 61 6e 6f 6e 79 6d 6f 75 73  sking..anonymous
03e0: 20 75 73 65 72 73 20 74 6f 20 72 65 70 6f 72 74   users to report
03f0: 20 62 75 67 73 20 74 6f 20 74 68 65 20 53 51 4c   bugs to the SQL
0400: 69 74 65 20 6d 61 69 6c 69 6e 67 20 6c 69 73 74  ite mailing list
0410: 2e 20 20 4d 61 6b 65 20 73 75 72 65 20 79 6f 75  .  Make sure you
0420: 20 63 68 65 63 6b 20 74 68 65 20 5b 68 74 74 70   check the [http
0430: 3a 2f 2f 77 77 77 2e 73 71 6c 69 74 65 2e 6f 72  ://www.sqlite.or
0440: 67 2f 73 72 63 2f 72 65 70 6f 72 74 6c 69 73 74  g/src/reportlist
0450: 20 7c 20 65 78 69 73 74 69 6e 67 20 62 75 67 20   | existing bug 
0460: 6c 69 73 74 5d 20 66 69 72 73 74 2e 20 54 6f 20  list] first. To 
0470: 72 65 70 6f 72 74 0d 0a 61 20 62 75 67 2c 20 70  report..a bug, p
0480: 6c 65 61 73 65 20 73 65 6e 64 20 65 6d 61 69 6c  lease send email
0490: 20 74 6f 20 0d 0a 5b 6d 61 69 6c 74 6f 3a 73 71   to ..[mailto:sq
04a0: 6c 69 74 65 2d 75 73 65 72 73 40 6d 61 69 6c 69  lite-users@maili
04b0: 6e 67 6c 69 73 74 73 2e 73 71 6c 69 74 65 2e 6f  nglists.sqlite.o
04c0: 72 67 20 7c 20 73 71 6c 69 74 65 2d 75 73 65 72  rg | sqlite-user
04d0: 73 40 6d 61 69 6c 69 6e 67 6c 69 73 74 73 2e 73  s@mailinglists.s
04e0: 71 6c 69 74 65 2e 6f 72 67 5d 2e 0d 0a 45 6d 61  qlite.org]...Ema
04f0: 69 6c 20 74 6f 20 74 68 69 73 20 6c 69 73 74 20  il to this list 
0500: 66 72 6f 6d 20 6e 6f 6e 2d 6d 65 6d 62 65 72 73  from non-members
0510: 20 77 69 6c 6c 20 62 65 20 68 65 6c 64 20 66 6f   will be held fo
0520: 72 20 72 65 76 69 65 77 20 61 6e 64 20 6d 61 79  r review and may
0530: 20 74 61 6b 65 0d 0a 61 20 64 61 79 20 6f 72 20   take..a day or 
0540: 6d 6f 72 65 20 74 6f 20 61 70 70 65 61 72 20 6f  more to appear o
0550: 6e 20 74 68 65 20 6c 69 73 74 2e 20 20 54 6f 20  n the list.  To 
0560: 65 78 70 65 64 69 74 65 20 79 6f 75 72 20 6d 65  expedite your me
0570: 73 73 61 67 65 2c 0d 0a 73 69 67 6e 20 75 70 20  ssage,..sign up 
0580: 66 6f 72 20 74 68 65 20 6d 61 69 6c 69 6e 67 20  for the mailing 
0590: 6c 69 73 74 20 61 74 0d 0a 5b 68 74 74 70 3a 2f  list at..[http:/
05a0: 2f 6d 61 69 6c 69 6e 67 6c 69 73 74 73 2e 73 71  /mailinglists.sq
05b0: 6c 69 74 65 2e 6f 72 67 2f 63 67 69 2d 62 69 6e  lite.org/cgi-bin
05c0: 2f 6d 61 69 6c 6d 61 6e 2f 6c 69 73 74 69 6e 66  /mailman/listinf
05d0: 6f 2f 73 71 6c 69 74 65 2d 75 73 65 72 73 5d 2e  o/sqlite-users].
05e0: 0d 0a 4e 6f 6e 2d 6d 65 6d 62 65 72 73 20 63 61  ..Non-members ca
05f0: 6e 20 66 6f 6c 6c 6f 77 20 74 68 65 20 6d 61 69  n follow the mai
0600: 6c 69 6e 67 20 6c 69 73 74 20 61 74 0d 0a 5b 68  ling list at..[h
0610: 74 74 70 3a 2f 2f 77 77 77 2e 6d 61 69 6c 2d 61  ttp://www.mail-a
0620: 72 63 68 69 76 65 2e 63 6f 6d 2f 73 71 6c 69 74  rchive.com/sqlit
0630: 65 2d 75 73 65 72 73 25 34 30 6d 61 69 6c 69 6e  e-users%40mailin
0640: 67 6c 69 73 74 73 2e 73 71 6c 69 74 65 2e 6f 72  glists.sqlite.or
0650: 67 2f 5d 2e 0d 0a 0d 0a 49 6e 20 6f 72 64 65 72  g/].....In order
0660: 20 66 6f 72 20 79 6f 75 72 20 62 75 67 20 72 65   for your bug re
0670: 70 6f 72 74 20 6f 72 20 72 65 71 75 65 73 74 20  port or request 
0680: 66 6f 72 20 68 65 6c 70 20 74 6f 20 62 65 20 63  for help to be c
0690: 6c 65 61 72 6c 79 20 75 6e 64 65 72 73 74 6f 6f  learly understoo
06a0: 64 20 62 79 20 74 68 65 20 70 65 6f 70 6c 65 20  d by the people 
06b0: 74 68 61 74 20 63 61 6e 20 68 65 6c 70 20 74 68  that can help th
06c0: 65 20 6d 6f 73 74 2c 20 70 6c 65 61 73 65 20 66  e most, please f
06d0: 6f 6c 6c 6f 77 20 74 68 65 73 65 20 67 75 69 64  ollow these guid
06e0: 65 6c 69 6e 65 73 3a 0d 0a 0d 0a 3c 75 6c 3e 0d  elines:....<ul>.
06f0: 0a 3c 6c 69 3e 3c 61 20 68 72 65 66 3d 22 68 74  .<li><a href="ht
0700: 74 70 3a 2f 2f 77 77 77 2e 63 68 69 61 72 6b 2e  tp://www.chiark.
0710: 67 72 65 65 6e 65 6e 64 2e 6f 72 67 2e 75 6b 2f  greenend.org.uk/
0720: 7e 73 67 74 61 74 68 61 6d 2f 62 75 67 73 2e 68  ~sgtatham/bugs.h
0730: 74 6d 6c 22 3e 48 6f 77 20 74 6f 20 72 65 70 6f  tml">How to repo
0740: 72 74 20 62 75 67 73 20 65 66 66 65 63 74 69 76  rt bugs effectiv
0750: 65 6c 79 3c 2f 61 3e 0d 0a 3c 6c 69 3e 3c 61 20  ely</a>..<li><a 
0760: 68 72 65 66 3d 22 68 74 74 70 3a 2f 2f 63 61 74  href="http://cat
0770: 62 2e 6f 72 67 2f 7e 65 73 72 2f 66 61 71 73 2f  b.org/~esr/faqs/
0780: 73 6d 61 72 74 2d 71 75 65 73 74 69 6f 6e 73 2e  smart-questions.
0790: 68 74 6d 6c 22 3e 48 6f 77 20 74 6f 20 61 73 6b  html">How to ask
07a0: 20 73 6d 61 72 74 20 71 75 65 73 74 69 6f 6e 73   smart questions
07b0: 3c 2f 61 3e 0d 0a 3c 2f 75 6c 3e 0d 0a 0d 0a 54  </a>..</ul>....T
07c0: 68 65 20 69 64 65 61 20 69 73 20 74 68 61 74 20  he idea is that 
07d0: 62 75 67 20 72 65 70 6f 72 74 73 20 63 61 6e 20  bug reports can 
07e0: 62 65 20 66 69 6c 74 65 72 65 64 20 6f 6e 20 74  be filtered on t
07f0: 68 65 20 6d 61 69 6c 69 6e 67 20 6c 69 73 74 20  he mailing list 
0800: 61 6e 64 0d 0a 74 68 6f 73 65 20 74 68 61 74 20  and..those that 
0810: 61 72 65 20 61 63 74 75 61 6c 20 6e 65 77 20 62  are actual new b
0820: 75 67 73 20 63 61 6e 20 62 65 20 74 72 61 6e 73  ugs can be trans
0830: 66 65 72 72 65 64 20 69 6e 74 6f 20 6f 75 72 20  ferred into our 
0840: 62 75 67 20 74 72 61 63 6b 69 6e 67 0d 0a 73 79  bug tracking..sy
0850: 73 74 65 6d 20 62 79 20 72 65 67 69 73 74 65 72  stem by register
0860: 65 64 20 64 65 76 65 6c 6f 70 65 72 73 2e 20 20  ed developers.  
0870: 41 6e 6f 6e 79 6d 6f 75 73 20 75 73 65 72 73 20  Anonymous users 
0880: 63 61 6e 20 63 6f 6e 74 69 6e 75 65 20 74 6f 0d  can continue to.
0890: 0a 61 70 70 65 6e 64 20 63 6f 6d 6d 65 6e 74 73  .append comments
08a0: 20 74 6f 20 65 78 69 73 74 69 6e 67 20 62 75 67   to existing bug
08b0: 73 2c 20 6a 75 73 74 20 6e 6f 74 20 63 72 65 61  s, just not crea
08c0: 74 65 20 6e 65 77 20 62 75 67 73 2e 0d 0a 0d 0a  te new bugs.....
08d0: 54 68 61 6e 6b 20 79 6f 75 20 66 6f 72 20 79 6f  Thank you for yo
08e0: 75 72 20 75 6e 64 65 72 73 74 61 6e 64 69 6e 67  ur understanding
08f0: 20 61 6e 64 20 63 6f 6f 70 65 72 61 74 69 6f 6e   and cooperation
0900: 2e 0d 0a 0d 0a 0a 5a 20 30 34 65 31 39 39 39 64  ......Z 04e1999d
0910: 63 33 36 38 34 38 65 36 39 32 37 35 64 65 36 63  c36848e69275de6c
0920: 66 37 30 39 32 32 38 66 0a                       f709228f.