View Issue Details
| ID | Project | Category | View Status | Date Submitted | Last Update |
|---|---|---|---|---|---|
| 0000794 | Database Workbench v4 | Visual Query Builder | public | 2014-02-05 19:54 | 2014-09-17 08:38 |
| Reporter | Louwrens van Deventer | 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 | 4.4.3 | ||||
| Fixed in Version | 4.4.8 | ||||
| Summary | 0000794: 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. | ||||
| DBMS & Version | |||||
| Date Modified | Username | Field | Change |
|---|---|---|---|
| 2014-02-05 19:54 | Louwrens van Deventer | New Issue | |
| 2014-02-06 10:04 | Martijn Tonies | Assigned To | => Martijn Tonies |
| 2014-02-06 10:04 | Martijn Tonies | Status | new => acknowledged |
| 2014-09-09 15:03 | Martijn Tonies | Issue cloned: 0001023 | |
| 2014-09-09 15:04 | Martijn Tonies | Status | acknowledged => resolved |
| 2014-09-09 15:04 | Martijn Tonies | Fixed in Version | => 4.4.8 |
| 2014-09-09 15:04 | Martijn Tonies | Resolution | open => fixed |
| 2014-09-17 08:38 | Martijn Tonies | Status | resolved => closed |
