tegdb 0.5.0

The name TegridyDB (short for TegDB) is inspired by the Tegridy Farm in South Park and tries to correct some of the wrong database implementations, such as null support, implicit conversion support, etc.
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
37
38
39
40
41
42
43
44
45
46

// Regression tests to exercise INSERT parsing with vector literals and strings
use tegdb::parser::parse_sql;

#[test]
fn regression_insert_vector_literal_should_parse() {
    let sql = "INSERT INTO chat_history (id, message, is_user, embedding) VALUES (1, 'hi', 1, [0.1, 0.2, 0.3])";
    let res = parse_sql(sql);
    assert!(
        res.is_ok(),
        "Failed to parse simple vector INSERT: {:?}",
        res.err()
    );
}

#[test]
fn regression_insert_single_line_string_should_parse() {
    let sql = "INSERT INTO chat_history (id, message, is_user, embedding) VALUES (1, 'hello world', 1, [0.1])";
    let res = parse_sql(sql);
    assert!(
        res.is_ok(),
        "Failed to parse single-line INSERT: {:?}",
        res.err()
    );
}

#[test]
fn regression_insert_long_string_should_parse() {
    let long_msg = "a".repeat(200);
    let sql = format!(
        "INSERT INTO chat_history (id, message, is_user, embedding) VALUES (1, '{long_msg}', 1, [0.1, 0.2])"
    );
    let res = parse_sql(&sql);
    assert!(res.is_ok(), "Failed to parse long INSERT: {:?}", res.err());
}

#[test]
fn regression_insert_beginning_at_col1_should_parse() {
    let sql = "INSERT INTO t (id) VALUES (1)";
    assert_eq!(sql.as_bytes()[0] as char, 'I');
    let res = parse_sql(sql);
    assert!(
        res.is_ok(),
        "Failed to parse INSERT at column 1: {:?}",
        res.err()
    );
}