|
From: | Markus Schiltknecht |
Subject: | Re: [Monotone-devel] unhexification of revision hashes |
Date: | Tue, 29 Jan 2008 21:38:16 +0100 |
User-agent: | Mozilla-Thunderbird 2.0.0.9 (X11/20080109) |
Hi, Ludovic Brenta wrote:
Sorry to interrupt but in standard SQL there is WHERE id LIKE 'deadbe%' and I happen to use it occasionally on the command line. I'm worried that that won't be possible anymore after the unhexification.
Agreed. Unfortunately the '%' doesn't work that well for binary values, so yes, you would loose the ability to query directly via LIKE.
The following supposedly still works, provided you use a monotone enhanced sqlite, which provides an unhex() function:
WHERE unhex(id) LIKE 'deadbe%' Regards Markus
[Prev in Thread] | Current Thread | [Next in Thread] |