First step rebuild sqlite from snapshot 202006241145 using this script:
usage="Usage : '$0 ' [-ahbd]"
if [[ $1 =~ (-[abdh]) ]]; then
echo "--------------"
else
echo "Not a valid option is given!"
echo $Usage
exit 1
fi
while getopts "abdh" opt; do
case ${opt} in
h )
echo $usage
echo "Options:"
echo " -b Compile without debug options"
echo " -d Compile with debug options"
echo " -h This menu for help"
exit 0
;;
a )
echo "Building a debug version of SQLite3 with all options"
./configure --enable-debug --enable-all
make
exit 0
;;
b )
echo "Building SQLite3 without debug options"
export CFLAGS="-fPIC \
-DSQLITE_ENABLE_FTS3 \
-DSQLITE_ENABLE_FTS3_PARENTHESIS \
-DSQLITE_ENABLE_FTS4 \
-DSQLITE_ENABLE_FTS5 \
-DSQLITE_ENABLE_JSON1 \
-DSQLITE_ENABLE_LOAD_EXTENSION \
-DSQLITE_ENABLE_RTREE \
-DSQLITE_ENABLE_STAT4 \
-DSQLITE_ENABLE_UPDATE_DELETE_LIMIT \
-DSQLITE_TEMP_STORE3 \
-DSQLITE_USE_URI \
-O2 "
;;
d )
echo "Bulding SQLite3 with debug options"
export SQLITE3_CFLAGS="-fPIC \
-DSQLITE_ENABLE_FTS3 \
-DSQLITE_ENABLE_FTS3_PARENTHESIS \
-DSQLITE_ENABLE_FTS4 \
-DSQLITE_ENABLE_FTS5 \
-DSQLITE_ENABLE_JSON1 \
-DSQLITE_ENABLE_LOAD_EXTENSION \
-DSQLITE_ENABLE_RTREE \
-DSQLITE_ENABLE_STAT4 \
-DSQLITE_ENABLE_UPDATE_DELETE_LIMIT \
-DSQLITE_TEMP_STORE3 \
-DSQLITE_USE_URI \
-DSQLITE_DEBUG \
-DSQLITE_ENABLE_EXPLAIN_COMMENTS \
-DSQLITE_ENABLE_SELECTTRACE \
-DSQLITE_ENABLE_WHERETRACE \
-O2"
;;
* )
echo "Invalid Option: -$OPTARG"
echo $usage >&2
exit 1
;;
esac
done
LIBS="-lm" ./configure --enable-shared --prefix="$PREFIX"
make
sudo make install
By the way the -DSQLITE options does not work.
Changed the name of SQLite3 to avoid confusing and …
$ ldd ./sqlite3_33_0
linux-vdso.so.1 (0x00007ffd32981000)
libreadline.so.5 => /lib/x86_64-linux-gnu/libreadline.so.5 (0x00007efceddc4000)
libz.so.1 => /lib/x86_64-linux-gnu/libz.so.1 (0x00007efcedda8000)
libm.so.6 => /lib/x86_64-linux-gnu/libm.so.6 (0x00007efcedc59000)
libdl.so.2 => /lib/x86_64-linux-gnu/libdl.so.2 (0x00007efcedc53000)
libpthread.so.0 => /lib/x86_64-linux-gnu/libpthread.so.0 (0x00007efcedc30000)
libc.so.6 => /lib/x86_64-linux-gnu/libc.so.6 (0x00007efceda3e000)
libtinfo.so.6 => /lib/x86_64-linux-gnu/libtinfo.so.6 (0x00007efceda0c000)
/lib64/ld-linux-x86-64.so.2 (0x00007efcee057000)
Presto: .selecttrace is back but I am still not able to reproduce the issue.
Here is the last part of the .selecttrace
| '-- 1
'-- RAISE abort('Error you are not allowed to change the status')
2/0/55CC014018C8: WhereBegin
1/82/55CC01420BC8: begin processing:
'-- SELECT (1/55CC01420BC8) selFlags=0xc4 nSelectRow=0
|-- result-set
| '-- {0:5} pTab=55CC0141C208 fg.af=40800000.n DDL
|-- FROM
| '-- {0:*} C1 tab='C1' nCol=8 ptr=55CC0141C208 used=21 DDL
|-- WHERE
| '-- EQ fg.af=40000000.n DDL
| |-- {0:0} pTab=55CC0141C208 fg.af=40800000.n DDL
| '-- NEW(0)
'-- LIMIT
'-- 1
1/82/55CC01420BC8: after name resolution:
'-- SELECT (1/55CC01420BC8) selFlags=0xc4 nSelectRow=0
|-- result-set
| '-- {0:5} pTab=55CC0141C208 fg.af=40800000.n DDL
|-- FROM
| '-- {0:*} C1 tab='C1' nCol=8 ptr=55CC0141C208 used=21 DDL
|-- WHERE
| '-- EQ fg.af=40000000.n DDL
| |-- {0:0} pTab=55CC0141C208 fg.af=40800000.n DDL
| '-- NEW(0)
'-- LIMIT
'-- 1
1/82/55CC01420BC8: Constant propagation not helpful
1/82/55CC01420BC8: After all FROM-clause analysis:
'-- SELECT (1/55CC01420BC8) selFlags=0xc4 nSelectRow=0
|-- result-set
| '-- {0:5} pTab=55CC0141C208 fg.af=40800000.n DDL
|-- FROM
| '-- {0:*} C1 tab='C1' nCol=8 ptr=55CC0141C208 used=21 DDL
|-- WHERE
| '-- EQ fg.af=40000000.n DDL
| |-- {0:0} pTab=55CC0141C208 fg.af=40800000.n DDL
| '-- NEW(0)
'-- LIMIT
'-- 1
1/82/55CC01420BC8: WhereBegin
1/82/55CC01420BC8: end processing
'-- SELECT (1/55CC01420BC8) selFlags=0x40c4 nSelectRow=0
|-- result-set
| '-- {0:5} pTab=55CC0141C208 fg.af=40800000.n DDL
|-- FROM
| '-- {0:*} C1 tab='C1' nCol=8 ptr=55CC0141C208 used=21 DDL
|-- WHERE
| '-- EQ fg.af=40000000.n DDL
| |-- {0:0} pTab=55CC0141C208 fg.af=40800000.n DDL
| '-- NEW(0)
'-- LIMIT
'-- 1
2/0/55CC014018C8: end processing
'-- SELECT (2/55CC014018C8) selFlags=0x4400c4 nSelectRow=0
'-- result-set
'-- AS END
'-- CASE
|-- 1
'-- LIST
|-- EQ fg.af=40000000.n DDL
| |-- NEW(5)
| '-- 2
'-- CASE
|-- 1
'-- LIST
|-- OR fg.af=40000000.n DDL
| |-- IN flags=0x42000000
| | |-- OLD(5)
| | '-- LIST
| | |-- 1
| | |-- 8
| | |-- 32
| | '-- 64
| '-- AND fg.af=40000000.n DDL
| |-- NOTNULL fg.af=40000000.n DDL
| | '-- OLD(6)
| '-- NOT fg.af=40000000.n DDL
| '-- EQ fg.af=40000000.n DDL
| |-- OLD(5)
| '-- 4
|-- RAISE abort('Error: someone goofed')
|-- EQ fg.af=40200000.n DDL
| |-- subquery-expr flags=0x42200800
| | '-- SELECT (1/55CC01420BC8) selFlags=0x40c4 nSelectRow=0
| | |-- result-set
| | | '-- {0:5} pTab=55CC0141C208 fg.af=40800000.n DDL
| | |-- FROM
| | | '-- {0:*} C1 tab='C1' nCol=8 ptr=55CC0141C208 used=21 DDL
| | |-- WHERE
| | | '-- EQ fg.af=40000000.n DDL
| | | |-- {0:0} pTab=55CC0141C208 fg.af=40800000.n DDL
| | | '-- NEW(0)
| | '-- LIMIT
| | '-- 1
| '-- 1
'-- RAISE abort('Error you are not allowed to change the status')