[JIRA] Closed: (OFBIZ-47) Quote SQL92 identifiers used in table definitions

Previous Topic Next Topic
 
classic Classic list List threaded Threaded
1 message Options
Reply | Threaded
Open this post in threaded view
|

[JIRA] Closed: (OFBIZ-47) Quote SQL92 identifiers used in table definitions

JIRA jira@ofbiz.org
     [ http://jira.undersunconsulting.com/browse/OFBIZ-47?page=all ]
     
Jacopo Cappellato closed OFBIZ-47:
----------------------------------

    Resolution: Won't Fix

> Quote SQL92 identifiers used in table definitions
> -------------------------------------------------
>
>          Key: OFBIZ-47
>          URL: http://jira.undersunconsulting.com/browse/OFBIZ-47
>      Project: [OFBiz] Open For Business
>         Type: Improvement
>   Components: entity
>     Reporter: Jeff Turner
>     Assignee: Jira Administrator

>
>
> Hi,
> We used 'position' as a field name, not knowing that it is a SQL92 reserved word, which causes certain databases like Frontbase to break.
> It would be nice if Ofbiz would quote-escape words it knows to be reserved to prevent this problem.
> See http://jira.atlassian.com/browse/JRA-4202 for the original issue

--
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators:
   http://jira.undersunconsulting.com/secure/Administrators.jspa
-
For more information on JIRA, see:
   http://www.atlassian.com/software/jira