Function test_temporary_views

src/environmentd/tests/sql.rs:1234–1260

()

#[mz_ore::test]
#[allow(clippy::disallowed_methods)]
fn test_temporary_views() {
    let server = test_util::TestHarness::default().start_blocking();
    let mut client_a = server.connect(postgres::NoTls).unwrap();
    let mut client_b = server.connect(postgres::NoTls).unwrap();
    client_a
        .batch_execute("CREATE VIEW v AS VALUES (1, 'foo'), (2, 'bar'), (3, 'foo'), (1, 'bar')")
        .unwrap();
    client_a
        .batch_execute("CREATE TEMPORARY VIEW temp_v AS SELECT * FROM v")
        .unwrap();

    let query_v = "SELECT count(*) FROM v;";
    let query_temp_v = "SELECT count(*) FROM temp_v;";

    // Ensure that client_a can query v and temp_v.
    let count: i64 = client_b.query_one(query_v, &[]).unwrap().get("count");
    assert_eq!(4, count);
    let count: i64 = client_a.query_one(query_temp_v, &[]).unwrap().get("count");
    assert_eq!(4, count);

    // Ensure that client_b can query v, but not temp_v.
    let count: i64 = client_b.query_one(query_v, &[]).unwrap().get("count");
    assert_eq!(4, count);

    let err = client_b.query_one(query_temp_v, &[]).unwrap_db_error();
    assert_eq!(err.message(), "unknown catalog item \'temp_v\'");
}

// Test EXPLAIN TIMESTAMP with tables.
#[mz_ore::test]