Skip to content

Releases: snelg/cakephp-3-oracle

Avoid ORA-00972 (identifier too long)

02 Mar 21:37
Compare
Choose a tag to compare

This is the code I'm least proud of so far in this project ;)
Oracle has an absolute limit of 30 characters for any identifier, including aliases (e.g. "SELECT field AS alias").
Cake's automagic creates aliases that follow the pattern "TABLENAME__FIELDNAME", so it's fairly common for those combined strings to exceed 30 characters.
My hacky workaround:

  1. Down inside "quoteIdentifier", I replace any >30-character identifier with "XXAUTO_SHORTENED_ID[n]" with [n] as a simple incrementing integer.
  2. After fetching each row, if there were any auto-shortened identifiers then I replace them with the original >30-character strings.

Really ugly, and I suspect it could cause problems in as-yet-unforeseen ways, but it Works For Me™

1.0.10: Revert "Ensure bound variables remain active until after execute"

02 Feb 17:21
Compare
Choose a tag to compare

Yajra 1.0.1 fixed PHP7 bug, so no longer need local workaround for the same bug

1.0.9

28 Jan 19:39
Compare
Choose a tag to compare

Updated yajra component to 1.0, necessitating a few internal changes to this project.

1.0.8

27 Jan 19:35
Compare
Choose a tag to compare

PHP 7 tweak to ensure bound parameters remain resident in memory until after statement execution

1.0.7

25 Jan 17:10
Compare
Choose a tag to compare

"bin/cake bake" now has correct model suggestions (compensating for Oracle's default ALL CAPS table names)

1.0.6

21 Jan 19:17
Compare
Choose a tag to compare

Insert statements fixed

1.0.5

11 Nov 22:47
Compare
Choose a tag to compare

More new abstract functions implemented.

1.0.4

11 Nov 19:46
Compare
Choose a tag to compare

Tiny update to README file

1.0.3

11 Nov 19:39
Compare
Choose a tag to compare

Implement new abstract function added to Cake\Database\Driver

1.0.2

27 Jul 17:28
Compare
Choose a tag to compare

A few more data types and default connection configs