View Issue Details

IDProjectCategoryView StatusLast Update
0008568VALENTINA STUDIOTool - Schema Editorpublic2019-07-03 18:11
ReporterFelipe Pessoa Assigned ToSergey Pashkov  
PrioritynormalSeveritymajorReproducibilityalways
Status resolvedResolutionfixed 
PlatformIntelOSLinuxOS VersionUbunu 18.04
Product Version9.2.x 
Target Version9.3.xFixed in Version9.3.x 
Summary0008568: Shema not show on list
DescriptionI have a scheme called "DEV" that not shows on database schemas list.
When a make a query on this schemas object( tables, views...), returns the data with no problem.
Additional InformationOne image is on DBeaver IDE and another on valentina studio
TagsNo tags attached.
Working with DB:SQL Server
Version of your DB:

Activities

Felipe Pessoa

Felipe Pessoa

2019-07-02 18:36

reporter  

Captura de tela de 2019-07-02 15-24-30.png (6,229 bytes)
Captura de tela de 2019-07-02 15-24-06.png (8,695 bytes)
Sergey Pashkov

Sergey Pashkov

2019-07-02 19:47

developer   ~0010869

Hello Felipe,

Could you please execute the following query in this database? Will it have DEV schema?

SELECT
  sys_sch.name AS 'Schema',
  sys_sch.schema_id AS 'ID',
  sys_dbp.name AS 'Owner'
FROM
  sys.schemas sys_sch
JOIN sys.database_principals sys_dbp
 ON sys_sch.principal_id = sys_dbp.principal_id
WHERE sys_sch.name <> 'information_schema'
AND sys_sch.name <> 'sys'
AND SUBSTRING( sys_sch.name,0,4 ) <> 'db_'
Felipe Pessoa

Felipe Pessoa

2019-07-02 21:36

reporter   ~0010870

Hello Sergey,

I ran the query and it hadn't DEV schema.

When I ran with LEFT Join i returns with "Owner' = NULL.
Captura de tela de 2019-07-02 18-30-13.png (40,326 bytes)
Captura de tela de 2019-07-02 18-29-47.png (38,192 bytes)
Sergey Pashkov

Sergey Pashkov

2019-07-03 11:29

developer   ~0010871

Thank you, so principal_id has value not present in the sys.database_principals?

What principal_id has the DEV schema?
SELECT * FROM sys.schemas WHERE name = 'DEV'
Felipe Pessoa

Felipe Pessoa

2019-07-03 14:13

reporter   ~0010872

Hello Sergey,

The Dev schema have principal_id 8, but this Id isn't present on sys.database_principals
Captura de tela de 2019-07-03 11-08-55.png (6,470 bytes)
Captura de tela de 2019-07-03 11-13-20.png (11,965 bytes)
Sergey Pashkov

Sergey Pashkov

2019-07-03 18:03

developer   ~0010873

Hello Felipe,

Thank you for the tests, I think we'll use LEFT JOIN in this query.

Issue History

Date Modified Username Field Change
2019-07-02 18:36 Felipe Pessoa New Issue
2019-07-02 18:36 Felipe Pessoa File Added: Captura de tela de 2019-07-02 15-24-30.png
2019-07-02 18:36 Felipe Pessoa File Added: Captura de tela de 2019-07-02 15-24-06.png
2019-07-02 19:47 Sergey Pashkov Note Added: 0010869
2019-07-02 21:36 Felipe Pessoa File Added: Captura de tela de 2019-07-02 18-30-13.png
2019-07-02 21:36 Felipe Pessoa File Added: Captura de tela de 2019-07-02 18-29-47.png
2019-07-02 21:36 Felipe Pessoa Note Added: 0010870
2019-07-03 11:17 Sergey Pashkov Assigned To => Sergey Pashkov
2019-07-03 11:17 Sergey Pashkov Status new => assigned
2019-07-03 11:29 Sergey Pashkov Note Added: 0010871
2019-07-03 14:13 Felipe Pessoa File Added: Captura de tela de 2019-07-03 11-08-55.png
2019-07-03 14:13 Felipe Pessoa File Added: Captura de tela de 2019-07-03 11-13-20.png
2019-07-03 14:13 Felipe Pessoa Note Added: 0010872
2019-07-03 18:03 Sergey Pashkov Note Added: 0010873
2019-07-03 18:11 Sergey Pashkov Status assigned => resolved
2019-07-03 18:11 Sergey Pashkov Resolution open => fixed
2019-07-03 18:11 Sergey Pashkov Fixed in Version => 9.3.x
2019-07-03 18:11 Sergey Pashkov Target Version => 9.3.x
2019-07-03 18:11 Sergey Pashkov Description Updated