ORA-01745: Ungültiger Host-/Bindevariablenname caused by :table

[michalbundyra]

In /src/Metadata/Source/OracleMetadata.php#L127 :table is a reserved word and therefore the query fails

---

Originally posted by @lkainers at zendframework/zend-db#28

[michalbundyra]

The query does also contain additional line breaks (#125, #128) and a semicolon at the end (#129)

---

Originally posted by @lkainers at zendframework/zend-db#28 (comment)

[michalbundyra]

Linking sources: https://github.com/zendframework/zend-db/blob/790123893c01ad597b28652b2a382ac86186c6c8/src/Metadata/Source/OracleMetadata.php

---

Originally posted by @Ocramius at zendframework/zend-db#28 (comment)

[michalbundyra]

@lkainers what oracle version are you testing against? Also, got an example of a generated query?

---

Originally posted by @Ocramius at zendframework/zend-db#28 (comment)

[michalbundyra]

Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit

There is no generated query https://github.com/zendframework/zend-db/blob/790123893c01ad597b28652b2a382ac86186c6c8/src/Metadata/Source/OracleMetadata.php#L107 is the query

---

Originally posted by @lkainers at zendframework/zend-db#28 (comment)

[michalbundyra]

$params = array(
'driver' => 'Oci8',
'hostname' => 'host',
'username' => 'user',
'password' => pass',
'port' => '',
);

$connection = new Zend\Db\Adapter\Driver\Oci8\Connection($params);
$driver = new Zend\Db\Adapter\Driver\Oci8\Oci8($connection);
$adapter = new Zend\Db\Adapter\Adapter($driver);

$metadata = new Zend\Db\Metadata\Metadata($adapter);
$metadata->getConstraints('tablename');

---

Originally posted by @lkainers at zendframework/zend-db#28 (comment)

[michalbundyra]

Here's a PR zendframework/zend-db#34 that would fix this issue

---

Originally posted by @vixriihi at zendframework/zend-db#28 (comment)

[samsonasik]

it seems already fixed by merged PR zendframework/zend-db#34 .

I am closing this.