Intellij IDEA database plugin return an error "Unknown column 'generation_expression' in 'field list'"

[zhenruyan]

Error encountered when performing Introspect schema xlqy: Unknown column 'generation_expression' in 'field list'.
Unknown column 'generation_expression' in 'field list'

[jackysp]

Thank you for your report! @zhenruyan
Database plugin of Intellij IDEA will send some SQL automatically. One of them is

select  ordinal_position,  column_name,  column_type, column_default,/* null */  generation_expression,  table_name,  column_comment,  is_nullable,  extra,  collation_name from information_schema.columns where table_schema = 'test' order by table_name, ordinal_position

But TiDB does not have column generation_expression in its information_schema.columns. I guess the plugin wants to return some meta data of the table you touched.

[zhenruyan]

Thank you very much. Does tidb plan to add this function in the future?

[jackysp]

We will fix it soon.

[jackysp]

Fixed by #7017 , @zhenruyan
Please try the latest master branch.