Range Check error in MySQL

Original Reporter info from Mantis: kluug.net @onpok
  • Reporter name: Ondrej Pokorny

Description:

I get a range check error when I execute this SQL:

SELECT * FROM INFORMATION_SCHEMA.COLUMNS WHERE table_name = :tablename ORDER BY ORDINAL_POSITION

The range check error happens in TConnectionName.MySQLDataType when assigning the ASize variable for AField^.Name='GENERATION_EXPRESSION'

because ASize is Integer and AField^.length>High(Integer)

Additional information:

Patch attached.

Mantis conversion info:

  • Mantis ID: 33916
  • Fixed in version: 3.1.1
  • Fixed in revision: 39320 (#52fd3256)
  • Target version: 3.2.0