Some Eclipse Foundation services are deprecated, or will be soon. Please ensure you've read this important communication.

Bug 322299

Summary: BadParseException in parsing SQL function TRIM with trim spec
Product: [Tools] Data Tools Reporter: Linda Chan <lchan>
Component: SQL Query ParserAssignee: dtp.sqldevtools-inbox <dtp.sqldevtools-inbox>
Status: NEW --- QA Contact:
Severity: normal    
Priority: P3 CC: bpayton
Version: 1.8   
Target Milestone: future   
Hardware: PC   
OS: Windows All   
Whiteboard:

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.