JVM: OpenJDK 64-Bit Server VM by JetBrains s.r.oĢ. Subscription is active until September 24, 2017 Sublime or Notepad have an advantage - no useless noise warnings.īuild #DB-163.13906.13, built on February 21, 2017 Autocomplete doesn't work as expected and a high noise of unresolved objects in source code.No guarantee metadata collected without a mistake. I should check actual objects (foreign key, constraints, etc.) related to a table manually.It's great if your database has 20 tables, but if it has more? or you see the database first time and is not familiar with it? I should check each field data type via system views (just in case, because I don't know is it number or a text).select a.column_a aĪt the moment DataGrip is a tool I can't trust in full. Though it's not a mission critical issue as point #1 above. As an example, no chance for below style. Source code style for SQL is very simple. DataGrip does not know about Oracle CHAR keyword for type definitions ħ. Even complete metadata uploading does not help.Ħ. A few actions by creating additional foreign keys - and first one is gone. IDE uploaded incrementally the foreign key. For PostgreSQL database I have seen issues with metadata collection. I'm still not sure what will be selected as a target database.ĥ. But when we are going to run a selected SQL query within an open file - DataGrip will silently execute the SQL query on a database associated with the file previously! Yes, it will be asked only first time you run the file, and. If we are going to execute a SQL file from Files tab - we will be asked about what database we should use. DataGrip logic of source code execution on a database is sick with f# dualism. DataGrip does not know about COLUMN_VALUE field of Oracle object type, as an example, AS TABLE OF NUMBER.Ĥ. As an example, a constant from package specification is not recognized in another package body (sic!). Sometimes it looks like 70% of the package is unresolved.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |