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

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

    [ https://issues.apache.org/jira/browse/METAMODEL-1220?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16949315#comment-16949315 ] 

longxin commented on METAMODEL-1220:
------------------------------------

you mean this column("PUST_NAME" NVARCHAR2(100 CHAR) ) cannot support LIKE query.It sucks.

> 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: Bug
>    Affects Versions: 5.3.1
>         Environment: Oracle 11g
>            Reporter: longxin
>            Priority: Minor
>
> ----------------------------------------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)