jvalencia wrote:On 5.2.2 you can type numbers but no letters
Yes this was a bug and is fixed in 5.2.3+
jvalencia wrote:On 5.2.3 shows the menu but the menu doesn't adjust to what I'm typing
I'll try 5.2.4 and see what it happens
in this area 5.2.4 should be the same as 5.2.3
But if you type fast then i guess it works. but if you type slower so first 1 char wait wait and then 1 more char the list is empty?
This is because we search then in memory on 1 string that is displayed instead of doing a like search on the database on 2 columns
Will see if i can improve this so that in memory behaves more like the database.
If you have 2 columns appended like you have in your example
column1 column2
then we generate a like on both:
elect distinct productid, productname from products where upper(productid) like ? or upper(productid) like ? or upper(productname) like ? or upper(productname) like ? order by productid asc, productname asc limit ?
so you get hits on both
but if we then have the list in memory and we know the database doesn't have more then we start searching in memory on the con catted string.. so you can suddenly no hits if you only hit the column2
The thing is what is really what we want if you append columns like that the user doesnt know we do a like value% so it should start with it.
is it logical that you get results from the database like that hits only column2? Because currently the typeahead behaves more like "like %value%" when looking in the ui...
EDIT: What database did you have when using 5.1 and which one on 5.2? Do you have something in your log?