VERIFIED SOLUTION i

Resolve the MapInfo Professional Query optimization bug - index file not closed - Bug

Products Affected: MapInfo Pro

Issue

The following scenario the produces a bug in MapInfo Pro
 
1. Try to open the attached two tables and run the attached MapBasic application
2. Hit Yes to continue to two times it appears
3. You should get a number of errors printed to the Message window similar to these:
 
366 (dtdtest.mb:55) Fil #1050 er ikke åben for adgang. EDProcessDataset_Single: 1023: Proces: Select into __MATCH__FOUND Latest Statement: Where KVHX = '5610 | Langstedgyden 31'
366 (dtdtest.mb:55) Fil #1050 er ikke åben for adgang. EDProcessDataset_Single: 2045: Proces: Select into __MATCH__FOUND Latest Statement: Where KVHX = '5610 | Ved Stranden 38'

“File 1050 is not open for access: …”

4. Change the column width of KVHX in MYTABLE_B to 128, the error will not appear. If you change it back to 129, the error appears again.

Cause

MapInfo Pro ® is hitting the limitations of the column width due to a bug.

Resolution

UPDATED: September 6, 2017
This bug has been raised under MIPRO-63500. This will be looked at for future releases of MapInfo Pro