PREHOOK: query: -- cast string floats to integer types
select
  cast('1' as float),
  cast('1.4' as float),
  cast('1.6' as float),
  cast('1' as int),
  cast('1.4' as int),
  cast('1.6' as int),
  cast('1' as tinyint),
  cast('1.4' as tinyint),
  cast('1.6' as tinyint),
  cast('1' as smallint),
  cast('1.4' as smallint),
  cast('1.6' as smallint),
  cast('1' as bigint),
  cast('1.4' as bigint),
  cast('1.6' as bigint),
  cast (cast('1' as float) as int),
  cast(cast ('1.4' as float) as int),
  cast(cast ('1.6' as float) as int),
  cast('+1e5' as int),
  cast('2147483647' as int),
  cast('-2147483648' as int),
  cast('32767' as smallint),
  cast('-32768' as smallint),
  cast('-128' as tinyint),
  cast('127' as tinyint),
  cast('1.0a' as int),
  cast('-1.-1' as int)
from src limit 1
PREHOOK: type: QUERY
PREHOOK: Input: default@src
#### A masked pattern was here ####
POSTHOOK: query: -- cast string floats to integer types
select
  cast('1' as float),
  cast('1.4' as float),
  cast('1.6' as float),
  cast('1' as int),
  cast('1.4' as int),
  cast('1.6' as int),
  cast('1' as tinyint),
  cast('1.4' as tinyint),
  cast('1.6' as tinyint),
  cast('1' as smallint),
  cast('1.4' as smallint),
  cast('1.6' as smallint),
  cast('1' as bigint),
  cast('1.4' as bigint),
  cast('1.6' as bigint),
  cast (cast('1' as float) as int),
  cast(cast ('1.4' as float) as int),
  cast(cast ('1.6' as float) as int),
  cast('+1e5' as int),
  cast('2147483647' as int),
  cast('-2147483648' as int),
  cast('32767' as smallint),
  cast('-32768' as smallint),
  cast('-128' as tinyint),
  cast('127' as tinyint),
  cast('1.0a' as int),
  cast('-1.-1' as int)
from src limit 1
POSTHOOK: type: QUERY
POSTHOOK: Input: default@src
#### A masked pattern was here ####
1.0	1.4	1.6	1	1	1	1	1	1	1	1	1	1	1	1	1	1	1	NULL	2147483647	-2147483648	32767	-32768	-128	127	NULL	NULL