Details
-
Type:
Suggestion
-
Status: Closed
-
Priority:
P2: Important
-
Resolution: Out of scope
-
Affects Version/s: 4.7.2
-
Fix Version/s: None
-
Component/s: SQL Support
-
Labels:None
-
Environment:
kubuntu 10.10 (64 bits)
Description
By default sqlite does not have an implementation for the statement "REGEXP".
So, the following sql order is failing:
"SELECT * FROM mytable WHERE myattribute REGEXP 'A[0-9]*';"
It could be very interesting to add an implementation for "REGEXP" base on QRegExp.
To do that, you have to call sqlite3_create_function in the SQLITE driver.
Regards.