Opened 15 years ago

Closed 14 years ago

#593 closed defect (fixed)

View Data failed for one feature with Calculation

Reported by: Aleck Owned by: Aleck
Priority: major Milestone: 3.5.0
Component: FDO API Version: 3.4.0
Severity: 3 Keywords:
Cc: External ID:

Description

When an RDBMS provider processes a computed identifier, a space in the name of the computed identifier will lead to an invalid SQL statement. Hence an exception will be thrown in this case.

This is because the name of the identifier is not in a pair of quotation marks. Therefore, a computer identifier named "new calculation" with expression "(1+1)" will generate a SQL statement SELECT (1+1) AS new calculation FROM ...

The space in the identifier name break the statement, and the solution is to put it between quotation marks.

Attachments (2)

1.patch (12.2 KB ) - added by Aleck 15 years ago.
patch
2.patch (2.2 KB ) - added by Aleck 15 years ago.
supplement patch

Download all attachments as: .zip

Change History (3)

by Aleck, 15 years ago

Attachment: 1.patch added

patch

by Aleck, 15 years ago

Attachment: 2.patch added

supplement patch

comment:1 by gregboone, 14 years ago

Resolution: fixed
Status: newclosed
Note: See TracTickets for help on using tickets.