Implement Unsigned<Tinyint> for MySql

[RazrFalcon]

Setup

Versions

• Diesel: 1.3.2

Feature Flags

• Diesel: mysql

Problem Description

Looks like diesel::mysql::types::Unsigned is not implemented for u8, aka Tinyint.

What are you trying to accomplish?

Use the TINYINT type.

What is the actual output?

error[E0277]: the trait bound `u8: diesel::Queryable<diesel::sql_types::Unsigned<diesel::sql_types::Tinyint>, diesel::mysql::Mysql>` is not satisfied

Steps to reproduce

Use this SQL to generate the schema

CREATE TABLE test (
    id INT,
    score TINYINT UNSIGNED
)

table! {
    test (id) {
        id -> Integer,
        score -> Nullable<Unsigned<Tinyint>>,
    }
}

and try to query it:

#[derive(Queryable)]
pub struct Test {
    pub id: i32,
    pub score: Option<u8>,
}

Checklist

• I have already looked over the issue tracker for similar issues.
• This issue can be reproduced on Rust's stable channel. (Your issue will be
  closed if this is not the case)

[sgrif]

For the record, SMALLINT is not the same as TINYINT but there does appear to be a legitimate omission here.

[RazrFalcon]

Yes. I've mistaken. Updated the post.