admin/ast-project
1
0
Fork 0
Code Issues Pull Requests Actions Packages Projects Releases Wiki Activity
Files
main
ast-project/part1/results/3/bug_7444c89a-60c7-4870-b145-afbda4318883_unexpected_error.md
T
admin fd930e15cb ---
2026-06-24 13:47:14 +02:00

5.7 KiB
Raw Permalink Blame History

Summary

**No review yet**

Minimized query

PRAGMA secure_delete = 'FAST';
BEGIN IMMEDIATE TRANSACTION;
SAVEPOINT sp4568;
ATTACH DATABASE ':memory:' AS aux38;
ATTACH DATABASE ':memory:' AS aux69;
PRAGMA empty_result_callbacks = TRUE;
PRAGMA vdbe_trace = NO;
PRAGMA foreign_key_check;
.dbconfig
PRAGMA encoding = 'utf-16';
CREATE TABLE [t1](abcd, efgh);
INSERT INTO t1 VALUES (x'f1', timediff(-randomblob(-(-(-(-(CAST(0 AS INTEGER)))))), 0));
CREATE VIEW v1 AS SELECT * FROM t1 WHERE abcd>efgh;

DETACH DATABASE aux69;
DETACH DATABASE aux38;
ROLLBACK TO sp4568;
RELEASE sp4568;
COMMIT TRANSACTION;
PRAGMA secure_delete = 'FAST';
BEGIN IMMEDIATE TRANSACTION;
SAVEPOINT sp4568;
ATTACH DATABASE ':memory:' AS aux38;
ATTACH DATABASE ':memory:' AS aux69;
PRAGMA empty_result_callbacks = TRUE;
PRAGMA vdbe_trace = NO;
PRAGMA foreign_key_check;
.dbconfig
PRAGMA encoding = 'utf-16';
CREATE TABLE [t1](abcd, efgh);
INSERT INTO t1 VALUES (x'f1', timediff(-randomblob(-(-(-(-(CAST(0 AS INTEGER)))))), 0));
CREATE VIEW v1 AS SELECT * FROM t1 WHERE abcd>efgh;

DETACH DATABASE aux69;
DETACH DATABASE aux38;
ROLLBACK TO sp4568;
RELEASE sp4568;
COMMIT TRANSACTION;
PRAGMA secure_delete = 'FAST';
BEGIN IMMEDIATE TRANSACTION;
SAVEPOINT sp4568;
ATTACH DATABASE ':memory:' AS aux38;
ATTACH DATABASE ':memory:' AS aux69;
PRAGMA empty_result_callbacks = TRUE;
PRAGMA vdbe_trace = NO;
PRAGMA foreign_key_check;
.dbconfig
PRAGMA encoding = 'utf-16';
CREATE TABLE [t1](abcd, efgh);
INSERT INTO t1 VALUES (x'f1', timediff(-randomblob(-(-(-(-(CAST(0 AS INTEGER)))))), 0));
CREATE VIEW v1 AS SELECT * FROM t1 WHERE abcd>efgh;

DETACH DATABASE aux69;
DETACH DATABASE aux38;
ROLLBACK TO sp4568;
RELEASE sp4568;
COMMIT TRANSACTION;
PRAGMA secure_delete = 'FAST';
BEGIN IMMEDIATE TRANSACTION;
SAVEPOINT sp4568;
ATTACH DATABASE ':memory:' AS aux38;
ATTACH DATABASE ':memory:' AS aux69;
PRAGMA empty_result_callbacks = TRUE;
PRAGMA vdbe_trace = NO;
PRAGMA foreign_key_check;
.dbconfig
PRAGMA encoding = 'utf-16';
CREATE TABLE [t1](abcd, efgh);
INSERT INTO t1 VALUES (x'f1', timediff(-randomblob(-(-(-(-(CAST(0 AS INTEGER)))))), 0));
CREATE VIEW v1 AS SELECT * FROM t1 WHERE abcd>efgh;

