google-code-export / sqlite-manager

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

Cannot user REGEXP #818

Open GoogleCodeExporter opened 9 years ago

GoogleCodeExporter commented 9 years ago
What steps will reproduce the problem?
1. Link to a database and query a table using regexp
2. SELECT * FROM events WHERE details REGEXP ".*"

What is the actual output?
SQLiteManager: Likely SQL syntax error: SELECT * FROM events WHERE details 
REGEXP ".*" [ no such function: REGEXP ]
Exception Name: NS_ERROR_FAILURE
Exception Message: Component returned failure code: 0x80004005 
(NS_ERROR_FAILURE) [mozIStorageConnection.createStatement]

What is the expected output?
Some lines of the table

What version of the product are you using? On what target Application 
Extension Version = 0.8.1
Application = Firefox 23.0.1
OS = Windows 7

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 heliosan...@gmail.com on 30 Oct 2013 at 11:28