InformixDialect has incorrect substring function

Description

InformixDialect extands default substring function

According documentation informix has 2 types of substring functions: substring(https://www.ibm.com/support/knowledgecenter/en/SSGU8G_12.1.0/com.ibm.sqls.doc/ids_sqs_1560.htm?view=embed) and substr(https://www.ibm.com/support/knowledgecenter/en/SSGU8G_12.1.0/com.ibm.sqls.doc/ids_sqs_1561.htm?view=embed)

The syntax differs between these 2 functions.
Substring function:

Example:

Substr Function:

Example:

The syntax of default Hibernate's substring function equals to substr, so I think it should be used in dialect.

Environment

None

Status

Assignee

Vlad Mihalcea

Reporter

Nikita Metzger

Fix versions

Labels

None

backPortable

None

Suitable for new contributors

None

Requires Release Note

None

Pull Request

None

backportDecision

None

Components

Affects versions

Priority

Major
Configure