0001034: SQL Editor reports error on INSERT of a hex value into BLOB field

Bug Tracking System

View Issue Details [ Jump to Notes ]

[ Issue History ] [ Print ]

Project

Category

View Status

Date Submitted

Last Update

0001034

Sqlite Developer

SQL Editor

public

2010-05-22 23:58

2010-05-23 11:17

Reporter

ve3meo

Assigned To

sharpplus

Priority

urgent

Severity

block

Reproducibility

always

Status

closed

Resolution

fixed

Platform

Windows

OS Version

XP SP3

Product Version

3.5.x

Target Version

3.6.x

Fixed in Version

3.6.x

Summary

0001034: SQL Editor reports error on INSERT of a hex value into BLOB field

Description

CREATE TABLE AddressTable (AddressID INTEGER PRIMARY KEY, AddressType INTEGER, Name TEXT COLLATE RMNOCASE, Street1 TEXT, Street2 TEXT, City TEXT, State TEXT, Zip TEXT, Country TEXT, Phone1 TEXT, Phone2 TEXT, Fax TEXT, Email TEXT, URL TEXT, Latitude INTEGER, Longitude INTEGER, Note BLOB );

Insert Into [AddressTable] ([AddressID],[AddressType],[Name],[Street1],[Street2],[City],[State],[Zip],[Country],[Phone1],[Phone2],[Fax],[Email],[URL],[Latitude],[Longitude],[Note]) Values("101","0","Adolf Wilhelm WEITZ","Burgwedelestr. 141",NULL,"Isernhagen","HB","30916","Germany","+-49-511-775-927",NULL,NULL,NULL,NULL,"0","0",X'48616E64793A20303137322D3435382D35382D3135');

Log:

Insert Into [AddressTable] ([AddressID],[AddressType],[Name],[Street1],[Street2],[City],[State],[Zip],[Country],[Phone1],[Phone2],[Fax],[Email],[URL],[Latitude],[Longitude],[Note]) Values("108","0","Wigand WEITZ","Krummbeher Weg 10",NULL,"Höhndorf",NULL,"24217","Germany",NULL,NULL,NULL,NULL,NULL,"0","0",X' expecting "RP" */

Tags

No tags attached.

Attached Files

Relationships

Notes
(0000269) sharpplus (administrator) 2010-05-23 11:17	Thank you for your bug report. There is a bug in the sqlite script lexer of sqlite developer. I just fixed it . Please download the http://www.sqlitedeveloper.com/downloads/SqliteDev368.zip [^] and try it.

Issue History
Date Modified	Username	Field	Change
2010-05-22 23:58	ve3meo	New Issue
2010-05-23 11:06	sharpplus	Target Version	=> 3.6.x
2010-05-23 11:17	sharpplus	Note Added: 0000269
2010-05-23 11:17	sharpplus	Status	new => closed
2010-05-23 11:17	sharpplus	Assigned To	=> sharpplus
2010-05-23 11:17	sharpplus	Resolution	open => fixed
2010-05-23 11:17	sharpplus	Fixed in Version	=> 3.6.x