epam / epam/Indigo

MS SQL Server databases with dash ("-") in name break z_CreateMoleculeIndex stored procedure

Open
#188 0 comments 0 reactions 0 assignees View on GitHub
Dominant language
C++
Stars
406
Forks
134
Avg merge
2d 11h
Merged PRs (30d)
24

Description

I confirmed this running directly in SQL Server Management Studio on both MS SQL Server 2012 and MS SQL Server 2017. I restored the same database each time from the same .bak file and renamed it. Of the four names listed, the three with dashes in them threw the SQL errors below.
Demo_Site_One_dashTest
Demo_Site-One_dashTest
Demo-Site_One_dashTest
Demo-Site-One_dashTest

Error indexing structure data in Demo_Site-One_dashTest: A .NET Framework error occurred during execution of user-defined routine or aggregate "z_CreateMoleculeIndex":
System.Data.SqlClient.SqlException: Incorrect syntax near 'One_dashTest'.
System.Data.SqlClient.SqlException:
at indigo.Bingo._ExecuteBingoOperation(SqlString bingo_schema, bingoOperationDelegate operationDelegate, bingoGetIndexDataDelegate getBingoDataDelegate, BingoOp op_flags)
at indigo.Bingo._ExecuteBingoOperationChangeIndex(SqlString bingo_schema, bingoOperationDelegate operationDelegate, bingoGetIndexDataDelegate getBingoDataDelegate, BingoOp flags)
at indigo.Bingo.CreateIndex(SqlString table, SqlString id_column, SqlString data_column, SqlString bingo_schema, Boolean reaction)

Error indexing structure data in Demo-Site_One_dashTest: A .NET Framework error occurred during execution of user-defined routine or aggregate "z_CreateMoleculeIndex":
System.Data.SqlClient.SqlException: Incorrect syntax near 'Site_One_dashTest'.
System.Data.SqlClient.SqlException:
at indigo.Bingo._ExecuteBingoOperation(SqlString bingo_schema, bingoOperationDelegate operationDelegate, bingoGetIndexDataDelegate getBingoDataDelegate, BingoOp op_flags)
at indigo.Bingo._ExecuteBingoOperationChangeIndex(SqlString bingo_schema, bingoOperationDelegate operationDelegate, bingoGetIndexDataDelegate getBingoDataDelegate, BingoOp flags)
at indigo.Bingo.CreateIndex(SqlString table, SqlString id_column, SqlString data_column, SqlString bingo_schema, Boolean reaction)


Error indexing structure data in Demo-Site-One_dashTest: A .NET Framework error occurred during execution of user-defined routine or aggregate "z_CreateMoleculeIndex":
System.Data.SqlClient.SqlException: Incorrect syntax near 'Site'.
System.Data.SqlClient.SqlException:
at indigo.Bingo._ExecuteBingoOperation(SqlString bingo_schema, bingoOperationDelegate operationDelegate, bingoGetIndexDataDelegate getBingoDataDelegate, BingoOp op_flags)
at indigo.Bingo._ExecuteBingoOperationChangeIndex(SqlString bingo_schema, bingoOperationDelegate operationDelegate, bingoGetIndexDataDelegate getBingoDataDelegate, BingoOp flags)
at indigo.Bingo.CreateIndex(SqlString table, SqlString id_column, SqlString data_column, SqlString bingo_schema, Boolean reaction)

As a note, this error is thrown after the molecules are processed -- in the ouput window, the errors above were preceded by the list of molecules that could not be processed, such as:

Record with ID=241 wasn't added to the index: molfile loader: direction of bond #3 makes no sense
Record with ID=630 wasn't added to the index: molfile loader: direction of bond #0 makes no sense
Record with ID=590 wasn't added to the index: stereocenters: directions of neighbor stereo bonds match
Record with ID=748 wasn't added to the index: stereocenters: stereo types of the opposite bonds mismatch
Record with ID=829 wasn't added to the index: molfile loader: direction of bond #0 makes no sense
Record with ID=843 wasn't added to the index: stereocenters: stereo types of the opposite bonds mismatch
Record with ID=1116 wasn't added to the index: element: bad valence on N having 4 drawn bonds, charge 0, and 0 radical electrons
Record with ID=1119 wasn't added to the index: element: bad valence on N having 4 drawn bonds, charge 0, and 0 radical electrons
...
and so on.

Contributor guide

No contributing guide indexed for this repository

Assessment

This issue has not been assessed yet.

Get new issues in your inbox

A short digest of beginner-friendly GitHub issues.