#6141: function describe in dbo_oracle.php
--------------------------+-------------------------------------------------
Reporter: wilderland | Owner: phishy
Type: Bug | Status: new
Priority: High | Milestone: 1.2.x.x
Component: Oracle | Version: 1.2 Final
Severity: Normal | Keywords: Oracle
Php_version: n/a | Cake_version:
--------------------------+-------------------------------------------------
On a Oracle-intance with different owners, it maybe get a error because
describe will get to much columns which may not exists in the table. The
model will get to much columns, because of missing
{{{
$sql = 'SELECT COLUMN_NAME, DATA_TYPE, DATA_LENGTH FROM all_tab_columns
WHERE table_name = 'sometable';
}}}
you will get colums for example of two tables because owner ist not
included in the where-Condition
better
{{{
$sql = 'SELECT COLUMN_NAME, DATA_TYPE, DATA_LENGTH FROM all_tab_columns
WHERE table_name = 'sometable' and owner='tableowner';
}}}
better and fast is using the user_tab_columns-Table
{{{
$sql = 'SELECT COLUMN_NAME, DATA_TYPE, DATA_LENGTH FROM USER_tab_columns
WHERE table_name = 'sometable' and owner='tableowner';
}}}
--
Ticket URL: <https://trac.cakephp.org/ticket/6141>
CakePHP : The Rapid Development Framework for PHP <https://trac.cakephp.org/>
Cake is a rapid development framework for PHP which uses commonly known design
patterns like ActiveRecord, Association Data Mapping, Front Controller and MVC.
Our primary goal is to provide a structured framework that enables PHP users at
all levels to rapidly develop robust web applications, without any loss to
flexibility.
--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google Groups
"tickets cakephp" group.
To post to this group, send email to [email protected]
To unsubscribe from this group, send email to
[email protected]
For more options, visit this group at
http://groups.google.com/group/tickets-cakephp?hl=en
-~----------~----~----~----~------~----~------~--~---
