You are viewing a plain text version of this content. The canonical link for it is here.
Posted to user@ignite.apache.org by gn01887818 <gn...@gmail.com> on 2019/04/01 06:58:12 UTC
When querying data, the field name needs to be all uppercase
Use client mode.(java code)
CREATE TABLE `Sa` (
`BuyID` bigint(20) unsigned NOT NULL DEFAULT 0,
`Type` smallint(5) unsigned NOT NULL DEFAULT 0
);
Select BuyID from Sa; =>No data found.
Select BUYID from Sa; => have information.
It feels like the field is capitalized.
Is there a way to change the settings of ignite DB?
Let select BuyID from Sa;
Can I query the information?
Thank you
--
Sent from: http://apache-ignite-users.70518.x6.nabble.com/
Re: When querying data, the field name needs to be all uppercase
Posted by Ilya Kasnacheev <il...@gmail.com>.
Hello!
What's the dialect of this SQL?
This does not look like Ignite's CREATE TABLE nor it looks like Ignite's
behavior.
Regards,
--
Ilya Kasnacheev
пн, 1 апр. 2019 г. в 09:58, gn01887818 <gn...@gmail.com>:
> Use client mode.(java code)
>
> CREATE TABLE `Sa` (
> `BuyID` bigint(20) unsigned NOT NULL DEFAULT 0,
> `Type` smallint(5) unsigned NOT NULL DEFAULT 0
> );
>
> Select BuyID from Sa; =>No data found.
> Select BUYID from Sa; => have information.
>
> It feels like the field is capitalized.
>
> Is there a way to change the settings of ignite DB?
> Let select BuyID from Sa;
> Can I query the information?
>
> Thank you
>
>
>
> --
> Sent from: http://apache-ignite-users.70518.x6.nabble.com/
>