I'm not sure where to report bugs/surprising behavior. The support page on the website doesn't mention a bug tracker.
I use SQLite 3 mostly through the Python interface. I am working on a database where I'm adapting a huge crufty old spreadsheet with incomplete data. I am thus frequently in the sqlite3 shell. I'm an Emacs user, so was pretty comfortable right off-the-bat with what appears to be a GNU readline/history-based interface. I was surprised badly a few minutes ago. I needed to correct some dates (end date before the start date) and was using statements like update swimmeet set start="2008-11-20" where id=1038; Then I retrieved that statement with Ctl-P, then clear the id with Ctl-B ESC-Del. I then entered the id of the next record to correct, backed up and adjusted the date, and hit enter. Imagine my surprise when what I actually typed (without checking, obviously!) was something like this: update swimmeet set end="1991-04-21" where 4193; which updated the end date for every record! Thank goodness for version control and frequent commits... The problem is that the ESC-Del sequence deleted back much more than a word. It seems to me that the "=" should not be considered a word character. For reference, I am using /usr/bin/sqlite3 on a Mac running Yosemite: % sqlite3 --version 3.8.5 2014-08-15 22:37:57 c8ade949d4a2eb3bba4702a4a0e17b405e9b6ace Thanks, Skip Montanaro
