ignite-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From iceguo <gu...@ffcs.cn>
Subject Re: The result of cross-cache SQL joins is incomplete.
Date Tue, 03 Nov 2015 10:33:30 GMT
Thank you for your kindness.

Could you please help me to collocate the following object?

CREATE TABLE  T1 
 ( LAT_ID        SMALLINT,
   DEV_ID    VARCHAR(20),
   DEV_LV    SMALLINT
 );
  
  CREATE TABLE  T2
 ( THE_DATE              DATE,
   DEV_ID           VARCHAR(20),
   DEV_LV          SMALLINT
 );
 
 CREATE TABLE  T3 
 ( ID         INTEGER     	PRIMARY KEY    NOT NULL,
   DEV_TYPE   VARCHAR(200),
   DEV_ID     VARCHAR(100)
 );

 p.s:
table T1 and T2 have no primary key.

SQL query:
SELECT t1.* from t1,t2,t3 where t2.DEV_ID = t1.DEV_ID and 
					     t2.DEV_LV = t1.DEV_LV and 
					     t1.DEV_ID = t3.DEV_ID;



--
View this message in context: http://apache-ignite-users.70518.x6.nabble.com/The-result-of-cross-cache-SQL-joins-is-incomplete-tp1723p1819.html
Sent from the Apache Ignite Users mailing list archive at Nabble.com.

Mime
View raw message