nsmcp::AccessRecordPartitions method partitionView (protected)

 <instance of nsmcp::AccessRecordPartitions> partitionView

Defined in /usr/local/ns/tcl/nsmcp/log-traffic-record-01-partitions.tcl

Testcases:

No testcase defined.

Source code:

set sources [list {SELECT * FROM row_template WHERE 0}]
set parts [${:db} execute {SELECT name FROM main.partitions ORDER BY start}]
if {[llength $parts]>256} {
    error "record-store-partition-limit"
}
foreach part $parts {
    set name [dict get $part name]
    if {![regexp {^p_[0-9]+$} $name]} {
        error "record-store-invalid-partition"
    }
    lappend sources "SELECT * FROM $name"
}
${:db} execute {DROP VIEW IF EXISTS main.rows}
${:db} execute "CREATE VIEW main.rows AS [join $sources { UNION ALL }]"

XQL Not present:

Generic, PostgreSQL, Oracle