Bug #16441 Pasting queries in with multiple tab indents causes weirdness
Submitted: 12 Jan 2006 9:39 Modified: 21 Nov 2006 9:13
Reporter: Chris Munasinha Email Updates:
Status: Closed Impact on me:
None 
Category:MySQL Query Browser Severity:S3 (Non-critical)
Version:1.1.18 OS:Windows (Win XP SP2)
Assigned to: Mike Lischke CPU Architecture:Any
Tags: Source Editors

[12 Jan 2006 9:39] Chris Munasinha 
Description:
When pasting in a query with multiple indents (and only pasting it seems) that use the tab character, if the last line has not got a line break, then for every tab, a character goes missing off the end. It sounds obscure but it's recreatable!

How to repeat:
e.g. (where \t is a tab indent and \n is a new line)

SELECT * FROM mytable\n
\t\tINNER JOIN mysecond ON mytable.i1=mysecond.i2\n
\t\tWHERE mytable.f="hello"

This ends up as:

SELECT * FROM mytable
		INNER JOIN mysecond ON mytable.i1=mysecond.i2
		WHERE mytable.f="hell

Which causes sql errors.
[12 Jan 2006 9:42] Chris Munasinha 
Just to note - I've found similar bug requests related to tabs (eg. #10581) that have been marked as closed, but perhaps it needs further investigation as it appears to still have some issues as of the latest version?
[12 Jan 2006 17:57] MySQL Verification Team 
Thank you for the bug report.
[24 May 2006 14:07] MySQL Verification Team 
Bug http://bugs.mysql.com/bug.php?id=20044 was marked as
duplicate of this one.
[25 May 2006 17:32] Xin Li 
any plan to fix this in a near future? It stops us from supporting MySQL Query Browser. Thanks.
[21 Nov 2006 9:13] Mike Lischke 
Thank you for your bug report. This issue has already been fixed in the latest released version of that product, which you can download at

  http://www.mysql.com/downloads/