[jira] [Created] (METAMODEL-1220) Metamodel judge Oracle dataType 'NVARCHAR2' not as a 'string' but 'OTHER'

["longxin (Jira)" <ji...@apache.org>]

longxin created METAMODEL-1220:
----------------------------------

             Summary: Metamodel judge Oracle dataType 'NVARCHAR2' not as a 'string' but 'OTHER'
                 Key: METAMODEL-1220
                 URL: https://issues.apache.org/jira/browse/METAMODEL-1220
             Project: Apache MetaModel
          Issue Type: Improvement
    Affects Versions: 5.3.1
         Environment: Oracle 11g
            Reporter: longxin


----------------------------------------table----------------------------

CREATE TABLE "XXX"."NewTable" (
"GUID" CHAR(32 BYTE) DEFAULT sys_guid() NOT NULL ,
"PUST_CODE" CHAR(12 BYTE) NOT NULL ,
"PUST_NAME" NVARCHAR2(100 CHAR) NOT NULL ,
"FROM_DATE" DATE NOT NULL ,
"TO_DATE" DATE NULL ,
PRIMARY KEY ("GUID")
)

----------------------------------------table----------------------------

when i do query like this:

*where("PUST_NAME").like("xxx")*

i get error below:

java.lang.IllegalArgumentException: Can only use LIKE operator with strings

java.lang.IllegalArgumentException: Can only use LIKE operator with strings at org.apache.metamodel.query.FilterItem.require(FilterItem.java:189) at org.apache.metamodel.query.FilterItem.<init>(FilterItem.java:109) at org.apache.metamodel.query.builder.AbstractFilterBuilder.like(AbstractFilterBuilder.java:450)



--
This message was sent by Atlassian Jira
(v8.3.4#803005)