create table t1 ( a int, b string(10));
insert into t1 values ( 1, 'alpha');
create btree b1 on t1(b,a); -- inverted, value for a would be not setup correctly

select
        sum(b) as sc,
        case when sum(b) > 700 
                then 'X'
		else 'Y' end as xy
from t1;

create table t1 ( a int, b string(30));
insert into t1 values ( 1, 'DONE');
insert into t1 values ( 2, 'DONE');
insert into t1 values ( 3, 'WAIT');
insert into t1 values ( 4, 'DONE');
insert into t1 values ( 5, 'WAIT');
update t1 set b = 'DONE' where b = 'WAIT' return :a = a; 

create table t1 ( a int, d datetime);
create btree b1 on t1(b);
select a from t1 where b = '12.07.2019'; -- should be casted from string to datetime

insert into a1 values ( 1, 'XXX');

create table t1 ( a int, b string(10), c string(30))
create alias a1 on t1 ( a as ax, b as bx);

drop if exists table t1;
list alias;
desc alias a1;
drop if exists alias a1;
create table t1 ( a int, b string(30));
create alias a1 on t1 ( a as ax, b as bx );

insert into a1 ( ax, bx ) values ( 1, 'XXX');
insert into a1 ( ax, bx ) values ( 2, 'YYY');
insert into a1 ( ax, bx ) values ( 3, 'ZZZ');

select ax from a1;

NUMRUN=100
DOTRANSACTION=-dotransaction
ARANGE=10000
AINTERVAL=500
ACOUNT=30000
PRIMARY=primary
POOLSIZE=191

• Fix added in CegoTransactionManager::commitUpdate, btree must be inserted with insertBTreeWithCommit
• Fix added in CegoTransactionManager::getCrashAffectedTables, schema entry must be searched with Find(CegoField(Chain(), SYS_RB_TABLE))

• In CegoRecoveryManager::recoverCurrentTransactionLog crash affected tables are analyzed at the beginning now. This must be done, since commit or rollback operations may occur in the recovery log
• In CegoTransactionManager, getObjectWithFix method calls have been eliminated. The sustained fix on the pages avoids writing the pages during checkpoint, which may result in inconsistent rollback segments
• In CegoObjectManager::createTableObject, the getNewFilePage method call was moved to the beginning. It may happen, that a checkpoint occur during the method call, which may result in inconsitent table entries ( newEntry is called, during getNewFilePage a checkpoint is forced which writes the incomplete page to disk and just after the checkpoint, the table information is encoded

select left(a,3) from t1 => length 3 is used for schema
select left(a,b) from t1 => definition of a is used for schema

start transaction;
insert into t1 values ( 1, 'XXX');
update t1 set b = 'FFF' where a = 1; -- here comes a duplicate error
commit;

#define NETMNG_MAXTUPLECOUNT 3000
#define NETMNG_MAXBYTECOUNT 10000000

create view v1 as
select a as a, b as b from t1
union all
select a as a, 0 as b from t2;

  select nextcount(mycount);

int s = sizeof(fv);
if ( fv.getLength() > STATICFIELDBUF )
   s += fv.getLength();
orderEntryLen += s; 

create table t1(a int); -- a sample table

select tx.a as xa, ty.a as ya from t1 tx left outer join t2 ty on tx.a = ty.a + 1;

drop if exists table t1;
create table t1 ( a int, b string(30));

drop if exists table t2;
create table t2 ( a int, b string(30));
create btree b2 on t2(a);

insert into t1 values ( 1, 'XXX');
insert into t1 values ( 2, 'YYY');
insert into t1 values ( 3, 'YYY');
insert into t1 values ( 4, 'YYY');

insert into t2 values ( 1, 'XXX');
insert into t2 values ( 2, 'YYY');
insert into t2 values ( 3, 'XXX');
insert into t2 values ( 4, 'YYY');


drop if exists procedure tproc;
@
create procedure tproc ( x in int )
begin
   delete from t1 where b in ( select b from t2 where a = :x );
end;
@

call tproc(2);
call tproc(3);

ma > create view tview as select distinct hostname, pfcontact from ma_sysview where sysrole = 'production'; 
View tview created 
ok ( 0.001 s ) 
ma > select * from tview; 
Error : Unknown attribute field  
Query failed 

drop if exists table t1;
create table t1 ( a int, b string(30));

create btree b1 on t1 ( a ); 
create unique btree b1 on t1 ( b );  -- this should result in an error

drop btree b1; 
drop btree b1;  -- at least both btrees could be dropped

For objectExists method, the value CegoObject::BTREE must be specifiy to detect the duplicates

drop if exists table t1; 
create table t1 ( a string(10), b string(10), c int ); 

insert into t1 values ( 'HUGO', 'ALPHA', 0 ); 
insert into t1 values ( 'HUGO', 'BETA', 0 ); 
insert into t1 values ( 'HUGO', 'GAMMA', 0 ); 
insert into t1 values ( 'HUGO', 'EPSILON', 0 ); 

create unique btree b1 on t1  ( a, b); 

-- this update will fail
update t1 set c = 1; 

 alter table t1 modify column a default 42; 

create table t1(a string(100));
insert into t1 values ( 'Hugo Habicht');
insert into t1 values ( 'Kim Kaiser');
select substr(a, 1, getpos(a, ' ')) from t1;

insert into t1 values ( 1, 'this is\
a multi line \
message \
with four lines');

CGCLT > select count(*) from t1;
+-----------+
|      AGGR |
|  count(*) |
+-----------+
|   2000000 |
+-----------+
1 tuples
ok ( 0.293 s )

CGCLT > select sum(a) + 0 from t1;
Error : Invalid expression sum(t1.a) + 0 for aggregation

fileId && pageId 

fileId || pageId

select count(*), a from t1 group by a; --works
select count(*), a from t1 tx group by a; -- broken

bigts > select count(*) from t1;
+-----------+
|      AGGR |
|  count(*) |
+-----------+
| 100119314 |
+-----------+
1 tuples
ok ( 47.803 s )
bigts > create btree b1 on t1(a);
Btree b1 created
ok ( 9584.849 s )