CODEWITHSUNDEEP
jdbcpostgresql-9.1postgresql-9.3squirrel-sql
Sven
Sven

Reputation: 952

squirrelsql doesn't like query_to_xml

I am using an SQL that includes query_to_xml:

select query_to_xml('select 1+1 answer', true, true, '') as_xml;

When any SQL with query_to_xml is executed in Squirrel SQL it will result in:

|      as_xml        |
+--------------------+
|<UnknownType (2009)>|

With the same JDBC driver, credentials and a Java class the SQL will result in the expected XML output:

|                          as_xml                            | 
+------------------------------------------------------------+
| <row xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance">|
|                                                            |
|   <answer>2</answer>                                       |
| </row>                                                     |

I can execute other functions in Squirrel and they will respond, like select version().

Is this a known feature in Squirrel?

Upvotes: 3

Views: 2234

Answers (2)

rKuion
rKuion

Reputation: 92

If you are using the latest squirrel client, Go to File, Global Preferences-> Data Type Controls, check the box under Unknown DataTypes section. Rerun the query, it might work.

Upvotes: 4

Colin Bell
Colin Bell

Reputation: 371

It seems to be an issue with the text option output for SQL results. It works if you change to the tabular output. Go to the Session menu and click "Session Properties". On the "General" tab under "Output" change "SQL Results" from Text to Table and rerun the query. You may need to close the existing results tabs first.

If this fixes it please add a bug report so that it can be fixed in the future.

Upvotes: 0

Related Questions