gistfile1.txt

error[E0277]: the trait bound `diesel::BoxableExpression<species::table, diesel::sqlite::Sqlite, SqlType=diesel::sql_types::Bool>: diesel::AppearsOnTable<diesel::query_source::joins::Join<species::table, heros::table, diesel::query_source::joins::Inner>>` is not satisfied
   --> src/main.rs:176:53
    |
176 |     let query = heros::table.into_boxed::<Sqlite>().filter(my_condition);
    |                                                     ^^^^^^ the trait `diesel::AppearsOnTable<diesel::query_source::joins::Join<species::table, heros::table, diesel::query_source::joins::Inner>>` is not implemented for `diesel::BoxableExpression<species::table, diesel::sqlite::Sqlite, SqlType=diesel::sql_types::Bool>`
    |
    = note: required because of the requirements on the impl of `diesel::AppearsOnTable<diesel::query_source::joins::Join<species::table, heros::table, diesel::query_source::joins::Inner>>` for `std::boxed::Box<diesel::BoxableExpression<species::table, diesel::sqlite::Sqlite, SqlType=diesel::sql_types::Bool>>`
    = note: required because of the requirements on the impl of `diesel::query_builder::where_clause::ValidWhereClause<diesel::query_source::joins::Join<species::table, heros::table, diesel::query_source::joins::Inner>>` for `diesel::query_builder::where_clause::WhereClause<std::boxed::Box<diesel::BoxableExpression<species::table, diesel::sqlite::Sqlite, SqlType=diesel::sql_types::Bool>>>`
    = note: required because of the requirements on the impl of `diesel::AppearsOnTable<heros::table>` for `diesel::query_builder::SelectStatement<species::table, diesel::query_builder::select_clause::SelectClause<species::columns::id>, diesel::query_builder::distinct_clause::NoDistinctClause, diesel::query_builder::where_clause::WhereClause<std::boxed::Box<diesel::BoxableExpression<species::table, diesel::sqlite::Sqlite, SqlType=diesel::sql_types::Bool>>>>`
    = note: required because of the requirements on the impl of `diesel::AppearsOnTable<heros::table>` for `diesel::expression::array_comparison::Subselect<diesel::query_builder::SelectStatement<species::table, diesel::query_builder::select_clause::SelectClause<species::columns::id>, diesel::query_builder::distinct_clause::NoDistinctClause, diesel::query_builder::where_clause::WhereClause<std::boxed::Box<diesel::BoxableExpression<species::table, diesel::sqlite::Sqlite, SqlType=diesel::sql_types::Bool>>>>, diesel::sql_types::Integer>`
    = note: required because of the requirements on the impl of `diesel::AppearsOnTable<heros::table>` for `diesel::expression::array_comparison::In<heros::columns::species, diesel::expression::array_comparison::Subselect<diesel::query_builder::SelectStatement<species::table, diesel::query_builder::select_clause::SelectClause<species::columns::id>, diesel::query_builder::distinct_clause::NoDistinctClause, diesel::query_builder::where_clause::WhereClause<std::boxed::Box<diesel::BoxableExpression<species::table, diesel::sqlite::Sqlite, SqlType=diesel::sql_types::Bool>>>>, diesel::sql_types::Integer>>`
    = note: required because of the requirements on the impl of `diesel::AppearsOnTable<heros::table>` for `std::boxed::Box<diesel::expression::array_comparison::In<heros::columns::species, diesel::expression::array_comparison::Subselect<diesel::query_builder::SelectStatement<species::table, diesel::query_builder::select_clause::SelectClause<species::columns::id>, diesel::query_builder::distinct_clause::NoDistinctClause, diesel::query_builder::where_clause::WhereClause<std::boxed::Box<diesel::BoxableExpression<species::table, diesel::sqlite::Sqlite, SqlType=diesel::sql_types::Bool>>>>, diesel::sql_types::Integer>>>`
    = note: required because of the requirements on the impl of `diesel::query_dsl::filter_dsl::FilterDsl<std::boxed::Box<diesel::expression::array_comparison::In<heros::columns::species, diesel::expression::array_comparison::Subselect<diesel::query_builder::SelectStatement<species::table, diesel::query_builder::select_clause::SelectClause<species::columns::id>, diesel::query_builder::distinct_clause::NoDistinctClause, diesel::query_builder::where_clause::WhereClause<std::boxed::Box<diesel::BoxableExpression<species::table, diesel::sqlite::Sqlite, SqlType=diesel::sql_types::Bool>>>>, diesel::sql_types::Integer>>>>` for `diesel::query_builder::BoxedSelectStatement<'_, (diesel::sql_types::Integer, diesel::sql_types::Text, diesel::sql_types::Integer, diesel::sql_types::Nullable<diesel::sql_types::Integer>), heros::table, diesel::sqlite::Sqlite>`