Details
-
Bug
-
Status: Closed (View Workflow)
-
Major
-
Resolution: Incomplete
-
2.6.2
-
None
-
OS. Suse Linux Enterprise Server 12.2
Description
Hello,
we are trying to execute this query:
select csc from cscs WHERE context = :source_host AND ((INET_NTOA((-1 << (33 - INSTR(BIN(INET_ATON(subnetmask)), '0')))&INET_ATON(:src_ip))=subnetmask) OR (INET_NTOA((-1 << (33 - INSTR(BIN(INET_ATON(subnetmask)), '0')))&INET_ATON(:dst_ip))=subnetmask))
then we are getting this error message:
Java::JavaSql::SQLSyntaxErrorException: Syntax error: Encountered \"<\" at line 1, column 73.
We tried different mysql as well as mariadb connectors, but with the same result.
It seems to be, that the connector thoughts that the < is not included in the sql syntax.
Greetings
Daniel