Issue Type: Patch Created: 2009-08-18T11:37:19.000+0000 Last Updated: 2009-08-24T10:51:58.000+0000 Status: Resolved Fix version(s): - 1.9.2 (25/Aug/09)
Reporter: Jayson Santos dos Reis (jaysonsantos) Assignee: Ralph Schindler (ralph) Tags: - Zend_Db
Related issues: Attachments: - Mssql.patch
In mssql if you don't pass variable @table_owner it will guess the table is in dbo schema. So in attachment is a patch to fix that. I'm also using that in sp_columns because is the right to do. If I have a 2 tables with the same name and different schemas, that will be confusing.
Posted by Jayson Santos dos Reis (jaysonsantos) on 2009-08-18T11:52:32.000+0000
Posted by Jayson Santos dos Reis (jaysonsantos) on 2009-08-18T19:10:17.000+0000
Just correcting, the procedure name is sp_pkeys.
Posted by Ralph Schindler (ralph) on 2009-08-21T09:36:35.000+0000
I am not sure what you are proposing. How do you expect to call describeTable() to trigger this functionality? Currently, the $schemaName is not used in the lookup. Why would schemaName be dotted? What does that represent?
Posted by Jayson Santos dos Reis (jaysonsantos) on 2009-08-21T11:55:42.000+0000
Hi Ralph, there are to problems that patch solve. First: When you have two tables in different schemas, procedures like sp_pkeys and sp_columns will get only one. Second: sp_pkeys need specify the schema or it will search in dbo, if that does not exist in dbo, will return a blank rowset.
And about the schema name using dot is because some times you need specify another database to do a join, because of that we use in schemaName db.schema.
Posted by Ralph Schindler (ralph) on 2009-08-21T15:22:46.000+0000
Fix provided in trunk at r17739, please test.
Posted by Alexandre Gomes Gaigalas (alganet) on 2009-08-22T22:49:09.000+0000
Support for catalogs in ZF is also very limited, see http://framework.zend.com/issues/browse/ZF-6665 (similar bug)
Posted by Ralph Schindler (ralph) on 2009-08-24T10:51:58.000+0000
Fixed in release branch 1.9
Have you found an issue?
See the Overview section for more details.