testdata/workloads/functional-query/queries/QueryTest/full-acid-rowid.test

====
---- QUERY
select * from functional_orc_def.alltypestiny;
---- LABELS
ID, BOOL_COL, TINYINT_COL, SMALLINT_COL, INT_COL, BIGINT_COL, FLOAT_COL, DOUBLE_COL, DATE_STRING_COL, STRING_COL, TIMESTAMP_COL, YEAR, MONTH
---- RESULTS
4,true,0,0,0,0,0,0,'03/01/09','0',2009-03-01 00:00:00,2009,3
5,false,1,1,1,10,1.100000023841858,10.1,'03/01/09','1',2009-03-01 00:01:00,2009,3
2,true,0,0,0,0,0,0,'02/01/09','0',2009-02-01 00:00:00,2009,2
3,false,1,1,1,10,1.100000023841858,10.1,'02/01/09','1',2009-02-01 00:01:00,2009,2
0,true,0,0,0,0,0,0,'01/01/09','0',2009-01-01 00:00:00,2009,1
1,false,1,1,1,10,1.100000023841858,10.1,'01/01/09','1',2009-01-01 00:01:00,2009,1
6,true,0,0,0,0,0,0,'04/01/09','0',2009-04-01 00:00:00,2009,4
7,false,1,1,1,10,1.100000023841858,10.1,'04/01/09','1',2009-04-01 00:01:00,2009,4
---- TYPES
INT, BOOLEAN, TINYINT, SMALLINT, INT, BIGINT, FLOAT, DOUBLE, STRING, STRING, TIMESTAMP, INT, INT
====
---- QUERY
select row__id.*, * from functional_orc_def.alltypestiny;
---- LABELS
OPERATION, ORIGINALTRANSACTION, BUCKET, ROWID, CURRENTTRANSACTION, ID, BOOL_COL, TINYINT_COL, SMALLINT_COL, INT_COL, BIGINT_COL, FLOAT_COL, DOUBLE_COL, DATE_STRING_COL, STRING_COL, TIMESTAMP_COL, YEAR, MONTH
---- RESULTS
0,5,536870912,0,5,2,true,0,0,0,0,0,0,'02/01/09','0',2009-02-01 00:00:00,2009,2
0,5,536870912,1,5,3,false,1,1,1,10,1.100000023841858,10.1,'02/01/09','1',2009-02-01 00:01:00,2009,2
0,5,536870912,0,5,6,true,0,0,0,0,0,0,'04/01/09','0',2009-04-01 00:00:00,2009,4
0,5,536870912,1,5,7,false,1,1,1,10,1.100000023841858,10.1,'04/01/09','1',2009-04-01 00:01:00,2009,4
0,5,536870912,0,5,0,true,0,0,0,0,0,0,'01/01/09','0',2009-01-01 00:00:00,2009,1
0,5,536870912,1,5,1,false,1,1,1,10,1.100000023841858,10.1,'01/01/09','1',2009-01-01 00:01:00,2009,1
0,5,536870912,0,5,4,true,0,0,0,0,0,0,'03/01/09','0',2009-03-01 00:00:00,2009,3
0,5,536870912,1,5,5,false,1,1,1,10,1.100000023841858,10.1,'03/01/09','1',2009-03-01 00:01:00,2009,3
---- TYPES
INT, BIGINT, INT, BIGINT, BIGINT, INT, BOOLEAN, TINYINT, SMALLINT, INT, BIGINT, FLOAT, DOUBLE, STRING, STRING, TIMESTAMP, INT, INT
====
---- QUERY
select row__id.operation, row__id.rowid, row__id.originaltransaction, *
from functional_orc_def.alltypestiny;
---- LABELS
ROW__ID.OPERATION, ROW__ID.ROWID, ROW__ID.ORIGINALTRANSACTION, ID, BOOL_COL, TINYINT_COL, SMALLINT_COL, INT_COL, BIGINT_COL, FLOAT_COL, DOUBLE_COL, DATE_STRING_COL, STRING_COL, TIMESTAMP_COL, YEAR, MONTH
---- RESULTS
0,0,5,2,true,0,0,0,0,0,0,'02/01/09','0',2009-02-01 00:00:00,2009,2
0,1,5,3,false,1,1,1,10,1.100000023841858,10.1,'02/01/09','1',2009-02-01 00:01:00,2009,2
0,0,5,4,true,0,0,0,0,0,0,'03/01/09','0',2009-03-01 00:00:00,2009,3
0,1,5,5,false,1,1,1,10,1.100000023841858,10.1,'03/01/09','1',2009-03-01 00:01:00,2009,3
0,0,5,6,true,0,0,0,0,0,0,'04/01/09','0',2009-04-01 00:00:00,2009,4
0,1,5,7,false,1,1,1,10,1.100000023841858,10.1,'04/01/09','1',2009-04-01 00:01:00,2009,4
0,0,5,0,true,0,0,0,0,0,0,'01/01/09','0',2009-01-01 00:00:00,2009,1
0,1,5,1,false,1,1,1,10,1.100000023841858,10.1,'01/01/09','1',2009-01-01 00:01:00,2009,1
---- TYPES
INT, BIGINT, BIGINT, INT, BOOLEAN, TINYINT, SMALLINT, INT, BIGINT, FLOAT, DOUBLE, STRING, STRING, TIMESTAMP, INT, INT
====
---- QUERY
select id from functional_orc_def.complextypestbl;
---- LABELS
ID
---- RESULTS
1
2
3
4
5
6
7
8
---- TYPES
BIGINT
====
---- QUERY
select row__id.*, id from functional_orc_def.complextypestbl;
---- LABELS
OPERATION, ORIGINALTRANSACTION, BUCKET, ROWID, CURRENTTRANSACTION, ID
---- RESULTS
0,1,536870912,0,1,1
0,1,536870912,1,1,2
0,1,536870912,2,1,3
0,1,536870912,3,1,4
0,1,536870912,4,1,5
0,1,536870912,5,1,6
0,1,536870912,6,1,7
0,1,536936448,0,1,8
---- TYPES
INT, BIGINT, INT, BIGINT, BIGINT, BIGINT
====
---- QUERY
select row__id.currenttransaction, row__id.bucket, row__id.rowid, id
from functional_orc_def.complextypestbl;
---- LABELS
ROW__ID.CURRENTTRANSACTION, ROW__ID.BUCKET, ROW__ID.ROWID, ID
---- RESULTS
1,536870912,0,1
1,536870912,1,2
1,536870912,2,3
1,536870912,3,4
1,536870912,4,5
1,536870912,5,6
1,536870912,6,7
1,536936448,0,8
---- TYPES
BIGINT, INT, BIGINT, BIGINT
====
---- QUERY
select row__id.*, item from functional_orc_def.complextypestbl c, c.int_array a;
---- LABELS
OPERATION, ORIGINALTRANSACTION, BUCKET, ROWID, CURRENTTRANSACTION, ITEM
---- RESULTS
0,1,536936448,0,1,-1
0,1,536870912,0,1,1
0,1,536870912,0,1,2
0,1,536870912,0,1,3
0,1,536870912,1,1,NULL
0,1,536870912,1,1,1
0,1,536870912,1,1,2
0,1,536870912,1,1,NULL
0,1,536870912,1,1,3
0,1,536870912,1,1,NULL
---- TYPES
INT, BIGINT, INT, BIGINT, BIGINT, INT
====
---- QUERY
select row__id.rowid, row__id.currenttransaction, row__id.operation,
       row__id.bucket, row__id.originaltransaction, item
