bareos: master 452a8a4e
| Author | Committer | Branch | Timestamp | Parent | |
|---|---|---|---|---|---|
| stephand | stephand | master | 2017-07-21 19:15 | master 42d7e719 | Pending |
| Changeset | Fix .bvfs_lsdirs: Don't show empty dirs from accurate jobs The SQL Query used by .bvfs_lsdirs did not consider the FileIndex column, which is 0 for deleted directories in accurate backup jobs, so that empty directories were returned by .bvfs_lsdirs. This commit also contains an optimized index for the above SQL query, without such an index .bvfs_lsdirs could be very slow on large databases. Also all variable length columns of the File table have been moved to the end, this may allow the database to optimize the physical layout. |
||||
| mod - src/cats/bdb_query_enum_class.h | Diff File | ||||
| mod - src/cats/bdb_query_names.inc | Diff File | ||||
| mod - src/cats/bvfs.c | Diff File | ||||
| mod - src/cats/ddl/creates/mysql.sql | Diff File | ||||
| mod - src/cats/ddl/creates/postgresql.sql | Diff File | ||||
| mod - src/cats/ddl/updates/mysql.2004_2170.sql | Diff File | ||||
| mod - src/cats/ddl/updates/postgresql.2004_2170.sql | Diff File | ||||
| mod - src/cats/mysql_queries.inc | Diff File | ||||
| mod - src/cats/postgresql_queries.inc | Diff File | ||||
| mod - src/cats/sqlite_queries.inc | Diff File | ||||
