| DESCRIBE FUNCTION mask; |
| DESC FUNCTION EXTENDED mask; |
| |
| explain select mask('TestString-123', 'X', 'x', '0', '1'); |
| |
| select mask('TestString-123', 'X', 'x', '0', ':'), |
| mask(cast('TestString-123' as varchar(24)), 'X', 'x', '0', ':'), |
| mask(cast('TestString-123' as char(24)), 'X', 'x', '0', ':'), |
| mask(cast(0 as tinyint), -1, -1, -1, -1, 4), |
| mask(cast(0 as smallint), -1, -1, -1, -1, 4), |
| mask(cast(0 as int), -1, -1, -1, -1, 4), |
| mask(cast(0 as bigint), -1, -1, -1, -1, 4), |
| mask(cast(123 as tinyint), -1, -1, -1, -1, '5'), |
| mask(cast(12345 as smallint), -1, -1, -1, -1, '5'), |
| mask(cast(12345 as int), -1, -1, -1, -1, '5'), |
| mask(cast(12345 as bigint), -1, -1, -1, -1, '5'), |
| mask(cast('2016-04-20' as date), -1, -1, -1, -1, -1, 0, 0, 0), |
| mask(cast('2016-04-20' as date), -1, -1, -1, -1, -1, -1, 0, 0), |
| mask(cast('2016-04-20' as date), -1, -1, -1, -1, -1, 1, -1, 0), |
| mask(cast('2016-04-20' as date), -1, -1, -1, -1, -1, 1, 0, -1), |
| mask(cast('2016-04-20' as date), -1, -1, -1, -1, -1, 1, -1, -1), |
| mask(cast('2016-04-20' as date), -1, -1, -1, -1, -1, -1, 0, -1), |
| mask(cast('2016-04-20' as date), -1, -1, -1, -1, -1, -1, -1, 0), |
| mask(cast('2016-04-20' as date), -1, -1, -1, -1, -1, -1, -1, -1); |