from functional_orc_def.complextypestbl c, c.int_array a;
---- LABELS
ROW__ID.ROWID, ROW__ID.CURRENTTRANSACTION, ROW__ID.OPERATION, ROW__ID.BUCKET, ROW__ID.ORIGINALTRANSACTION, ITEM
---- RESULTS
0,1,0,536936448,1,-1
0,1,0,536870912,1,1
0,1,0,536870912,1,2
0,1,0,536870912,1,3
1,1,0,536870912,1,NULL
1,1,0,536870912,1,1
1,1,0,536870912,1,2
1,1,0,536870912,1,NULL
1,1,0,536870912,1,3
1,1,0,536870912,1,NULL
---- TYPES
BIGINT, BIGINT, INT, INT, BIGINT, INT
====
---- QUERY
select row__id.rowid, row__id.currenttransaction, row__id.operation,
       row__id.bucket, row__id.originaltransaction, item
from functional_orc_def.complextypestbl_minor_compacted c, c.int_array a;
---- LABELS
ROW__ID.ROWID, ROW__ID.CURRENTTRANSACTION, ROW__ID.OPERATION, ROW__ID.BUCKET, ROW__ID.ORIGINALTRANSACTION, ITEM
---- RESULTS
0,1,0,536870912,1,1
0,1,0,536870912,1,2
0,1,0,536870912,1,3
0,2,0,536870912,2,NULL
0,2,0,536870912,2,1
0,2,0,536870912,2,2
0,2,0,536870912,2,NULL
0,2,0,536870912,2,3
0,2,0,536870912,2,NULL
0,8,0,536870912,8,-1
---- TYPES
BIGINT, BIGINT, INT, INT, BIGINT, INT
====
---- QUERY
select row__id.originaltransaction, row__id.bucket, row__id.rowid, id
from functional_orc_def.complextypestbl_deleted_rows;
---- LABELS
ROW__ID.ORIGINALTRANSACTION, ROW__ID.BUCKET, ROW__ID.ROWID, ID
---- RESULTS
1,536870912,0,1
1,536870912,2,3
1,536870912,4,5
1,536870912,6,7
---- TYPES
BIGINT, INT, BIGINT, BIGINT
====
---- QUERY
select row__id.originaltransaction, row__id.bucket, row__id.rowid, id, item
from functional_orc_def.complextypestbl_deleted_rows t, t.int_array;
---- LABELS
ROW__ID.ORIGINALTRANSACTION, ROW__ID.BUCKET, ROW__ID.ROWID, ID, ITEM
---- RESULTS
1,536870912,0,1,1
1,536870912,0,1,2
1,536870912,0,1,3
---- TYPES
BIGINT, INT, BIGINT, BIGINT, INT
====
---- QUERY
select row__id.originaltransaction, row__id.bucket, row__id.rowid, id, item
from functional_orc_def.complextypestbl_deleted_rows t, t.int_array_array.item;
---- LABELS
ROW__ID.ORIGINALTRANSACTION, ROW__ID.BUCKET, ROW__ID.ROWID, ID, ITEM
---- RESULTS
1,536870912,0,1,1
1,536870912,0,1,2
1,536870912,0,1,3
1,536870912,0,1,4
1,536870912,6,7,5
1,536870912,6,7,6
---- TYPES
BIGINT, INT, BIGINT, BIGINT, INT
====
---- QUERY
select row__id.originaltransaction, row__id.bucket, row__id.rowid, id, e
from functional_orc_def.complextypestbl_deleted_rows t, t.nested_struct.c.d.item;
---- LABELS
ROW__ID.ORIGINALTRANSACTION, ROW__ID.BUCKET, ROW__ID.ROWID, ID, E
---- RESULTS
1,536870912,0,1,10
1,536870912,0,1,-10
1,536870912,0,1,11
1,536870912,6,7,NULL
---- TYPES
BIGINT, INT, BIGINT, BIGINT, INT
====
---- QUERY
select row__id.originaltransaction, row__id.bucket, row__id.rowid, id, item
from functional_orc_def.complextypestbl t, t.nested_struct.g.value.h.i;
---- LABELS
ROW__ID.ORIGINALTRANSACTION, ROW__ID.BUCKET, ROW__ID.ROWID, ID, ITEM
---- RESULTS
1,536870912,0,1,1.1
1,536870912,1,2,2.2
1,536870912,1,2,NULL
1,536870912,4,5,2.2
1,536870912,4,5,3.3
---- TYPES
BIGINT, INT, BIGINT, BIGINT, DOUBLE
====
====
---- QUERY
select row__id.originaltransaction, row__id.bucket, row__id.rowid, id, item
from functional_orc_def.complextypestbl_deleted_rows t, t.nested_struct.g.value.h.i;
---- LABELS
ROW__ID.ORIGINALTRANSACTION, ROW__ID.BUCKET, ROW__ID.ROWID, ID, ITEM
---- RESULTS
1,536870912,0,1,1.1
1,536870912,4,5,2.2
1,536870912,4,5,3.3
---- TYPES
BIGINT, INT, BIGINT, BIGINT, DOUBLE
====