Re: [Monotone-devel] unhexification of revision hashes

[Markus Schiltknecht]

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