diesel_compile_tests/tests/compile-fail/aggregate_expression_requires_column_from_same_table.rs

#[macro_use]
extern crate diesel;

use diesel::*;

table! {
    users {
        id -> Integer,
    }
}

table! {
    posts {
        id -> Integer,
    }
}

fn main() {
    use diesel::expression::dsl::*;
    let source = users::table.select(sum(posts::id));
    //~^ ERROR E0277
    //~| ERROR AppearsInFromClause
    //~| ERROR E0277
    //~| ERROR E0277
    //~| ERROR E0277
    //~| ERROR E0277
    let source = users::table.select(avg(posts::id));
    //~^ ERROR E0277
    //~| ERROR AppearsInFromClause
    //~| ERROR E0277
    //~| ERROR E0277
    //~| ERROR E0277
    //~| ERROR E0277
    let source = users::table.select(max(posts::id));
    //~^ ERROR E0277
    //~| ERROR AppearsInFromClause
    //~| ERROR E0277
    //~| ERROR E0277
    //~| ERROR E0277
    //~| ERROR E0277
    let source = users::table.select(min(posts::id));
    //~^ ERROR E0277
    //~| ERROR AppearsInFromClause
    //~| ERROR E0277
    //~| ERROR E0277
    //~| ERROR E0277
    //~| ERROR E0277
}