Skip to content

Instantly share code, notes, and snippets.

@nirbhayc
Created May 24, 2019 14:34
Show Gist options
  • Star 1 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save nirbhayc/963ce2d05e2bb17911986cb5f5d65e35 to your computer and use it in GitHub Desktop.
Save nirbhayc/963ce2d05e2bb17911986cb5f5d65e35 to your computer and use it in GitHub Desktop.
Comdb2 temporary tables
create table t1(i int)$$
select * from t1;
- cur->vs_stab = bdb_temp_table_create(cur->state, bdberr); // bdb/cursor.c (Table of records to skip in the virtual stripe.)
insert into t1 values(1);
- tran->db = bdb_temp_array_create(thedb->bdb_env, &bdberr); // osqlq_bplog_start() db/osqlblockproc.c (temptable for bplog)
- tran->db_ins = bdb_temp_array_create(thedb->bdb_env, &bdberr); // osqlq_bplog_start() db/osqlblockproc.c (reorder)
- rc = create_tablecursor(env->bdb_env, &tbl->add_tbl, &tbl->add_cur, &bdberr, // osql_insrec() (shadow - add tbl)
- rc = create_tablecursor(env->bdb_env, &tbl->upd_tbl, &tbl->upd_cur, &bdberr, // osql_insrec() (shadow - upd tbl)
- rc = create_tablecursor(env->bdb_env, &tbl->blb_tbl, &tbl->blb_cur, &bdberr, // osql_insrec() (shadow - blb tbl)
- rc = create_tablecursor(env->bdb_env, &tbl->delidx_tbl, &tbl->delidx_cur, (shadow - delidx tbl)
- rc = create_tablecursor(env->bdb_env, &tbl->insidx_tbl, &tbl->insidx_cur, (shadow - inxidx tbl)
- thdinfo->ct_add_table = create_constraint_table();
- thdinfo->ct_del_table = create_constraint_table();
- thdinfo->ct_add_index = create_constraint_index_table();
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment