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)