New issue
Advanced search Search tips
Note: Color blocks (like or ) mean that a user may not be available. Tooltip shows the reason.

Issue 818389 link

Starred by 2 users

Issue metadata

Status: Closed
Owner:
Closed: Dec 17
Cc:
Components:
EstimatedDays: ----
NextAction: ----
OS: Linux , Windows , Mac
Pri: 1
Type: Bug-Regression



Sign in to add a comment

Unable to type 2nd statement into WebSQL SQL Console after executing first sql statement

Reported by garybarn...@gmail.com, Mar 3 2018

Issue description

UserAgent: Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/64.0.3282.186 Safari/537.36

Steps to reproduce the problem:
1. Visit https://jsfiddle.net/Trae/76srLbwr/ or any other page that has a WebSQL database
2. Select the WebSQL database in Dev Tools->Application tab and execute the following line of SQL
select * from SQLITE_MASTER
3.Notice that the table displays correctly.
4.Click to place the caret beside the > under the table.

What is the expected behavior?
Should be able to place caret beside the > on the subsequent line and type another SQL statement.

What went wrong?
The caret does not appear. It is buggy in general.

Did this work before? N/A 

Chrome version: 64.0.3282.186  Channel: stable
OS Version: 10.0
Flash Version: 

Found this issue on 2 different Windows 10 PCs. WebSQL is deprecated, but for as long as its available it is useful in the development of cordova apps which target sqlite when deployed to devices. These can run and be debugged locally on PCs in the browser by using WebSQL.

https://github.com/litehelpers/Cordova-sqlite-storage
 
Labels: Needs-Triage-M64
Cc: sindhu.chelamcherla@chromium.org
Components: Blink>Editing>Selection
Labels: -Type-Bug -Pri-2 hasbisect-per-revision RegressedIn-60 Triaged-ET M-67 Target-67 FoundIn-67 OS-Linux OS-Mac Pri-1 Type-Bug-Regression
Owner: yoichio@chromium.org
Status: Assigned (was: Unconfirmed)
Able to reproduce this issue on reported version 64.0.3282.186 and on latest canary 67.0.3361.0 using Windows 10, MAc 10.13.3 and Ubuntu 14.04 with steps mentioned above.

Good Build: 60.0.3104.0
Bad Build: 60.0.3105.0

You are probably looking for a change made after 473152 (known good), but no later than 473153 (first known bad).
CHANGELOG URL:
 https://chromium.googlesource.com/chromium/src/+log/5b593eae748eb6b7145dfbe0692a2b97536c1da9..f56b768202fbf0ea253e350a43259781e453c48d

Review-Url: https://codereview.chromium.org/2887303002

Suspecting same from changelog.

@ yoichio: Please help in re-assigning if it is not related to your change.

Thanks!
Components: -Blink>Editing>Selection
Owner: ----
Status: Available (was: Assigned)
Since focusing is also broken, I didn't check if caret should blink.
WebSQL SQL Console is implemented with DatabaseQueryView.js unlike
general console(codemirror.js).

Since DatabaseQueryView doesn't implement focusing well, the SQL console
also should be implemented with codemirror.js.
Owner: hhli@chromium.org
Status: Assigned (was: Available)
Status: Unconfirmed (was: Assigned)
Hmm.. I can't repro it.

Visiting and running the script in https://jsfiddle.net/Trae/76srLbwr/ doesn't give me a WebSQL, so I tested on https://webkit.org/demos/sticky-notes/
Screen Shot 2018-12-13 at 15.02.21.png
35.2 KB View Download
Status: Closed (was: Unconfirmed)
I tested on 64.0.3282.0 on mac, and this problem does exist in that version. However it's gone in the current version (71.0.3578.98 on mac). Someone might fixed this issue by working on another issue, making this one obsolete.

Sign in to add a comment