You signed in with another tab or window. Reload to refresh your session.You signed out in another tab or window. Reload to refresh your session.You switched accounts on another tab or window. Reload to refresh your session.Dismiss alert
I'm experiencing an issue with the database analysis tool when running a query to get constraint columns. The error message is:
Local gateway: Internal Server Error: Error ER_BAD_FIELD_ERROR on query getConstraintColumns: Unknown column 'i.EXPRESSION' in 'field list'
The query that's causing the error is:
sql
SELECT
c.CONSTRAINT_NAME AS constraint_name,
c.CONSTRAINT_TYPE AS constraint_type,
c.TABLE_SCHEMA AS table_schema,
c.TABLE_NAME AS table_name,
cc.ORDINAL_POSITION AS column_index,
cc.COLUMN_NAME AS column_name,
null AS column_expr,
cc.REFERENCED_TABLE_SCHEMA AS ref_schema,
cc.REFERENCED_TABLE_NAME AS ref_table,
cc.REFERENCED_COLUMN_NAME AS ref_column
FROM
information_schema.TABLE_CONSTRAINTS c
LEFT JOIN information_schema.KEY_COLUMN_USAGE cc
ON cc.CONSTRAINT_CATALOG = c.CONSTRAINT_CATALOG
AND cc.CONSTRAINT_SCHEMA = c.CONSTRAINT_SCHEMA
AND cc.CONSTRAINT_NAME = c.CONSTRAINT_NAME
AND cc.TABLE_NAME = c.TABLE_NAME
WHERE
c.CONSTRAINT_TYPE != 'CHECK'
AND c.TABLE_SCHEMA = 'hqms'
UNION
SELECT
i.INDEX_NAME AS constraint_name,
"INDEX" AS constraint_type,
i.TABLE_SCHEMA AS table_schema,
i.TABLE_NAME AS table_name,
i.SEQ_IN_INDEX AS column_index,
i.COLUMN_NAME AS column_name,
i.EXPRESSION AS column_expr,
null AS ref_schema,
null AS ref_table,
null AS ref_column
FROM
information_schema.STATISTICS i
LEFT JOIN information_schema.TABLE_CONSTRAINTS c
ON c.TABLE_SCHEMA = i.TABLE_SCHEMA
AND c.TABLE_NAME = i.TABLE_NAME
AND c.CONSTRAINT_NAME = i.INDEX_NAME
WHERE
c.CONSTRAINT_TYPE IS NULL
AND i.TABLE_SCHEMA = 'hqms'
ORDER BY
table_schema, table_name, constraint_name, column_index;
The text was updated successfully, but these errors were encountered:
I'm experiencing an issue with the database analysis tool when running a query to get constraint columns. The error message is:
Local gateway: Internal Server Error: Error ER_BAD_FIELD_ERROR on query getConstraintColumns: Unknown column 'i.EXPRESSION' in 'field list'
The query that's causing the error is:
sql
SELECT
c.CONSTRAINT_NAME AS constraint_name,
c.CONSTRAINT_TYPE AS constraint_type,
c.TABLE_SCHEMA AS table_schema,
c.TABLE_NAME AS table_name,
cc.ORDINAL_POSITION AS column_index,
cc.COLUMN_NAME AS column_name,
null AS column_expr,
cc.REFERENCED_TABLE_SCHEMA AS ref_schema,
cc.REFERENCED_TABLE_NAME AS ref_table,
cc.REFERENCED_COLUMN_NAME AS ref_column
FROM
information_schema.TABLE_CONSTRAINTS c
LEFT JOIN information_schema.KEY_COLUMN_USAGE cc
ON cc.CONSTRAINT_CATALOG = c.CONSTRAINT_CATALOG
AND cc.CONSTRAINT_SCHEMA = c.CONSTRAINT_SCHEMA
AND cc.CONSTRAINT_NAME = c.CONSTRAINT_NAME
AND cc.TABLE_NAME = c.TABLE_NAME
WHERE
c.CONSTRAINT_TYPE != 'CHECK'
AND c.TABLE_SCHEMA = 'hqms'
UNION
SELECT
i.INDEX_NAME AS constraint_name,
"INDEX" AS constraint_type,
i.TABLE_SCHEMA AS table_schema,
i.TABLE_NAME AS table_name,
i.SEQ_IN_INDEX AS column_index,
i.COLUMN_NAME AS column_name,
i.EXPRESSION AS column_expr,
null AS ref_schema,
null AS ref_table,
null AS ref_column
FROM
information_schema.STATISTICS i
LEFT JOIN information_schema.TABLE_CONSTRAINTS c
ON c.TABLE_SCHEMA = i.TABLE_SCHEMA
AND c.TABLE_NAME = i.TABLE_NAME
AND c.CONSTRAINT_NAME = i.INDEX_NAME
WHERE
c.CONSTRAINT_TYPE IS NULL
AND i.TABLE_SCHEMA = 'hqms'
ORDER BY
table_schema, table_name, constraint_name, column_index;
The text was updated successfully, but these errors were encountered: