Unable to run Select statment after installation of InfiniDB 4.5.0-1

8 posts / 0 new
Last post
jaydeep
jaydeep's picture
Offline
Last seen: 3 days 14 hours ago
Joined: Sep 20 2013
Junior Boarder

Posts: 5

jaydeep dalvi
Unable to run Select statment after installation of InfiniDB 4.5.0-1

 

I am able to create new database & table but unable to run select statment on that table.

Its showing below error for table GlobalelEment.

ERROR 138 (HY000): IDB-1000: 'GlobalelEment' and 'GlobalElement' are not joined.

 

I am able to run select statment on  default ''test'' database.

radams
radams's picture
Offline
Last seen: 7 hours 31 min ago
Joined: Jan 3 2011
Administrator

Posts: 492

Robert Adams
Unable to run Select statement after installation InfiniDB4.5

 

 

Can you post your sql? (show create table and query)

 

Thanks,

 

Robert

 

 

 

jaydeep
jaydeep's picture
Offline
Last seen: 3 days 14 hours ago
Joined: Sep 20 2013
Junior Boarder

Posts: 5

jaydeep dalvi
 

 

CREATE TABLE  `TmpDB`.`GlobalElement`
(
  `GEleRefID` bigint NULL,
  `TransformID` smallint NULL
) ENGINE=InfiniDB ;

SELECT * FROM TmpDB.GlobalElement;

 

Its showing below error

 

Description                                                                         

IDB-1000: 'globalelement' and 'globalelement' are not joined.

 

ErrorNr.

138

 

radams
radams's picture
Offline
Last seen: 7 hours 31 min ago
Joined: Jan 3 2011
Administrator

Posts: 492

Robert Adams
 We have no issues with

 

We have no issues with installing and running the same test. If you continue to have an issue, try 

a clean installation and  make sure postConfigure completes successfully.

 

Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 7
Server version: 5.1.73 InfiniDB 4.5.0-1
 
Copyright (c) 2014, InfiniDB, Inc. and/or its affiliates. All rights reserved.
Copyright (c) 2000, 2013, Oracle and/or its affiliates. All rights reserved.
 
InfiniDB is a registered trademark of InfiniDB, Inc. and/or its affiliates.
Oracle is a registered trademark of Oracle Corporation and/or its
affiliates. Other names may be trademarks of their respective
owners.
 
Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.
 
mysql> create database tmpdb;
Query OK, 1 row affected (0.00 sec)
 
mysql>  
mysql> CREATE TABLE  `TmpDB`.`GlobalElement`
    -> (
    ->   `GEleRefID` bigint NULL,
    ->   `TransformID` smallint NULL
    -> ) ENGINE=InfiniDB ;
Query OK, 0 rows affected (4.16 sec)
 
mysql> SELECT * FROM TmpDB.GlobalElement;
Empty set (0.67 sec)
jaydeep
jaydeep's picture
Offline
Last seen: 3 days 14 hours ago
Joined: Sep 20 2013
Junior Boarder

Posts: 5

jaydeep dalvi
 

 

Thank you very much for your help.

 

It is also worked for me if I am createing database in lower case.

 

Please let me know the setting if i want to create database in upper case.

 

Thanks

Jaydeep

 

 

jaydeep
jaydeep's picture
Offline
Last seen: 3 days 14 hours ago
Joined: Sep 20 2013
Junior Boarder

Posts: 5

jaydeep dalvi
 

 

Hello Robert,

 

I am able to create Table in upper case but not database.

 

However I am able to create all objects in upper / lower case in Calpont InfiniDB Community 2.2.11-1 by adding  set-variable =lower_case_table_names=0

in  /usr/local/Calpont/mysql/my.cnf
 

Thanks,

Robert

jaydeep
jaydeep's picture
Offline
Last seen: 3 days 14 hours ago
Joined: Sep 20 2013
Junior Boarder

Posts: 5

jaydeep dalvi
 

 

Hello Robert,

 

I am able to create Table in upper case but not database.

 

However I am able to create all objects in upper / lower case in Calpont InfiniDB Community 2.2.11-1 by adding  set-variable =lower_case_table_names=0

in  /usr/local/Calpont/mysql/my.cnf
 

Thanks,

Jaydeep

radams
radams's picture
Offline
Last seen: 7 hours 31 min ago
Joined: Jan 3 2011
Administrator

Posts: 492

Robert Adams
  Hi Jaydeep, As noted in the

 

 

Hi Jaydeep,

 

As noted in the Syntax Guide, all object names are stored in lower case in InfiniDB.

Calpont InfiniDB Community 2.2.11-1 is no longer supported.

 

Thanks,

 

Robert