Hello, please try:
create table mt ( mf varchar(5) ) select x."mf" from mt x I use Pentaho Mondrian, which appears to generate queries with double-quotes and it produces errors for me. Strangely, the error message correctly shows the name x.mf, but the rest of Derby doesn't. Thanks, Oliver