0001014: view code cut off when using UNION

Bug Tracking System

View Issue Details [ Jump to Notes ]

[ Issue History ] [ Print ]

Project

Category

View Status

Date Submitted

Last Update

0001014

Sqlite Developer

SQL Editor

public

2009-11-30 17:17

2009-12-10 10:46

Reporter

Gillissie

Assigned To

sharpplus

Priority

urgent

Severity

major

Reproducibility

always

Status

closed

Resolution

fixed

Platform

Windows

Vista 64 bit

OS Version

Product Version

Target Version

3.5.x

Fixed in Version

3.5.x

Summary

0001014: view code cut off when using UNION

Description

When creating a view that uses a UNION in the query, query the view works as expected. But when you go back in to edit the view, the query text is cut off after the first part of the query. Everything from the UNION and below is missing. If you update again, it is permanently missing.

version 3.5.7.435

Steps To Reproduce

Create any view with a UNION, save it, then edit the view to see the UNION part missing.

For example, in a view named TestView:

SELECT 1
UNION
SELECT 2

Now query the view to verify the UNION works:
SELECT * FROM TestView

Now edit the view to only see:
SELECT 1

Tags

No tags attached.

Attached Files

Relationships

Notes
(0000256) sharpplus (administrator) 2009-12-06 08:36	Thank you for your bug report. I will check it as soon as possible

(0000257) sharpplus (administrator) 2009-12-10 10:46	I just fixed the bug. please try with the latest version http://www.sqlitedeveloper.com/downloads/SqliteDev358.zip [^]

Issue History
Date Modified	Username	Field	Change
2009-11-30 17:17	Gillissie	New Issue
2009-12-06 08:36	sharpplus	Note Added: 0000256
2009-12-06 08:36	sharpplus	Assigned To	=> sharpplus
2009-12-06 08:36	sharpplus	Status	new => assigned
2009-12-06 08:37	sharpplus	Target Version	=> 3.5.x
2009-12-10 10:46	sharpplus	Note Added: 0000257
2009-12-10 10:46	sharpplus	Status	assigned => closed
2009-12-10 10:46	sharpplus	Resolution	open => fixed
2009-12-10 10:46	sharpplus	Fixed in Version	=> 3.5.x