Bug 7945 - rename DB columns in Koha, that are 'reserved words' in SQL
Summary: rename DB columns in Koha, that are 'reserved words' in SQL
Status: CLOSED WONTFIX
Alias: None
Product: Koha
Classification: Unclassified
Component: Database (show other bugs)
Version: Main
Hardware: All All
: P5 - low normal (vote)
Assignee: Galen Charlton
QA Contact:
URL:
Keywords:
Depends on:
Blocks:
 
Reported: 2012-04-12 05:37 UTC by Mason James
Modified: 2015-12-03 22:00 UTC (History)
0 users

See Also:
Change sponsored?: ---
Patch complexity: ---
Documentation contact:
Documentation submission:
Text to go in the release notes:
Version(s) released in:


Attachments

Note You need to log in before you can comment on or make changes to this bug.
Description Mason James 2012-04-12 05:37:45 UTC
some database columns in Koha match SQL reserved-words

this bug will attempt to locate these columns, and rename them


fyi: here's some links for reserved-words in mysql and postgres...
 http://dev.mysql.com/doc/refman/5.5/en/reserved-words.html
 http://www.postgresql.org/docs/8.1/static/sql-keywords-appendix.html

and some other dbs too...
 http://www.adp-gmbh.ch/ora/sql/reserved_words.html
 http://msdn.microsoft.com/en-us/library/aa238507(v=sql.80).aspx
 http://drupal.org/node/141051
Comment 1 Mason James 2012-04-12 05:40:48 UTC
(In reply to comment #0)
> some database columns in Koha match SQL reserved-words
> 
> this bug will attempt to locate these columns, and rename them

afaik, there are 2 offending columns in Koha...
 - old_issues.return 
 - issues.return

i'll attempt to use a script to find more :)
Comment 2 Mason James 2014-12-03 07:06:27 UTC
(In reply to Mason James from comment #1)
> (In reply to comment #0)
> > some database columns in Koha match SQL reserved-words
> > 
> > this bug will attempt to locate these columns, and rename them
> 
> afaik, there are 2 offending columns in Koha...
>  - old_issues.return 
>  - issues.return
> 
> i'll attempt to use a script to find more :)


hmm, this has got to be a WONTFIX, i think.. :p