select repeat('hello', 1)
select repeat('hello', 20)
SELECT REPEAT('a', 2)
SELECT CONCAT('g',CONCAT(';',repeat('a',60), repeat('b',60), repeat('c',60), repeat ('d',100)),'h')
SELECT CONCAT('g',CONCAT_WS(';',repeat('a',60), repeat('b',60), repeat('c',60), repeat ('d',100)),'h')
SELECT CONCAT_WS('g',CONCAT_WS(';',repeat('a',60), repeat('b',60), repeat('c',60), repeat ('d',100)),'h')
select length(concat(repeat("a",3200),repeat("a",3200)))
select length(replace("aaaaa","a",concat(repeat("a",10000),repeat("a",12))))
select repeat('北京taos', 6)
select repeat(nch1, 6) from ts_4893.meters order by ts limit 5
select repeat(var1, 6) from ts_4893.meters order by ts limit 5
select position(nch1 in repeat(nch1,6)) from ts_4893.meters order by ts limit 5
select position(var1 in repeat(var1,6)) from ts_4893.meters order by ts limit 5
select position(nch1 in repeat(var1,6)) from ts_4893.meters where nch1 = var1 order by ts limit 5
select position(var1 in repeat(nch1,6)) from ts_4893.meters where nch1 = var1 order by ts limit 5
select repeat(nch1, id) from ts_4893.meters where id > 0 order by ts limit 5
select repeat(var1, id) from ts_4893.meters where id > 0 order by ts limit 5
select repeat('nch1', id) from ts_4893.meters where id > 0 order by ts limit 5
select repeat('var1', id) from ts_4893.meters where id > 0 order by ts limit 5
select repeat('taos', 1)
select repeat('taos', 2)
select repeat(name, 3) from ts_4893.d0 order by ts limit 10
select repeat(name, 3) from ts_4893.meters order by ts limit 10
select repeat(nch1, 3) from ts_4893.d0 order by ts limit 10
select repeat(nch1, 3) from ts_4893.meters order by ts limit 10
select repeat(var1, 3) from ts_4893.d0 order by ts limit 10
select repeat(var1, 3) from ts_4893.meters order by ts limit 10
select repeat(name, groupid) from ts_4893.d0 order by ts limit 10
select repeat(name, groupid) from ts_4893.meters order by ts limit 10
select repeat(nch1, groupid) from ts_4893.d0 order by ts limit 10
select repeat(nch1, groupid) from ts_4893.meters order by ts limit 10
select repeat(null, 3)
select repeat('taos', null)
select repeat('taos', 0)
select repeat('', 5)
select repeat('A', 0)
select repeat('A', 10)
select repeat('A B', 5)
select repeat('ABC', 1)
select repeat('Hello', 2)
select repeat('HelloWorld', 2)
select repeat('123', 5)
select repeat('12345', 3)
select repeat('!@#', 3)
select repeat('你好', 2)
select repeat('abc', length('abc'))
select repeat(concat('A', 'B', 'C'), 3)
select repeat(upper('abc'), 4)
select repeat(trim('  Hello  '), 3)
select name, repeat(name, 3) from ts_4893.meters limit 1
select name, repeat(substring(name, 1, 5), 2) from ts_4893.meters limit 1
select var1, repeat(var1, 2) from ts_4893.meters limit 1
select nch1, repeat(nch1, 4) from ts_4893.meters limit 1
