zend-db

zend-db copied to clipboard

no error code for statement runtime exception

4

Using Zend\Db\Adapter\Driver\Oci8\Statement as an example, if a runtime error occurs during sql execution (eg duplicate value on insert), the exception's code is populated with a DMBS error code. Is there...

brettmc

Looking for a clear example about how to use BLOB/CLOB with OCI8

1

Dear all, i have some difficulties to use CLOB with OCI8 driver. I was able to do it with ZF1 like this: ``` $sql = "INSERT INTO MY_TABLE (COL1, COL2,COLCLOB)...

parktrip

DDL improves

2

Hello, guys I want to add column with options such as AUTO INCREMENT and unsigned. How it do? Finally I've created follow class and add Constraint `class AutoIncrement extends AbstractConstraint...

vitaliimelnychuk

Fix AlterTable::dropConstraint() by allowing the use of decorator

17

Fixes a broken implementation under MySQL: `DROP CONSTRAINT` is not supported, you have to use `DROP [FOREIGN KEY | INDEX | KEY]` instead. See issue #36 **Warning:** introduces a potential...

nanawel

Support for Common table expressions

1

Any thoughts about supporting CTE (common table expressions) ? In mariadb 10.2: https://mariadb.com/kb/en/mariadb/non-recursive-common-table-expressions-overview/ Or postgresql: https://www.postgresql.org/docs/9.1/static/queries-with.html Would be a nice addition and I might work on this if a bit...

belgattitude

Allow column names to contain any character

9

In regards to issues #8 and #208 I've created a regex that will allow user to use any character as column name. It will also keep functionality of allowing user...

metalinspired

Update adapter examples documentation

1

https://github.com/zendframework/zend-db/blob/master/doc/book/adapter.md#examples Needs updating, the example: ``` $sql = 'UPDATE ' . $qi('artist') . ' SET ' . $qi('name') . ' = ' . $fp('name') . ' WHERE ' . $qi('id')...

GeeH

Few `limit` issue

1

Briefly: SQL queries fails when few `limit` statements is used (sub-select, maybe unions) Context: PDO Mysql driver Expected SQL (simplified): ```sql SELECT (SELECT column FROM foo LIMIT 1) AS column...

autowp

Creating Index during CREATE TABLE doesn't work across different platforms

4

Currently if I use DDL to add the basic (not unique) Index as constraint via CreateTable or AlterTable it does it via INDEX inside the CREATE TABLE statement like this:...

rarog

Escaping of table, column and index name is wrong

2

It seems that escaping is wrong for at least DDLs, I didn't test SELECT and other commands. ~~It goes wrong with (MySQL) and without (SQLite) decorators.~~ The example for SQLite...

rarog