View Issue Details
| ID | Project | Category | View Status | Date Submitted | Last Update |
|---|---|---|---|---|---|
| 0001023 | Database Workbench v5 | Visual Query Builder | public | 2014-09-09 15:03 | 2014-09-18 10:36 |
| Reporter | Martijn Tonies | Assigned To | Martijn Tonies | ||
| Priority | normal | Severity | minor | Reproducibility | always |
| Status | closed | Resolution | fixed | ||
| Platform | 64bit Desktop | OS | Windows 7 x64 | OS Version | 6.1.7601 |
| Product Version | 5.0 | ||||
| Fixed in Version | 5.0.2 | ||||
| Summary | 0001023: Firebird TRIM Function with extended paramters not correctly parsed by VQB. | ||||
| Description | The VQB can only parse a very basic TRIM(Varchar) function but breaks as soon as extra parameters are present when trying to edit it using Visual Query Builder. The use of the function works without any problems when executing from SQL Editor and it is only the VQB that's unable to parse the function correctly it seems. | ||||
| Steps To Reproduce | The following will be parsed and opened by VQB: SELECT TRIM(REGISTRATION) FROM VEHICLES Trying to edit any of the following will fail: SELECT TRIM('.' FROM REGISTRATION) FROM VEHICLES (Invalid SELECT statement. Unexpected token "FROM" at line 1, pos 17) SELECT TRIM(TRAILING 'Y' FROM REGISTRATION) FROM VEHICLES (Invalid SELECT statement. Unexpected token "TRAILING" at line 1, pos 13) | ||||
| Additional Information | TRIM() Available in: DSQL, PSQL Added in: 2.0 Description: Removes leading and/or trailing spaces (or optionally other strings) from the input string. The result is a VARCHAR(n) with n the formal length of the input string. Result type: VARCHAR(n) Syntax: TRIM ([<adjust>] str) <adjust> ::= {[where] [what]} FROM where ::= BOTH | LEADING | TRAILING /* default is BOTH */ what ::= The substring to be removed (repeatedly if necessary) from str's head and/or tail. Default is ' ' (space). Syntax and examples available here: http://www.firebirdsql.org/refdocs/langrefupd20-trim.html | ||||
| Tags | No tags attached. | ||||
| Date Modified | Username | Field | Change |
|---|---|---|---|
| 2014-09-09 15:03 | Martijn Tonies | New Issue | |
| 2014-09-09 15:03 | Martijn Tonies | Status | new => assigned |
| 2014-09-09 15:03 | Martijn Tonies | Assigned To | => Martijn Tonies |
| 2014-09-09 15:03 | Martijn Tonies | Issue generated from: 0000794 | |
| 2014-09-09 15:03 | Martijn Tonies | Project | Database Workbench v4 => Database Workbench v5 |
| 2014-09-09 15:04 | Martijn Tonies | Status | assigned => resolved |
| 2014-09-09 15:04 | Martijn Tonies | Fixed in Version | => 5.0.2 |
| 2014-09-09 15:04 | Martijn Tonies | Resolution | open => fixed |
| 2014-09-18 10:36 | Martijn Tonies | Status | resolved => closed |
