FWD » Core Development » Database

There are known warnings printed by FqlToSqlConverter into log about Property '<identifier>' not found to extract column name. Assuming it is a column name already.
These are generated only when the FQL statement was generated in TemporaryBuffer.readAllRows and the ORDER BY clause is the result of invocation of getPrimaryOrderByClause(). This method uses the SQL name instead of the property name, breaking this way the semantics of FQL. Since these identifiers have sometimes different values, FqlToSqlConverter will fail to obtain the associated property for further processing. In this case, as the message says, it will use the identifier as it is, the SQL column name being propagated this way to SQL statement generated by FqlToSqlConverter. The result is, nevertheless, a valid SQL statement.

• emitting the correct property name in TemporaryBuffer.getPrimaryOrderByClause() - this fixes the FQL;
• attempt to replace the property with SQL column name in FqlToSqlConverter.generateProperty().

The fix did not hold because, depending on the location of the identifier, in FQL it possibly requires wrapping/decoration if a character field is processed and had to be temporarily reverted (r12365/3821c). The problem is that the information is not always available and depends on the current dialect.

Exactly.