[Bug 1208636] New: [Build 20230223] sqlite 3.41.0: openQA test fails in __sqlite3_run-tests_t

24 Feb 2023

      http://bugzilla.opensuse.org/show_bug.cgi?id=1208636

            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/__sq
                    lite3_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/...

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/step...)

## 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:
You are on the CC list for the bug.

[Bug 1208636] New: [Build 20230223] sqlite 3.41.0: openQA test fails in __sqlite3_run-tests_t

bugzilla_noreply＠suse.com