# Test that joins between INFORMATION_SCHEMA tables work as expected.
---
- CreateTable: c (cid INT PRIMARY KEY NOT NULL, cname VARCHAR(128))
---
- Statement: SELECT column_name, data_type, type_category, type_bundle_name FROM information_schema.columns c LEFT OUTER JOIN information_schema.types t ON c.data_type = t.type_name WHERE table_schema = 'test' AND table_name = 'c'
- output: [['cid', 'INT', 'INTEGER', 'MCOMPAT'],
           ['cname', 'VARCHAR', 'STRING_CHAR', 'MCOMPAT']]
...
Add a test for the originally reported failure.
Add a test for the originally reported failure.
