Routine dependencies not working when Truncate function is used

shlomi-noach / common-schema-legacy

Automatically exported from code.google.com/p/common-schema

5 stars 6 forks source link

Routine dependencies not working when Truncate function is used #56

Open GoogleCodeExporter opened 9 years ago

GoogleCodeExporter commented 9 years ago

Which version of common_schema are you using? (specify
revision+distribution)

version: 2.2, Revision: 523

Which component is failing? (specify the view, function, etc.)
Routine dependencies

What is the expected output? What do you see instead?
It should handle truncate function. Instead its treating it as DDL command

Original issue reported on code.google.com by hackersd...@gmail.com on 19 Feb 2014 at 4:42

GoogleCodeExporter commented 9 years ago

But, TRUNCATE *is* a DDL command? What's the error?

At any case the status for Routine-dependencies is still BETA and I'm not sure 
it's going to change in the near future (unless you are able to provide with 
good patches).

Original comment by shlomi.n...@gmail.com on 19 Feb 2014 at 7:49

GoogleCodeExporter commented 9 years ago

Hi,

There is also a in-built mathematical function in mysql called truncate.

https://dev.mysql.com/doc/refman/5.0/en/mathematical-functions.html#function_tru
ncate

When TRUNCATE function is encountered, it throws the following exception:

Error: unexpected state truncate

Thanks,
A. Anish

Original comment by hackersd...@gmail.com on 19 Feb 2014 at 8:57