Derby DELETE doesn't work with a schema. #2074

gordski opened this Issue Jan 1, 2017 · 0 comments


None yet

1 participant

gordski commented Jan 1, 2017 edited

When using a schema that isn't the default schema, Derby rejects DELETE queries with WHERE clauses that don't reference the schema:

  1. DELETE FROM schema.table WHERE table.column = 'value' -- Doesn't work
  2. DELETE FROM schema.table WHERE schema.table.column = 'value' -- Does work

When configuring QueryDSL with the 'printSchema' option set the Derby templates generate (1).

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment