[JBoss JIRA] (ISPN-7209) Collation not set properly when data stored via Hot Rod when JdbcStringBasedStore is used with MariaDB
by Jiří Holuša (JIRA)
[ https://issues.jboss.org/browse/ISPN-7209?page=com.atlassian.jira.plugin.... ]
Jiří Holuša commented on ISPN-7209:
-----------------------------------
[~ryanemerson] I used the MariaDB driver. I know they are quite similar, but it occurred to me that it's a first choice to use MariaDB driver when using MariaDB database :-D Silly me :-D
> Collation not set properly when data stored via Hot Rod when JdbcStringBasedStore is used with MariaDB
> ------------------------------------------------------------------------------------------------------
>
> Key: ISPN-7209
> URL: https://issues.jboss.org/browse/ISPN-7209
> Project: Infinispan
> Issue Type: Bug
> Components: Loaders and Stores
> Affects Versions: 9.0.0.Alpha4
> Reporter: Jiří Holuša
> Assignee: Ryan Emerson
>
> Given following scenario:
> 1) store entry to ISPN server via Hot Rod (e.g. with RemoteCache)
> 2) have the server configured to use JdbcStringBasedStore
> 3) used database is MariaDB 10
> Following exception is thrown:
> {code}
> ERROR [org.infinispan.persistence.jdbc.stringbased.JdbcStringBasedStore] (HotRodServerHandler-3-2) ISPN008024: Error while storing string key to database; key: '9A09AJAAAAAAAAA==': java.sql.BatchUpdateException: Illegal mix of collations (latin1_swedish_ci,IMPLICIT) and (utf8_general_ci,COERCIBLE) for operation '='
> {code}
> Note that his doesn't happen when stored via, for example, Memcached client. Also this issue doesn't appear in library mode, doesn't appear in any with any other database (including MySQL, which is very similar to MariaDB).
--
This message was sent by Atlassian JIRA
(v7.2.3#72005)
7 years, 5 months
[JBoss JIRA] (ISPN-7280) Boolean comparisons fail during parsing of query string
by Gustavo Fernandes (JIRA)
[ https://issues.jboss.org/browse/ISPN-7280?page=com.atlassian.jira.plugin.... ]
Gustavo Fernandes updated ISPN-7280:
------------------------------------
Status: Resolved (was: Pull Request Sent)
Resolution: Done
> Boolean comparisons fail during parsing of query string
> -------------------------------------------------------
>
> Key: ISPN-7280
> URL: https://issues.jboss.org/browse/ISPN-7280
> Project: Infinispan
> Issue Type: Bug
> Components: Embedded Querying, Remote Querying
> Reporter: Adrian Nistor
> Assignee: Adrian Nistor
> Fix For: 9.0.0.Beta1
>
>
> The query "SELECT _gen0.name, _gen0.age FROM runner _gen0 WHERE _gen0.finished = true" fails at render phase.
> java.lang.IllegalStateException: ISPN028517: The predicate org.infinispan.objectfilter.impl.syntax.parser.FilterExpressionBuilder$LazyLeafBooleanExpr@44bfa0bd can not be added since there may be only one root predicate.
--
This message was sent by Atlassian JIRA
(v7.2.3#72005)
7 years, 5 months