Inconsistent results in use of regexp under SQLite-Manager (0.8.3.1) vs SQLiteStudio (3.1.1):
SQLiteManager: Likely SQL syntax error: PRAGMA "main".table_info("vw_template_page_a") [ **no such function: regexp** ]
Exception Name: NS_ERROR_FAILURE
Exception Message: Component returned failure code: 0x80004005 (NS_ERROR_FAILURE) [mozIStorageConnection.createStatement]
Following query functions as expected in SQLiteStudio:
SELECT
templ_id my_templ
,CASE
WHEN xml_content regexp ('ss:ExpandedColumnCount="11" ')
or xml_content regexp ('^ </Table>$')
THEN NULL
ELSE row_no
END page_start
,NULL page_end
,'['
|| xml_content
|| ']'
xml_content
FROM
_template templ
WHERE
xml_content
regexp ('<Table |</Table>')
AND page_start
IS NOT NULL
GROUP BY
my_templ
,row_no
Inconsistent results in use of regexp under SQLite-Manager (0.8.3.1) vs SQLiteStudio (3.1.1):
Following query functions as expected in SQLiteStudio: