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_5f6625a8-a649-4af0-91b2-1b328c708755_unexpected_error.md
T
admin fd930e15cb ---
2026-06-24 13:47:14 +02:00

5.9 KiB
Raw Permalink Blame History

Summary

**No review yet**

Minimized query

PRAGMA cache_spill = 1;
.dbconfig fk off
.log stderr
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((replace(rtrim(NULL), 1.7976931348623157e+308, 0) + 0.0) AS INTEGER)))))), 0));
CREATE VIEW v1 AS SELECT * FROM t1 WHERE NOT NOT (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;

VACUUM main;

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