uqa-sql 0.5.1

PostgreSQL-compatible SQL compiler built on libpg_query
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

//
// Unified Query Algebra
//
// Copyright (c) 2023-2026 Cognica, Inc.
//

use crate::parse_statements;

#[test]
fn listener_classification_uses_direct_parser_nodes_without_compiling_bodies() {
    let statements = parse_statements(
        "/* LISTEN ignored */ SELECT 'UNLISTEN *'; \
         LiStEn \"NOTIFY\"; UNLISTEN \"Quoted channel\"; UNLISTEN *; \
         NOTIFY events, 'LISTEN'; SELECT pg_notify('events', 'UNLISTEN'); \
         DO $$ BEGIN LISTEN nested; END $$; \
         CREATE FUNCTION deferred() RETURNS void LANGUAGE plpgsql AS $$ BEGIN UNLISTEN *; END $$",
    )
    .unwrap();
    assert_eq!(
        statements
            .iter()
            .map(crate::ParsedStatement::is_notification_listener_command)
            .collect::<Vec<_>>(),
        [false, true, true, true, false, false, false, false]
    );
}

#[test]
fn listener_classification_does_not_move_semantic_errors_before_admission() {
    let statements = parse_statements("SELECT missing_column FROM absent; LISTEN events").unwrap();
    assert!(!statements[0].is_notification_listener_command());
    assert!(statements[1].is_notification_listener_command());
}