ZF-7629: Zend_Db_Adapter_Pdo_Mssql should pass @table_owner to sp_pkeys

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.

Thank you

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 (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.


© 2006-2018 by Zend, a Rogue Wave Company. Made with by awesome contributors.

This website is built using zend-expressive and it runs on PHP 7.