sqlite-viewer-vscode icon indicating copy to clipboard operation
sqlite-viewer-vscode copied to clipboard

Using a column name which contains '.', the values of that column are shown as NULL.

Open Diego-0110 opened this issue 2 years ago • 0 comments

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',)]

image

Diego-0110 avatar Oct 26 '23 07:10 Diego-0110