UCanAccess Select语句，带有数字通配符，提供意外标记:REGEXP_MATCHES required

Question

Select [Field1], [Field2], [Table2].[Field3] from [Table1] 
LEFT JOIN [Table1] ON [Table1].[Field1] = [Table2].[Field1] 
where [Field1] NOT LIKE "T*"

try(PreparedStatement s = conn.prepareStatement("Select [Field1], [Field2], [Field3] from [Query1] where [Field2] 
BETWEEN ? AND ?")){
s.setDate(1,java.sql.Date.valueOf(df.getValue()));
s.setDate(2,java.sql.Date.valueOf(dfEnd.getValue()));
try(ResultSet rs = s.executeQuery()){ .... etc etc}

因此，我尝试更改保存在Access中的查询，如下所示：

问题1：

Select [Field1], [Field2], [Table2].[Field3] from [Table1] 
LEFT JOIN [Table1] ON [Table1].[Field1] = [Table2].[Field1] 
where [Field1] NOT LIKE "T#####"

在Access中，这很好地拉出了一个查询，从我所看到的来看，Access中没有任何问题。

 Select [Field1], [Field2], [Table2].[Field3] from [Table1] 
LEFT JOIN [Table1] ON [Table1].[Field1] = [Table2].[Field1] 
where [Field1] NOT LIKE \"T####\" AND [Field2] BETWEEN ? AND ?")){
s.setDate(1,java.sql.Date.valueOf(df.getValue()));
s.setDate(2,java.sql.Date.valueOf(dfEnd.getValue()));
try(ResultSet rs = s.executeQuery()){ .... etc etc}

UCAEXC::4.0.2意外标记：REGEXP_MATCHES必需：

我不确定从这里到哪里去。我的问题是为什么它不接受##这是UCanAccess的问题吗？java问题？权限问题？有变通办法吗？

Answer 1

我复制了你的问题。在UCanAccess 4.0.2下，以下工作如下：

SELECT * FROM Table1 WHERE Field1 LIKE "T#####"

但这失败了：

SELECT * FROM Table1 WHERE Field1 NOT LIKE "T#####"

不过，这个变通办法似乎还可以：

SELECT * FROM Table1 WHERE NOT (Field1 LIKE "T#####")