to_date function returns wrong result
I expect vertica returns error when converting to date from wrong/incomplete string
which doesn't make any sense. We expect incorrect date to fail to convert.
Same query in oracle correctly gives an error (not a valid month / input value not long enough for dateformat)
I found that it actually might be a feature rather than a bug,
Is there a way how to disable this 'lenient '/unpredictable feature?