[Bug 7945] New: rename DB columns in Koha, that are 'reserved words' in SQL
http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=7945 Priority: P5 - low Change sponsored?: --- Bug ID: 7945 Assignee: gmcharlt@gmail.com Summary: rename DB columns in Koha, that are 'reserved words' in SQL QA Contact: koha.sekjal@gmail.com Severity: normal Classification: Unclassified OS: All Reporter: mtj@kohaaloha.com Hardware: All Status: NEW Version: master Component: Database Product: Koha 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 -- You are receiving this mail because: You are watching all bug changes.
http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=7945 --- Comment #1 from Mason James <mtj@kohaaloha.com> --- (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 :) -- You are receiving this mail because: You are watching all bug changes.
http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=7945 Mason James <mtj@kohaaloha.com> changed: What |Removed |Added ---------------------------------------------------------------------------- Status|NEW |RESOLVED Resolution|--- |WONTFIX --- Comment #2 from Mason James <mtj@kohaaloha.com> --- (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 -- You are receiving this mail because: You are watching all bug changes.
participants (1)
-
bugzilla-daemon@bugs.koha-community.org