I apologize if my last comment sounded snotty. That was not my intention. I'm sorry if I am being dense, but in the docs it says that a component and a dynamic component can be treated as "conceptually" the same thing.

I have tried to debug this but it is way over my head. I will continue looking, but if you could review this revised test case. Please note that the only query marked as "this one fails" is the only query that fails with an Exception origionating with a column not found.

The exception seems to suggest that it doesn't join on the N table and properly associate the column with the correct table. When I traced "from N where b = ?" the inner join was correctly performed. Also when I traced down for "from N as n where n.dyn.a = ?" the inner join was correctly performed. Only "from N as n where n.dyn.b = ?" causes the failure.

Again, I sincerly apologize if I sounded like an ass.

Testcase:

package org.hibernate.test.component;

import java.util.HashMap;
import java.util.List;
import java.util.Map;

import org.hibernate.Session;
import org.hibernate.test.TestCase;

public class DynamicComponentTest extends TestCase {

public DynamicComponentTest(String name) {
super(name);
}

public void testDynamicComponent() throws Exception {
Session session = openSession();

M m = new M();
Map mValues = new HashMap();
mValues.put("a", "ma");
m.setDyn(mValues);
session.save(m);

N n = new N();
Map nValues = new HashMap();
nValues.put("a", "na");
nValues.put("b", "nb");
n.setDyn(nValues);
session.save;

List list = session.createQuery("from M as m where m.dyn.a = ?")
.setString(0, "ma")
.list();

assertEquals(1, list.size());
assertTrue(list.contains(m));

list = session.createQuery("from M as m where a = ?")
.setString(0, "ma")
.list();

assertEquals(1, list.size());
assertTrue(list.contains(m));

list = session.createQuery("from N as n where n.dyn.a = ?")
.setString(0, "na")
.list();

assertEquals(1, list.size());
assertTrue(list.contains);

list = session.createQuery("from N where b = ?")
.setString(0, "nb")
.list();

assertEquals(1, list.size());
assertTrue(list.contains);

// this is the only one that fails with the SQL exception
list = session.createQuery("from N as n where n.dyn.b = ?")
.setString(0, "nb")
.list();

assertEquals(1, list.size());
assertTrue(list.contains);

session.delete(m);
session.delete;
session.close();
}

protected String[] getMappings() {
return new String[] { "component/MN.hbm.xml" };
}
}

Mapping File:
<hibernate-mapping package="org.hibernate.test.component">

<class name="M">
<id name="id" type="string">
<generator class="uuid"/>
</id>
<dynamic-component name="dyn">
<property name="a" type="string"/>
</dynamic-component>
</class>

<joined-subclass name="N" extends="M">
<key column="M"/>
<dynamic-component name="dyn">
<property name="b" type="string"/>
</dynamic-component>
</joined-subclass>

</hibernate-mapping>

Classes:
package org.hibernate.test.component;

import java.io.Serializable;
import java.util.Map;

public class M {

private Serializable id;
private Map dyn;

public M() {
super();
}

public Serializable getId() {
return id;
}

public void setId(Serializable id) {
this.id = id;
}

public Map getDyn() {
return dyn;
}

public void setDyn(Map dyn) {
this.dyn = dyn;
}

public boolean equals(Object obj) {
if (!(obj instanceof M)) return false;
M that = (M) obj;
return this.dyn == null ? that.dyn == null : this.dyn.equals(that.dyn);
}

public int hashCode() {
return this.dyn == null ? super.hashCode() : this.dyn.hashCode();
}
}

package org.hibernate.test.component;

public class N extends M {

public N() {
super();
}

public boolean equals(Object obj) {
if (!(obj instanceof N)) return false;
return super.equals(obj);
}
}

