[sqlite] shell edit() trips on Windows newline kink

2018-08-10 Thread Larry Brasfield
Upon thinking further about this bug, I realize that "correct" behavior is not obvious and might warrant some discussion. At first, I questioned whether it is appropriate to handle data differently depending upon whether it is typed as BLOB or text. Maybe the edit() function needed a flag for

[sqlite] shell edit() trips on Windows newline kink

2018-08-05 Thread Larry Brasfield
I was experimenting today with a v3.25.0 variant and encountered this bug, on my Windows 10 system, when I used the SQLite CLI shell's edit() function. Because I had put a newline in the text with the invoked editor, and it was written and read back as a text file, the following code got unhappy: