google-code-export / ords

Automatically exported from code.google.com/p/ords
1 stars 0 forks source link

SQL query box doesn't preserve carriage returns in queries #438

Closed GoogleCodeExporter closed 9 years ago

GoogleCodeExporter commented 9 years ago
What steps will reproduce the problem?
1. Construct a long, complicated query with lots of clauses in the SQL query 
box. Use carriage returns to separate the various clauses, because you find 
this helps you keep track of the structure of the query. Click 'Run query'. 
2. Realize you made a silly mistake somewhere in your query, and go back to the 
query box to correct it.
3. Discover that your carefully separated clauses are now all squidged together 
in one paragraph.

What is the expected output? What do you see instead?
I'm told that people are often taught to write SQL with each clause on a 
separate line. This is also the way textbooks often lay out examples - it's 
easier to follow than a big amorphous block of text. ORDS will let you type in 
a query this way, but running it removes the carriage returns. 

Please use labels and text to provide additional information.

Original issue reported on code.google.com by meriel.p...@gmail.com on 14 Jul 2014 at 1:10

GoogleCodeExporter commented 9 years ago
The SQL query form now splits your query in to seperate clauses.

Original comment by marxjohn...@gmail.com on 8 Jan 2015 at 10:57