search

myramnath / common-schema

Automatically exported from code.google.com/p/common-schema
0 stars 0 forks source link

sql_mode parameter for sql tokenizer #13

Open GoogleCodeExporter opened 9 years ago

GoogleCodeExporter commented 9 years ago 
Right now the tokenizer dynamically retrieves the sql_mode from the session 
(currently only for determining if ANSI_QUOTES are in effect)

the sql mode should be a parameter. 

This is required for correct operation of the dependencies procs. that's 
because the sql_mode in effect at ddl time when creating a view or routine is 
saved along with the object. when running the routine or selecting from the 
view that mode is used. so the only way to correctly analyze code is if we know 
what sql_mode applies for that object.

Original issue reported on code.google.com by roland.bouman on 16 Sep 2011 at 1:05