infer_schema! fails when using two features together

[jackalcooper]

Setup

[patch.crates-io]
diesel = { git = "https://github.com/diesel-rs/diesel", features = ["sqlite", "mysql"] }
diesel_codegen = { git = "https://github.com/diesel-rs/diesel", features = ["sqlite", "mysql"] }

Versions

• Rust:
  rustc 1.24.0-nightly (560a5da9f 2017-11-27)
• Diesel:
  master
• Database:
  sqlite3 and mysql5.5
• Operating System
  macOS

Feature Flags

• diesel:
  ["sqlite", "mysql"]
• diesel_codegen:
  ["sqlite", "mysql"]

Problem Description

Failed to compile when using features "sqlite" and "mysql" together.

What are you trying to accomplish?

transfer data from mysql to sqlite

What is the expected output?

succeed compiling

What is the actual output?

failed to do so

MacBook-of-Jackal:license-bureau jackalcooper$ cargo run --bin create_partner --verbose
    Updating registry `https://github.com/rust-lang/crates.io-index`
       *********
   Compiling diesel_infer_schema v0.16.0
       Fresh native-tls v0.1.4
     Running `rustc --crate-name diesel_infer_schema /Users/jackalcooper/.cargo/registry/src/github.com-1ecc6299db9ec823/diesel_infer_schema-0.16.0/src/lib.rs --crate-type lib --emit=dep-info,link -C debuginfo=2 --cfg 'feature="diesel"' --cfg 'feature="mysql"' --cfg 'feature="sqlite"' --cfg 'feature="uses_information_schema"' -C metadata=256f7be3b5b79b6e -C extra-filename=-256f7be3b5b79b6e --out-dir /Users/jackalcooper/rust/license-bureau/target/debug/deps -L dependency=/Users/jackalcooper/rust/license-bureau/target/debug/deps --extern diesel=/Users/jackalcooper/rust/license-bureau/target/debug/deps/libdiesel-a4652098ef005d57.rlib --cap-lints allow -Lnative=/usr/local/Cellar/mysql/5.7.19/lib`
       Fresh lettre v0.7.0
       Fresh ring v0.11.0
       Fresh cookie v0.9.2
       Fresh rocket v0.3.3
       Fresh rocket_codegen v0.3.3
error[E0599]: no method named `load` found for type `diesel::query_builder::SelectStatement<information_schema::information_schema::key_column_usage::table, diesel::query_builder::select_clause::SelectClause<information_schema::information_schema::key_column_usage::columns::column_name>, diesel::query_builder::distinct_clause::NoDistinctClause, diesel::query_builder::where_clause::WhereClause<diesel::expression::operators::And<diesel::expression::operators::And<diesel::expression::array_comparison::In<information_schema::information_schema::key_column_usage::columns::constraint_name, diesel::expression::array_comparison::Subselect<diesel::query_builder::SelectStatement<information_schema::information_schema::table_constraints::table, diesel::query_builder::select_clause::SelectClause<information_schema::information_schema::table_constraints::columns::constraint_name>, diesel::query_builder::distinct_clause::NoDistinctClause, diesel::query_builder::where_clause::WhereClause<diesel::expression::operators::Eq<information_schema::information_schema::table_constraints::columns::constraint_type, diesel::expression::bound::Bound<diesel::types::Text, &str>>>>, diesel::types::Text>>, diesel::expression::operators::Eq<information_schema::information_schema::key_column_usage::columns::table_name, diesel::expression::bound::Bound<diesel::types::Text, &std::string::String>>>,diesel::expression::operators::Eq<information_schema::information_schema::key_column_usage::columns::table_schema, diesel::expression::bound::Bound<diesel::types::Text, std::string::String>>>>, diesel::query_builder::order_clause::OrderClause<information_schema::information_schema::key_column_usage::columns::ordinal_position>>`in the current scope
   --> /Users/jackalcooper/.cargo/registry/src/github.com-1ecc6299db9ec823/diesel_infer_schema-0.16.0/src/information_schema.rs:156:10
    |
