| /* |
| * Licensed to the Apache Software Foundation (ASF) under one |
| * or more contributor license agreements. See the NOTICE file |
| * distributed with this work for additional information |
| * regarding copyright ownership. The ASF licenses this file |
| * to you under the Apache License, Version 2.0 (the |
| * "License"); you may not use this file except in compliance |
| * with the License. You may obtain a copy of the License at |
| * |
| * http://www.apache.org/licenses/LICENSE-2.0 |
| * |
| * Unless required by applicable law or agreed to in writing, |
| * software distributed under the License is distributed on an |
| * "AS IS" BASIS, WITHOUT WARRANTIES OR CONDITIONS OF ANY |
| * KIND, either express or implied. See the License for the |
| * specific language governing permissions and limitations |
| * under the License. |
| */ |
| Sorting scalars: |
| ---------------- |
| |
| String order: |
| - aardvark |
| - Barbara |
| - beetroot |
| - whale |
| - zeppelin |
| |
| First: aardvark |
| Last: zeppelin |
| Size 5 |
| |
| Numerical order: |
| - -324 |
| - -34 |
| - 0 |
| - 0.1 |
| - 0.11 |
| - 1 |
| - 5 |
| - 111 |
| - 123 |
| - 543 |
| |
| First: -324 |
| Last: 543 |
| Size 10 |
| |
| Date/time order: |
| - 06:05 |
| - 08:05 |
| - 08:15 |
| - 18:00 |
| |
| Boolean order: |
| - false |
| - false |
| - true |
| - true |
| |
| |
| Sorting hashes: |
| --------------- |
| |
| Order by name: |
| - aardvark: 30 |
| - Barbara: 53 |
| - beetroot: 0.3 |
| - whale: 2000 |
| - zeppelin: -200 |
| |
| Order by weight: |
| - zeppelin: -200 |
| - beetroot: 0.3 |
| - aardvark: 30 |
| - Barbara: 53 |
| - whale: 2000 |
| |
| Order by a.x.v: |
| - aqweqw |
| - dfgdf |
| - qweqw |
| - utyu |
| |
| Order by a.y, which is a date: |
| - 1998-02-20 |
| - 1999-01-20 |
| - 1999-04-19 |
| - 1999-04-20 |
| |
| Reverse: |
| -------- |
| |
| Order by weight desc: |
| - whale: 2000 |
| - Barbara: 53 |
| - aardvark: 30 |
| - beetroot: 0.3 |
| - zeppelin: -200 |
| |
| Order by weight desc desc: |
| - zeppelin: -200 |
| - beetroot: 0.3 |
| - aardvark: 30 |
| - Barbara: 53 |
| - whale: 2000 |
| |
| Order by weight desc desc desc: |
| - whale: 2000 |
| - Barbara: 53 |
| - aardvark: 30 |
| - beetroot: 0.3 |
| - zeppelin: -200 |
| |
| Contains: |
| --------- |
| |
| True: |
| true |
| true |
| true |
| true |
| true |
| true |
| true |
| |
| False: |
| false |
| false |
| false |
| false |
| false |
| false |
| false |
| |
| False: false |
| |
| Index_of: |
| --------- |
| |
| 0 = 0 |
| 1 = 1 |
| 2 = 2 |
| 6 = 6 |
| 0 = 0 |
| 1 = 1 |
| 2 = 2 |
| |
| -1 = -1 |
| -1 = -1 |
| -1 = -1 |
| -1 = -1 |
| -1 = -1 |
| -1 = -1 |
| -1 = -1 |
| |
| -1 = -1 |
| |
| Last_index_of: |
| -------------- |
| |
| 6 = 6 |
| 1 = 1 |
| 2 = 2 |
| 7 = 7 |
| -1 = -1 |
| 0 = 0 |
| 1 = 1 |
| 2 = 2 |
| -1 = -1 |
| |
| Index_of and last_index_of with starting indices |
| ------------------------------------------------ |
| |
| seq_index_of "Joe": |
| 0 = 0 |
| 0 = 0 |
| 0 = 0 |
| 2 = 2 |
| 2 = 2 |
| -1 = -1 |
| -1 = -1 |
| |
| seq_last_index_of "Joe": |
| -1 = -1 |
| -1 = -1 |
| 0 = 0 |
| 0 = 0 |
| 2 = 2 |
| 2 = 2 |
| 2 = 2 |
| |
| seq_index_of "Susan": |
| 3 = 3 |
| 3 = 3 |
| 3 = 3 |
| 3 = 3 |
| 3 = 3 |
| 3 = 3 |
| -1 = -1 |
| |
| seq_last_index_of "Susan": |
| -1 = -1 |
| -1 = -1 |
| -1 = -1 |
| -1 = -1 |
| -1 = -1 |
| 3 = 3 |
| 3 = 3 |
| |
| seq_index_of "a": |
| 0 = 0 |
| 0 = 0 |
| 0 = 0 |
| -1 = -1 |
| -1 = -1 |
| -1 = -1 |
| -1 = -1 |
| |
| seq_index_of "b": |
| 1 = 1 |
| 1 = 1 |
| 1 = 1 |
| 1 = 1 |
| -1 = -1 |
| -1 = -1 |
| |
| seq_index_of "c": |
| 2 = 2 |
| 2 = 2 |
| 2 = 2 |
| 2 = 2 |
| 2 = 2 |
| -1 = -1 |
| |
| seq_last_index_of "a": |
| -1 = -1 |
| -1 = -1 |
| 0 = 0 |
| 0 = 0 |
| 0 = 0 |
| 0 = 0 |
| 0 = 0 |
| |
| seq_last_index_of "b": |
| -1 = -1 |
| -1 = -1 |
| -1 = -1 |
| 1 = 1 |
| 1 = 1 |
| 1 = 1 |
| |
| seq_last_index_of "c": |
| -1 = -1 |
| -1 = -1 |
| -1 = -1 |
| -1 = -1 |
| 2 = 2 |
| 2 = 2 |
| |
| Sequence builtins ignoring nulls |
| -------------------------------- |
| |
| true = true |
| 2 = 2 |
| 0 = 0 |
| |
| These should throw exception, but for BC they don't: |
| false = false |
| -1 = -1 |
| -1 = -1 |
| |
| Sequence built-ins failing on date-type mismatch |
| ------------------------------------------------ |
| |
| |
| Chunk |
| ----- |
| |
| columns = 1, fill = NULL: |
| Rows: 7 |
| a <-- Columns: 1 |
| b <-- Columns: 1 |
| c <-- Columns: 1 |
| d <-- Columns: 1 |
| e <-- Columns: 1 |
| f <-- Columns: 1 |
| g <-- Columns: 1 |
| |
| columns = 2, fill = NULL: |
| Rows: 4 |
| a b <-- Columns: 2 |
| c d <-- Columns: 2 |
| e f <-- Columns: 2 |
| g <-- Columns: 1 |
| |
| columns = 3, fill = NULL: |
| Rows: 3 |
| a b c <-- Columns: 3 |
| d e f <-- Columns: 3 |
| g <-- Columns: 1 |
| |
| columns = 4, fill = NULL: |
| Rows: 2 |
| a b c d <-- Columns: 4 |
| e f g <-- Columns: 3 |
| |
| columns = 5, fill = NULL: |
| Rows: 2 |
| a b c d e <-- Columns: 5 |
| f g <-- Columns: 2 |
| |
| columns = 10, fill = NULL: |
| Rows: 1 |
| a b c d e f g <-- Columns: 7 |
| |
| columns = 1, fill = -: |
| Rows: 7 |
| a <-- Columns: 1 |
| b <-- Columns: 1 |
| c <-- Columns: 1 |
| d <-- Columns: 1 |
| e <-- Columns: 1 |
| f <-- Columns: 1 |
| g <-- Columns: 1 |
| |
| columns = 2, fill = -: |
| Rows: 4 |
| a b <-- Columns: 2 |
| c d <-- Columns: 2 |
| e f <-- Columns: 2 |
| g - <-- Columns: 2 |
| |
| columns = 3, fill = -: |
| Rows: 3 |
| a b c <-- Columns: 3 |
| d e f <-- Columns: 3 |
| g - - <-- Columns: 3 |
| |
| columns = 4, fill = -: |
| Rows: 2 |
| a b c d <-- Columns: 4 |
| e f g - <-- Columns: 4 |
| |
| columns = 5, fill = -: |
| Rows: 2 |
| a b c d e <-- Columns: 5 |
| f g - - - <-- Columns: 5 |
| |
| columns = 10, fill = -: |
| Rows: 1 |
| a b c d e f g - - - <-- Columns: 10 |
| |
| columns = 3, fill = NULL: |
| Rows: 3 |
| 1 2 3 <-- Columns: 3 |
| 4 5 6 <-- Columns: 3 |
| 7 8 9 <-- Columns: 3 |
| |
| columns = 3, fill = -: |
| Rows: 3 |
| 1 2 3 <-- Columns: 3 |
| 4 5 6 <-- Columns: 3 |
| 7 8 9 <-- Columns: 3 |
| |
| columns = 3, fill = NULL: |
| Rows: 1 |
| 1 <-- Columns: 1 |
| |
| columns = 3, fill = -: |
| Rows: 1 |
| 1 - - <-- Columns: 3 |
| |
| columns = 3, fill = NULL: |
| Rows: 0 |
| |
| columns = 3, fill = -: |
| Rows: 0 |
| |
| |
| |
| |
| Join |
| ---- |
| |
| - 1, two, three, 4 |
| - |
| - 1, two, three, 4. |
| - (empty) |
| - a, c |
| - a, c |
| - a, c. |
| - |
| - (empty) |
| - (empty) |
| - a, b, c. |
| - a, b, c. |
| |
| |
| Misc |
| ---- |
| |
| First of set 1: a |
| First of set 2: a |