COALESCE GROUPING SOUNDEX

rowid拦截
lob拦截？

COALESCE
参数个数>=1
返回第一个非null

GROUPING
5.7好像没有这个函数

SOUNDEX
参数个数1

1. 保留首字母：它保留字符串的第一个字母（大写）。
2. 忽略元音字母（A, E, I, O, U）以及一些其他字符，如 H, W, Y。
3. 去除连续重复字母
4. 将剩余的字母映射为数字。每个字母有一个对应的数字，具体规则如下：
   • B, F, P, V → 1
   • C, G, J, K, Q, S, X, Z → 2
   • D, T → 3
   • L → 4
   • M, N → 5
   • R → 6
5. 如果生成的编码不足四个字符，会通过数字 0 填充至四个字符。超过四个之后就不用填充了。

仅适用于英语
不适用于多字节字符集

用例

create or replace view vv as select null;
desc vv;
select COALESCE(null);
create or replace view vv as select COALESCE(null);
desc vv;
select COALESCE(null, null);
create or replace view vv as select COALESCE(null, null);
desc vv;
SELECT COALESCE(NULL,NULL,NULL);
create or replace view vv as SELECT COALESCE(NULL,NULL,NULL);
desc vv;

SELECT COALESCE(NULL,1);
create or replace view vv as SELECT COALESCE(NULL,1);
desc vv;

SELECT COALESCE(NULL,1);
create or replace view vv as SELECT COALESCE(NULL,1);
desc vv;

SELECT COALESCE(NULL,1,'test');
create or replace view vv as SELECT COALESCE(NULL,1,'test');
desc vv;

create or replace view vv as select COALESCE(151354, 3, 'a', 0x5);
desc vv;

drop table t1;
create table t1(
	ti tinyint,
	si smallint,
	ii int,
	bi bigint,
	uti tinyint unsigned,
	usi smallint unsigned,
	uii int unsigned,
	ubi bigint unsigned,
	nm  decimal(20, 10),
	fl float, 
	db double,
	ts timestamp,
	dt date,
	tim time,
	ch char(10),
	ch2 char(255),
	vc varchar(10),
	vc2 varchar(255),
	vbina varbinary(10),
	vblob blob,
	vclob text
);
insert into t1 values(1,2,-3,4,5,1,2,3,5.7, 8.0, 8.1, 
'2001-03-04 00:00:01','2001-03-04','00:01:02', '5', '6', 'a', 'b', '3', '4', '4');

select COALESCE(ti, ti) from t1;
select COALESCE(ti, si) from t1;
select COALESCE(ti, ii) from t1;
select COALESCE(ti, bi) from t1;
select COALESCE(ti, uti) from t1;
select COALESCE(ti, usi) from t1;
select COALESCE(ti, uii) from t1;
select COALESCE(ti, ubi) from t1;
select COALESCE(ti, nm) from t1;
select COALESCE(ti, fl) from t1;
select COALESCE(ti, db) from t1;
select COALESCE(ti, ts) from t1;
select COALESCE(ti, dt) from t1;
select COALESCE(ti, tim) from t1;
select COALESCE(ti, ch) from t1;
select COALESCE(ti, ch2) from t1;
select COALESCE(ti, vc) from t1;
select COALESCE(ti, vc2) from t1;
select COALESCE(ti, vbina) from t1;
select COALESCE(ti, vblob) from t1;
select COALESCE(ti, vclob) from t1;

select COALESCE(si, ti) from t1;
select COALESCE(si, si) from t1;
select COALESCE(si, ii) from t1;
select COALESCE(si, bi) from t1;
select COALESCE(si, uti) from t1;
select COALESCE(si, usi) from t1;
select COALESCE(si, uii) from t1;
select COALESCE(si, ubi) from t1;
select COALESCE(si, nm) from t1;
select COALESCE(si, fl) from t1;
select COALESCE(si, db) from t1;
select COALESCE(si, ts) from t1;
select COALESCE(si, dt) from t1;
select COALESCE(si, tim) from t1;
select COALESCE(si, ch) from t1;
select COALESCE(si, ch2) from t1;
select COALESCE(si, vc) from t1;
select COALESCE(si, vc2) from t1;
select COALESCE(si, vbina) from t1;
select COALESCE(si, vblob) from t1;
select COALESCE(si, vclob) from t1;