DETACH DATABASE aux69;
DETACH DATABASE aux38;
ROLLBACK TO sp4568;
RELEASE sp4568;
COMMIT TRANSACTION;
PRAGMA secure_delete = 'FAST';
BEGIN IMMEDIATE TRANSACTION;
SAVEPOINT sp4568;
ATTACH DATABASE ':memory:' AS aux38;
ATTACH DATABASE ':memory:' AS aux69;
PRAGMA empty_result_callbacks = TRUE;
PRAGMA vdbe_trace = NO;
PRAGMA foreign_key_check;
.dbconfig
PRAGMA encoding = 'utf-16';
CREATE TABLE [t1](abcd, efgh);
INSERT INTO t1 VALUES (x'f1', timediff(-randomblob(-(-(-(-(CAST(0 AS INTEGER)))))), 0));
CREATE VIEW v1 AS SELECT * FROM t1 WHERE abcd>efgh;

DETACH DATABASE aux69;
DETACH DATABASE aux38;
ROLLBACK TO sp4568;
RELEASE sp4568;
COMMIT TRANSACTION;
PRAGMA secure_delete = 'FAST';
BEGIN IMMEDIATE TRANSACTION;
SAVEPOINT sp4568;
ATTACH DATABASE ':memory:' AS aux38;
ATTACH DATABASE ':memory:' AS aux69;
PRAGMA empty_result_callbacks = TRUE;
PRAGMA vdbe_trace = NO;
PRAGMA foreign_key_check;
.dbconfig
PRAGMA encoding = 'utf-16';
CREATE TABLE [t1](abcd, efgh);
INSERT INTO t1 VALUES (x'f1', timediff(-randomblob(-(-(-(-(CAST(0 AS INTEGER)))))), 0));
CREATE VIEW v1 AS SELECT * FROM t1 WHERE abcd>efgh;

DETACH DATABASE aux69;
DETACH DATABASE aux38;
ROLLBACK TO sp4568;
RELEASE sp4568;
COMMIT TRANSACTION;

Actual output

2
          defensive off
            dqs_ddl on
            dqs_dml on
        enable_fkey off
        enable_qpsg off
     enable_trigger on
        enable_view on
     fts3_tokenizer off
 legacy_alter_table off
 legacy_file_format off
     load_extension on
   no_ckpt_on_close off
     reset_database off
        trigger_eqp off
     trusted_schema on
    writable_schema off
2
          defensive off
            dqs_ddl on
            dqs_dml on
        enable_fkey off
        enable_qpsg off
     enable_trigger on
        enable_view on
     fts3_tokenizer off
 legacy_alter_table off
 legacy_file_format off
     load_extension on
   no_ckpt_on_close off
     reset_database off
        trigger_eqp off
     trusted_schema on
    writable_schema off
2
          defensive off
            dqs_ddl on
            dqs_dml on
        enable_fkey off
        enable_qpsg off
     enable_trigger on
        enable_view on
     fts3_tokenizer off
 legacy_alter_table off
 legacy_file_format off
     load_extension on
   no_ckpt_on_close off
     reset_database off
        trigger_eqp off
     trusted_schema on
    writable_schema off
2
          defensive off
            dqs_ddl on
            dqs_dml on
        enable_fkey off
        enable_qpsg off
     enable_trigger on
        enable_view on
     fts3_tokenizer off
 legacy_alter_table off
 legacy_file_format off
     load_extension on
   no_ckpt_on_close off
     reset_database off
        trigger_eqp off
     trusted_schema on
    writable_schema off
2
          defensive off
            dqs_ddl on
            dqs_dml on
        enable_fkey off
        enable_qpsg off
     enable_trigger on
        enable_view on
     fts3_tokenizer off
 legacy_alter_table off
 legacy_file_format off
     load_extension on
   no_ckpt_on_close off
     reset_database off
        trigger_eqp off
     trusted_schema on
    writable_schema off
2
          defensive off
            dqs_ddl on
            dqs_dml on
        enable_fkey off
        enable_qpsg off
     enable_trigger on
        enable_view on
     fts3_tokenizer off
 legacy_alter_table off
 legacy_file_format off
     load_extension on
   no_ckpt_on_close off
     reset_database off
        trigger_eqp off
     trusted_schema on
    writable_schema off

Expectation

Flag
Reference in New Issue View Git Blame Copy Permalink