USE tpch1;
select cidx, cdouble, repeat(cdouble, 3) from datatypetestm order by cidx;
cidx	cdouble	repeat(cdouble, 3)
1	-1.797693231e108	-1.79769e108-1.79769e108-1.79769e108
2	-1.79769323e108	-1.79769e108-1.79769e108-1.79769e108
3	-1.797693229e108	-1.79769e108-1.79769e108-1.79769e108
4	-1.797693228e108	-1.79769e108-1.79769e108-1.79769e108
5	-1.797693227e108	-1.79769e108-1.79769e108-1.79769e108
6	1.797693227e108	1.79769e1081.79769e1081.79769e108
7	1.797693228e108	1.79769e1081.79769e1081.79769e108
8	1.797693229e108	1.79769e1081.79769e1081.79769e108
9	1.79769323e108	1.79769e1081.79769e1081.79769e108
10	1.797693231e108	1.79769e1081.79769e1081.79769e108
11	0	000
select cidx, cfloat,  repeat(cfloat, 3) from datatypetestm order by cidx;
cidx	cfloat	repeat(cfloat, 3)
1	-3.40287e18	-3.40287e18-3.40287e18-3.40287e18
2	-3.40287e18	-3.40287e18-3.40287e18-3.40287e18
3	-3.40286e18	-3.40286e18-3.40286e18-3.40286e18
4	-3.40286e18	-3.40286e18-3.40286e18-3.40286e18
5	-3.40286e18	-3.40286e18-3.40286e18-3.40286e18
6	3.40286e18	3.40286e183.40286e183.40286e18
7	3.40286e18	3.40286e183.40286e183.40286e18
8	3.40286e18	3.40286e183.40286e183.40286e18
9	3.40287e18	3.40287e183.40287e183.40287e18
10	3.40287e18	3.40287e183.40287e183.40287e18
11	0	000
select cidx, cdouble, concat(cdouble, 'abc') from datatypetestm order by cidx;
cidx	cdouble	concat(cdouble, 'abc')
1	-1.797693231e108	-1.79769e108abc
2	-1.79769323e108	-1.79769e108abc
3	-1.797693229e108	-1.79769e108abc
4	-1.797693228e108	-1.79769e108abc
5	-1.797693227e108	-1.79769e108abc
6	1.797693227e108	1.79769e108abc
7	1.797693228e108	1.79769e108abc
8	1.797693229e108	1.79769e108abc
9	1.79769323e108	1.79769e108abc
10	1.797693231e108	1.79769e108abc
11	0	0abc
select cidx, cfloat,  concat(cfloat, 'abc') from datatypetestm order by cidx;
cidx	cfloat	concat(cfloat, 'abc')
1	-3.40287e18	-3.40287e18abc
2	-3.40287e18	-3.40287e18abc
3	-3.40286e18	-3.40286e18abc
4	-3.40286e18	-3.40286e18abc
5	-3.40286e18	-3.40286e18abc
6	3.40286e18	3.40286e18abc
7	3.40286e18	3.40286e18abc
8	3.40286e18	3.40286e18abc
9	3.40287e18	3.40287e18abc
10	3.40287e18	3.40287e18abc
11	0	0abc
select cidx, cdouble, concat_ws('|', cdouble, 'abc') from datatypetestm order by cidx;
cidx	cdouble	concat_ws('|', cdouble, 'abc')
1	-1.797693231e108	-1.79769e108|abc
2	-1.79769323e108	-1.79769e108|abc
3	-1.797693229e108	-1.79769e108|abc
4	-1.797693228e108	-1.79769e108|abc
5	-1.797693227e108	-1.79769e108|abc
6	1.797693227e108	1.79769e108|abc
7	1.797693228e108	1.79769e108|abc
8	1.797693229e108	1.79769e108|abc
9	1.79769323e108	1.79769e108|abc
10	1.797693231e108	1.79769e108|abc
11	0	0|abc
select cidx, cfloat,  concat_ws('|', cfloat, 'abc') from datatypetestm order by cidx;
cidx	cfloat	concat_ws('|', cfloat, 'abc')
1	-3.40287e18	-3.40287e18|abc
2	-3.40287e18	-3.40287e18|abc
3	-3.40286e18	-3.40286e18|abc
4	-3.40286e18	-3.40286e18|abc
5	-3.40286e18	-3.40286e18|abc
6	3.40286e18	3.40286e18|abc
7	3.40286e18	3.40286e18|abc
8	3.40286e18	3.40286e18|abc
9	3.40287e18	3.40287e18|abc
10	3.40287e18	3.40287e18|abc
11	0	0|abc
select cidx, cdouble, elt(1, cdouble, cfloat) from datatypetestm order by cidx;
cidx	cdouble	elt(1, cdouble, cfloat)
1	-1.797693231e108	-1.79769e108
2	-1.79769323e108	-1.79769e108
3	-1.797693229e108	-1.79769e108
4	-1.797693228e108	-1.79769e108
5	-1.797693227e108	-1.79769e108
6	1.797693227e108	1.79769e108
7	1.797693228e108	1.79769e108
8	1.797693229e108	1.79769e108
9	1.79769323e108	1.79769e108
10	1.797693231e108	1.79769e108
11	0	0
select cidx, cdouble, elt(2, cdouble, cfloat) from datatypetestm order by cidx;
cidx	cdouble	elt(2, cdouble, cfloat)
1	-1.797693231e108	-3.40287e18
2	-1.79769323e108	-3.40287e18
3	-1.797693229e108	-3.40286e18
4	-1.797693228e108	-3.40286e18
5	-1.797693227e108	-3.40286e18
6	1.797693227e108	3.40286e18
7	1.797693228e108	3.40286e18
8	1.797693229e108	3.40286e18
9	1.79769323e108	3.40287e18
10	1.797693231e108	3.40287e18
11	0	0
select cidx, cdouble, insert(cdouble, 3, 4, 'abc') from datatypetestm order by cidx;
cidx	cdouble	insert(cdouble, 3, 4, 'abc')
1	-1.797693231e108	-1abc69e108
2	-1.79769323e108	-1abc69e108
3	-1.797693229e108	-1abc69e108
4	-1.797693228e108	-1abc69e108
5	-1.797693227e108	-1abc69e108
6	1.797693227e108	1.abc9e108
7	1.797693228e108	1.abc9e108
8	1.797693229e108	1.abc9e108
9	1.79769323e108	1.abc9e108
10	1.797693231e108	1.abc9e108
11	0	0
select cidx, cfloat,  insert(cfloat, 3, 4, 'abc') from datatypetestm order by cidx;
cidx	cfloat	insert(cfloat, 3, 4, 'abc')
1	-3.40287e18	-3abc87e18
2	-3.40287e18	-3abc87e18
3	-3.40286e18	-3abc86e18
4	-3.40286e18	-3abc86e18
5	-3.40286e18	-3abc86e18
6	3.40286e18	3.abc6e18
7	3.40286e18	3.abc6e18
8	3.40286e18	3.abc6e18
9	3.40287e18	3.abc7e18
10	3.40287e18	3.abc7e18
11	0	0
select cidx, cdouble, reverse(cdouble) from datatypetestm order by cidx;
cidx	cdouble	reverse(cdouble)
1	-1.797693231e108	801e96797.1-
2	-1.79769323e108	801e96797.1-
3	-1.797693229e108	801e96797.1-
4	-1.797693228e108	801e96797.1-
5	-1.797693227e108	801e96797.1-
6	1.797693227e108	801e96797.1
7	1.797693228e108	801e96797.1
8	1.797693229e108	801e96797.1
9	1.79769323e108	801e96797.1
10	1.797693231e108	801e96797.1
11	0	0
select cidx, cfloat,  reverse(cfloat) from datatypetestm order by cidx;
cidx	cfloat	reverse(cfloat)
1	-3.40287e18	81e78204.3-
2	-3.40287e18	81e78204.3-
3	-3.40286e18	81e68204.3-
4	-3.40286e18	81e68204.3-
5	-3.40286e18	81e68204.3-
6	3.40286e18	81e68204.3
7	3.40286e18	81e68204.3
8	3.40286e18	81e68204.3
9	3.40287e18	81e78204.3
10	3.40287e18	81e78204.3
11	0	0