合 GBase 8a查询报错ERROR 1733 (HY000) at line 214: (GBA-01EX-700) Gbase general error: UNION/INTERSECT/MINUS of non-matching columns: VARCHAR UNION/INTERSECT/MINUS LONG_BLOB
现象
1 2 3 4 5 | ERROR 1733 (HY000) at line 214: (GBA-01EX-700) Gbase general error: UNION/INTERSECT/MINUS of non-matching columns: VARCHAR UNION/INTERSECT/MINUS LONG_BLOB ERROR 1733 (HY000) at line 430: (GBA-01EX-700) Gbase general error: UNION/INTERSECT/MINUS of non-matching columns: VARCHAR UNION/INTERSECT/MINUS MEDIUM_BLOB ERROR 1733 (HY000) at line 519: (GBA-01EX-700) Gbase general error: UNION/INTERSECT/MINUS of non-matching columns: VARCHAR UNION/INTERSECT/MINUS LONG_BLOB ERROR 1733 (HY000) at line 535: (GBA-01EX-700) Gbase general error: UNION/INTERSECT/MINUS of non-matching columns: VARCHAR UNION/INTERSECT/MINUS LONG_BLOB ERROR 1733 (HY000) at line 736: (GBA-01EX-700) Gbase general error: UNION/INTERSECT/MINUS of non-matching columns: VARCHAR UNION/INTERSECT/MINUS LONG_BLOB |
分析
找到脚本得第214行,发现是表SELECT * FROM INFORMATION_SCHEMA.PLUGINS
,