select COALESCE(ii, ti) from t1;
select COALESCE(ii, si) from t1;
select COALESCE(ii, ii) from t1;
select COALESCE(ii, bi) from t1;
select COALESCE(ii, uti) from t1;
select COALESCE(ii, usi) from t1;
select COALESCE(ii, uii) from t1;
select COALESCE(ii, ubi) from t1;
select COALESCE(ii, nm) from t1;
select COALESCE(ii, fl) from t1;
select COALESCE(ii, db) from t1;
select COALESCE(ii, ts) from t1;
select COALESCE(ii, dt) from t1;
select COALESCE(ii, tim) from t1;
select COALESCE(ii, ch) from t1;
select COALESCE(ii, ch2) from t1;
select COALESCE(ii, vc) from t1;
select COALESCE(ii, vc2) from t1;
select COALESCE(ii, vbina) from t1;
select COALESCE(ii, vblob) from t1;
select COALESCE(ii, vclob) from t1;

select COALESCE(bi, ti) from t1;
select COALESCE(bi, si) from t1;
select COALESCE(bi, ii) from t1;
select COALESCE(bi, bi) from t1;
select COALESCE(bi, uti) from t1;
select COALESCE(bi, usi) from t1;
select COALESCE(bi, uii) from t1;
select COALESCE(bi, ubi) from t1;
select COALESCE(bi, nm) from t1;
select COALESCE(bi, fl) from t1;
select COALESCE(bi, db) from t1;
select COALESCE(bi, ts) from t1;
select COALESCE(bi, dt) from t1;
select COALESCE(bi, tim) from t1;
select COALESCE(bi, ch) from t1;
select COALESCE(bi, ch2) from t1;
select COALESCE(bi, vc) from t1;
select COALESCE(bi, vc2) from t1;
select COALESCE(bi, vbina) from t1;
select COALESCE(bi, vblob) from t1;
select COALESCE(bi, vclob) from t1;

select COALESCE(uti, ti) from t1;
select COALESCE(uti, si) from t1;
select COALESCE(uti, ii) from t1;
select COALESCE(uti, bi) from t1;
select COALESCE(uti, uti) from t1;
select COALESCE(uti, usi) from t1;
select COALESCE(uti, uii) from t1;
select COALESCE(uti, ubi) from t1;
select COALESCE(uti, nm) from t1;
select COALESCE(uti, fl) from t1;
select COALESCE(uti, db) from t1;
select COALESCE(uti, ts) from t1;
select COALESCE(uti, dt) from t1;
select COALESCE(uti, tim) from t1;
select COALESCE(uti, ch) from t1;
select COALESCE(uti, ch2) from t1;
select COALESCE(uti, vc) from t1;
select COALESCE(uti, vc2) from t1;
select COALESCE(uti, vbina) from t1;
select COALESCE(uti, vblob) from t1;
select COALESCE(uti, vclob) from t1;

select COALESCE(usi, ti) from t1;
select COALESCE(usi, si) from t1;
select COALESCE(usi, ii) from t1;
select COALESCE(usi, bi) from t1;
select COALESCE(usi, uti) from t1;
select COALESCE(usi, usi) from t1;
select COALESCE(usi, uii) from t1;
select COALESCE(usi, ubi) from t1;
select COALESCE(usi, nm) from t1;
select COALESCE(usi, fl) from t1;
select COALESCE(usi, db) from t1;
select COALESCE(usi, ts) from t1;
select COALESCE(usi, dt) from t1;
select COALESCE(usi, tim) from t1;
select COALESCE(usi, ch) from t1;
select COALESCE(usi, ch2) from t1;
select COALESCE(usi, vc) from t1;
select COALESCE(usi, vc2) from t1;
select COALESCE(usi, vbina) from t1;
select COALESCE(usi, vblob) from t1;
select COALESCE(usi, vclob) from t1;

select COALESCE(uii, ti) from t1;
select COALESCE(uii, si) from t1;
select COALESCE(uii, ii) from t1;
select COALESCE(uii, bi) from t1;
select COALESCE(uii, uti) from t1;
select COALESCE(uii, usi) from t1;
select COALESCE(uii, uii) from t1;
select COALESCE(uii, ubi) from t1;
select COALESCE(uii, nm) from t1;
select COALESCE(uii, fl) from t1;
select COALESCE(uii, db) from t1;
select COALESCE(uii, ts) from t1;
select COALESCE(uii, dt) from t1;
select COALESCE(uii, tim) from t1;
select COALESCE(uii, ch) from t1;
select COALESCE(uii, ch2) from t1;
select COALESCE(uii, vc) from t1;
select COALESCE(uii, vc2) from t1;
select COALESCE(uii, vbina) from t1;
select COALESCE(uii, vblob) from t1;
select COALESCE(uii, vclob) from t1;

select COALESCE(ubi, ti) from t1;
select COALESCE(ubi, si) from t1;
select COALESCE(ubi, ii) from t1;
select COALESCE(ubi, bi) from t1;
select COALESCE(ubi, uti) from t1;
select COALESCE(ubi, usi) from t1;
select COALESCE(ubi, uii) from t1;
select COALESCE(ubi, ubi) from t1;
select COALESCE(ubi, nm) from t1;
select COALESCE(ubi, fl) from t1;
select COALESCE(ubi, db) from t1;
select COALESCE(ubi, ts) from t1;
select COALESCE(ubi, dt) from t1;
select COALESCE(ubi, tim) from t1;
select COALESCE(ubi, ch) from t1;
select COALESCE(ubi, ch2) from t1;
select COALESCE(ubi, vc) from t1;
select COALESCE(ubi, vc2) from t1;
select COALESCE(ubi, vbina) from t1;
select COALESCE(ubi, vblob) from t1;
select COALESCE(ubi, vclob) from t1;

select COALESCE(nm, ti) from t1;
select COALESCE(nm, si) from t1;
select COALESCE(nm, ii) from t1;
select COALESCE(nm, bi) from t1;
select COALESCE(nm, uti) from t1;
select COALESCE(nm, usi) from t1;
select COALESCE(nm, uii) from t1;
select COALESCE(nm, ubi) from t1;
select COALESCE(nm, nm) from t1;
select COALESCE(nm, fl) from t1;
select COALESCE(nm, db) from t1;
select COALESCE(nm, ts) from t1;
select COALESCE(nm, dt) from t1;
select COALESCE(nm, tim) from t1;
select COALESCE(nm, ch) from t1;
select COALESCE(nm, ch2) from t1;
select COALESCE(nm, vc) from t1;
select COALESCE(nm, vc2) from t1;
select COALESCE(nm, vbina) from t1;
select COALESCE(nm, vblob) from t1;
select COALESCE(nm, vclob) from t1;

select COALESCE(fl, ti) from t1;
select COALESCE(fl, si) from t1;
select COALESCE(fl, ii) from t1;
select COALESCE(fl, bi) from t1;
select COALESCE(fl, uti) from t1;
select COALESCE(fl, usi) from t1;
select COALESCE(fl, uii) from t1;
select COALESCE(fl, ubi) from t1;
select COALESCE(fl, nm) from t1;
select COALESCE(fl, fl) from t1;
select COALESCE(fl, db) from t1;
select COALESCE(fl, ts) from t1;
select COALESCE(fl, dt) from t1;
select COALESCE(fl, tim) from t1;
select COALESCE(fl, ch) from t1;
select COALESCE(fl, ch2) from t1;
select COALESCE(fl, vc) from t1;
select COALESCE(fl, vc2) from t1;
select COALESCE(fl, vbina) from t1;
select COALESCE(fl, vblob) from t1;
select COALESCE(fl, vclob) from t1;

select COALESCE(db, ti) from t1;
select COALESCE(db, si) from t1;
select COALESCE(db, ii) from t1;
select COALESCE(db, bi) from t1;
select COALESCE(db, uti) from t1;
select COALESCE(db, usi) from t1;
select COALESCE(db, uii) from t1;
select COALESCE(db, ubi) from t1;
select COALESCE(db, nm) from t1;
select COALESCE(db, fl) from t1;
select COALESCE(db, db) from t1;
select COALESCE(db, ts) from t1;
select COALESCE(db, dt) from t1;
select COALESCE(db, tim) from t1;
select COALESCE(db, ch) from t1;
select COALESCE(db, ch2) from t1;
select COALESCE(db, vc) from t1;
select COALESCE(db, vc2) from t1;
select COALESCE(db, vbina) from t1;
select COALESCE(db, vblob) from t1;
select COALESCE(db, vclob) from t1;

