Rule for virtual foreign key with fix destination table
I have an MSSQL database with nearly no foreign keys, everything is matched by naming conventions.
The rules for virtual foreign keys look great, but they don't seem to work for my case.
E.g.
Table1: test1234
Columns: ColPgId and ColumnTestPgId
Table2: purse_group
Column: pg_id
Column Pattern: .*(?i)Pg(?i)Id
Target Column Pattern: purse_group\\.pg_id
If write “select * from test1234 as t join”, I get no option for a join to purse_group.
Yet the rule debugger seems to properly accept the data:

Am I missing something?
请先登录再写评论。
Please check if you have Suggest Non Strict key option turned on in File | Settings | Editor | General | Code Completion
https://www.jetbrains.com/help/datagrip/virtual-foreign-keys.html#-32g3mv_19
If it's activated and you still don't get a completion prompted based on your pk-fk relation, please specify your current IDE version, and we'll have a look