Column called "index" causes ADA 4.1.14 to fail actions 0.1 and 4.D_1

[davidnutter]

This issue arises with ADA 4.1.14

A tableIndex file which triggers the problem is attached.

tabelIndex-causes-ada4_114-to-crash.txt

Summary:

The column "index" in "table77" (name: "fitbit_sleep_data") causes the error given in ADA_ERROR.txt to appear. This prevents ADA from undertaking many tests as the table information is not available.

Renaming the column and corresponding column in the primary key to "sleep_index" resolve the issue and ADA can analyse the file again.

I suspect some input escaping is missing in ADA somewhere so the bareword "index" is treated as the INDEX SQL keyword, causing a syntax error.