select COALESCE(ts, ti) from t1;
select COALESCE(ts, si) from t1;
select COALESCE(ts, ii) from t1;
select COALESCE(ts, bi) from t1;
select COALESCE(ts, uti) from t1;
select COALESCE(ts, usi) from t1;
select COALESCE(ts, uii) from t1;
select COALESCE(ts, ubi) from t1;
select COALESCE(ts, nm) from t1;
select COALESCE(ts, fl) from t1;
select COALESCE(ts, db) from t1;
select COALESCE(ts, ts) from t1;
select COALESCE(ts, dt) from t1;
select COALESCE(ts, tim) from t1;
select COALESCE(ts, ch) from t1;
select COALESCE(ts, ch2) from t1;
select COALESCE(ts, vc) from t1;
select COALESCE(ts, vc2) from t1;
select COALESCE(ts, vbina) from t1;
select COALESCE(ts, vblob) from t1;
select COALESCE(ts, vclob) from t1;

select COALESCE(dt, ti) from t1;
select COALESCE(dt, si) from t1;
select COALESCE(dt, ii) from t1;
select COALESCE(dt, bi) from t1;
select COALESCE(dt, uti) from t1;
select COALESCE(dt, usi) from t1;
select COALESCE(dt, uii) from t1;
select COALESCE(dt, ubi) from t1;
select COALESCE(dt, nm) from t1;
select COALESCE(dt, fl) from t1;
select COALESCE(dt, db) from t1;
select COALESCE(dt, ts) from t1;
select COALESCE(dt, dt) from t1;
select COALESCE(dt, tim) from t1;
select COALESCE(dt, ch) from t1;
select COALESCE(dt, ch2) from t1;
select COALESCE(dt, vc) from t1;
select COALESCE(dt, vc2) from t1;
select COALESCE(dt, vbina) from t1;
select COALESCE(dt, vblob) from t1;
select COALESCE(dt, vclob) from t1;

select COALESCE(tim, ti) from t1;
select COALESCE(tim, si) from t1;
select COALESCE(tim, ii) from t1;
select COALESCE(tim, bi) from t1;
select COALESCE(tim, uti) from t1;
select COALESCE(tim, usi) from t1;
select COALESCE(tim, uii) from t1;
select COALESCE(tim, ubi) from t1;
select COALESCE(tim, nm) from t1;
select COALESCE(tim, fl) from t1;
select COALESCE(tim, db) from t1;
select COALESCE(tim, ts) from t1;
select COALESCE(tim, dt) from t1;
select COALESCE(tim, tim) from t1;
select COALESCE(tim, ch) from t1;
select COALESCE(tim, ch2) from t1;
select COALESCE(tim, vc) from t1;
select COALESCE(tim, vc2) from t1;
select COALESCE(tim, vbina) from t1;
select COALESCE(tim, vblob) from t1;
select COALESCE(tim, vclob) from t1;

select COALESCE(ch, ti) from t1;
select COALESCE(ch, si) from t1;
select COALESCE(ch, ii) from t1;
select COALESCE(ch, bi) from t1;
select COALESCE(ch, uti) from t1;
select COALESCE(ch, usi) from t1;
select COALESCE(ch, uii) from t1;
select COALESCE(ch, ubi) from t1;
select COALESCE(ch, nm) from t1;
select COALESCE(ch, fl) from t1;
select COALESCE(ch, db) from t1;
select COALESCE(ch, ts) from t1;
select COALESCE(ch, dt) from t1;
select COALESCE(ch, tim) from t1;
select COALESCE(ch, ch) from t1;
select COALESCE(ch, ch2) from t1;
select COALESCE(ch, vc) from t1;
select COALESCE(ch, vc2) from t1;
select COALESCE(ch, vbina) from t1;
select COALESCE(ch, vblob) from t1;
select COALESCE(ch, vclob) from t1;

select COALESCE(ch2, ti) from t1;
select COALESCE(ch2, si) from t1;
select COALESCE(ch2, ii) from t1;
select COALESCE(ch2, bi) from t1;
select COALESCE(ch2, uti) from t1;
select COALESCE(ch2, usi) from t1;
select COALESCE(ch2, uii) from t1;
select COALESCE(ch2, ubi) from t1;
select COALESCE(ch2, nm) from t1;
select COALESCE(ch2, fl) from t1;
select COALESCE(ch2, db) from t1;
select COALESCE(ch2, ts) from t1;
select COALESCE(ch2, dt) from t1;
select COALESCE(ch2, tim) from t1;
select COALESCE(ch2, ch) from t1;
select COALESCE(ch2, ch2) from t1;
select COALESCE(ch2, vc) from t1;
select COALESCE(ch2, vc2) from t1;
select COALESCE(ch2, vbina) from t1;
select COALESCE(ch2, vblob) from t1;
select COALESCE(ch2, vclob) from t1;