Log:
21:00:16,152 INFO Environment:464 - Hibernate 3.0.2
21:00:16,181 INFO Environment:482 - loaded properties from resource hibernate.properties: {hibernate.order_updates=true, hibernate.default_batch_fetch_size=8, hibernate.connection.driver_class=org.hsqldb.jdbcDriver, hibernate.cglib.use_reflection_optimizer=true, hibernate.cache.provider_class=org.hibernate.cache.HashtableCacheProvider, hibernate.max_fetch_depth=1, hibernate.dialect=org.hibernate.dialect.HSQLDialect, hibernate.jdbc.use_streams_for_binary=true, hibernate.query.substitutions=true 1, false 0, yes 'Y', no 'N', hibernate.proxool.pool_alias=pool1, hibernate.connection.username=sa, hibernate.cache.region_prefix=hibernate.test, hibernate.connection.url=jdbc:hsqldb:., hibernate.connection.password=****, hibernate.jdbc.batch_versioned_data=true, hibernate.connection.pool_size=1}
21:00:16,184 INFO Environment:509 - using java.io streams to persist binary types
21:00:16,184 INFO Environment:510 - using CGLIB reflection optimizer
21:00:16,186 INFO Environment:540 - using JDK 1.4 java.sql.Timestamp handling
21:00:16,234 INFO Configuration:424 - Mapping resource: org/hibernate/test/component/MN.hbm.xml
21:00:16,614 INFO HbmBinder:259 - Mapping class: org.hibernate.test.component.M -> M
21:00:16,666 INFO HbmBinder:780 - Mapping joined-subclass: org.hibernate.test.component.N -> N
21:00:16,686 INFO Dialect:92 - Using dialect: org.hibernate.dialect.HSQLDialect
21:00:16,725 INFO Configuration:852 - processing extends queue
21:00:16,725 INFO Configuration:856 - processing collection mappings
21:00:16,726 INFO Configuration:865 - processing association property references
21:00:16,726 INFO Configuration:894 - processing foreign key constraints
21:00:16,782 INFO DriverManagerConnectionProvider:41 - Using Hibernate built-in connection pool (not for production use!)
21:00:16,787 INFO DriverManagerConnectionProvider:42 - Hibernate connection pool size: 1
21:00:16,787 INFO DriverManagerConnectionProvider:45 - autocommit mode: false
21:00:16,790 INFO DriverManagerConnectionProvider:80 - using driver: org.hsqldb.jdbcDriver at URL: jdbc:hsqldb:.
21:00:16,791 INFO DriverManagerConnectionProvider:86 - connection properties: {user=sa, password=****}
21:00:17,104 INFO SettingsFactory:72 - RDBMS: HSQL Database Engine, version: 1.7.3
21:00:17,105 INFO SettingsFactory:73 - JDBC driver: HSQL Database Engine Driver, version: 1.7.3
21:00:17,109 INFO Dialect:92 - Using dialect: org.hibernate.dialect.HSQLDialect
21:00:17,110 INFO SettingsFactory:123 - JDBC batch size: 15
21:00:17,111 INFO SettingsFactory:126 - JDBC batch updates for versioned data: enabled
21:00:17,112 INFO SettingsFactory:131 - Scrollable result sets: enabled
21:00:17,112 INFO SettingsFactory:139 - JDBC3 getGeneratedKeys(): disabled
21:00:17,113 INFO SettingsFactory:147 - Connection release mode: null
21:00:17,114 INFO SettingsFactory:165 - Maximum outer join fetch depth: 1
21:00:17,114 INFO SettingsFactory:168 - Default batch fetch size: 8
21:00:17,114 INFO SettingsFactory:172 - Generate SQL with comments: disabled
21:00:17,115 INFO SettingsFactory:176 - Order SQL updates by primary key: enabled
21:00:17,115 INFO SettingsFactory:314 - Query translator: org.hibernate.hql.ast.ASTQueryTranslatorFactory
21:00:17,126 INFO ASTQueryTranslatorFactory:21 - Using ASTQueryTranslatorFactory
21:00:17,128 INFO SettingsFactory:184 - Query language substitutions: {no='N', true=1, yes='Y', false=0}
21:00:17,130 INFO TransactionFactoryFactory:31 - Using default transaction strategy (direct JDBC transactions)
21:00:17,133 INFO TransactionManagerLookupFactory:33 - No TransactionManagerLookup configured (in JTA environment, use of read-write or transactional second-level cache is not recommended)
21:00:17,133 INFO SettingsFactory:193 - Automatic flush during beforeCompletion(): disabled
21:00:17,134 INFO SettingsFactory:197 - Automatic session close at end of transaction: disabled
21:00:17,134 INFO SettingsFactory:203 - Second-level cache: enabled
21:00:17,135 INFO SettingsFactory:207 - Query cache: disabled
21:00:17,135 INFO SettingsFactory:301 - Cache provider: org.hibernate.cache.HashtableCacheProvider
21:00:17,136 INFO SettingsFactory:222 - Optimize cache for minimal puts: disabled
21:00:17,137 INFO SettingsFactory:227 - Cache region prefix: hibernate.test
21:00:17,137 INFO SettingsFactory:231 - Structured second-level cache entries: enabled
21:00:17,145 INFO SettingsFactory:255 - Statistics: disabled
21:00:17,145 INFO SettingsFactory:259 - Deleted entity synthetic identifier rollback: disabled
21:00:17,146 INFO SettingsFactory:273 - Default entity-mode: pojo
21:00:17,260 INFO SessionFactoryImpl:150 - building session factory
21:00:17,471 INFO SessionFactoryObjectFactory:82 - Not binding factory to JNDI, no JNDI name configured
21:00:17,475 INFO Dialect:92 - Using dialect: org.hibernate.dialect.HSQLDialect
21:00:17,478 INFO Configuration:852 - processing extends queue
21:00:17,479 INFO Configuration:856 - processing collection mappings
21:00:17,480 INFO Configuration:865 - processing association property references
21:00:17,482 INFO Configuration:894 - processing foreign key constraints
21:00:17,486 INFO Configuration:852 - processing extends queue
21:00:17,487 INFO Configuration:856 - processing collection mappings
21:00:17,487 INFO Configuration:865 - processing association property references
21:00:17,487 INFO Configuration:894 - processing foreign key constraints
21:00:17,488 INFO SchemaExport:113 - Running hbm2ddl schema export
21:00:17,488 INFO SchemaExport:129 - exporting generated schema to database
21:00:17,489 INFO DriverManagerConnectionProvider:41 - Using Hibernate built-in connection pool (not for production use!)
21:00:17,489 INFO DriverManagerConnectionProvider:42 - Hibernate connection pool size: 1
21:00:17,491 INFO DriverManagerConnectionProvider:45 - autocommit mode: false
21:00:17,491 INFO DriverManagerConnectionProvider:80 - using driver: org.hsqldb.jdbcDriver at URL: jdbc:hsqldb:.
21:00:17,492 INFO DriverManagerConnectionProvider:86 - connection properties: {user=sa, password=****}
21:00:17,492 DEBUG SchemaExport:143 - alter table N drop constraint FK4E45136813
21:00:17,494 DEBUG SchemaExport:149 - Unsuccessful: alter table N drop constraint FK4E45136813
21:00:17,494 DEBUG SchemaExport:150 - Table not found: N in statement [alter table N]
21:00:17,494 DEBUG SchemaExport:143 - drop table M if exists
21:00:17,494 DEBUG SchemaExport:143 - drop table N if exists
21:00:17,497 DEBUG SchemaExport:161 - create table M (
id varchar(255) not null,
a varchar(255),
primary key (id)
)
21:00:17,501 DEBUG SchemaExport:161 - create table N (
M varchar(255) not null,
b varchar(255),
primary key (M)
)
21:00:17,502 DEBUG SchemaExport:161 - alter table N add constraint FK4E45136813 foreign key (M) references M
21:00:17,506 INFO SchemaExport:173 - schema export complete
21:00:17,526 INFO DriverManagerConnectionProvider:147 - cleaning up connection pool: jdbc:hsqldb:.
21:00:17,527 INFO Dialect:92 - Using dialect: org.hibernate.dialect.HSQLDialect
21:00:17,528 INFO Configuration:852 - processing extends queue
21:00:17,528 INFO Configuration:856 - processing collection mappings
21:00:17,528 INFO Configuration:865 - processing association property references
21:00:17,529 INFO Configuration:894 - processing foreign key constraints
21:00:17,529 INFO Configuration:852 - processing extends queue
21:00:17,530 INFO Configuration:856 - processing collection mappings
21:00:17,530 INFO Configuration:865 - processing association property references
21:00:17,530 INFO Configuration:894 - processing foreign key constraints
21:00:17,532 INFO SessionFactoryImpl:376 - Checking 0 named queries
21:00:17,801 WARN JDBCExceptionReporter:71 - SQL Error: -28, SQLState: S0022
21:00:17,802 ERROR JDBCExceptionReporter:72 - Column not found: N0_1_.B in statement [select n0_.M as id, n0_1_.a as a0_, n0_.b as b1_ from N n0_ inner join M n0_1_ on n0_.M=n0_1_.id where n0_1_.b=?]
21:00:17,803 WARN JDBCExceptionReporter:71 - SQL Error: -28, SQLState: S0022
21:00:17,804 ERROR JDBCExceptionReporter:72 - Column not found: N0_1_.B in statement [select n0_.M as id, n0_1_.a as a0_, n0_.b as b1_ from N n0_ inner join M n0_1_ on n0_.M=n0_1_.id where n0_1_.b=?]
21:00:17,805 INFO SessionFactoryImpl:758 - closing
21:00:17,805 INFO DriverManagerConnectionProvider:147 - cleaning up connection pool: jdbc:hsqldb:.
21:00:17,806 INFO SchemaExport:113 - Running hbm2ddl schema export
21:00:17,874 INFO DriverManagerConnectionProvider:147 - cleaning up connection pool: jdbc:hsqldb:.
21:00:17,875 INFO SchemaExport:129 - exporting generated schema to database
21:00:17,875 INFO DriverManagerConnectionProvider:41 - Using Hibernate built-in connection pool (not for production use!)
21:00:17,876 INFO DriverManagerConnectionProvider:42 - Hibernate connection pool size: 1
21:00:17,876 INFO DriverManagerConnectionProvider:45 - autocommit mode: false
21:00:17,876 INFO DriverManagerConnectionProvider:80 - using driver: org.hsqldb.jdbcDriver at URL: jdbc:hsqldb:.
21:00:17,877 INFO DriverManagerConnectionProvider:86 - connection properties: {user=sa, password=****}
21:00:17,877 DEBUG SchemaExport:143 - alter table N drop constraint FK4E45136813
21:00:17,878 DEBUG SchemaExport:143 - drop table M if exists
21:00:17,879 DEBUG SchemaExport:143 - drop table N if exists
21:00:17,879 INFO SchemaExport:173 - schema export complete
21:00:17,880 INFO DriverManagerConnectionProvider:147 - cleaning up connection pool: jdbc:hsqldb:.

Oh, you're right, the query is fine.

Anyway, if you really believe there is a bug, please produce a patch. Thanks.

I didn't know that a dynamic-component was considered a collection value type. I'm searching the docs on how to do this correctly. However, why does "from BB as b where b.values.field1 = ?" work? But form BB as b where b.values.field3 = ?" not work? I assumed that the bug was because the super class mapping BA hid the BB mapping when it was aliased because "from BB as b where field3 = ?" works.

It is not supported to navigate a collection-valued path expression in HQL. Please refer to the docs and HiA for supported HQL syntax.