spg-engine 7.37.23

Execution engine for SPG: glues spg-sql parsing to spg-storage. Foreign keys, joins, vectors, cold tier.
Documentation 
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36

//! v7.17.0 Phase 3.P0-58 — `SHOW DATABASES` / `SHOW SCHEMAS`.

use spg_engine::{Engine, QueryResult};
use spg_storage::Value;

fn rows(r: QueryResult) -> Vec<Vec<Value<'static>>> {
    match r {
        QueryResult::Rows { rows, .. } => rows.into_iter().map(|r| r.values).collect(),
        _ => panic!("expected rows"),
    }
}

#[test]
fn show_databases_returns_canonical_mysql_set() {
    let mut e = Engine::new();
    let r = rows(e.execute("SHOW DATABASES").unwrap());
    let names: Vec<String> = r
        .into_iter()
        .map(|row| match row[0].clone() {
            Value::Text(s) => s.into_owned(),
            _ => panic!(),
        })
        .collect();
    assert!(names.contains(&"information_schema".to_string()));
    assert!(names.contains(&"mysql".to_string()));
    assert!(names.contains(&"performance_schema".to_string()));
    assert!(names.contains(&"sys".to_string()));
    assert!(names.contains(&"postgres".to_string()));
}

#[test]
fn show_schemas_is_alias() {
    let mut e = Engine::new();
    let r = rows(e.execute("SHOW SCHEMAS").unwrap());
    assert_eq!(r.len(), 5);
}