select COALESCE(vc, ti) from t1;
select COALESCE(vc, si) from t1;
select COALESCE(vc, ii) from t1;
select COALESCE(vc, bi) from t1;
select COALESCE(vc, uti) from t1;
select COALESCE(vc, usi) from t1;
select COALESCE(vc, uii) from t1;
select COALESCE(vc, ubi) from t1;
select COALESCE(vc, nm) from t1;
select COALESCE(vc, fl) from t1;
select COALESCE(vc, db) from t1;
select COALESCE(vc, ts) from t1;
select COALESCE(vc, dt) from t1;
select COALESCE(vc, tim) from t1;
select COALESCE(vc, ch) from t1;
select COALESCE(vc, ch2) from t1;
select COALESCE(vc, vc) from t1;
select COALESCE(vc, vc2) from t1;
select COALESCE(vc, vbina) from t1;
select COALESCE(vc, vblob) from t1;
select COALESCE(vc, vclob) from t1;

select COALESCE(vc2, ti) from t1;
select COALESCE(vc2, si) from t1;
select COALESCE(vc2, ii) from t1;
select COALESCE(vc2, bi) from t1;
select COALESCE(vc2, uti) from t1;
select COALESCE(vc2, usi) from t1;
select COALESCE(vc2, uii) from t1;
select COALESCE(vc2, ubi) from t1;
select COALESCE(vc2, nm) from t1;
select COALESCE(vc2, fl) from t1;
select COALESCE(vc2, db) from t1;
select COALESCE(vc2, ts) from t1;
select COALESCE(vc2, dt) from t1;
select COALESCE(vc2, tim) from t1;
select COALESCE(vc2, ch) from t1;
select COALESCE(vc2, ch2) from t1;
select COALESCE(vc2, vc) from t1;
select COALESCE(vc2, vc2) from t1;
select COALESCE(vc2, vbina) from t1;
select COALESCE(vc2, vblob) from t1;
select COALESCE(vc2, vclob) from t1;

select COALESCE(vbina, ti) from t1;
select COALESCE(vbina, si) from t1;
select COALESCE(vbina, ii) from t1;
select COALESCE(vbina, bi) from t1;
select COALESCE(vbina, uti) from t1;
select COALESCE(vbina, usi) from t1;
select COALESCE(vbina, uii) from t1;
select COALESCE(vbina, ubi) from t1;
select COALESCE(vbina, nm) from t1;
select COALESCE(vbina, fl) from t1;
select COALESCE(vbina, db) from t1;
select COALESCE(vbina, ts) from t1;
select COALESCE(vbina, dt) from t1;
select COALESCE(vbina, tim) from t1;
select COALESCE(vbina, ch) from t1;
select COALESCE(vbina, ch2) from t1;
select COALESCE(vbina, vc) from t1;
select COALESCE(vbina, vc2) from t1;
select COALESCE(vbina, vbina) from t1;
select COALESCE(vbina, vblob) from t1;
select COALESCE(vbina, vclob) from t1;

select COALESCE(vblob, ti) from t1;
select COALESCE(vblob, si) from t1;
select COALESCE(vblob, ii) from t1;
select COALESCE(vblob, bi) from t1;
select COALESCE(vblob, uti) from t1;
select COALESCE(vblob, usi) from t1;
select COALESCE(vblob, uii) from t1;
select COALESCE(vblob, ubi) from t1;
select COALESCE(vblob, nm) from t1;
select COALESCE(vblob, fl) from t1;
select COALESCE(vblob, db) from t1;
select COALESCE(vblob, ts) from t1;
select COALESCE(vblob, dt) from t1;
select COALESCE(vblob, tim) from t1;
select COALESCE(vblob, ch) from t1;
select COALESCE(vblob, ch2) from t1;
select COALESCE(vblob, vc) from t1;
select COALESCE(vblob, vc2) from t1;
select COALESCE(vblob, vbina) from t1;
select COALESCE(vblob, vblob) from t1;
select COALESCE(vblob, vclob) from t1;

