How to use capture groups in a regex in Data explorer?

数据与报告
1

I get an error when I try to use capture groups with a question mark (...)?. For example:

select p.raw 
from posts p 
where p.raw ~* '^(muchas )?gracias$' 
limit 1;

This is the error:

ActiveRecord::PreparedStatementInvalid: wrong number of bind variables (1 for 2) in: /*
 * DataExplorer Query
 * Query: /admin/plugins/explorer?id=12
 * Started by: nacho
 */
WITH query AS (
select p.raw from posts p where p.raw ~* '^(muchas )?gracias$' limit 1
) SELECT * FROM query
LIMIT 1000

This works perfectly when querying the DB directly. Is there a way to bypass this in Data Explorer?

2 个赞
2

抱歉回复晚了。您报告的错误消息在搜索时出现了您的主题。

我最近在查看一个类似的问题。奇怪的是，如果添加以下注释，查询就可以在 Data Explorer 中运行：/*:0*/。例如：

select p.raw 
from posts p 
where p.raw ~* '^(muchas )?gracias$' 
limit 1

/*:0*/
4 个赞