Error with '::' in PostgreSQL query

garethhayter · Post by **garethhayter** » Wed 06 Jul 2011 10:09

I am getting this error when my query includes a double colon. When I run this same query in pgAdmin, it executes fine. This same query used to work in a previous version of dotConnect Universal. I am using version 3.20.31 which I reverted to from the 3.20.53 because that version still has the Oracle bug.

Eg:

Code: Select all

SELECT COLUMN_NAME::varchar
FROM INFORMATION_SCHEMA.KEY_COLUMN_USAGE

The stacktrace is:

Code: Select all

   at Devart.Data.PostgreSql.k.PrepareStmt(be stmt)
   at Devart.Data.PostgreSql.be.PreparedResult()
   at Devart.Data.PostgreSql.bw.a(Boolean A_0, Int32 A_1, Int32 A_2)
   at Devart.Common.DbCommandBase.ExecuteDbDataReader(CommandBehavior behavior, Boolean nonQuery)
   at Devart.Common.DbCommandBase.ExecuteDbDataReader(CommandBehavior behavior)
   at System.Data.Common.DbCommand.System.Data.IDbCommand.ExecuteReader(CommandBehavior behavior)
   at Devart.Data.Universal.UniCommand.a(CommandBehavior A_0, IDisposable A_1, Int32 A_2, Int32 A_3, Boolean A_4)

Thanks,
Gareth.

Shalex · Post by **Shalex** » Thu 07 Jul 2011 12:46

1. We have reproduced the "syntax error at or near "::"" error with dotConnect for Universal v 3.20.53 using the query with a double colon. We will investigate the issue and notify you about the results.
2. Could you please describe (or specify the exact post/ticket where it is described) the problem with Oracle you have mentioned in the previous post?

Shalex · Post by **Shalex** » Fri 08 Jul 2011 15:53

1. The bug with using '::' in UniCommand.CommandText when working with PostgreSQL is fixed. We will notify you when the corresponding build of dotConnect Universal is available for download.

garethhayter · Post by **garethhayter** » Mon 11 Jul 2011 03:22

Great, thank-you. I'll try to get a reproducible scenario for the Oracle bug.

Shalex · Post by **Shalex** » Fri 29 Jul 2011 07:25

New build of dotConnect Universal 3.20.55 is available for download now!
It can be downloaded from http://www.devart.com/dotconnect/univer ... nload.html (trial version) or from Registered Users' Area (for users with valid subscription only): http://secure.devart.com/ .
For more information, please refer to http://www.devart.com/forums/viewtopic.php?t=21611 .