why TDengine database could not store "La" and "la" as column name together?

Question

when I ran

create table t10 (ts timestamp,la int,`La` int);

it would tell me duplicated columns, I guess it is a bug ,right?

Answer 1

TDengine with this sql is ok:

create table t10 (`ts` timestamp, `la` int, `La` int);

But insert and select will cause error, this is surely a bug here. We'll work on this.

Answer 2

Hi， Since TDengine database 2.4.0.26 and 2.6.0.4 ，this bug has been fixed ,you could download it and try.