#738 Strange SQL-query form

[azz]

1) Move to "SQL command" page
2) Past SQL to SQL-query form:

SELECT *
FROM
  "log" lc
  JOIN "con" c ON c.id = lc.id
WHERE
  "c_id" IN ($1,$2) AND
  "timestamp" >= $3 AND
  "timestamp" <= $4
  AND (
    data->>'code' = $5 AND data->'data'->>'key' = $6
  )
  OR (
    data->>'code' = $7 AND data->'data'->>'key' = $8
  )
ORDER BY "lc"."id" DESC
LIMIT 10 OFFSET 0

3) Try to delete (via Del or Backspace) parameters $1 or $2
As result cursor jump to the first/last symbol of the query, depending of browser.
Tested on Windows 7, FF 72.0.2, IE 11.0.9600.19569, Chrome 80.0.3987.87

Adminer version 4.7.6, with no other plugins or css

[Jakub Vrána]

I couldn't reproduce this. Which DB server?

[azz]

Interesting. I see this only in PostgreSQL. If server MySQL, all ok. Also, in PostgreSQL the sql highlight is broken after "SELECT *"

[Jakub Vrána]

Fixed by 64d4818a.