Skip to content

Commit d6263cd

Browse files
zhenglin-charlie-lizhenglin-charlie-li
authored
chore: upgrade versions in CI (sqlancer#787)
* chore: upgrade versions in CI * fix: typo and version * fix: add integers in mysql * fix: fix mysql Unknown system variable 'myisam_repair_threads' * fix: Set up typo
1 parent e696c6e commit d6263cd

4 files changed

Lines changed: 88 additions & 63 deletions

File tree

‎.github/workflows/main.yml‎

Lines changed: 47 additions & 58 deletions
Original file line numberDiff line numberDiff line change
@@ -14,18 +14,18 @@ jobs:
1414
runs-on: ubuntu-latest
1515

1616
steps:
17-
- uses: actions/checkout@v2
17+
- uses: actions/checkout@v3
1818
with:
1919
fetch-depth: 0
2020
- name: Set up JDK 11
21-
uses: actions/setup-java@v1
21+
uses: actions/setup-java@v1.4.4
2222
with:
2323
java-version: 11
2424
- name: Verify
2525
run: mvn -B verify -DskipTests=true
2626
- name: Misc Tests
2727
run: mvn -B '-Dtest=!sqlancer.dbms.**,!sqlancer.qpg.**' test
28-
- name: Setup Python
28+
- name: Set up Python
2929
uses: actions/setup-python@v4
3030
with:
3131
python-version: '3.10'
@@ -36,11 +36,11 @@ jobs:
3636
name: DBMS Tests (Citus)
3737
runs-on: ubuntu-latest
3838
steps:
39-
- uses: actions/checkout@v2
39+
- uses: actions/checkout@v3
4040
with:
4141
fetch-depth: 0
4242
- name: Set up JDK 11
43-
uses: actions/setup-java@v1
43+
uses: actions/setup-java@v1.4.4
4444
with:
4545
java-version: 11
4646
- name: Build SQLancer
@@ -82,11 +82,11 @@ jobs:
8282
name: DBMS Tests (ClickHouse)
8383
runs-on: ubuntu-latest
8484
steps:
85-
- uses: actions/checkout@v2
85+
- uses: actions/checkout@v3
8686
with:
8787
fetch-depth: 0
8888
- name: Set up JDK 11
89-
uses: actions/setup-java@v1
89+
uses: actions/setup-java@v1.4.4
9090
with:
9191
java-version: 11
9292
- name: Build SQLancer
@@ -105,17 +105,15 @@ jobs:
105105
docker stop clickhouse-server
106106
docker rm clickhouse-server
107107
108-
109-
110108
cockroachdb:
111109
name: DBMS Tests (CockroachDB)
112110
runs-on: ubuntu-latest
113111
steps:
114-
- uses: actions/checkout@v2
112+
- uses: actions/checkout@v3
115113
with:
116114
fetch-depth: 0
117115
- name: Set up JDK 11
118-
uses: actions/setup-java@v1
116+
uses: actions/setup-java@v1.4.4
119117
with:
120118
java-version: 11
121119
- name: Build SQLancer
@@ -134,11 +132,11 @@ jobs:
134132
name: QPG Tests (CockroachDB)
135133
runs-on: ubuntu-latest
136134
steps:
137-
- uses: actions/checkout@v2
135+
- uses: actions/checkout@v3
138136
with:
139137
fetch-depth: 0
140138
- name: Set up JDK 11
141-
uses: actions/setup-java@v1
139+
uses: actions/setup-java@v1.4.4
142140
with:
143141
java-version: 11
144142
- name: Build SQLancer
@@ -166,11 +164,11 @@ jobs:
166164
- 8000:8000
167165
- 3307:3307
168166
steps:
169-
- uses: actions/checkout@v2
167+
- uses: actions/checkout@v3
170168
with:
171169
fetch-depth: 0
172170
- name: Set up JDK 11
173-
uses: actions/setup-java@v1
171+
uses: actions/setup-java@v1.4.4
174172
with:
175173
java-version: 11
176174
- name: Build SQLancer
@@ -179,17 +177,16 @@ jobs:
179177
run: |
180178
DATABEND_AVAILABLE=true mvn -Dtest=TestDatabend test
181179
182-
183180
duckdb:
184181
name: DBMS Tests (DuckDB)
185182
runs-on: ubuntu-latest
186183

187184
steps:
188-
- uses: actions/checkout@v2
185+
- uses: actions/checkout@v3
189186
with:
190187
fetch-depth: 0
191188
- name: Set up JDK 11
192-
uses: actions/setup-java@v1
189+
uses: actions/setup-java@v1.4.4
193190
with:
194191
java-version: 11
195192
- name: Build
@@ -201,11 +198,11 @@ jobs:
201198
name: DBMS Tests (H2)
202199
runs-on: ubuntu-latest
203200
steps:
204-
- uses: actions/checkout@v2
201+
- uses: actions/checkout@v3
205202
with:
206203
fetch-depth: 0
207204
- name: Set up JDK 11
208-
uses: actions/setup-java@v1
205+
uses: actions/setup-java@v1.4.4
209206
with:
210207
java-version: 11
211208
- name: Build SQLancer
@@ -215,14 +212,14 @@ jobs:
215212

216213
mariadb:
217214
name: DBMS Tests (MariaDB)
218-
runs-on: ubuntu-18.04
215+
runs-on: ubuntu-latest
219216

220217
steps:
221-
- uses: actions/checkout@v2
218+
- uses: actions/checkout@v3
222219
with:
223220
fetch-depth: 0
224221
- name: Set up JDK 11
225-
uses: actions/setup-java@v1
222+
uses: actions/setup-java@v1.4.4
226223
with:
227224
java-version: 11
228225
- name: Build SQLancer
@@ -243,7 +240,7 @@ jobs:
243240
name: DBMS Tests (Materialize)
244241
runs-on: ubuntu-latest
245242
steps:
246-
- uses: actions/checkout@v2
243+
- uses: actions/checkout@v3
247244
with:
248245
fetch-depth: 0
249246
- name: Set up Materialize
@@ -254,7 +251,7 @@ jobs:
254251
# Workaround for https://github.com/cockroachdb/cockroach/issues/93892
255252
psql postgres://root@localhost:26257 -c "SET CLUSTER SETTING sql.stats.forecasts.enabled = false"
256253
- name: Set up JDK 11
257-
uses: actions/setup-java@v1
254+
uses: actions/setup-java@v1.4.4
258255
with:
259256
java-version: 11
260257
- name: Build SQLancer
@@ -268,7 +265,7 @@ jobs:
268265
name: QPG Tests (Materialize)
269266
runs-on: ubuntu-latest
270267
steps:
271-
- uses: actions/checkout@v2
268+
- uses: actions/checkout@v3
272269
with:
273270
fetch-depth: 0
274271
- name: Set up Materialize
@@ -279,7 +276,7 @@ jobs:
279276
# Workaround for https://github.com/cockroachdb/cockroach/issues/93892
280277
psql postgres://root@localhost:26257 -c "SET CLUSTER SETTING sql.stats.forecasts.enabled = false"
281278
- name: Set up JDK 11
282-
uses: actions/setup-java@v1
279+
uses: actions/setup-java@v1.4.4
283280
with:
284281
java-version: 11
285282
- name: Build SQLancer
@@ -291,42 +288,36 @@ jobs:
291288
292289
mysql:
293290
name: DBMS Tests (MySQL)
294-
runs-on: ubuntu-18.04
291+
runs-on: ubuntu-latest
295292
steps:
296-
- uses: actions/checkout@v2
293+
- uses: actions/checkout@v3
297294
with:
298295
fetch-depth: 0
299296
- name: Set up JDK 11
300-
uses: actions/setup-java@v1
297+
uses: actions/setup-java@v1.4.4
301298
with:
302299
java-version: 11
303300
- name: Build SQLancer
304301
run: mvn -B package -DskipTests=true
305302
- name: Set up MySQL
306303
run: |
307-
sudo apt-get install libssl-dev libmecab2 libjson-perl mecab-ipadic-utf8
308-
sudo apt-get remove mysql-*
309-
wget -q https://dev.mysql.com/get/Downloads/MySQL-8.0/mysql-server_8.0.20-1ubuntu18.04_amd64.deb-bundle.tar
310-
tar -xvf mysql-server_8.0.20-1ubuntu18.04_amd64.deb-bundle.tar
311-
sudo dpkg -i *.deb
312-
sudo systemctl start mysql
304+
sudo systemctl start mysql.service # MySQL 8.0.32-0ubuntu0.22.04.2
313305
- name: Create SQLancer user
314306
run: mysql -uroot -proot -e "CREATE USER 'sqlancer'@'localhost' IDENTIFIED BY 'sqlancer'; GRANT ALL PRIVILEGES ON * . * TO 'sqlancer'@'localhost';"
315307
- name: Run Tests
316308
run: |
317309
MYSQL_AVAILABLE=true mvn test -Dtest=TestMySQLPQS
318310
MYSQL_AVAILABLE=true mvn test -Dtest=TestMySQLTLP
319311
320-
321312
postgres:
322313
name: DBMS Tests (PostgreSQL)
323314
runs-on: ubuntu-latest
324315
steps:
325-
- uses: actions/checkout@v2
316+
- uses: actions/checkout@v3
326317
with:
327318
fetch-depth: 0
328319
- name: Set up PostgreSQL
329-
uses: harmon758/postgresql-action@v1
320+
uses: harmon758/postgresql-action@v1.0.0
330321
with:
331322
postgresql version: '12'
332323
postgresql user: 'sqlancer'
@@ -346,11 +337,11 @@ jobs:
346337
runs-on: ubuntu-latest
347338

348339
steps:
349-
- uses: actions/checkout@v2
340+
- uses: actions/checkout@v3
350341
with:
351342
fetch-depth: 0
352343
- name: Set up JDK 11
353-
uses: actions/setup-java@v1
344+
uses: actions/setup-java@v1.4.4
354345
with:
355346
java-version: 11
356347
- name: Build
@@ -360,17 +351,16 @@ jobs:
360351
mvn -Dtest=TestSQLitePQS test
361352
mvn -Dtest=TestSQLite3 test
362353
363-
364354
sqlite-qpg:
365355
name: QPG Tests (SQLite)
366356
runs-on: ubuntu-latest
367357

368358
steps:
369-
- uses: actions/checkout@v2
359+
- uses: actions/checkout@v3
370360
with:
371361
fetch-depth: 0
372362
- name: Set up JDK 11
373-
uses: actions/setup-java@v1
363+
uses: actions/setup-java@v1.4.4
374364
with:
375365
java-version: 11
376366
- name: Build
@@ -379,16 +369,15 @@ jobs:
379369
run: |
380370
mvn -Dtest=TestSQLiteQPG test
381371
382-
383372
tidb:
384373
name: DBMS Tests (TiDB)
385374
runs-on: ubuntu-latest
386375
steps:
387-
- uses: actions/checkout@v2
376+
- uses: actions/checkout@v3
388377
with:
389378
fetch-depth: 0
390379
- name: Set up JDK 11
391-
uses: actions/setup-java@v1
380+
uses: actions/setup-java@v1.4.4
392381
with:
393382
java-version: 11
394383
- name: Build SQLancer
@@ -407,11 +396,11 @@ jobs:
407396
name: QPG Tests (TiDB)
408397
runs-on: ubuntu-latest
409398
steps:
410-
- uses: actions/checkout@v2
399+
- uses: actions/checkout@v3
411400
with:
412401
fetch-depth: 0
413402
- name: Set up JDK 11
414-
uses: actions/setup-java@v1
403+
uses: actions/setup-java@v1.4.4
415404
with:
416405
java-version: 11
417406
- name: Build SQLancer
@@ -430,16 +419,16 @@ jobs:
430419
name: DBMS Tests (YugabyteDB)
431420
runs-on: ubuntu-latest
432421
steps:
433-
- uses: actions/checkout@v2
422+
- uses: actions/checkout@v3
434423
with:
435424
fetch-depth: 0
436425
- name: Set up JDK 11
437-
uses: actions/setup-java@v1
426+
uses: actions/setup-java@v1.4.4
438427
with:
439428
java-version: 11
440429
- name: Build SQLancer
441430
run: mvn -B package -DskipTests=true
442-
- name: Setup Yugabyte
431+
- name: Set up Yugabyte
443432
run: |
444433
docker pull yugabytedb/yugabyte:latest
445434
docker run -d --name yugabyte -p7000:7000 -p9000:9000 -p5433:5433 -p9042:9042 yugabytedb/yugabyte:latest bin/yugabyted start --daemon=false
@@ -493,11 +482,11 @@ jobs:
493482
runs-on: ubuntu-latest
494483

495484
steps:
496-
- uses: actions/checkout@v2
485+
- uses: actions/checkout@v3
497486
with:
498487
fetch-depth: 0
499488
- name: Set up JDK 13
500-
uses: actions/setup-java@v1
489+
uses: actions/setup-java@v1.4.4
501490
with:
502491
java-version: 13
503492
- name: Build
@@ -510,11 +499,11 @@ jobs:
510499
runs-on: ubuntu-latest
511500

512501
steps:
513-
- uses: actions/checkout@v2
502+
- uses: actions/checkout@v3
514503
with:
515504
fetch-depth: 0
516505
- name: Set up JDK 14
517-
uses: actions/setup-java@v1
506+
uses: actions/setup-java@v1.4.4
518507
with:
519508
java-version: 14
520509
- name: Build
@@ -527,11 +516,11 @@ jobs:
527516
runs-on: ubuntu-latest
528517

529518
steps:
530-
- uses: actions/checkout@v2
519+
- uses: actions/checkout@v3
531520
with:
532521
fetch-depth: 0
533522
- name: Set up JDK 15
534-
uses: actions/setup-java@v1
523+
uses: actions/setup-java@v1.4.4
535524
with:
536525
java-version: 15-ea
537526
- name: Build

0 commit comments

Comments
 (0)