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?

0
Hi,

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
0

请先登录再写评论。