Loading...

XML

Word

Printable

Type: Bug
Resolution: Done
Priority: Major
Fix Version/s: 9.0, 8.12.5
Affects Version/s: 8.12.3
Component/s: JDBC Connector
Labels:
None

Workaround:

Workaround Exists
Workaround Description:

Hide

Cast to tinyint before calling MIN/MAX

Show
Cast to tinyint before calling MIN/MAX
Bugzilla References:
https://bugzilla.redhat.com/show_bug.cgi?id=1306991

Vertica does not support calling MIN and MAX aggregate functions on boolean values, attempting that fails with

Remote com.vertica.support.exceptions.SyntaxErrorException: [Vertica][VJDBC](3457) ERROR: Function MIN(boolean) does not exist, or permission is denied for MIN(boolean)

is related to

TEIID-3812 HANA MIN and MAX functions not applicable on boolean

Closed

Assignee:: Steven Hawkins

Reporter:: Andrej Smigala

Votes:: 0 Vote for this issue

Watchers:: 3 Start watching this issue

Created:: 2016/02/12 6:50 AM

Updated:: 2017/12/06 10:33 AM

Resolved:: 2016/02/12 3:39 PM