Bug Report #1142

Database->list_tables() ignores table_prefix

Added by Chris Bandy almost 3 years ago. Updated over 2 years ago.

Status:Closed Start date:
Priority:Normal Due date:
Assignee:Jeremy Bush % Done:

100%
Category:Libraries:Database
Target version:2.4
Resolution:fixed Points:

Description

The function should return a list of tables with the configured prefix rather than all tables existing in the database.

For example, a database hosting two applications would utilize two prefixes, 'mdl_' and 'jos_', to avoid collisions. Each application should be agnostic to the configured prefix and should find only its tables.

Attached are patches against branch/2.4 which depend on #1049.

0001-Only-list-tables-with-the-configured-table_prefix.patch (3.1 kB) Chris Bandy, 02/27/2009 04:15 pm

0002-Strip-table_prefix-from-introspection-output.patch (1.9 kB) Chris Bandy, 02/27/2009 04:15 pm

Related issues

related to Kohana v2.x - Bug Report #1288: MSSQL list_fields has MySQL request 2.3.4 Closed

Associated revisions

Revision 4419
Added by John Heathco over 2 years ago

Fixing #1142 (adding list_tables to 2.4 Database library)

Revision 4641
Added by Chris Bandy over 2 years ago

Strip table_prefix from list_tables() output. Refs #1142

History

#1
Updated by Chris Bandy almost 3 years ago

According to the documentation I found for MSSQL, the current driver looks wrong and I am unable to test. MSSQL is excluded from these patches.

#2
Updated by John Heathco over 2 years ago

  • Status changed from New to Closed
  • % Done changed from 0 to 100
  • Resolution set to fixed
  • 11 set to 2.3.4

Also available in: Atom PDF