Skip to content

Running view in both SQLite-Manager and SQLiteStudio...regexp not recognized #88

@curleb

Description

@curleb

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

Metadata

Metadata

Assignees

No one assigned

    Labels

    No labels
    No labels

    Projects

    No projects

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions