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

Activity

Show:
Vlad Mihalcea
June 16, 2016, 1:28 PM

We might want to backport this to 5.1 and 5.0 too.

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