View Issue Details
ID | Project | Category | View Status | Date Submitted | Last Update |
---|---|---|---|---|---|
0007644 | mantisbt | db oracle | public | 2006-12-09 16:34 | 2015-03-16 19:24 |
Reporter | Martin Fuchs | Assigned To | dregad | ||
Priority | normal | Severity | major | Reproducibility | always |
Status | closed | Resolution | fixed | ||
Product Version | 1.1.0a2 | ||||
Target Version | 1.3.0-beta.1 | Fixed in Version | 1.3.0-beta.1 | ||
Summary | 0007644: Problems when creating the Mantis database schema on Oracle | ||||
Description | As reported in Issue 0005289 there are a numer of problems when trying to create an Oracle database schema for Mantis: ============================================== Oracle Specific Issues: Identifiers to long on tables:
Trigger Identifiers to long:
Index Identifiers to long:
I get an "such colum list already indexed" error for: For date fields to take: core/adodb/drivers/adodb-oci8.inc.php Line#84 | ||||
Steps To Reproduce | create an schema SQL script using the admin/install.php for Oracle. After this save the script into a SQL file, change the "END;;" trigger endings into: Then try to execute the script using SQL*Plus - you will see the errors mentioned above. | ||||
Tags | No tags attached. | ||||
related to | 0005289 | closed | grangeway | Use ADODB DataDict for DB Creation / Upgrade |
related to | 0013433 | closed | dregad | Error ORA-00904: "PROTECTED": invalid identifier for the query |
child of | 0013227 | closed | dregad | Oracle DB support multiple issues |
child of | 0013438 | closed | dregad | adodb: Fatal error: Call to a member function FetchRow() on a non-object |
If the suffix "_table" of table names will be changed to "_tbl" the currently longest name "mantis_custom_field_project_table" will be short enough to be created in Oracle databases with the 31 characters of "mantis_custom_field_project_tbl". If it's feasable, the table names could be changed only for Oracle databases to provide backward compatibility for MySQL schemas. |
|
|
|
Tested with RC2 (I use prefix "m" and postfix "_t" to avoid length problems) CREATE INDEX idx_project_id ON m_project_t (id); INSERT INTO m_user_t.... CREATE INDEX idx_email_id ON m_email_t (email_id); ALTER TABLE m_user_pref_t MODIFY( category_migrate; And the DB creation script ended with: And TRIGGER endings, quite annoying ( 0011014 ), they must be ended with: But its completely useless unless 0010996 is not solved. Hope this will help. |
|
MantisBT: master 2ce60e47 2011-08-10 08:34 Details Diff |
Fix 0013227: Oracle database support (oci8) Mantis 1.2.6 currently does not work with Oracle DB: 1. Installation: 1.1. Oracle DB autocreates PK, so index creation for same field forbidden 1.2. Oracle DB uses datetime literal format timestamp'YYYY-MM-DD HH-MI:SS' 1.3. Oracle DB don't allows altering field property NOT NULL into NOT NULL 1.4. Oracle DB max object length is 30 chars, so some index names must be reduced 1.5. Oracle DB means empty string as NULLs, so NOT NULL restriction must be disabled for some field 1.6. Oracle DB can resolve database server name through TNS, so database name cannot be required 2. General: 2.2. Direct DB query execution result accessing instead of db_fetch_array() 1.3. usage didn't works with Oracle DB 2.4. Oracle DB binds variable by name, so bind names in statement must be sorted to address them. 2.5. Oracle DB handles NULL/DEFAULT values with specific way. 2.6. Oracle DB returns NULL value as true PHP null 2.7. Oracle DB handles sequence access with specific syntax 2.8. Nothing returned by db_prepare_string() in case of oci8 2.9. Oracle DB max object length is 30 chars, so table names must be reduced 2.10. Oracle DB uses LOB literal format similar to mssql 2.11. GetRowAssoc returns empty field values with oci8, it's need to enable returning both associative and indexed arrays. The original patch was provided by DKuranov. He reckons that this also resolves issues 0006853, 0007644, 0010437, 0010996, 0011265, 0011270, 0011276, 0012152, 0012478 Porting to 1.3 - Conflicts: admin/install.php admin/schema.php core/database_api.php manage_tags_page.php |
Affected Issues 0006853, 0007644, 0010437, 0010996, 0011265, 0011270, 0011276, 0012152, 0012478, 0013227 |
|
mod - admin/install.php | Diff File | ||
mod - admin/schema.php | Diff File | ||
mod - core/database_api.php | Diff File |