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)


You are receiving this mail because: