PostgreSQL "syntax error at or near "LIKE" at character 16"

[jyri-aganitsh]

Evolve 3.0.0 Npsql 5.0.4

In db log:

ERROR:  syntax error at or near "LIKE" at character 16
STATEMENT:  SHOW VARIABLES LIKE '%version%'

[lecaillon]

It is normal. It is the way Evolve knows what kind of database it is currently running against. Details here if you're interrested

[xperiandri]

Can't it be done without the exception?

[lecaillon]

Yes, you can use the last alpha version and the new optional parmeter in the constructor called dbms

[andrii-berestov-lula]

Hi @lecaillon. This issue is still reproduced with 3.1.0-alpha7 for us. The error message is the same, as below

Npgsql.PostgresException (0x80004005): 42601: syntax error at or near "LIKE"

POSITION: 16
   at Npgsql.Internal.NpgsqlConnector.<ReadMessage>g__ReadMessageLong|228_0(NpgsqlConnector connector, Boolean async, DataRowLoadingMode dataRowLoadingMode, Boolean readingNotifications, Boolean isReadingPrependedMessage)
  Exception data:
    Severity: ERROR
    SqlState: 42601
    MessageText: syntax error at or near "LIKE"
    Position: 16
    File: scan.l
    Line: 1188
    Routine: scanner_yyerror

[xperiandri]

Yes, you can use the last alpha version and the new optional parmeter in the constructor called dbms

We still catch an exception. Were not you managed to fix that?

[lecaillon]

yes. how do you instantiate Evolve ? Can you give me more insight please