sqlalchemy-monetdb icon indicating copy to clipboard operation
sqlalchemy-monetdb copied to clipboard

Tests to be fixed in 1.4 test suite

Open smavros opened this issue 3 years ago • 0 comments

Errors

  • [ ] JSONTest issue #52, 87 failures due to lack of dialect support for JSON type
  • [ ] IdentityColumnTest the errors comes from the fact that one column of this test's table is named "desc" which collides with the SQL Standard DESC keyword.
  • [ ] IdentityAutoincrementTest same as IdentityColumnTest
  • [ ] CTETests use the INSERT INTO for tables with recursive keys (create table foo (id int primary key, num int references foo(id));) which is known to not work properly in Monet (https://github.com/MonetDB/MonetDB/issues/6131) e.g. insert into foo values (1,null), (2,1); raises FOREIGN KEY constraint 'foo.foo_num_fkey' violated
  • [ ] QuotedNameArgumentTests are failing because of the NOT supported column CHECK constraint. Of course this is not raising an error or an exception but simply issues a warning through MonetDB dialect compiler so the user would know that the CHECK is a no-op. The problem comes from the fact that for the testing suite the SAWarnings are turned into errors (see. sqlalchemy/testing/warnings.py). Another issue with this group of tests is that we do not support comment_reflection which, I guess, was supposed to be supported given the fact that we support _COMMENT_s for SQL objects.

Failures

  • [ ] != needs to be translated properly. #51

smavros avatar Apr 28 '22 13:04 smavros