PREHOOK: query: -- Should all be true
select
  cast('abc' as char(10)) =  cast('abc' as char(10)),
  cast('abc' as char(10)) <= cast('abc' as char(10)),
  cast('abc' as char(10)) >= cast('abc' as char(10)),
  cast('abc' as char(10)) <  cast('abd' as char(10)),
  cast('abc' as char(10)) >  cast('abb' as char(10)),
  cast('abc' as char(10)) <> cast('abb' as char(10))
from src limit 1
PREHOOK: type: QUERY
PREHOOK: Input: default@src
#### A masked pattern was here ####
POSTHOOK: query: -- Should all be true
select
  cast('abc' as char(10)) =  cast('abc' as char(10)),
  cast('abc' as char(10)) <= cast('abc' as char(10)),
  cast('abc' as char(10)) >= cast('abc' as char(10)),
  cast('abc' as char(10)) <  cast('abd' as char(10)),
  cast('abc' as char(10)) >  cast('abb' as char(10)),
  cast('abc' as char(10)) <> cast('abb' as char(10))
from src limit 1
POSTHOOK: type: QUERY
POSTHOOK: Input: default@src
#### A masked pattern was here ####
true	true	true	true	true	true
PREHOOK: query: -- Different char lengths should still compare the same
select
  cast('abc' as char(10)) =  cast('abc' as char(3)),
  cast('abc' as char(10)) <= cast('abc' as char(3)),
  cast('abc' as char(10)) >= cast('abc' as char(3)),
  cast('abc' as char(10)) <  cast('abd' as char(3)),
  cast('abc' as char(10)) >  cast('abb' as char(3)),
  cast('abc' as char(10)) <> cast('abb' as char(3))
from src limit 1
PREHOOK: type: QUERY
PREHOOK: Input: default@src
#### A masked pattern was here ####
POSTHOOK: query: -- Different char lengths should still compare the same
select
  cast('abc' as char(10)) =  cast('abc' as char(3)),
  cast('abc' as char(10)) <= cast('abc' as char(3)),
  cast('abc' as char(10)) >= cast('abc' as char(3)),
  cast('abc' as char(10)) <  cast('abd' as char(3)),
  cast('abc' as char(10)) >  cast('abb' as char(3)),
  cast('abc' as char(10)) <> cast('abb' as char(3))
from src limit 1
POSTHOOK: type: QUERY
POSTHOOK: Input: default@src
#### A masked pattern was here ####
true	true	true	true	true	true
PREHOOK: query: -- Should work with string types as well
select
  cast('abc' as char(10)) =  'abc',
  cast('abc' as char(10)) <= 'abc',
  cast('abc' as char(10)) >= 'abc',
  cast('abc' as char(10)) <  'abd',
  cast('abc' as char(10)) >  'abb',
  cast('abc' as char(10)) <> 'abb'
from src limit 1
PREHOOK: type: QUERY
PREHOOK: Input: default@src
#### A masked pattern was here ####
POSTHOOK: query: -- Should work with string types as well
select
  cast('abc' as char(10)) =  'abc',
  cast('abc' as char(10)) <= 'abc',
  cast('abc' as char(10)) >= 'abc',
  cast('abc' as char(10)) <  'abd',
  cast('abc' as char(10)) >  'abb',
  cast('abc' as char(10)) <> 'abb'
from src limit 1
POSTHOOK: type: QUERY
POSTHOOK: Input: default@src
#### A masked pattern was here ####
true	true	true	true	true	true
PREHOOK: query: -- leading space is significant for char
select
  cast(' abc' as char(10)) <> cast('abc' as char(10))
from src limit 1
PREHOOK: type: QUERY
PREHOOK: Input: default@src
#### A masked pattern was here ####
POSTHOOK: query: -- leading space is significant for char
select
  cast(' abc' as char(10)) <> cast('abc' as char(10))
from src limit 1
POSTHOOK: type: QUERY
POSTHOOK: Input: default@src
#### A masked pattern was here ####
true
PREHOOK: query: -- trailing space is not significant for char
select
  cast('abc ' as char(10)) = cast('abc' as char(10))
from src limit 1
PREHOOK: type: QUERY
PREHOOK: Input: default@src
#### A masked pattern was here ####
POSTHOOK: query: -- trailing space is not significant for char
select
  cast('abc ' as char(10)) = cast('abc' as char(10))
from src limit 1
POSTHOOK: type: QUERY
POSTHOOK: Input: default@src
#### A masked pattern was here ####
true