Running SELECT SQL with Line Wraps Failed

Originally reported on Google Code with ID 39 ```

What steps will reproduce the problem?

1. Create a table "members" with "email" and "member_id" fields in it.

2. Create a table "passwords" with "email" and "password" fields in it.

3. Click a SQL tab and try to run this, but notice the line wraps, and instead of the space indent, use tabs, although you might also test with space indents:

SELECT p.password FROM passwords AS "p" JOIN members AS "m" ON p.email = m.email WHERE m.member_id = '29555' LIMIT 1;

What is the expected output?

No errors, even if no records matched. If records matched, show that record.

What do you see instead?

Error: "The query could not be run. Check your syntax."

The solution was that I made the SQL statement all one continuous line, removing tabs and line wraps. Then, it worked.

What version of the product are you using?

1.8.6

On what operating system?

Ubuntu 10.04.2 LTS

PDO

SQLite3

PHP 5.3.2-1ubuntu4.9 with Suhosin-Patch (cli) (built: May 3 2011 00:43:34) Copyright (c) 1997-2009 The PHP Group Zend Engine v2.3.0, Copyright (c) 1998-2010 Zend Technologies with the ionCube PHP Loader v4.0.8, Copyright (c) 2002-2011, by ionCube Ltd.

```

Reported by `volomike` on 2011-06-09 23:11:20

Comments (2)