select trim('foo')
select trim('foo' from 'foobarfoo')
select trim(trailing 'foo' from 'foobarfoo')
select trim(leading 'foo' from 'foobarfoo')
select trim(both 'foo' from 'foobarfoo')
select trim('   blank     ')
select trim(both ' ' from '   bla  nk     ')
select trim(leading ' ' from '   bla  nk')
select trim(trailing ' ' from '   bla  nk     ')
select trim(' ' from '   blank     ')
select TRIM(BOTH 'å' FROM 'aæaå')
select trim('  中文测试  ')
select trim(both ' ' from '  中文测试  ')
select trim(leading ' ' from '  中文测试')
select trim(trailing ' ' from '  中文测试  ')
select trim(' ' from '  中文测试  ')
select trim('一' from '一二中文测试一')
select trim(both '一' from '一二中文测试一')
select trim(leading '一' from '一二中文测试一')
select trim(trailing '一' from '一二中文测试一')
select trim('   中文andEnglish测试Test   ')
select trim(both ' ' from '   中文andEnglish测试Test   ')
select trim(leading ' ' from '   中文andEnglish测试Test')
select trim(trailing ' ' from '   中文andEnglish测试Test   ')
select trim('空格' from '空格中文andEngTes空格空格')
select trim(both '空格' from '空格中文andEngTes空格空格')
select trim(leading '空格' from '空格中文andEngTes空格空格')
select trim(trailing '空格' from '空格中文andEngTes空格空格')
select trim('blank' from 'blankblank中文andEnglish测试Tesblankblankblank')
select trim(both 'blank' from 'blankblank中文andEnglish测试Tesblankblankblank')
select trim(leading 'blank' from 'blankblank中文andEnglish测试Tesblankblankblank')
select trim(trailing 'blank' from 'blankblank中文andEnglish测试Tesblankblankblank')
select trim('空格blank' from '空格blank空格中Tes空格blank空')
select trim(both '空格blank' from '空格blank空格中Tes空格blank空')
select trim(leading '空格blank' from '空格blank空格中Tes空格blank空')
select trim(trailing '空格blank' from '空格blank空格中Tes空格blank空')
select trim(both from nch1) from ts_4893.meters order by ts limit 5
select trim(leading from nch1) from ts_4893.meters order by ts limit 5
select trim(trailing from nch1) from ts_4893.meters order by ts limit 5
select trim(nch2 from nch1) from ts_4893.meters where position(nch2 in nch1) != 0 order by ts limit 5
select trim(both nch2 from nch1) from ts_4893.meters where position(nch2 in nch1) != 0 order by ts limit 5
select trim(leading nch2 from nch1) from ts_4893.meters where position(nch2 in nch1) != 0 order by ts limit 5
select trim(trailing nch2 from nch1) from ts_4893.meters where position(nch2 in nch1) != 0 order by ts limit 5
select trim(nch2 from nch1) from ts_4893.meters where position(nch2 in nch1) = 0 order by ts limit 5
select trim(both nch2 from nch1) from ts_4893.meters where position(nch2 in nch1) = 0 order by ts limit 5
select trim(leading nch2 from nch1) from ts_4893.meters where position(nch2 in nch1) = 0 order by ts limit 5
select trim(trailing nch2 from nch1) from ts_4893.meters where position(nch2 in nch1) = 0 order by ts limit 5
select trim(var2 from nch1) from ts_4893.meters where position(var2 in nch1) != 0 order by ts limit 5
select trim(both var2 from nch1) from ts_4893.meters where position(var2 in nch1) != 0 order by ts limit 5
select trim(leading var2 from nch1) from ts_4893.meters where position(var2 in nch1) != 0 order by ts limit 5
select trim(trailing var2 from nch1) from ts_4893.meters where position(var2 in nch1) != 0 order by ts limit 5
select trim(var2 from nch1) from ts_4893.meters where position(var2 in nch1) = 0 order by ts limit 5
select trim(both var2 from nch1) from ts_4893.meters where position(var2 in nch1) = 0 order by ts limit 5
select trim(leading var2 from nch1) from ts_4893.meters where position(var2 in nch1) = 0 order by ts limit 5
select trim(trailing var2 from nch1) from ts_4893.meters where position(var2 in nch1) = 0 order by ts limit 5
select trim(nch2 from var1) from ts_4893.meters where position(nch2 in var1) != 0 order by ts limit 5
select trim(both nch2 from var1) from ts_4893.meters where position(nch2 in var1) != 0 order by ts limit 5
select trim(leading nch2 from var1) from ts_4893.meters where position(nch2 in var1) != 0 order by ts limit 5
select trim(trailing nch2 from var1) from ts_4893.meters where position(nch2 in var1) != 0 order by ts limit 5
select trim(nch2 from var1) from ts_4893.meters where position(nch2 in var1) = 0 order by ts limit 5
select trim(both nch2 from var1) from ts_4893.meters where position(nch2 in var1) = 0 order by ts limit 5
select trim(leading nch2 from var1) from ts_4893.meters where position(nch2 in var1) = 0 order by ts limit 5
select trim(trailing nch2 from var1) from ts_4893.meters where position(nch2 in var1) = 0 order by ts limit 5
select trim(var2 from var1) from ts_4893.meters where position(var2 in var1) != 0 order by ts limit 5
select trim(both var2 from var1) from ts_4893.meters where position(var2 in var1) != 0 order by ts limit 5
select trim(leading var2 from var1) from ts_4893.meters where position(var2 in var1) != 0 order by ts limit 5
select trim(trailing var2 from var1) from ts_4893.meters where position(var2 in var1) != 0 order by ts limit 5
select trim(var2 from var1) from ts_4893.meters where position(var2 in var1) = 0 order by ts limit 5
select trim(both var2 from var1) from ts_4893.meters where position(var2 in var1) = 0 order by ts limit 5
select trim(leading var2 from var1) from ts_4893.meters where position(var2 in var1) = 0 order by ts limit 5
select trim(trailing var2 from var1) from ts_4893.meters where position(var2 in var1) = 0 order by ts limit 5
select trim('一' from nch1) from ts_4893.meters where position('一' in nch1) != 0 order by ts limit 5
select trim(both '一' from nch1) from ts_4893.meters where position('一' in nch1) != 0 order by ts limit 5
select trim(leading '一' from nch1) from ts_4893.meters where position('一' in nch1) != 0 order by ts limit 5
select trim(trailing '一' from nch1) from ts_4893.meters where position('一' in nch1) != 0 order by ts limit 5
select trim('一' from nch1) from ts_4893.meters where position('一' in nch1) = 0 order by ts limit 5
select trim(both '一' from nch1) from ts_4893.meters where position('一' in nch1) = 0 order by ts limit 5
select trim(leading '一' from nch1) from ts_4893.meters where position('一' in nch1) = 0 order by ts limit 5
select trim(trailing '一' from nch1) from ts_4893.meters where position('一' in nch1) = 0 order by ts limit 5
select trim('一' from var1) from ts_4893.meters where position('一' in var1) != 0 order by ts limit 5
select trim(both '一' from var1) from ts_4893.meters where position('一' in var1) != 0 order by ts limit 5
select trim(leading '一' from var1) from ts_4893.meters where position('一' in var1) != 0 order by ts limit 5
select trim(trailing '一' from var1) from ts_4893.meters where position('一' in var1) != 0 order by ts limit 5
select trim('一' from var1) from ts_4893.meters where position('一' in var1) = 0 order by ts limit 5
select trim(both '一' from var1) from ts_4893.meters where position('一' in var1) = 0 order by ts limit 5
select trim(leading '一' from var1) from ts_4893.meters where position('一' in var1) = 0 order by ts limit 5
select trim(trailing '一' from var1) from ts_4893.meters where position('一' in var1) = 0 order by ts limit 5
select trim(nch2 from '三abbcfp三a') from ts_4893.meters where position(nch2 in '三abbcfp三a') != 0 order by ts limit 5
select trim(both nch2 from '三abbcfp三a') from ts_4893.meters where position(nch2 in '三abbcfp三a') != 0 order by ts limit 5
select trim(leading nch2 from '三abbcfp三a') from ts_4893.meters where position(nch2 in '三abbcfp三a') != 0 order by ts limit 5
select trim(trailing nch2 from '三abbcfp三a') from ts_4893.meters where position(nch2 in '三abbcfp三a') != 0 order by ts limit 5
select trim(nch2 from '三abbcfp三a') from ts_4893.meters where position(nch2 in '三abbcfp三a') = 0 order by ts limit 5
select trim(both nch2 from '三abbcfp三a') from ts_4893.meters where position(nch2 in '三abbcfp三a') = 0 order by ts limit 5
select trim(leading nch2 from '三abbcfp三a') from ts_4893.meters where position(nch2 in '三abbcfp三a') = 0 order by ts limit 5
select trim(trailing nch2 from '三abbcfp三a') from ts_4893.meters where position(nch2 in '三abbcfp三a') = 0 order by ts limit 5
select trim(var2 from '三abbcfp三a') from ts_4893.meters where position(var2 in '三abbcfp三a') != 0 order by ts limit 5
select trim(both var2 from '三abbcfp三a') from ts_4893.meters where position(var2 in '三abbcfp三a') != 0 order by ts limit 5
select trim(leading var2 from '三abbcfp三a') from ts_4893.meters where position(var2 in '三abbcfp三a') != 0 order by ts limit 5
select trim(trailing var2 from '三abbcfp三a') from ts_4893.meters where position(var2 in '三abbcfp三a') != 0 order by ts limit 5
select trim(var2 from '三abbcfp三a') from ts_4893.meters where position(var2 in '三abbcfp三a') = 0 order by ts limit 5
select trim(both var2 from '三abbcfp三a') from ts_4893.meters where position(var2 in '三abbcfp三a') = 0 order by ts limit 5
select trim(leading var2 from '三abbcfp三a') from ts_4893.meters where position(var2 in '三abbcfp三a') = 0 order by ts limit 5
select trim(trailing var2 from '三abbcfp三a') from ts_4893.meters where position(var2 in '三abbcfp三a') = 0 order by ts limit 5
select trim('     A      ')
select trim('     涛思      ')
select trim('a' FROM 'aaab      bbba')
select trim(LEADING FROM '      aaa      ')
select trim(LEADING 'a' FROM '   aaa    abab   aaaa   ')
select trim(LEADING 'a' FROM 'aaa    abab   aaaa   ')
select trim(LEADING '北' FROM '北京涛思数据科技有限公司北')
select trim(LEADING '北' FROM '北bei京涛思数据科技有限公司北')
select trim(TRAILING FROM '   aaa    abab   aaaa   ')
select trim(TRAILING 'a' FROM 'aaa    abab   aaaa')
select trim(TRAILING 'a' FROM '   aaa    abab   aaaa')
select trim(TRAILING '北' FROM '北京涛思数据科技有限公司北') as sub
select trim(TRAILING '北' FROM '北京涛思数据科技有限公司bei北')
select trim(BOTH FROM '   aaa    abab   aaaa   ')
select trim(BOTH 'a' FROM '   aaa    abab   aaaa    ')
select trim(BOTH 'a' FROM 'aaa    abab   aaaa')
select trim(BOTH '北' FROM '北京涛思数据科技有限公司北')
select trim(nch2 from nch1) from ts_4893.d0 order by ts limit 10
select trim(nch2 from nch1) from ts_4893.meters order by ts limit 10
select trim(nch2 from var1) from ts_4893.d0 order by ts limit 10
select trim(nch2 from var1) from ts_4893.meters order by ts limit 10
select trim(var2 from nch1) from ts_4893.d0 order by ts limit 10
select trim(var2 from nch1) from ts_4893.meters order by ts limit 10
select trim(var2 from var1) from ts_4893.d0 order by ts limit 10
select trim(var2 from var1) from ts_4893.meters order by ts limit 10
select trim(null)
select trim('')
select trim(leading ' ' from '   hello')
select trim(trailing ' ' from 'hello   ')
select trim('0' from '000123000')
select trim('  hello  ')
select trim('   apple banana   ')
select var2, trim('*' from var2) from ts_4893.meters limit 1
select trim('x' from 'hello')
select trim('longer' from 'short')
select trim('hello')
select trim('   12345   ')
select trim(concat('   hello', '   world   '))
select trim(upper('  hello world  '))
select trim(substring('   hello world   ', 4))
select trim(replace('   hello world   ', ' ', '-'))
select name, trim(name) from ts_4893.meters limit 1
select var1, trim(trailing '!' from var1) from ts_4893.meters limit 1
select nch1, trim(leading '-' from nch1) from ts_4893.meters limit 1
