Search for similar Uuid with default ToSql?

[OscarCreator]

I have a sqlite database

CREATE TABLE IF NOT EXISTS tasks (
  id TEXT PRIMARY KEY NOT NULL,
  name TEXT NOT NULL,
)

Where the id is a Uuid

struct Task {
  id: Uuid,
  name: String,
}

Is it possible to search for similar tasks with the default ToSql for Uuid?

conn.execute("
  SELECT * FROM tasks
  WHERE id LIKE ?1
  ", 
  params!["bee5d"]
)

I got it working if I saved the Uuid as a string task.id.to_string(), but I would like to use the default ToSql implementation for Uuid so I don't need to add extra parsing when reading from the database.

If I use the default ToSql for Uuid it can look like '(`pl>U' in the database.

[gwenn]

Is it possible to search for similar tasks with the default ToSql for Uuid ?

I don't think so:

rusqlite/src/types/value.rs

Line 59 in 30a2110

Value::Blob(id.as_bytes().to_vec())

But you should be able to use the task.id.as_bytes()[..6] as parameter (not tested).