| Ticket UUID: | 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 | ||
| Detected By: | Application_Fault | ||
| Version Found In: | 3.6.18 | ||
| Description & Comments: | |||
In mode insert the shell should show blobs using the X'' notation (.dump does this correctly). Instead it just spews out the raw bytes.
sqlite> .mode insert
sqlite> select X'4445464748';
INSERT INTO table VALUES('DEFGH');
shane added on 2009-10-22 17:30:20: shane added on 2009-10-22 18:15:07: shane added on 2009-10-22 21:27:19: | |||