Function test_select_distinct_order_by

datafusion/sql/tests/sql_integration.rs:4494–4506

()

#[test]
fn test_select_distinct_order_by() {
    let sql = "SELECT distinct '1' from person order by id";

    // It should return error.
    let result = logical_plan(sql);
    assert!(result.is_err());
    let err = result.err().unwrap().strip_backtrace();

    assert_snapshot!(
        err,
        @"Error during planning: For SELECT DISTINCT, ORDER BY expressions person.id must appear in select list"
    );
}

#[test]
fn test_select_qualify_basic() {