User created functions in mozIStorageConnection will error if used asynchronously

NEW
Unassigned

Status

()

defect
P3
major
8 years ago
3 years ago

People

(Reporter: agilmore, Unassigned)

Tracking

(Blocks 1 bug)

Firefox Tracking Flags

(Not tracked)

Details

Attachments

(1 attachment)

1.18 KB, application/javascript
Details
(Reporter)

Description

8 years ago
User-Agent:       Mozilla/5.0 (X11; U; Linux i686; en-US) AppleWebKit/534.16 (KHTML, like Gecko) Chrome/10.0.648.204 Safari/534.16
Build Identifier: 4.0

If you create a function (https://developer.mozilla.org/en/mozIStorageConnection#createAsyncStatement()) it will work if you execute it synchronously, but will error with "SQL logic error or missing database" when you attempt to execute asynchronously.

This worked as expected without issue in FF 3.6, the error is new in FF4.

Reproducible: Always

Steps to Reproduce:
1.Connect to a database
2.Create a function
3.Execute statement asynchronously that calls the created function
Actual Results:  
Errors, "SQL logic error or missing database"

Expected Results:  
It should execute the statement without error.

This error is new in FF4, it worked fine in FF3.6.  It's additionally problematic as all documentation encourages asynchronously execution of SQL, synchronous execute is "strongly discouraged".
(Reporter)

Comment 1

8 years ago
Posted file Demonstrates bug
Attached JS can be run in Developer's Extension's "JavaScript Environment".  On 3.6 it works, errors on 4.0.
Component: General → Storage
Product: Core → Toolkit
QA Contact: general → storage
This broke because of bug 608142.
Blocks: 608142
Status: UNCONFIRMED → NEW
Ever confirmed: true
Priority: -- → P3
You need to log in before you can comment on or make changes to this bug.