156 |         .load(conn)
    |          ^^^^
    |
    = note: the method `load` exists but the following trait bounds were not satisfied:
            `diesel::query_builder::SelectStatement<information_schema::information_schema::key_column_usage::table, diesel::query_builder::select_clause::SelectClause<information_schema::information_schema::key_column_usage::columns::column_name>, diesel::query_builder::distinct_clause::NoDistinctClause, diesel::query_builder::where_clause::WhereClause<diesel::expression::operators::And<diesel::expression::operators::And<diesel::expression::array_comparison::In<information_schema::information_schema::key_column_usage::columns::constraint_name, diesel::expression::array_comparison::Subselect<diesel::query_builder::SelectStatement<information_schema::information_schema::table_constraints::table, diesel::query_builder::select_clause::SelectClause<information_schema::information_schema::table_constraints::columns::constraint_name>, diesel::query_builder::distinct_clause::NoDistinctClause, diesel::query_builder::where_clause::WhereClause<diesel::expression::operators::Eq<information_schema::information_schema::table_constraints::columns::constraint_type, diesel::expression::bound::Bound<diesel::types::Text, &str>>>>, diesel::types::Text>>, diesel::expression::operators::Eq<information_schema::information_schema::key_column_usage::columns::table_name, diesel::expression::bound::Bound<diesel::types::Text, &std::string::String>>>, diesel::expression::operators::Eq<information_schema::information_schema::key_column_usage::columns::table_schema, diesel::expression::bound::Bound<diesel::types::Text, std::string::String>>>>, diesel::query_builder::order_clause::OrderClause<information_schema::information_schema::key_column_usage::columns::ordinal_position>> : diesel::LoadDsl<_>`
            `&diesel::query_builder::SelectStatement<information_schema::information_schema::key_column_usage::table, diesel::query_builder::select_clause::SelectClause<information_schema::information_schema::key_column_usage::columns::column_name>, diesel::query_builder::distinct_clause::NoDistinctClause, diesel::query_builder::where_clause::WhereClause<diesel::expression::operators::And<diesel::expression::operators::And<diesel::expression::array_comparison::In<information_schema::information_schema::key_column_usage::columns::constraint_name, diesel::expression::array_comparison::Subselect<diesel::query_builder::SelectStatement<information_schema::information_schema::table_constraints::table, diesel::query_builder::select_clause::SelectClause<information_schema::information_schema::table_constraints::columns::constraint_name>, diesel::query_builder::distinct_clause::NoDistinctClause, diesel::query_builder::where_clause::WhereClause<diesel::expression::operators::Eq<information_schema::information_schema::table_constraints::columns::constraint_type, diesel::expression::bound::Bound<diesel::types::Text,&str>>>>, diesel::types::Text>>, diesel::expression::operators::Eq<information_schema::information_schema::key_column_usage::columns::table_name, diesel::expression::bound::Bound<diesel::types::Text, &std::string::String>>>, diesel::expression::operators::Eq<information_schema::information_schema::key_column_usage::columns::table_schema, diesel::expression::bound::Bound<diesel::types::Text, std::string::String>>>>, diesel::query_builder::order_clause::OrderClause<information_schema::information_schema::key_column_usage::columns::ordinal_position>> : diesel::LoadDsl<_>`
            `&mut diesel::query_builder::SelectStatement<information_schema::information_schema::key_column_usage::table, diesel::query_builder::select_clause::SelectClause<information_schema::information_schema::key_column_usage::columns::column_name>, diesel::query_builder::distinct_clause::NoDistinctClause, diesel::query_builder::where_clause::WhereClause<diesel::expression::operators::And<diesel::expression::operators::And<diesel::expression::array_comparison::In<information_schema::information_schema::key_column_usage::columns::constraint_name, diesel::expression::array_comparison::Subselect<diesel::query_builder::SelectStatement<information_schema::information_schema::table_constraints::table, diesel::query_builder::select_clause::SelectClause<information_schema::information_schema::table_constraints::columns::constraint_name>, diesel::query_builder::distinct_clause::NoDistinctClause, diesel::query_builder::where_clause::WhereClause<diesel::expression::operators::Eq<information_schema::information_schema::table_constraints::columns::constraint_type, diesel::expression::bound::Bound<diesel::types::Text, &str>>>>, diesel::types::Text>>, diesel::expression::operators::Eq<information_schema::information_schema::key_column_usage::columns::table_name, diesel::expression::bound::Bound<diesel::types::Text, &std::string::String>>>, diesel::expression::operators::Eq<information_schema::information_schema::key_column_usage::columns::table_schema, diesel::expression::bound::Bound<diesel::types::Text, std::string::String>>>>, diesel::query_builder::order_clause::OrderClause<information_schema::information_schema::key_column_usage::columns::ordinal_position>> : diesel::LoadDsl<_>`

error: aborting due to previous error

error: Could not compile `diesel_infer_schema`.

Caused by:
  process didn't exit successfully: `rustc --crate-name diesel_infer_schema /Users/jackalcooper/.cargo/registry/src/github.com-1ecc6299db9ec823/diesel_infer_schema-0.16.0/src/lib.rs --crate-type lib --emit=dep-info,link -C debuginfo=2 --cfg feature="diesel" --cfgfeature="mysql" --cfg feature="sqlite" --cfg feature="uses_information_schema" -C metadata=256f7be3b5b79b6e -C extra-filename=-256f7be3b5b79b6e --out-dir /Users/jackalcooper/rust/license-bureau/target/debug/deps -L dependency=/Users/jackalcooper/rust/license-bureau/target/debug/deps --extern diesel=/Users/jackalcooper/rust/license-bureau/target/debug/deps/libdiesel-a4652098ef005d57.rlib --cap-lints allow -L native=/usr/local/Cellar/mysql/5.7.19/lib` (exit code: 101)

[sgrif]

I'm unable to reproduce with the latest release. Please open a new issue if you continue to have problems on 0.99.0