File: reference_vector_key_time.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 (12 lines) | stat: -rw-r--r-- 297 bytes parent folder | download | duplicates (5) 
1
2
3
4
5
6
7
8
9
10
11
12
 
table_create Dates TABLE_PAT_KEY Time

table_create Values TABLE_NO_KEY
column_create Values time_values COLUMN_VECTOR Dates

load --table Values
[
{"time_values": ["2017-07-12 00:00:00", "2017-05-12 00:00:00"]}
]

select Values \
  --output_columns '_id, min(time_values, "2017-06-12 00:00:00")'