static void test_mdev_4995() { DYNAMIC_COLUMN dyncol; uint column_count= 5; int rc; mariadb_dyncol_init(&dyncol); rc= mariadb_dyncol_column_count(&dyncol,&column_count); ok( (rc == ER_DYNCOL_OK), "%s", "test_mdev_4995"); }
static int dyncol_column_count(MYSQL *mysql) { DYNAMIC_COLUMN dyncol; uint column_count= 5; int rc; mariadb_dyncol_init(&dyncol); /* memset(&dyncol, 0, sizeof(DYNAMIC_COLUMN)) */ rc= mariadb_dyncol_column_count(&dyncol, &column_count); diag("rc=%d", rc); FAIL_IF(rc < 0, "unexpected error"); FAIL_IF(column_count > 0, "Expected column_count=0"); return OK; }
static int create_dyncol_num(MYSQL *mysql) { DYNAMIC_COLUMN dyncol; DYNAMIC_COLUMN_VALUE vals[5]; uint i, column_count= 5; uint my_count; MYSQL_LEX_STRING *my_keys; DYNAMIC_COLUMN_VALUE *my_vals; int rc; char *strval[]= {"Val1", "Val2", "Val3", "Val4", "Val5"}; uint keys1[5]= {1,2,3,4,5}, keys2[5]= {1,2,2,4,5}; MYSQL_LEX_STRING key1= {"1",1}; for (i=0; i < column_count; i++) { vals[i].type= DYN_COL_STRING; vals[i].x.string.value.str= strval[i]; vals[i].x.string.value.length= strlen(strval[i]); vals[i].x.string.charset= (CHARSET_INFO *)mysql->charset; } FAIL_IF(mariadb_dyncol_create_many_num(&dyncol, column_count, keys1, vals, 1) <0, "Error (keys1)"); vals[0].x.string.value.str= strval[1]; rc= mariadb_dyncol_update_many_named(&dyncol,1, &key1, vals); diag("update: %d", rc); rc= mariadb_dyncol_unpack(&dyncol, &my_count, &my_keys, &my_vals); diag("unpack: %d %d", rc, my_count); diag("---------------__"); for(i=0; i < 5; i++) { diag("%s %d", my_keys[i].str, my_keys[i].length); } free(my_keys); free(my_vals); FAIL_IF(mariadb_dyncol_column_count(&dyncol, &column_count) < 0, "Error"); FAIL_IF(column_count != 5, "5 columns expected"); mariadb_dyncol_free(&dyncol); FAIL_IF(mariadb_dyncol_create_many_num(&dyncol, column_count, keys2, vals, 1) >=0, "Error expected (keys2)"); mariadb_dyncol_free(&dyncol); return OK; }
static int create_dyncol_named(MYSQL *mysql) { DYNAMIC_COLUMN dyncol; DYNAMIC_COLUMN_VALUE *vals; uint i, column_count= 6; int rc; char *strval[]= {"Val1", "Val2", "Val3", "Val4", "Val5", "Val6"}; MYSQL_LEX_STRING keys1[]= {{"key1", 4}, {"key2", 4}, {"key3", 4}, {"key4", 4}, {"key5", 4}, {"key6", 4}}, keys2[]= {{"key1", 4}, {"key1", 4}, {"key3", 4}, {"key4", 4}, {"key5", 4}, {"key6", 4}}, keys3[]= {{"\x70\x61\x72\x61\x00\x30", 6}, {"\x70\x61\x72\x61\x00\x31", 6}, {"\x70\x61\x72\x61\x00\x32", 6}, {"\x70\x61\x72\x61\x00\x33", 6}, {"\x70\x61\x72\x61\x00\x34", 6}, {"\x70\x61\x72\x61\x00\x35", 6}}; MYSQL_LEX_STRING *my_keys; uint my_count; vals= (DYNAMIC_COLUMN_VALUE *)malloc(column_count * sizeof(DYNAMIC_COLUMN_VALUE)); for (i=0; i < column_count; i++) { vals[i].type= DYN_COL_STRING; vals[i].x.string.value.str= strval[i]; vals[i].x.string.value.length= strlen(strval[i]); vals[i].x.string.charset= (CHARSET_INFO *)mysql->charset; diag("%s", keys3[i].str); } mariadb_dyncol_init(&dyncol); rc= mariadb_dyncol_create_many_named(&dyncol, column_count, keys1, vals, 0); FAIL_IF(mariadb_dyncol_create_many_named(&dyncol, column_count, keys1, vals, 1) < 0, "Error"); column_count= 0; FAIL_IF(mariadb_dyncol_column_count(&dyncol, &column_count) < 0, "Error"); FAIL_IF(column_count != 6, "6 columns expected"); mariadb_dyncol_free(&dyncol); rc= mariadb_dyncol_create_many_named(&dyncol, column_count, keys3, vals, 1); if (rc < 0) { diag("Error!!: %d", rc); return FAIL; } column_count= 0; FAIL_IF(mariadb_dyncol_column_count(&dyncol, &column_count) < 0, "Error"); FAIL_IF(column_count != 6, "6 columns expected"); mariadb_dyncol_free(&dyncol); /* Now try to add a duplicate key */ FAIL_IF(mariadb_dyncol_create_many_named(&dyncol, column_count, keys2, vals, 1) >=0, "Error expected"); mariadb_dyncol_free(&dyncol); /* binary keys */ rc= mariadb_dyncol_create_many_named(&dyncol, column_count, keys3, vals, 1); FAIL_IF(rc < 0, "binary keys failed"); /* get keys*/ rc= mariadb_dyncol_list_named(&dyncol, &my_count, &my_keys); FAIL_IF(rc < 0, "list named failed"); for (i=0; i < my_count; i++) { if (memcmp(my_keys[i].str, keys3[i].str, keys3[i].length) != 0) diag("error key %d", i); vals[i].type=DYN_COL_NULL; } rc= mariadb_dyncol_update_many_named(&dyncol, column_count, keys3, vals); FAIL_IF(rc < 0, "update failed"); mariadb_dyncol_free(&dyncol); keys3[0].str= "test"; for (i=0; i < column_count; i++) diag("%s", my_keys[i].str); free(vals); free(my_keys); return OK; }