@@ -3919,9 +3919,9 @@ QUERY: COPY BINARY stud_emp FROM '_CWD_/stud_emp.data';
39193919QUERY: SELECT * FROM stud_emp;
39203920name |age|location |salary|manager|gpa|percent
39213921-----+---+----------+------+-------+---+-------
3922- jeff | 23|(8,7.7) | 600|sharon |3.5|0
3923- cim | 30|(10.5,4.7)| 400| |3.4|0
3924- linda| 19|(0.9,6.1) | 100| |2.9|0
3922+ jeff | 23|(8,7.7) | 600|sharon |3.5|
3923+ cim | 30|(10.5,4.7)| 400| |3.4|
3924+ linda| 19|(0.9,6.1) | 100| |2.9|
39253925(3 rows)
39263926
39273927QUERY: SELECT count(*) FROM onek;
@@ -6764,11 +6764,11 @@ xacttest
67646764(63 rows)
67656765
67666766QUERY: SELECT * FROM arrtest;
6767- a |b |c |d |e
6768- -----------+---------------+-------------+-----------------+-------------
6769- {1,2,3,4,5}|{{{0,0},{ 1,2}}}|{} |{} |
6770- {11,12,23} |{{3,4},{4, 5}}
6771- {} |{3,4}, "foo"}
6767+ a |b
6768+ -----------+--------------------- +-------------+-----------------+-------------
6769+ {1,2,3,4,5}|{{{0,0}},{{ 1,2}}}
6770+ {11,12,23} |{{{3},{4}},{{4},{ 5}}} |{"foobar"} |{{"elt1","elt2"}}|{"3.4","6.7"}
6771+ {} |{{{ 3,4},{0,0}}} |{"foo","bar"}|{{ "bar"},{ "foo"}} |
67726772(3 rows)
67736773
67746774QUERY: SELECT arrtest.a[1],
@@ -6780,8 +6780,8 @@ QUERY: SELECT arrtest.a[1],
67806780 a|b|c |d |e
67816781--+-+------+----+-
67826782 1|0| | |
6783- 11|
6784- |
6783+ 11|3 |foobar|elt1|
6784+ |3 |foo |bar |
67856785(3 rows)
67866786
67876787QUERY: SELECT arrtest.a[1:3],
@@ -6791,17 +6791,17 @@ QUERY: SELECT arrtest.a[1:3],
67916791 FROM arrtest;
67926792a |b |c |d
67936793----------+---------------+-------------+-----------------
6794- {1,2,3} |{{{0,0},{1,2}}} | |
6794+ {1,2,3} |
67956795{11,12,23}| | |{{"elt1","elt2"}}
6796- |
6796+ |{{{3,4},{0,0}}} |{"foo","bar"}|
67976797(3 rows)
67986798
67996799QUERY: SELECT array_dims(arrtest.b) AS x;
68006800x
68016801---------------
6802+ [1:2][1:1][1:2]
6803+ [1:2][1:2][1:1]
68026804[1:1][1:2][1:2]
6803- [1:2][1:2]
6804- [1:2]
68056805(3 rows)
68066806
68076807QUERY: SELECT *
@@ -6819,9 +6819,9 @@ QUERY: SELECT arrtest.a[1:3],
68196819 FROM arrtest;
68206820a |b |c |d
68216821----------+---------------+-------------+-----------------
6822- {1,2,3} |{{{0,0},{1,2}}} | |
6822+ {1,2,3} |
68236823{11,12,23}| | |{{"elt1","elt2"}}
6824- |
6824+ |{{{3,4},{0,0}}} |{"foo","bar"}|
68256825(3 rows)
68266826
68276827=============== running error queries ... =================