zend-db icon indicating copy to clipboard operation
zend-db copied to clipboard

Db component from Zend Framework

Results 100 zend-db issues
Sort by recently updated
recently updated
newest added

On sql queries connecting to another database is valid with query like this: `... FROM [db2].[dbo].[archive_sap] .... ` When I provide schema with [], left part is "removed": ` $select->from('db2].[dbo].[archive_sap')...

Hello, we have been using Zend-Db as the database abstraction layer for our [Directus](https://github.com/directus/directus) framework and there has been a significant bug where columns with dashes (`e-mail`), spaces `first name`...

bug

`SqlServer\Ddl\CreatTableDecorator` does not know how to process `$id->setOption('IDENTITY', '1, 1');` , equivalent to AUTO_INCREMENT from MySQL or SEQUENCE from PostgreSQL

enhancement
awaiting author updates

SQL Server `Ddl\AlterTable` `addColumn` produces ``` ALTER TABLE [users] ADD COLUMN [profile_image] INTEGER ``` Should be ``` ALTER TABLE [users] ADD [profile_image] INTEGER ```

enhancement
awaiting author updates
feature request

bug
awaiting author updates
Needs tests

Hi, how can i work with JSONB (postgresql) in zend framework 3?. for example i want make query's like this `SELECT id, data->'title' AS title, data->'description' as description FROM tablename`...

#215, #214 as starting points plus everything else - [ ] CreateTable - [x] Column options as outlined in https://msdn.microsoft.com/en-us/library/ms187742.aspx#Syntax - [ ] Test constraint variations - [x] AlterTable -...

awaiting maintainer response

#206 Allow expression of full path towards table by allowing array as parameter for $schema in TableIdentifier and use `quoteIdentifierChain` in Sql table resolver. Reasoning explained in the issue. While...

enhancement

Clean up identifier quoting. quoteIdentifierChain was doing the same thing quoteIdentifier was doing but without safety of using predefined escape tokens. In turn, quoteIdentifier was producing same result as quoteIdentifierChain...

enhancement

Oci8 driver does not support some functionality of original oci8 driver. See official [doc](http://php.net/manual/en/function.oci-bind-by-name.php): > In Oracle, bind variables are commonly divided into IN binds for values that are passed...