File: reference_vector_column_uint8.test

package info (click to toggle)
groonga 16.0.0%2Bdfsg-1
  • links: PTS, VCS
  • area: main
  • in suites: forky, sid
  • size: 188,416 kB
  • sloc: ansic: 772,827; cpp: 52,396; ruby: 40,556; javascript: 10,250; yacc: 7,045; sh: 5,627; python: 2,821; makefile: 1,679
file content (20 lines) | stat: -rw-r--r-- 392 bytes parent folder | download | duplicates (5) 
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
 
table_create Users TABLE_PAT_KEY ShortText
column_create Users age COLUMN_SCALAR UInt8

table_create Logs TABLE_NO_KEY
column_create Logs users COLUMN_VECTOR Users

load --table Users
[
{"_key": "alice", "age": 12},
{"_key": "bob",   "age": 29},
{"_key": "chris", "age": 3}
]

load --table Logs
[
{"users": ["bob", "chris", "alice"]}
]

select Logs \
  --output_columns '_id, min(users.age)'