"Fossies" - the Fresh Open Source Software Archive

Member "groonga-10.0.8/test/command/suite/select/index/multi_column/range/accessor.expected" (22 Oct 2020, 1565 Bytes) of package /linux/misc/groonga-10.0.8.tar.gz:


As a special service "Fossies" has tried to format the requested text file into HTML format (style: standard) with prefixed line numbers. Alternatively you can here view or download the uninterpreted source code file.

    1 table_create Numbers TABLE_PAT_KEY Int32
    2 [[0,0.0,0.0],true]
    3 table_create Pairs TABLE_HASH_KEY ShortText
    4 [[0,0.0,0.0],true]
    5 column_create Pairs number1 COLUMN_SCALAR Int32
    6 [[0,0.0,0.0],true]
    7 column_create Pairs number2 COLUMN_SCALAR Int32
    8 [[0,0.0,0.0],true]
    9 column_create Numbers pairs   COLUMN_INDEX|WITH_SECTION   Pairs number1,number2
   10 [[0,0.0,0.0],true]
   11 table_create Memos TABLE_HASH_KEY ShortText
   12 [[0,0.0,0.0],true]
   13 column_create Memos pair1 COLUMN_SCALAR Pairs
   14 [[0,0.0,0.0],true]
   15 column_create Memos pair2 COLUMN_SCALAR Pairs
   16 [[0,0.0,0.0],true]
   17 column_create Pairs memos   COLUMN_INDEX|WITH_SECTION   Memos pair1,pair2
   18 [[0,0.0,0.0],true]
   19 load --table Pairs
   20 [
   21   {
   22     "_key": "2-30",
   23     "number1": 2,
   24     "number2": 30
   25   },
   26   {
   27     "_key": "3-10",
   28     "number1": 3,
   29     "number2": 10
   30   },
   31   {
   32     "_key": "1-20",
   33     "number1": 1,
   34     "number2": 20
   35   }
   36 ]
   37 [[0,0.0,0.0],3]
   38 load --table Memos
   39 [
   40   {
   41     "_key": "300",
   42     "pair1": "1-20",
   43     "pair2": "2-30"
   44   },
   45   {
   46     "_key": "200",
   47     "pair1": "3-10",
   48     "pair2": "1-20"
   49   },
   50   {
   51     "_key": "100",
   52     "pair1": "2-30",
   53     "pair2": "3-10"
   54   }
   55 ]
   56 [[0,0.0,0.0],3]
   57 select Memos   --filter 'pair2.number1 >= 2 && pair2.number2 >= 20'   --output_columns '_key,pair1,pair2'
   58 [
   59   [
   60     0,
   61     0.0,
   62     0.0
   63   ],
   64   [
   65     [
   66       [
   67         1
   68       ],
   69       [
   70         [
   71           "_key",
   72           "ShortText"
   73         ],
   74         [
   75           "pair1",
   76           "Pairs"
   77         ],
   78         [
   79           "pair2",
   80           "Pairs"
   81         ]
   82       ],
   83       [
   84         "300",
   85         "1-20",
   86         "2-30"
   87       ]
   88     ]
   89   ]
   90 ]