search

tds-fdw / tds_fdw

A PostgreSQL foreign data wrapper to connect to TDS databases (Sybase and Microsoft SQL Server)
Other
377 stars 101 forks source link

Drop view_simple needs to go with test 029 #264

Closed juliogonzalez closed 4 years ago

juliogonzalez commented 4 years ago

Since test 029 creates the view view_simple, the DROP should go at that test.

juliogonzalez commented 4 years ago

Closing, now I remember why I did it the other way around:

00:11:17 [ERROR] Error running view creation (simple) (tests/mssql/029_create_view_simple.sql)
00:11:17 [ERROR] Query:
00:11:17 IF OBJECT_ID('postgresql95_ubuntu1804_test.view_simple', 'V') IS NOT NULL
00:11:17         DROP VIEW postgresql95_ubuntu1804_test.view_simple;
00:11:17 
00:11:17 CREATE VIEW postgresql95_ubuntu1804_test.view_simple (id, data)
00:11:17         AS SELECT id, data FROM postgresql95_ubuntu1804_test.table_view_simple;
00:11:17 
00:11:17 [ERROR] (111, "'CREATE VIEW' must be the first statement in a query batch.DB-Lib error message 20018, severity 15:\nGeneral SQL Server error: Check messages from the SQL Server\n")

:-)

jenkins-juliogonzalez commented 4 years ago

Test FAILed.