select COALESCE(vclob, ti) from t1;
select COALESCE(vclob, si) from t1;
select COALESCE(vclob, ii) from t1;
select COALESCE(vclob, bi) from t1;
select COALESCE(vclob, uti) from t1;
select COALESCE(vclob, usi) from t1;
select COALESCE(vclob, uii) from t1;
select COALESCE(vclob, ubi) from t1;
select COALESCE(vclob, nm) from t1;
select COALESCE(vclob, fl) from t1;
select COALESCE(vclob, db) from t1;
select COALESCE(vclob, ts) from t1;
select COALESCE(vclob, dt) from t1;
select COALESCE(vclob, tim) from t1;
select COALESCE(vclob, ch) from t1;
select COALESCE(vclob, ch2) from t1;
select COALESCE(vclob, vc) from t1;
select COALESCE(vclob, vc2) from t1;
select COALESCE(vclob, vbina) from t1;
select COALESCE(vclob, vblob) from t1;
select COALESCE(vclob, vclob) from t1;


create or replace view vv as  select COALESCE(si, vclob) from t1;
desc vv;

create or replace view vv as  select COALESCE(si, vclob) from t1;
desc vv;

select SOUNDEX('6');
select SOUNDEX('s');
select SOUNDEX('S');
select SOUNDEX(6);
select SOUNDEX('e');
select SOUNDEX('ee');
select SOUNDEX('eea');
select SOUNDEX('ddadddddddabcdefghijklmnl');
select SOUNDEX('Robert');
select SOUNDEX('Rupert');
select SOUNDEX('Rubin');
select SOUNDEX('Ashcraft');
select SOUNDEX('Ashcroft');
select SOUNDEX('Tymczak');
select SOUNDEX('Pfister');
select SOUNDEX('Honeyman');
select SOUNDEX('Jackson');
select SOUNDEX('Smith');
select SOUNDEX('Smyth');
select SOUNDEX('Ghosh');
select SOUNDEX('Ghoshhhhh');
select SOUNDEX('Ellery');
select SOUNDEX('Euler');
select SOUNDEX('Example');
select SOUNDEX('Excelsior');
select SOUNDEX('Ae');
select SOUNDEX('Aa');
select SOUNDEX('Bb');
select SOUNDEX('cc');
select SOUNDEX('dd');
select SOUNDEX('ll');
select SOUNDEX('mm');
select SOUNDEX('nn');
select SOUNDEX('rr');
select SOUNDEX('xyz');
select SOUNDEX('qrs');
select SOUNDEX('aeiou');
select SOUNDEX('why');
select SOUNDEX('hw');
select SOUNDEX('wh');
select SOUNDEX('');
select SOUNDEX('123');
select SOUNDEX('abc123def');
select SOUNDEX('BFPV');
select SOUNDEX('CGJKQXZ');
select SOUNDEX('DT');
select SOUNDEX('L');
select SOUNDEX('MN');
select SOUNDEX('R');
select SOUNDEX(123);
select SOUNDEX(0);
select SOUNDEX(-456);
select SOUNDEX(3.14159);
select SOUNDEX(true);
select SOUNDEX(false);
select SOUNDEX(null);
select SOUNDEX(date'2025-12-14');
select SOUNDEX(timestamp'2025-12-14 10:30:00');
select SOUNDEX(interval '5 days');
select SOUNDEX('   ');
select SOUNDEX('\t\n\r');
select SOUNDEX('!@#$%^&*()');
select SOUNDEX('1a2b3c');
select SOUNDEX('A1B2C3');
select SOUNDEX('中文');
select SOUNDEX('مرحبا');
select SOUNDEX('🙂');
select SOUNDEX('αβγ');
select SOUNDEX('कखग');
select SOUNDEX(ti) from t1;
select SOUNDEX(si) from t1;
select SOUNDEX(ii) from t1;
select SOUNDEX(bi) from t1;
select SOUNDEX(uti) from t1;
select SOUNDEX(usi) from t1;
select SOUNDEX(uii) from t1;
select SOUNDEX(ubi) from t1;
select SOUNDEX(nm) from t1;
select SOUNDEX(fl) from t1;
select SOUNDEX(db) from t1;
select SOUNDEX(ts) from t1;
select SOUNDEX(dt) from t1;
select SOUNDEX(tim) from t1;
select SOUNDEX(ch) from t1;
select SOUNDEX(ch2) from t1;
select SOUNDEX(vc) from t1;
select SOUNDEX(vc2) from t1;
select SOUNDEX(vbina) from t1;
select SOUNDEX(vblob) from t1;
select SOUNDEX(vclob) from t1;

create or replace view vv as select SOUNDEX('6');
desc vv;
create or replace view vv as select SOUNDEX('s');
desc vv;
create or replace view vv as select SOUNDEX('S');
desc vv;
create or replace view vv as select SOUNDEX(6);
desc vv;
create or replace view vv as select soundex('eat');
desc vv;