SQLite Forum

pragma table_info Bug
Login
Hello ,
since version 3.37.0 the pragma table info command gives incorrect information on unsigned word fields.

example: pragma table_info(database)

cid	name	type	notnull	dflt_value	pk
0	CleArt	VARCHAR(10)	0		1
1	bNoWeb	UNSIGNED WORD](1	0	'0'	0
2	RefFrn	VARCHAR(13)	0	''	0
3	NomArt	VARCHAR(40)	0	''	0
4	OldLib	VARCHAR(10)	0	''	0
5	Fou	VARCHAR(6)	0	''	0
6	CleFam	VARCHAR(3)	0	''	0
7	CleSFam	VARCHAR(3)	0	''	0
8	CTva	UNSIGNED WORD](1	0	'0'	0
9	CTpf	UNSIGNED WORD](1	0	'0'	0
10	UVente	VARCHAR(2)	0	''	0

there are brackets instead of parentheses : bNoWeb UNSIGNED WORD(1)