com.pivotal.gemfirexd.internal.shared.common.
sanity.AssertFailure?: ASSERT FAILED No parameters expected 
to be < 0.0

update trade.portfolio set subTotal = ? * qty.

update trade.portfolio 
set subTotal = Cast(?) 
as decimal(30,20) * qty

select cid, cast(max(price) as decimal(30,1))
from trade.txhistory  where tid =? GROUP BY cid, type

update foo set col1=val1 where col1=val0;
delete from foo where col1=val1;

• JDBCMBean for monitoring the JDBC driver version information.
• ManagementMBean for monitoring the management status.
• NetworkServerMBean for monitoring statistics associated with a GemFire XD member's Network Server (client) connections.
• VersionMBean for monitoring the GemFire XD member version and product information.

CREATE TABLE T1 (COL1 INTEGER, COL2 INTEGER); 
CREATE UNIQUE INDEX I1 ON T1(COL1,COL2); 
INSERT INTO T1 VALUES (1, 2); 
INSERT INTO T1 VALUES (2,1); 
UPDATE T1 SET COL1 = COL2, COL2 = COL1;

select * from sys.members

gfxd>  create table t1 (c1 int, c2 int) 
> partition by column(c1);
gfxd>  create table empty (c1 int, c2 int) 
> partition by column(c1); 
gfxd>  insert into t1 values 
> (null,null),(1,1),(null,null),(2,1),(3,1),(10,10); 
gfxd>  select max((select c1 from empty)) 
> from t1;

[info 2013/09/11 11:20:32.525 EDT SQLF:  tid=0x44] 
(XID=154(UserTransaction)@463505cb;txState=null;
supportsTX=true), 
(SESSIONID = 3), (DATABASE = sqlfire), (DRDAID = null), 
Failed Statement is: 
select max((select c1 from empty)) from t1
com.gemstone.gemfire.internal.cache.execute.
BucketMovedException:
    Bucket migrated to another node. Please
    retry.[buckedId=1,region=/APP/EMPTY] 
[...]

create table t1(c1 int) partition by column(c1);
create table insert_test(c1 int, c2 int, c3 int);

delete from insert_test where c1 = 
 (select 9 from t1 a join t1 b
  on a.c1 = b.c1 where a.c1 = 1);

create table insert_test
(c1 int, c2 int, c3 int) 
partition by primary key;

select col1 from z where col1 in (select 
sum(distinct col2) 
from x group by col2);

java.lang.ClassCastException:
  com.pivotal.gemfirexd.internal.iapi.types.
SQLInteger cannot 
  be cast to com.pivotal.gemfirexd.internal.iapi.
types.UserDataValue

select col1 from z 
where col1 in 
(select cast(sum(distinct col2) 
as int) 
from x group by col2);

select (select i from t where i = 2) * 
  (select s from t where i = 2) from s 
  where i > (select i from t where i = 0) - 
  (select i from t where i = 0);

22003:The resulting value is outside the range 
for the data type <datatypeName>

try {
 conn.rollback();
 conn.close(); 
} catch (SQLException sqle) {
 // log failure if required 
}

1. Site-2 has a table with one extra column, compared to an associated table in site-1.
2. A row is inserted on site-1 which is then replicated to site-2.
3. A select query of the table on site-2 will hang.

1. The member hosting secondary buckets for the table goes offline.
2. The member hosting primary buckets evicts a table entry.
3. The secondary member returns online, and recovers the older entry.
4. The primary member goes offline.

gfxd> create table a (symbol varchar(10), 
> exchange varchar(10), constraint sec_uq
> unique (symbol, exchange)); 
0 rows inserted/updated/deleted 
gfxd> set ISOLATION READ COMMITTED; 
0 rows inserted/updated/deleted 
gfxd> insert into a (symbol, exchange) 
> values('a', 'a'); 
1 row inserted/updated/deleted 
gfxd> commit; 
gfxd> AUTOCOMMIT off; 
gfxd> update a set symbol = 'b' where 
> symbol='a' and exchange = 'a'; 
1 row inserted/updated/deleted 
gfxd> select * from a; 
SYMBOL |EXCHANGE
------------------- 
b      |a 
1 row selected 
gfxd> update a set symbol =
  'a' where symbol ='b' and exchange = 'a'; 
ERROR 23505: SQLSTATE=23505,SEVERITY=-1: 
[...]

select innerQuery.nl, innerQuery.valid_until
> from (select b.valid_until, b.nl from A a 
> LEFT JOIN B b ON a.cell_id=b.cell_id)
> innerQuery group by innerQuery.nl;

Re-writing the query to add the missing column from the inner query (valid_until) to the outer query succeeds:

select innerQuery.nl, innerQuery.valid_until
> from (select b.valid_until, b.nl from A a 
> LEFT JOIN B b ON a.cell_id=b.cell_id)
> innerQuery group by innerQuery.nl,
> innerQuery.valid_until;

CREATE TABLE APP."Order" ( Id int NOT NULL );
INSERT INTO APP."Order"(id) values (1);

select dsid() as "Member", * from emp;

select dsid() as "member", 
 e.* from emp e;

For example, consider the case where a long-running query is being executed and a DDL operation such as TRUNCATE TABLE is executed on the same table. The DDL operation obtains a data dictionary lock and then waits for the table lock that was obtained by the query. The data dictionary lock prevents new connections to the system, so you cannot create a new connection in order to cancel the long-running query. In this case you would need to wait until the DDL statement times out (5 minutes by default) before you could connect to the system and cancel the long-running query.

This problem does not occur when mapping stored procedures to a model objects that were generated from existing GemFire XD objects (the "database first" approach described in Generating a New Model from a GemFire XD Schema).