649151 - User created functions in mozIStorageConnection will error if used asynchronously

Status: RESOLVED DUPLICATE of bug 1205205

(Core :: SQLite and Embedded Database Bindings, defect, P3)

Description

[agilmore]

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".

Comment 1

[agilmore]

Attachment: Demonstrates bug

Attached JS can be run in Developer's Extension's "JavaScript Environment".  On 3.6 it works, errors on 4.0.

Comment 2

[Shawn Wilsher :sdwilsh]

This broke because of bug 608142.

Comment 3

[BugBot [:suhaib / :marco/ :calixte]]

In the process of migrating remaining bugs to the new severity system, the severity for this bug cannot be automatically determined. Please retriage this bug using the new severity system.

Comment 4

[BugBot [:suhaib / :marco/ :calixte]]

The severity field is not set for this bug.
:mak, could you have a look please?

For more information, please visit BugBot documentation.

Comment 5

[Marco Bonardo [:mak]]

we don't want functions to be implemented in js, let's just keep everything in bug 1205205