Дистриб yii-1.1.9.r3527.tar.gz
База Oracle-10.2.0.4
Apache-2.0.48/php-5.2.6
Файл: yii\framework\db\schema\oci\COciSchema.php
В новом проекте при попытке зайти в "Model Generator" выводится следующее:
CDbCommand failed to execute the SQL statement: SQLSTATE[HY000]: General error: 904 OCIStmtExecute: ORA-00904: "B"."OBJECT_NAME": invalid identifier
Кривой запрос:
SELECT a.column_name,
a.data_type
|| CASE
WHEN data_precision IS NOT NULL
THEN '('
|| a.data_precision
|| CASE
WHEN a.data_scale > 0
THEN ',' || a.data_scale
ELSE ''
END
|| ')'
WHEN data_type = 'DATE'
THEN ''
WHEN data_type = 'NUMBER'
THEN ''
ELSE '(' || TO_CHAR (a.data_length) || ')'
END AS data_type,
a.nullable, a.data_default,
(SELECT d.constraint_type
FROM SYS.all_cons_columns c INNER JOIN SYS.all_constraints d
ON d.owner = c.owner
AND d.constraint_name = c.constraint_name
WHERE c.owner = b.owner
AND c.table_name = b.object_name
AND c.column_name = a.column_name
AND d.constraint_type = 'P') AS KEY
FROM SYS.all_tab_columns a INNER JOIN all_objects b
ON b.owner = a.owner AND LTRIM (b.object_name) = LTRIM (a.table_name)
WHERE a.owner = ‘SOME_ORA_USER’
AND (b.object_type = 'TABLE' OR b.object_type = 'VIEW')
AND b.object_name = 'MY_SOME_TABLE'
ORDER BY a.column_id
Объекты ALL_CONS_COLUMNS, ALL_CONSTRAINTS, ALL_TAB_COLUMNS, USER_TABLES и ALL_OBJECTS находятся в схеме sys.
После добавления "sys." к объектам, Yii нормально отработал.