Some Eclipse Foundation services are deprecated, or will be soon. Please ensure you've read this important communication.
Bug 322299 - BadParseException in parsing SQL function TRIM with trim spec
Summary: BadParseException in parsing SQL function TRIM with trim spec
Status: NEW
Alias: None
Product: Data Tools
Classification: Tools
Component: SQL Query Parser (show other bugs)
Version: 1.8   Edit
Hardware: PC Windows All
: P3 normal (vote)
Target Milestone: future   Edit
Assignee: dtp.sqldevtools-inbox CLA
QA Contact:
URL:
Whiteboard:
Keywords:
Depends on:
Blocks:
 
Reported: 2010-08-10 19:06 EDT by Linda Chan CLA
Modified: 2010-09-22 19:39 EDT (History)
1 user (show)

See Also:

Attachments
Add an attachment (proposed patch, testcase, etc.)

Note You need to log in before you can comment on or make changes to this bug.
Description Linda Chan CLA 2010-08-10 19:06:54 EDT 
Got a BadParseException in SQB when a manually edited SQL text contains the TRIM function including the trim specification.
E.g. SELECT TRIM( LEADING FROM column1 ) from table1

This happens regardless of the DBMS type.
Comment 1 Brian Payton CLA 2010-09-22 19:39:25 EDT 
Unfortunately the Query parser doesn't yet have support for most functions that have unusual syntax, such as the "LEADING FROM" part of the TRIM function.  That requires a lot of function-specific grammar rules that aren't there yet.