# Deeply nested namespace creation
admin 'CREATE NAMESPACE a::b::c'
replicate
---
version: 2
query 'FROM system::namespaces FILTER {name == "a" or name == "a::b" or name == "a::b::c"} SORT {name:ASC}'
---
+---------+-----------+--------------+-------------+
| id | name | local_name | parent_id |
+---------+-----------+--------------+-------------+
| 16385 | a | a | 0 |
| 16386 | a::b | b | 16385 |
| 16387 | a::b::c | c | 16386 |
+---------+-----------+--------------+-------------+