[hiero]

I really would be happy to get the NEW and OLD keyword support already in 6.1 Final as I'm working quite often with triggers referencing fields based on these two keywords.

[hiero]

And as I said in my first post, I can enter the 'definer' statement manually and it does what I want.

[hiero]

I'm using version 5.0.37 with a lot of triggers, functions and procedures.

[hiero]

Have a look for the region below the “begin”. In the first screenshot, the text begins in position 5 and in the other screenshot in position 6. It's most obvious for the line starting with “end”, which only starts in the second position in the second screenshot.

For your reference I have attached a short SQL script which demonstrates the bug.

[attachment=765:function.zip]

Regards,

Frank

[hiero]

In the meantime I realized that the export was from a utf8 encoded database using INNODB-engine. Maybe it's related to the use of utf8, because the file being generated by mysqldump is utf8 encoded as well.

[hiero]

I have verified that the export with mysqldump is ok (5.0.37). For your reference, I have attached two screenshots, one with the code sequence generated by mysqldump and one with the code after import:

[attachment=763:SQL_Impo…ysqldump.gif]

[attachment=764:SQL_Import_done.gif]

[Author]

Posts