Hello!
Doesn't seem to match my observations:
~/Downloads/apache-ignite-2.7.6-bin% bin/sqlline.sh
sqlline version 1.3.0
sqlline> !connect jdbc:ignite:thin://localhost
Enter username for jdbc:ignite:thin://localhost:
Enter password for jdbc:ignite:thin://localhost:
0: jdbc:ignite:thin://localhost> CREATE TABLE "table" ("lowercaseid" INT
PRIMARY KEY, "mixedCaseVal" VARCHAR);
No rows affected (0,158 seconds)
0: jdbc:ignite:thin://localhost> select * from "table";
+--------------------------------+--------------------------------+
| lowercaseid | mixedCaseVal |
+--------------------------------+--------------------------------+
+--------------------------------+--------------------------------+
No rows selected (0,036 seconds)
0: jdbc:ignite:thin://localhost> select * from TABLE;
Error: Failed to parse query. Таблица "TABLE" не найдена
Table "TABLE" not found; SQL statement:
select * from TABLE [42102-197] (state=42000,code=1001)
0: jdbc:ignite:thin://localhost> select * from Table;
Error: Failed to parse query. Таблица "TABLE" не найдена
Table "TABLE" not found; SQL statement:
select * from Table [42102-197] (state=42000,code=1001)
0: jdbc:ignite:thin://localhost> !tables
+--------------------------------+--------------------------------+--------------------------------+--------------------------------+
| TABLE_CAT | TABLE_SCHEM |
TABLE_NAME | TABLE_TYPE |
+--------------------------------+--------------------------------+--------------------------------+--------------------------------+
| | PUBLIC | *table*
| TABLE |
+--------------------------------+--------------------------------+--------------------------------+--------------------------------+
0: jdbc:ignite:thin://localhost>
Note the lower case (in bold). Can you show what you see on your side?
Regards,
--
Ilya Kasnacheev
вт, 18 февр. 2020 г. в 17:44, Abhay Gupta <[email protected]>:
> As I said if we create table with “table”
>
> Then select would be like select * from “table” and not select * from
> table and same for every column where by default it makes table as TABLE
> and select * from table or Table or TABLE everything works fine .
>
> Regards
>
>
> On 18-Feb-2020, at 7:15 PM, Ilya Kasnacheev <[email protected]>
> wrote:
>
>
> Hello!
>
> Have you tried using case-sensitive column names, such as
> CREATE TABLE "table" ("lowercaseid" INT PRIMARY KEY, "mixedCaseVal"
> VARCHAR);
>
> Maybe it will help with your use case.
>
> Regards,
> --
> Ilya Kasnacheev
>
>
> вт, 18 февр. 2020 г. в 15:09, Igor Sapego <[email protected]>:
>
>> There are no such way in ODBC, but maybe SQL guys can suggest
>> some solution here.
>>
>> Anyway this is weird, as software that uses ODBC can actually query
>> ODBC driver for the case of the returned SQL symbols, and our driver
>> clearly states that it uses upper case.
>>
>> Best Regards,
>> Igor
>>
>>
>> On Tue, Feb 18, 2020 at 11:06 AM Abhay Gupta <[email protected]> wrote:
>>
>>> Hi,
>>>
>>>
>>>
>>> I am using UNIX ODBC and since create table command causes column name
>>> in UPPER case , and so SQLDescribeCol returns column name in UPPER case .
>>>
>>>
>>>
>>> Some of the application servers like Asterisk which checks the column
>>> name breaks as they expect the column name to be lower case . Is there a
>>> way to create column name in lower case and run the query on them without
>>> using double quotes .
>>>
>>>
>>>
>>> Regards,
>>>
>>>
>>>
>>> Abhay Gupta
>>>
>>>
>>>
>>
