Bug 107917 - SQLParser QUOTED_ID does not support SQL Server quoted id's
Summary: SQLParser QUOTED_ID does not support SQL Server quoted id's
Keywords:
Status: CLOSED EOL
Alias: None
Product: Red Hat Web Application Framework
Classification: Retired
Component: persistence
Version: nightly
Hardware: All
OS: Linux
medium
medium
Target Milestone: ---
Assignee: ccm-bugs-list
QA Contact: Jon Orris
URL:
Whiteboard:
Depends On:
Blocks:
TreeView+ depends on / blocked
 
Reported: 2003-10-24 13:24 UTC by Brett Prucha
Modified: 2020-03-27 16:47 UTC (History)
0 users

Fixed In Version:
Doc Type: Enhancement
Doc Text:
Clone Of:
Environment:
Last Closed: 2020-03-27 16:47:40 UTC
Embargoed:


Attachments (Terms of Use)

Description Brett Prucha 2003-10-24 13:24:03 UTC
From Bugzilla Helper:
User-Agent: Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.0)

Description of problem:
Microsoft SQL Server uses the '[' and ']' characters to quote an ID.  The 
current SQL parser only accepts the '"' character.  Not really a bug since the 
framework doesn't support SQL Server.  But to maintain compatibility with as 
many databases as possible it would be nice to have it added to the SQL Parser.

Version-Release number of selected component (if applicable):


How reproducible:
Always

Steps to Reproduce:
SQL Server does support '"' as a quoted id except I ran into a problem when 
calling a stored procedure that calls "exec sp_executesql @sql" where @sql 
contains "sp_executesql N'sql statement'" where the sql statement contains the 
quoted identifier that was generated from 
com.arsdigita.persistence.InFilter.getConditions().  I modified that code to 
return "[insub]" and thats when I ran into the problem.

Additional info:


Note You need to log in before you can comment on or make changes to this bug.