I found a possible bug at the night build SmartGWT/12.0p/EnterpriseEval\latest at 19/12/2019
When I try to fetch with Criteria textMatchStyle:"startsWith" on a field with attribute sqlStorageStrategy="ntext";
The following SQL statement is generated!
SELECT COUNT(*) FROM STYLE_SPEC WHERE (LOWER(STYLE_SPEC.SPEC_CAT) LIKEN'color%' {ESCAPE '\'} AND STYLE_SPEC.SPEC_CAT IS NOT NULL) on db: SQLServer threw exception: com.microsoft.sqlserver.jdbc.SQLServerException: Incorrect syntax near 'LIKEN'. - assuming stale connection and retrying query.
LIKEN'color%' {ESCAPE '\'} ---- THERE SHOULD BE SPACE AFTER LIKE!!
<DataSource
dbName="SQLServer"
tableName="STYLE_SPEC"
ID="STYLE_SPEC"
serverType="sql"
>
<fields>
<field name="STYLE_SPEC_ID" primaryKey="true" type="sequence" hidden="true" ></field>
<field name="SPEC_CAT" length="50" type="text" sqlStorageStrategy="ntext"></field>
</fields>
When I try to fetch with Criteria textMatchStyle:"startsWith" on a field with attribute sqlStorageStrategy="ntext";
The following SQL statement is generated!
SELECT COUNT(*) FROM STYLE_SPEC WHERE (LOWER(STYLE_SPEC.SPEC_CAT) LIKEN'color%' {ESCAPE '\'} AND STYLE_SPEC.SPEC_CAT IS NOT NULL) on db: SQLServer threw exception: com.microsoft.sqlserver.jdbc.SQLServerException: Incorrect syntax near 'LIKEN'. - assuming stale connection and retrying query.
LIKEN'color%' {ESCAPE '\'} ---- THERE SHOULD BE SPACE AFTER LIKE!!
<DataSource
dbName="SQLServer"
tableName="STYLE_SPEC"
ID="STYLE_SPEC"
serverType="sql"
>
<fields>
<field name="STYLE_SPEC_ID" primaryKey="true" type="sequence" hidden="true" ></field>
<field name="SPEC_CAT" length="50" type="text" sqlStorageStrategy="ntext"></field>
</fields>
Comment