@ExcludeIn(ORACLE)
public void Substring2() {
QCompany company = QCompany.company;
StringExpression name = company.name;
Integer companyId = query().from(company).singleResult(company.id);
JPQLQuery query = query().from(company).where(company.id.eq(companyId));
String str = query.singleResult(company.name);
assertEquals(Integer.valueOf(29),
query.singleResult(name.length().subtract(11)));
assertEquals(str.substring(0, 7),
query.singleResult(name.substring(0, 7)));
assertEquals(str.substring(15),
query.singleResult(name.substring(15)));
assertEquals(str.substring(str.length()),
query.singleResult(name.substring(name.length())));
assertEquals(str.substring(str.length() - 11),
query.singleResult(name.substring(name.length().subtract(11))));
}