DBeaver issue with query and new line
When I'm trying to run a query with some newline, DBeaver always gives me an error:
Errore SQL [156] [S0001]: Incorrect syntax near the keyword ....
What's the problem? What can I do? This is an example of query:
select * from table2
inner join table3 on idtable2 = idtable3;
Solution
Ok, I've found the way. DBeaver simply consider the newline/breakline as a statement separator.
But there is a way to remove this option in Editor > Editor SQL > SQL Processing
Credit: Link
- Convert hour to 12 hr format after extracting 'hour' using DatePart(hour,Datetime)
- SQL Management Studio can't drag table / object from Explorer to Query Editor
- How can I put a where condition on a SqLite view statement?
- Get 2 Digit Number For The Month
- Set a column unique without being the primary key
- How to simulate a deadlock in SQL Server in a single process?
- "The big SQL RegEx": How do I RegEx split a SQL query?
- Determine column to insert into based on content
- Can a 4 column address be merged into a 2 columns address with a SELECT statement?
- How to write a "recursive update"?
- hierarchical query in Oracle
- How to Select all Columns from a Table for a Record - but to exclude a Column if all entries for that Record in said Column are null?
- Find patients admitted multiple times for the same primary diagnosis in SQL
- Updating SQL Server records with replace
- Export data from dynamic XML hierarchy in SQL Server
- How to resolve this error Ora-25137 "Data Value Out of range" in oracle
- Writing a SQL Query with multiple Where statements
- VBA - Convert a few numeric cells as text
- MySql: unknown column id in 'field list'
- SQL Server TDS protocol response problem when calling a stored procedure
- Can Postgres use the foreign key (between two tables) as the "ON" clause when LEFT JOINing them?
- Count matching value in two columns in SQL
- Why UNION and UNION ALL don't work in my code?
- Could not drop object 'dbo.Table1' because it is referenced by a FOREIGN KEY constraint
- PostgreSQL: Give all permissions to a user on a PostgreSQL database
- How does group by works in sequelize?
- Cursor bug when editing sql file
- Add a given value from a column based on the value from another column
- How can I make SQL case sensitive string comparison on MySQL?
- How to fix "java.sql.SQLException: Can't call commit when autocommit=true"