How to use regexp condition in IQ?

788 Views

Dear All,

Now customer is migrating some of their system from vertica to our IQ. But there's some problems prevent we moving forward...

In vertica, there are some regular expression function eg. expreg(string,pattern).. and it's really helpful for their analysis systems. Now in IQ, I think maybe we can try the expreg condition to replace that ... But I can't make it work ==

(DBA)> select top 1 * from tt where Short_Text like '%support%';
Short_Text
--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
Upgrade Questions support@Huawei

(1 rows)

Execution time: 0.028 seconds
[Sybase][ODBC Driver][Sybase IQ]The result returned is non-deterministic

The result returned is non-deterministic
SQLCODE=122, ODBC 3 State="01000"
Line 1, column 1
select top 1 * from tt where Short_Text like '%support%'

(DBA)> select top 1 * from tt where Short_Text regexp '%support%';
Short_Text
--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------

(0 rows)

Execution time: 0.023 seconds

==

Would you please kind have a look? Thanks in advance for any help.

Regards

Eisen