SQLite

View Ticket
Login
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.
sqlite> .mode insert
sqlite> select X'4445464748';
INSERT INTO table VALUES('DEFGH');

shane added on 2009-10-22 17:30:20:
Check-in [a2ad9e6363].


shane added on 2009-10-22 18:15:07:
Also check-in [ab99faca6c].


shane added on 2009-10-22 21:27:19:
Also check-in [790402c150].