#4916 (ok 4.5) Autocomplete either doesn't function at all or auto completes the original table name when joining multiple aliased tables

[DrY]

Suppose we have 3 tables table1, table2, table3

Whenever I write query of the form:

select t1.*, t2.field1, t3.* from
table1 as t1 inner join table2 as t2
on t1.id = t2.id -- 1st join condition
inner join table3 as t3
on t2.fk = t3.id -- 2nd join condition

then when I am in the process of typing the 2nd join condition, the autocomplete engine recognizes the list of t3 fields but when I select one of them it brings the full (unaliased) name of the table, i.e table3.

For the 1st condition, autocomplete simply doesn't work

[Madhura Jayaratne]

Autocomplete functionality uses a third party library and I have sent them a pull request here with fixes https://github.com/codemirror/CodeMirror/pull/3274

[Nisarg Jhaveri]

CodeMirror version 5.4.0 is released. Probably we can update the library now.

[Madhura Jayaratne]

Thanks Nisarg, I will update the library.

[Madhura Jayaratne]

Should be fixed with https://github.com/phpmyadmin/phpmyadmin/commit/0a0879ea1e517edeec0405aeccc9e7761d77f4c2