| Ticket Hash: | 72adc99de9f6a443943557043ad8d47da1f76063 | |||
| Title: | shell mode insert doesn't output blobs as blobs | |||
| Status: | Fixed | Type: | Code_Defect | |
| Severity: | Minor | Priority: | Low | |
| Subsystem: | Shell | Resolution: | Fixed | |
| Last Modified: | 2009-10-22 21:27:19 | |||
| Version Found In: | 3.6.18 | |||
| Description: | ||||
In mode insert the shell should show blobs using the X'' notation (.dump does this correctly). Instead it just spews out the raw bytes.
<pre>
sqlite> .mode insert
sqlite> select X'4445464748';
INSERT INTO table VALUES('DEFGH');
</pre>
<hr><i>shane added on 2009-10-22 17:30:20:</i><br>
Check-in [a2ad9e6363].
<hr><i>shane added on 2009-10-22 18:15:07:</i><br>
Also check-in [ab99faca6c].
<hr><i>shane added on 2009-10-22 21:27:19:</i><br>
Also check-in [790402c150].
| ||||