deleteByExample error using table alias, ANNOTATEDMAPPER and mysql about generator HOT 7 CLOSED

It is a known issue. It only arises on certain databases like MySQL. I think the best solution would be to change the generate so the alias is only used on select statements and not anywhere else. I'll take a look at making that fix.

from generator.

The behaviour with MAPPER option, instead of ANNOTATEDMAPPER, was not to use the alias in DELETE clause. So, I agree with you, it can be just ignored and will be compatible with old codes that used MAPPER.

from generator.

Still happening - any updates?

from generator.

This turns out to be difficult to solve with the generator as it stands now. I've been working on a new SQL templating library for MyBatis and I have a fix for this issue in that new library. I think that's how it's ultimately going to be fixed because it would just be too cumbersome to fix it in the current generator.

from generator.

This will not be resolved in what I'm now calling the "legacy" code generators - it would mean generating a huge amount of new code.

This IS resolved in the new code generator that is based on MyBatis Dynamic SQL that was just released.

from generator.

Which version can solve this problem?

from generator.

It is fixed in the latest version (1.3.6) - but only if you change to the new Dynamic SQL runtime. You do that by specifying <context targetRuntime"MyBatis3DynamicSql">

If you do this, please note that the generated code is not 100% compatible with prior versions. I think it is much better and far more flexible. If you have not made the change to this new runtime yet, then I recommend you read about it first to see if this is a good option for you. http://www.mybatis.org/generator/generatedobjects/dynamicSql.html

from generator.