google-code-export / sqlite-manager

Automatically exported from code.google.com/p/sqlite-manager
1 stars 0 forks source link

sqlite manager not running with recursive query #846

Open GoogleCodeExporter opened 9 years ago

GoogleCodeExporter commented 9 years ago
What steps will reproduce the problem?
1. run this query:
WITH RECURSIVE
  cnt(x) AS (VALUES(1) UNION ALL SELECT x+1 FROM cnt WHERE x<1000000)
SELECT x FROM cnt;
which is copied from the sqlite site
http://www.sqlite.org/lang_with.html

2.
3.

What is the actual output?
SQLiteManager: Likely SQL syntax error: WITH RECURSIVE
  cnt(x) AS (VALUES(1) UNION ALL SELECT x+1 FROM cnt WHERE x<1000000)
SELECT x FROM cnt; [ near "WITH": syntax error ]
Exception Name: NS_ERROR_FAILURE
Exception Message: Component returned failure code: 0x80004005 
(NS_ERROR_FAILURE) [mozIStorageConnection.createStatement]

What is the expected output?
1 2 3 4 5 6 7 8 9 10

What version of the product are you using? On what target Application (e.g.
Firefox 4.0.1, etc.)? On what operating system? firefox 29.0.1
Extension Version = 0.8.1
Application =
OS = win7

Please provide any additional information below. In some cases
errors/warnings may be logged in the Error Console (in Firefox) which is
available under the Tools menu or using Ctrl+Shift+J. If you find any
related to this extension, please report that too.

Original issue reported on code.google.com by david.an...@gmail.com on 7 Jun 2014 at 6:26