Bug ID | 1208636 |
---|---|
Summary | [Build 20230223] sqlite 3.41.0: openQA test fails in __sqlite3_run-tests_t |
Classification | openSUSE |
Product | openSUSE Tumbleweed |
Version | Current |
Hardware | Other |
URL | https://openqa.opensuse.org/tests/3141458/modules/__sqlite3_run-tests_t/steps/1 |
OS | Other |
Status | NEW |
Severity | Normal |
Priority | P5 - None |
Component | Other |
Assignee | screening-team-bugs@suse.de |
Reporter | dimstar@opensuse.org |
QA Contact | qa-bugs@suse.de |
Found By | openQA |
Blocker | Yes |
## Observation The test tries to run: sqlite3 --list --header /root/sqlite3/movies.db < /root/sqlite3/init-tables.sql init_tables.sql is the file as received from https://github.com/os-autoinst/os-autoinst-distri-opensuse/blob/master/data/sqlite3/init-tables.sql So essentially it does: CREATE TABLE directors (did integer primary key, name varchar(32)); CREATE TABLE movies (mid integer primary key, name varchar(64), year integer); --Rename tables here before adding FOREIGN KEYs. Older versions of sqlite3 --don't update the FKs when renaming tables ALTER TABLE movies RENAME TO movie; ALTER TABLE directors RENAME TO director; CREATE TABLE director_movie ( did integer, mid integer, FOREIGN KEY(did) REFERENCES director(did), FOREIGN KEY(mid) REFERENCES movie(mid) ); CREATE UNIQUE INDEX movie_dirx on director_movie(did,mid); INSERT INTO director (name) VALUES ("Jim Jarmusch"), ( "Tim Burton"); This test worked until sqlite 3.40, now with 3.41 it fails with: Parse error near line 17: no such column: Tim Burton T INTO director (name) VALUES ("Jim Jarmusch"), ( "Tim Burton"); error here ---^ openQA test in scenario opensuse-Tumbleweed-DVD-x86_64-extra_tests_webserver@64bit fails in [__sqlite3_run-tests_t](https://openqa.opensuse.org/tests/3141458/modules/__sqlite3_run-tests_t/steps/1) ## Test suite description ## Reproducible Fails since (at least) Build [20230223](https://openqa.opensuse.org/tests/3141458) (current job) ## Expected result Last good: [20230222](https://openqa.opensuse.org/tests/3139245) (or more recent) ## Further details Always latest result in this scenario: [latest](https://openqa.opensuse.org/tests/latest?arch=x86_64&distri=opensuse&flavor=DVD&machine=64bit&test=extra_tests_webserver&version=Tumbleweed)