You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@ignite.apache.org by "Mikhail Pochatkin (Jira)" <ji...@apache.org> on 2025/10/02 14:49:00 UTC
[jira] [Updated] (IGNITE-26586) Fix column casesensitive mapping
[ https://issues.apache.org/jira/browse/IGNITE-26586?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Mikhail Pochatkin updated IGNITE-26586:
---------------------------------------
Description:
When creating a case sensitive column in SQL DDL
{code:java}
sql-cli> CREATE TABLE sampleTable ("lowercase" varchar(255), id int primary key); sql-cli> select * from sampleTable;
╔═══════════╤════╗
║ lowercase │ ID ║{code}
{code:java}
static class PojoExample {
@Id int id;
@Column("lowercase") //tried ("LOWERCASE") and even ("\"lowercase\"")
String lowercase;
}
{code}
As result
{code:java}
RecordView<PojoExample> rView = client.tables().table("sampleTable").recordView(PojoExample.class);
PojoExample pojo = new PojoExample(1,"test");
rView.upsert(null, pojo); {code}
I always get an error
{code:java}
java.lang.IllegalArgumentException: Fields [lowercase] of type javatables.JavaTableAnnotationExample$PojoExample are not mapped to columns {code}
was:
When creating a case sensitive column in SQL DDL
sql-cli> CREATE TABLE sampleTable ("lowercase" varchar(255), id int primary key); sql-cli> select * from sampleTable;
╔═══════════╤════╗
║ lowercase │ ID ║
static class PojoExample {
@Id int id;
@Column("lowercase") //tried ("LOWERCASE") and even ("\"lowercase\"") String lowercase;
}
As result
RecordView<PojoExample> rView = client.tables().table("sampleTable").recordView(PojoExample.class);
PojoExample pojo = new PojoExample(1,"test");
rView.upsert(null, pojo);
I always get an error
{{}}
{code:java}
java.lang.IllegalArgumentException: Fields [lowercase] of type javatables.JavaTableAnnotationExample$PojoExample are not mapped to columns {code}
> Fix column casesensitive mapping
> ---------------------------------
>
> Key: IGNITE-26586
> URL: https://issues.apache.org/jira/browse/IGNITE-26586
> Project: Ignite
> Issue Type: Bug
> Components: tables ai3
> Affects Versions: 3.0
> Reporter: Mikhail Pochatkin
> Assignee: Mikhail Pochatkin
> Priority: Major
> Labels: ignite-3
> Time Spent: 10m
> Remaining Estimate: 0h
>
> When creating a case sensitive column in SQL DDL
> {code:java}
> sql-cli> CREATE TABLE sampleTable ("lowercase" varchar(255), id int primary key); sql-cli> select * from sampleTable;
> ╔═══════════╤════╗
> ║ lowercase │ ID ║{code}
>
> {code:java}
> static class PojoExample {
> @Id int id;
> @Column("lowercase") //tried ("LOWERCASE") and even ("\"lowercase\"")
> String lowercase;
> }
> {code}
>
>
> As result
> {code:java}
> RecordView<PojoExample> rView = client.tables().table("sampleTable").recordView(PojoExample.class);
> PojoExample pojo = new PojoExample(1,"test");
> rView.upsert(null, pojo); {code}
>
> I always get an error
> {code:java}
> java.lang.IllegalArgumentException: Fields [lowercase] of type javatables.JavaTableAnnotationExample$PojoExample are not mapped to columns {code}
--
This message was sent by Atlassian Jira
(v8.20.10#820010)