sqlite-viewer-vscode
sqlite-viewer-vscode copied to clipboard
Using a column name which contains '.', the values of that column are shown as NULL.
Version: v0.14.1
import sqlite3
conn = sqlite3.connect('test.sqlite')
conn.execute('''CREATE TABLE Test (
Id INTEGER PRIMARY KEY,
"Name." TEXT
)
''')
conn.execute('''INSERT INTO Test (Id, "Name.") VALUES (?, ?)''', [1, 'Name1'])
conn.commit()
rows = conn.execute('SELECT "Name." FROM Test')
print(rows.fetchall())
The output confirms that "Name." column exists and has one value, but the SQLite Viewer Extension shows just NULL value.
[('Name1',)]