Hi all,
I'm trying to retrieve the SQL definition of a view from
information_schema via:
SELECT view_definition FROM information_schema.views WHERE
table_name = 'viewname';
It appears the definition returned is truncated at a fixed number of
characters - for this view it's 7650.
Does anybody know where this problem is in information_schema, or in the
actual storage of the text definition. If it's the former, is there a
way I can query the text definition directly?
This occurs in both server versions 8.0 and v7.4.1, BTW.
Many thanks,
Eric
