Function test_information_schema_tables

tests/information_schema_test.rs:47–73

()

#[tokio::test]
async fn test_information_schema_tables() {
    let _ = env_logger::builder().is_test(true).try_init();

    let server = common::setup_test_server_with_init(|db| {
        Box::pin(async move {
            // Create a test table and view
            db.execute("CREATE TABLE test_table (id INTEGER, name TEXT)").await?;
            db.execute("CREATE VIEW test_view AS SELECT id FROM test_table").await?;
            Ok(())
        })
    }).await;
    let client = &server.client;

    // Test SELECT table_name, table_type FROM information_schema.tables
    let rows = client.query("SELECT table_name, table_type FROM information_schema.tables", &[]).await.unwrap();

    // Should return at least our test table and view
    assert!(rows.len() >= 2);

    // Check that our table and view are present with correct types
    let table_info: Vec<(&str, &str)> = rows.iter()
        .map(|row| (row.get::<_, &str>(0), row.get::<_, &str>(1)))
        .collect();

    assert!(table_info.contains(&("test_table", "BASE TABLE")));
    assert!(table_info.contains(&("test_view", "VIEW")));
}

#[tokio::test]
async fn test_information_schema_tables_all_columns() {