DDC-245: Inheritance Breaks When Child Has No Table #303

New Issue

admin · 2026-01-22T12:33:58+01:00

admin commented

2026-01-22 12:33:58 +01:00

Originally created by @doctrinebot on GitHub (Jan 7, 2010).

Jira issue originally created by user mridgway:

I have a class hierarchy where the the super class uses SINGLE_TABLE inheritance:

Example:

/*
 * @Entity
 * @InheritanceType("SINGLE_TABLE")
 * @DiscriminatorColumn(name="type", type="string")
 * @DiscriminatorMap({"Static"="StaticBlock", "Test"="Test"})
*/
abstract class Block
{
    /****
     * @Id @Column(name="id", type="integer")
     * @GeneratedValue(strategy="AUTO")
     */
    protected $id;
//...

abstract class DynamicBlock extends Block
{
//... No doctrine properties
}

/*
 * @Entity
 */
class Test extends DynamicBlock
{
//... No doctrine properties
}

CreateSchema runs without error and creates the tables that I would want (Block table but no DynamicBlock table and no Test table). I am then able to persist new objects of type Test, but when I try to load one again I get "Base table or view not found: 1146 Table 'db.dynamic' doesn't exist".

I'm not sure if it should be creating that table (which I wouldn't want personally) or if there's a bug when it goes to load these objects. It looks like there is some inconsistency in how this is handled.

Originally created by @doctrinebot on GitHub (Jan 7, 2010). Jira issue originally created by user mridgway: I have a class hierarchy where the the super class uses SINGLE_TABLE inheritance: Example: ``` none /* * @Entity * @InheritanceType("SINGLE_TABLE") * @DiscriminatorColumn(name="type", type="string") * @DiscriminatorMap({"Static"="StaticBlock", "Test"="Test"}) */ abstract class Block { /**** * @Id @Column(name="id", type="integer") * @GeneratedValue(strategy="AUTO") */ protected $id; //... ``` ``` none abstract class DynamicBlock extends Block { //... No doctrine properties } ``` ``` none /* * @Entity */ class Test extends DynamicBlock { //... No doctrine properties } ``` CreateSchema runs without error and creates the tables that I would want (Block table but no DynamicBlock table and no Test table). I am then able to persist new objects of type Test, but when I try to load one again I get "Base table or view not found: 1146 Table 'db.dynamic' doesn't exist". I'm not sure if it should be creating that table (which I wouldn't want personally) or if there's a bug when it goes to load these objects. It looks like there is some inconsistency in how this is handled.

admin added the Bug label 2026-01-22 12:33:58 +01:00

admin closed this issue

2026-01-22 12:33:59 +01:00

admin commented

2026-01-22 12:34:00 +01:00

@doctrinebot commented on GitHub (Jan 7, 2010):

Comment created by romanb:

Attached a test case that works flawlessly. Please take a look and let me know.

@doctrinebot commented on GitHub (Jan 7, 2010): Comment created by romanb: Attached a test case that works flawlessly. Please take a look and let me know.

admin commented

2026-01-22 12:34:01 +01:00

@doctrinebot commented on GitHub (Jan 8, 2010):

Comment created by mridgway:

Turned out to be a lingering discriminator in another class.

@doctrinebot commented on GitHub (Jan 8, 2010): Comment created by mridgway: Turned out to be a lingering discriminator in another class.

admin commented

2026-01-22 12:34:02 +01:00

@doctrinebot commented on GitHub (Jan 8, 2010):

Issue was closed with resolution "Invalid"

@doctrinebot commented on GitHub (Jan 8, 2010): Issue was closed with resolution "Invalid"

admin commented

2026-01-22 12:34:03 +01:00

@doctrinebot commented on GitHub (Dec 13, 2015):

Imported 1 attachments from Jira into https://gist.github.com/28aa54b8b1b0bbd585df

10273_DDC245Test.php

@doctrinebot commented on GitHub (Dec 13, 2015): Imported 1 attachments from Jira into https://gist.github.com/28aa54b8b1b0bbd585df - [10273_DDC245Test.php](https://gist.github.com/28aa54b8b1b0bbd585df#file-10273_DDC245Test-php)

admin referenced this issue

2026-01-22 15:57:54 +01:00

[PR #303] [MERGED] Fix GROUP BY clauses for PostgreSQL #8001

admin referenced this issue

2026-01-22 15:57:54 +01:00

[PR #303] Fix GROUP BY clauses for PostgreSQL #8004

Sign in to join this conversation.