Movatterモバイル変換

[0]ホーム
URL:

Skip to content

Navigation Menu

Sign in
Appearance settings

Search code, repositories, users, issues, pull requests...

Provide feedback

We read every piece of feedback, and take your input very seriously.

Saved searches

Use saved searches to filter your results more quickly

 Sign up
Appearance settings

Commitabd8ecd

Browse files
author
Marina Polyakova
committed
Code cleanup
1 parentfeaf986 commitabd8ecd

File tree

2 files changed

+32
-30
lines changed

2 files changed

+32
-30
lines changed

‎src/bin/pgbench/pgbench.c

Lines changed: 18 additions & 18 deletions
Original file line numberDiff line numberDiff line change
@@ -352,24 +352,6 @@ typedef struct BuiltinScript
352352
constchar*script;/* actual pgbench script */
353353
}BuiltinScript;
354354

355-
/* Default transaction isolation level */
356-
typedefenumDefaultIsolationLevel
357-
{
358-
READ_COMMITTED,
359-
REPEATABLE_READ,
360-
SERIALIZABLE,
361-
NUM_DEFAULT_ISOLATION_LEVEL
362-
}DefaultIsolationLevel;
363-
364-
DefaultIsolationLeveldefault_isolation_level=READ_COMMITTED;
365-
366-
staticconstchar*DEFAULT_ISOLATION_LEVEL_ABBREVIATION[]= {"RC","RR","S"};
367-
staticconstchar*DEFAULT_ISOLATION_LEVEL_SQL[]= {
368-
"read committed",
369-
"repeatable read",
370-
"serializable"
371-
};
372-
373355
staticconstBuiltinScriptbuiltin_script[]=
374356
{
375357
{
@@ -408,6 +390,24 @@ static const BuiltinScript builtin_script[] =
408390
}
409391
};
410392

393+
/* Default transaction isolation level */
394+
typedefenumDefaultIsolationLevel
395+
{
396+
READ_COMMITTED,
397+
REPEATABLE_READ,
398+
SERIALIZABLE,
399+
NUM_DEFAULT_ISOLATION_LEVEL
400+
}DefaultIsolationLevel;
401+
402+
DefaultIsolationLeveldefault_isolation_level=READ_COMMITTED;
403+
404+
staticconstchar*DEFAULT_ISOLATION_LEVEL_ABBREVIATION[]= {"RC","RR","S"};
405+
staticconstchar*DEFAULT_ISOLATION_LEVEL_SQL[]= {
406+
"read committed",
407+
"repeatable read",
408+
"serializable"
409+
};
410+
411411

412412
/* Function prototypes */
413413
staticvoidsetIntValue(PgBenchValue*pv,int64ival);

‎src/bin/pgbench/t/003_deadlock_errors.pl

Lines changed: 14 additions & 12 deletions
Original file line numberDiff line numberDiff line change
@@ -15,20 +15,22 @@
1515
.'INSERT INTO xy VALUES (1, 2), (2, 3);');
1616

1717
my$script1 =$node->basedir .'/pgbench_script1';
18-
append_to_file($script1,"\\set delta1 random(-5000, 5000)\n");
19-
append_to_file($script1,"\\set delta2 random(-5000, 5000)\n");
20-
append_to_file($script1,"BEGIN;");
21-
append_to_file($script1,"UPDATE xy SET y = y + :delta1 WHERE x = 1;");
22-
append_to_file($script1,"UPDATE xy SET y = y + :delta2 WHERE x = 2;");
23-
append_to_file($script1,"END;");
18+
append_to_file($script1,
19+
"\\set delta1 random(-5000, 5000)\n"
20+
."\\set delta2 random(-5000, 5000)\n"
21+
."BEGIN;"
22+
."UPDATE xy SET y = y + :delta1 WHERE x = 1;"
23+
."UPDATE xy SET y = y + :delta2 WHERE x = 2;"
24+
."END;");
2425

2526
my$script2 =$node->basedir .'/pgbench_script2';
26-
append_to_file($script2,"\\set delta1 random(-5000, 5000)\n");
27-
append_to_file($script2,"\\set delta2 random(-5000, 5000)\n");
28-
append_to_file($script2,"BEGIN;");
29-
append_to_file($script2,"UPDATE xy SET y = y + :delta2 WHERE x = 2;");
30-
append_to_file($script2,"UPDATE xy SET y = y + :delta1 WHERE x = 1;");
31-
append_to_file($script2,"END;");
27+
append_to_file($script2,
28+
"\\set delta1 random(-5000, 5000)\n"
29+
."\\set delta2 random(-5000, 5000)\n"
30+
."BEGIN;"
31+
."UPDATE xy SET y = y + :delta2 WHERE x = 2;"
32+
."UPDATE xy SET y = y + :delta1 WHERE x = 1;"
33+
."END;");
3234

3335
# Test deadlock transactions with Read committed default isolation level:
3436
$node->command_like(

0 commit comments

Comments
 (0)
[8]ページ先頭
©2009-2025 Movatter.jp