You are viewing a plain text version of this content. The canonical link for it is here.
Posted to commits@calcite.apache.org by jh...@apache.org on 2014/08/01 01:41:22 UTC
[03/20] Change license headers from "Julian Hyde" to "ASF";
add headers where missing.
http://git-wip-us.apache.org/repos/asf/incubator-optiq/blob/bfa3daee/core/src/test/java/org/eigenbase/test/concurrent/test.ref
----------------------------------------------------------------------
diff --git a/core/src/test/java/org/eigenbase/test/concurrent/test.ref b/core/src/test/java/org/eigenbase/test/concurrent/test.ref
deleted file mode 100644
index 9725dad..0000000
--- a/core/src/test/java/org/eigenbase/test/concurrent/test.ref
+++ /dev/null
@@ -1,182 +0,0 @@
--- setup
-> create schema foo;
-0 rows affected.
-> create view foo.crossview as (
-> select * from sales.depts x
-> cross join sales.emps y
-> cross join sales.emps z
-> );
-0 rows affected.
--- end of setup
-
--- thread reader
-pwd
-/work/dt/src/stab/farrago/src/org/eigenbase/test/concurrent
-echo mtsql*
-mtsql mtsql.loggers
-hostname; whoami
-teapot
-mb
-head -1 < package.html | cat | cat > foo; cat foo
-<html>
-$N is 7 and $S is bagel bag.
-The $HOSTNAME is teapot.
-The $HOSTNAME is teapot, teapot, "teapot", "teapot", 'teapot', 'teapot'.
-The $HOSTNAME is "teapot, teapot".
-$WHO is mb@teapot
-$RecursiveVar is 7 bagel bag teapot mb@teapot
-> values (1,2,3);
-+------------+------------+------------+
-| EXPR$0 | EXPR$1 | EXPR$2 |
-+------------+------------+------------+
-| 1 | 2 | 3 |
-+------------+------------+------------+
-
-> values (4, 'teapot', 'mb@teapot');
-+------------+--------+-----------+
-| EXPR$0 | EXPR$1 | EXPR$2 |
-+------------+--------+-----------+
-| 4 | teapot | mb@teapot |
-+------------+--------+-----------+
-
-> values (7, 'bagel bag');
-+------------+-----------+
-| EXPR$0 | EXPR$1 |
-+------------+-----------+
-| 7 | bagel bag |
-+------------+-----------+
-
-> select * from sales.depts;
-+------------+----------------------------------------------------------------------------------------------------------------------------------+
-| DEPTNO | NAME |
-+------------+----------------------------------------------------------------------------------------------------------------------------------+
-| 10 | Sales |
-| 20 | Marketing |
-| 30 | Accounts |
-+------------+----------------------------------------------------------------------------------------------------------------------------------+
-
--- end of thread reader
-
--- thread printer
-> select * from foo.crossview;
-printing all
-+------------+----------------------------------------------------------------------------------------------------------------------------------+------------+----------------------------------------------------------------------------------------------------------------------------------+------------+--------+----------------------------------------------------------------------------------------------------------------------------------+------------+------------+----------------------------------------------------+---------+---------+------------+----------------------------------------------------------------------------------------------------------------------------------+------------+---------+----------------------------------------------------------------------------------------------------------------------------------+------------+------------+----------------------------------------------------+----------+----------+
-| DEPTNO | NAME | EMPNO | NAME0 | DEPTNO0 | GENDER | CITY | EMPID | AGE | PUBLIC_KEY | SLACKER | MANAGER | EMPNO0 | NAME1 | DEPTNO1 | GENDER0 | CITY0 | EMPID0 | AGE0 | PUBLIC_KEY0 | SLACKER0 | MANAGER0 |
-+------------+----------------------------------------------------------------------------------------------------------------------------------+------------+----------------------------------------------------------------------------------------------------------------------------------+------------+--------+----------------------------------------------------------------------------------------------------------------------------------+------------+------------+----------------------------------------------------+---------+---------+------------+----------------------------------------------------------------------------------------------------------------------------------+------------+---------+----------------------------------------------------------------------------------------------------------------------------------+------------+------------+----------------------------------------------------+----------+----------+
-| 10 | Sales | 100 | Fred | 10 | | | 30 | 25 | 41626320 | true | false | 100 | Fred | 10 | | | 30 | 25 | 41626320 | true | false |
-| 10 | Sales | 100 | Fred | 10 | | | 30 | 25 | 41626320 | true | false | 110 | Eric | 20 | M | San Francisco | 3 | 80 | 416263 | | false |
-| 10 | Sales | 100 | Fred | 10 | | | 30 | 25 | 41626320 | true | false | 120 | Wilma | 20 | F | | 1 | 50 | | | true |
-| 10 | Sales | 100 | Fred | 10 | | | 30 | 25 | 41626320 | true | false | 110 | John | 40 | M | Vancouver | 2 | | 58797A | false | true |
-| 10 | Sales | 110 | Eric | 20 | M | San Francisco | 3 | 80 | 416263 | | false | 100 | Fred | 10 | | | 30 | 25 | 41626320 | true | false |
-| 10 | Sales | 110 | Eric | 20 | M | San Francisco | 3 | 80 | 416263 | | false | 110 | Eric | 20 | M | San Francisco | 3 | 80 | 416263 | | false |
-| 10 | Sales | 110 | Eric | 20 | M | San Francisco | 3 | 80 | 416263 | | false | 120 | Wilma | 20 | F | | 1 | 50 | | | true |
-| 10 | Sales | 110 | Eric | 20 | M | San Francisco | 3 | 80 | 416263 | | false | 110 | John | 40 | M | Vancouver | 2 | | 58797A | false | true |
-| 10 | Sales | 120 | Wilma | 20 | F | | 1 | 50 | | | true | 100 | Fred | 10 | | | 30 | 25 | 41626320 | true | false |
-| 10 | Sales | 120 | Wilma | 20 | F | | 1 | 50 | | | true | 110 | Eric | 20 | M | San Francisco | 3 | 80 | 416263 | | false |
-| 10 | Sales | 120 | Wilma | 20 | F | | 1 | 50 | | | true | 120 | Wilma | 20 | F | | 1 | 50 | | | true |
-| 10 | Sales | 120 | Wilma | 20 | F | | 1 | 50 | | | true | 110 | John | 40 | M | Vancouver | 2 | | 58797A | false | true |
-| 10 | Sales | 110 | John | 40 | M | Vancouver | 2 | | 58797A | false | true | 100 | Fred | 10 | | | 30 | 25 | 41626320 | true | false |
-| 10 | Sales | 110 | John | 40 | M | Vancouver | 2 | | 58797A | false | true | 110 | Eric | 20 | M | San Francisco | 3 | 80 | 416263 | | false |
-| 10 | Sales | 110 | John | 40 | M | Vancouver | 2 | | 58797A | false | true | 120 | Wilma | 20 | F | | 1 | 50 | | | true |
-| 10 | Sales | 110 | John | 40 | M | Vancouver | 2 | | 58797A | false | true | 110 | John | 40 | M | Vancouver | 2 | | 58797A | false | true |
-| 20 | Marketing | 100 | Fred | 10 | | | 30 | 25 | 41626320 | true | false | 100 | Fred | 10 | | | 30 | 25 | 41626320 | true | false |
-| 20 | Marketing | 100 | Fred | 10 | | | 30 | 25 | 41626320 | true | false | 110 | Eric | 20 | M | San Francisco | 3 | 80 | 416263 | | false |
-| 20 | Marketing | 100 | Fred | 10 | | | 30 | 25 | 41626320 | true | false | 120 | Wilma | 20 | F | | 1 | 50 | | | true |
-| 20 | Marketing | 100 | Fred | 10 | | | 30 | 25 | 41626320 | true | false | 110 | John | 40 | M | Vancouver | 2 | | 58797A | false | true |
-| 20 | Marketing | 110 | Eric | 20 | M | San Francisco | 3 | 80 | 416263 | | false | 100 | Fred | 10 | | | 30 | 25 | 41626320 | true | false |
-| 20 | Marketing | 110 | Eric | 20 | M | San Francisco | 3 | 80 | 416263 | | false | 110 | Eric | 20 | M | San Francisco | 3 | 80 | 416263 | | false |
-| 20 | Marketing | 110 | Eric | 20 | M | San Francisco | 3 | 80 | 416263 | | false | 120 | Wilma | 20 | F | | 1 | 50 | | | true |
-| 20 | Marketing | 110 | Eric | 20 | M | San Francisco | 3 | 80 | 416263 | | false | 110 | John | 40 | M | Vancouver | 2 | | 58797A | false | true |
-| 20 | Marketing | 120 | Wilma | 20 | F | | 1 | 50 | | | true | 100 | Fred | 10 | | | 30 | 25 | 41626320 | true | false |
-| 20 | Marketing | 120 | Wilma | 20 | F | | 1 | 50 | | | true | 110 | Eric | 20 | M | San Francisco | 3 | 80 | 416263 | | false |
-| 20 | Marketing | 120 | Wilma | 20 | F | | 1 | 50 | | | true | 120 | Wilma | 20 | F | | 1 | 50 | | | true |
-| 20 | Marketing | 120 | Wilma | 20 | F | | 1 | 50 | | | true | 110 | John | 40 | M | Vancouver | 2 | | 58797A | false | true |
-| 20 | Marketing | 110 | John | 40 | M | Vancouver | 2 | | 58797A | false | true | 100 | Fred | 10 | | | 30 | 25 | 41626320 | true | false |
-| 20 | Marketing | 110 | John | 40 | M | Vancouver | 2 | | 58797A | false | true | 110 | Eric | 20 | M | San Francisco | 3 | 80 | 416263 | | false |
-| 20 | Marketing | 110 | John | 40 | M | Vancouver | 2 | | 58797A | false | true | 120 | Wilma | 20 | F | | 1 | 50 | | | true |
-| 20 | Marketing | 110 | John | 40 | M | Vancouver | 2 | | 58797A | false | true | 110 | John | 40 | M | Vancouver | 2 | | 58797A | false | true |
-| 30 | Accounts | 100 | Fred | 10 | | | 30 | 25 | 41626320 | true | false | 100 | Fred | 10 | | | 30 | 25 | 41626320 | true | false |
-| 30 | Accounts | 100 | Fred | 10 | | | 30 | 25 | 41626320 | true | false | 110 | Eric | 20 | M | San Francisco | 3 | 80 | 416263 | | false |
-| 30 | Accounts | 100 | Fred | 10 | | | 30 | 25 | 41626320 | true | false | 120 | Wilma | 20 | F | | 1 | 50 | | | true |
-| 30 | Accounts | 100 | Fred | 10 | | | 30 | 25 | 41626320 | true | false | 110 | John | 40 | M | Vancouver | 2 | | 58797A | false | true |
-| 30 | Accounts | 110 | Eric | 20 | M | San Francisco | 3 | 80 | 416263 | | false | 100 | Fred | 10 | | | 30 | 25 | 41626320 | true | false |
-| 30 | Accounts | 110 | Eric | 20 | M | San Francisco | 3 | 80 | 416263 | | false | 110 | Eric | 20 | M | San Francisco | 3 | 80 | 416263 | | false |
-| 30 | Accounts | 110 | Eric | 20 | M | San Francisco | 3 | 80 | 416263 | | false | 120 | Wilma | 20 | F | | 1 | 50 | | | true |
-| 30 | Accounts | 110 | Eric | 20 | M | San Francisco | 3 | 80 | 416263 | | false | 110 | John | 40 | M | Vancouver | 2 | | 58797A | false | true |
-| 30 | Accounts | 120 | Wilma | 20 | F | | 1 | 50 | | | true | 100 | Fred | 10 | | | 30 | 25 | 41626320 | true | false |
-| 30 | Accounts | 120 | Wilma | 20 | F | | 1 | 50 | | | true | 110 | Eric | 20 | M | San Francisco | 3 | 80 | 416263 | | false |
-| 30 | Accounts | 120 | Wilma | 20 | F | | 1 | 50 | | | true | 120 | Wilma | 20 | F | | 1 | 50 | | | true |
-| 30 | Accounts | 120 | Wilma | 20 | F | | 1 | 50 | | | true | 110 | John | 40 | M | Vancouver | 2 | | 58797A | false | true |
-| 30 | Accounts | 110 | John | 40 | M | Vancouver | 2 | | 58797A | false | true | 100 | Fred | 10 | | | 30 | 25 | 41626320 | true | false |
-| 30 | Accounts | 110 | John | 40 | M | Vancouver | 2 | | 58797A | false | true | 110 | Eric | 20 | M | San Francisco | 3 | 80 | 416263 | | false |
-| 30 | Accounts | 110 | John | 40 | M | Vancouver | 2 | | 58797A | false | true | 120 | Wilma | 20 | F | | 1 | 50 | | | true |
-| 30 | Accounts | 110 | John | 40 | M | Vancouver | 2 | | 58797A | false | true | 110 | John | 40 | M | Vancouver | 2 | | 58797A | false | true |
-+------------+----------------------------------------------------------------------------------------------------------------------------------+------------+----------------------------------------------------------------------------------------------------------------------------------+------------+--------+----------------------------------------------------------------------------------------------------------------------------------+------------+------------+----------------------------------------------------+---------+---------+------------+----------------------------------------------------------------------------------------------------------------------------------+------------+---------+----------------------------------------------------------------------------------------------------------------------------------+------------+------------+----------------------------------------------------+----------+----------+
-
-printing none
-printing every 5th row
- +------------+----------------------------------------------------------------------------------------------------------------------------------+------------+----------------------------------------------------------------------------------------------------------------------------------+------------+--------+----------------------------------------------------------------------------------------------------------------------------------+------------+------------+----------------------------------------------------+---------+---------+------------+----------------------------------------------------------------------------------------------------------------------------------+------------+---------+----------------------------------------------------------------------------------------------------------------------------------+------------+------------+----------------------------------------------------+----------+----------+
- | DEPTNO | NAME | EMPNO | NAME0 | DEPTNO0 | GENDER | CITY | EMPID | AGE | PUBLIC_KEY | SLACKER | MANAGER | EMPNO0 | NAME1 | DEPTNO1 | GENDER0 | CITY0 | EMPID0 | AGE0 | PUBLIC_KEY0 | SLACKER0 | MANAGER0 |
- +------------+----------------------------------------------------------------------------------------------------------------------------------+------------+----------------------------------------------------------------------------------------------------------------------------------+------------+--------+----------------------------------------------------------------------------------------------------------------------------------+------------+------------+----------------------------------------------------+---------+---------+------------+----------------------------------------------------------------------------------------------------------------------------------+------------+---------+----------------------------------------------------------------------------------------------------------------------------------+------------+------------+----------------------------------------------------+----------+----------+
-(000000) | 10 | Sales | 100 | Fred | 10 | | | 30 | 25 | 41626320 | true | false | 100 | Fred | 10 | | | 30 | 25 | 41626320 | true | false |
-(000005) | 10 | Sales | 110 | Eric | 20 | M | San Francisco | 3 | 80 | 416263 | | false | 110 | Eric | 20 | M | San Francisco | 3 | 80 | 416263 | | false |
-(000010) | 10 | Sales | 120 | Wilma | 20 | F | | 1 | 50 | | | true | 120 | Wilma | 20 | F | | 1 | 50 | | | true |
-(000015) | 10 | Sales | 110 | John | 40 | M | Vancouver | 2 | | 58797A | false | true | 110 | John | 40 | M | Vancouver | 2 | | 58797A | false | true |
-(000020) | 20 | Marketing | 110 | Eric | 20 | M | San Francisco | 3 | 80 | 416263 | | false | 100 | Fred | 10 | | | 30 | 25 | 41626320 | true | false |
-(000025) | 20 | Marketing | 120 | Wilma | 20 | F | | 1 | 50 | | | true | 110 | Eric | 20 | M | San Francisco | 3 | 80 | 416263 | | false |
-(000030) | 20 | Marketing | 110 | John | 40 | M | Vancouver | 2 | | 58797A | false | true | 120 | Wilma | 20 | F | | 1 | 50 | | | true |
-(000035) | 30 | Accounts | 100 | Fred | 10 | | | 30 | 25 | 41626320 | true | false | 110 | John | 40 | M | Vancouver | 2 | | 58797A | false | true |
-(000040) | 30 | Accounts | 120 | Wilma | 20 | F | | 1 | 50 | | | true | 100 | Fred | 10 | | | 30 | 25 | 41626320 | true | false |
-(000045) | 30 | Accounts | 110 | John | 40 | M | Vancouver | 2 | | 58797A | false | true | 110 | Eric | 20 | M | San Francisco | 3 | 80 | 416263 | | false |
- +------------+----------------------------------------------------------------------------------------------------------------------------------+------------+----------------------------------------------------------------------------------------------------------------------------------+------------+--------+----------------------------------------------------------------------------------------------------------------------------------+------------+------------+----------------------------------------------------+---------+---------+------------+----------------------------------------------------------------------------------------------------------------------------------+------------+---------+----------------------------------------------------------------------------------------------------------------------------------+------------+------------+----------------------------------------------------+----------+----------+
-
-printing every 7th row
- +------------+----------------------------------------------------------------------------------------------------------------------------------+------------+----------------------------------------------------------------------------------------------------------------------------------+------------+--------+----------------------------------------------------------------------------------------------------------------------------------+------------+------------+----------------------------------------------------+---------+---------+------------+----------------------------------------------------------------------------------------------------------------------------------+------------+---------+----------------------------------------------------------------------------------------------------------------------------------+------------+------------+----------------------------------------------------+----------+----------+
- | DEPTNO | NAME | EMPNO | NAME0 | DEPTNO0 | GENDER | CITY | EMPID | AGE | PUBLIC_KEY | SLACKER | MANAGER | EMPNO0 | NAME1 | DEPTNO1 | GENDER0 | CITY0 | EMPID0 | AGE0 | PUBLIC_KEY0 | SLACKER0 | MANAGER0 |
- +------------+----------------------------------------------------------------------------------------------------------------------------------+------------+----------------------------------------------------------------------------------------------------------------------------------+------------+--------+----------------------------------------------------------------------------------------------------------------------------------+------------+------------+----------------------------------------------------+---------+---------+------------+----------------------------------------------------------------------------------------------------------------------------------+------------+---------+----------------------------------------------------------------------------------------------------------------------------------+------------+------------+----------------------------------------------------+----------+----------+
-(000000) | 10 | Sales | 100 | Fred | 10 | | | 30 | 25 | 41626320 | true | false | 100 | Fred | 10 | | | 30 | 25 | 41626320 | true | false |
-(000007) | 10 | Sales | 110 | Eric | 20 | M | San Francisco | 3 | 80 | 416263 | | false | 110 | John | 40 | M | Vancouver | 2 | | 58797A | false | true |
-(000014) | 10 | Sales | 110 | John | 40 | M | Vancouver | 2 | | 58797A | false | true | 120 | Wilma | 20 | F | | 1 | 50 | | | true |
-(000021) | 20 | Marketing | 110 | Eric | 20 | M | San Francisco | 3 | 80 | 416263 | | false | 110 | Eric | 20 | M | San Francisco | 3 | 80 | 416263 | | false |
-(000028) | 20 | Marketing | 110 | John | 40 | M | Vancouver | 2 | | 58797A | false | true | 100 | Fred | 10 | | | 30 | 25 | 41626320 | true | false |
-(000035) | 30 | Accounts | 100 | Fred | 10 | | | 30 | 25 | 41626320 | true | false | 110 | John | 40 | M | Vancouver | 2 | | 58797A | false | true |
-(000042) | 30 | Accounts | 120 | Wilma | 20 | F | | 1 | 50 | | | true | 120 | Wilma | 20 | F | | 1 | 50 | | | true |
- +------------+----------------------------------------------------------------------------------------------------------------------------------+------------+----------------------------------------------------------------------------------------------------------------------------------+------------+--------+----------------------------------------------------------------------------------------------------------------------------------+------------+------------+----------------------------------------------------+---------+---------+------------+----------------------------------------------------------------------------------------------------------------------------------+------------+---------+----------------------------------------------------------------------------------------------------------------------------------+------------+------------+----------------------------------------------------+----------+----------+
-
-printing every other row
- +------------+----------------------------------------------------------------------------------------------------------------------------------+------------+----------------------------------------------------------------------------------------------------------------------------------+------------+--------+----------------------------------------------------------------------------------------------------------------------------------+------------+------------+----------------------------------------------------+---------+---------+------------+----------------------------------------------------------------------------------------------------------------------------------+------------+---------+----------------------------------------------------------------------------------------------------------------------------------+------------+------------+----------------------------------------------------+----------+----------+
- | DEPTNO | NAME | EMPNO | NAME0 | DEPTNO0 | GENDER | CITY | EMPID | AGE | PUBLIC_KEY | SLACKER | MANAGER | EMPNO0 | NAME1 | DEPTNO1 | GENDER0 | CITY0 | EMPID0 | AGE0 | PUBLIC_KEY0 | SLACKER0 | MANAGER0 |
- +------------+----------------------------------------------------------------------------------------------------------------------------------+------------+----------------------------------------------------------------------------------------------------------------------------------+------------+--------+----------------------------------------------------------------------------------------------------------------------------------+------------+------------+----------------------------------------------------+---------+---------+------------+----------------------------------------------------------------------------------------------------------------------------------+------------+---------+----------------------------------------------------------------------------------------------------------------------------------+------------+------------+----------------------------------------------------+----------+----------+
-(000000) | 10 | Sales | 100 | Fred | 10 | | | 30 | 25 | 41626320 | true | false | 100 | Fred | 10 | | | 30 | 25 | 41626320 | true | false |
-(000002) | 10 | Sales | 100 | Fred | 10 | | | 30 | 25 | 41626320 | true | false | 120 | Wilma | 20 | F | | 1 | 50 | | | true |
-(000004) | 10 | Sales | 110 | Eric | 20 | M | San Francisco | 3 | 80 | 416263 | | false | 100 | Fred | 10 | | | 30 | 25 | 41626320 | true | false |
-(000006) | 10 | Sales | 110 | Eric | 20 | M | San Francisco | 3 | 80 | 416263 | | false | 120 | Wilma | 20 | F | | 1 | 50 | | | true |
-(000008) | 10 | Sales | 120 | Wilma | 20 | F | | 1 | 50 | | | true | 100 | Fred | 10 | | | 30 | 25 | 41626320 | true | false |
-(000010) | 10 | Sales | 120 | Wilma | 20 | F | | 1 | 50 | | | true | 120 | Wilma | 20 | F | | 1 | 50 | | | true |
-(000012) | 10 | Sales | 110 | John | 40 | M | Vancouver | 2 | | 58797A | false | true | 100 | Fred | 10 | | | 30 | 25 | 41626320 | true | false |
-(000014) | 10 | Sales | 110 | John | 40 | M | Vancouver | 2 | | 58797A | false | true | 120 | Wilma | 20 | F | | 1 | 50 | | | true |
-(000016) | 20 | Marketing | 100 | Fred | 10 | | | 30 | 25 | 41626320 | true | false | 100 | Fred | 10 | | | 30 | 25 | 41626320 | true | false |
-(000018) | 20 | Marketing | 100 | Fred | 10 | | | 30 | 25 | 41626320 | true | false | 120 | Wilma | 20 | F | | 1 | 50 | | | true |
-(000020) | 20 | Marketing | 110 | Eric | 20 | M | San Francisco | 3 | 80 | 416263 | | false | 100 | Fred | 10 | | | 30 | 25 | 41626320 | true | false |
-(000022) | 20 | Marketing | 110 | Eric | 20 | M | San Francisco
<TRUNCATED>