View Issue Details

IDProjectCategoryView StatusLast Update
0000975bareos-core[All Projects] apipublic2019-07-11 17:22
ReporterfrankAssigned Toarogge 
PrioritynormalSeveritymajorReproducibilityalways
Status resolvedResolutionfixed 
PlatformLinuxOSCentOSOS Version7
Product Version17.2.6 
Target VersionFixed in Version 
Summary0000975: .bvfs_lsdirs limit offset command parameters do not work properly
Description.bvfs_lsdirs limit offset command parameters do not work properly.

Steps To Reproduce*.bvfs_lsdirs jobid=2,111,112,122,130,138 path=/etc/
123 11500 138 P0A BAABB EHt BM A A A CAA BAA Y BbNJKO BbNLO2 BbNLO2 A A C .
809 0 0 A A A A A A A A A A A A A A ..
112 1426 2 P0A DBG22 EHt H A A A CG BAA A Ba+/we BbB9X7 BbB9X7 A A C NetworkManager/
96 1478 2 P0A BADLX EHt F A A A 5 BAA A BazZZL BbB85h BbB85h A A C X11/
231 1192 2 P0A BAA8i EHt C A A A Ds BAA A BbB9YK BbB9X7 BbB9X7 A A C alternatives/
239 3476 2 P0A DBcGD EHo D A A A r BAA A BazZQQ BbB853 BbB853 A A C audisp/
66 3482 2 P0A BBLZn EHo D A A A BT BAA A BazZQQ BbB8/P BbB8/P A A C audit/
41 11499 138 P0A ClO8 EHt H A Pj A Cr BAA A BbNLO1 BbNLO1 BbNLO1 A A C bareos/
251 1481 2 P0A J82 EHt C A A A s BAA A BazYwT BbB9a/ BbB9a/ A A C bash_completion.d/
19 1290 2 P0A DA17e EHt C A A A G BAA A BbB8/O BazbsQ BbB85h A A C binfmt.d/
46 1193 2 P0A CAKIj EHt C A A A G BAA A BZhHqO BZhHqO BbB84m A A C chkconfig.d/
188 1737 2 P0A DBG5Y EHt C A A A V BAA A BbB8/P BbB85o BbB85o A A C cron.d/
111 1724 2 P0A BAear EHt C A A A q BAA A BbB+MV BbB85y BbB85y A A C cron.daily/
148 1671 2 P0A BA704 EHt C A A A W BAA A BbB9DN BTljHH BbB85o A A C cron.hourly/
88 1750 2 P0A CBPGb EHt C A A A G BAA A BbB+x1 BTljHH BbB85o A A C cron.monthly/
200 1673 2 P0A DBG5f EHt C A A A G BAA A BbB+fF BTljHH BbB85o A A C cron.weekly/
223 1378 2 P0A DA17c EHt E A A A BO BAA A Bazbfp BbB85j BbB85j A A C dbus-1/
7 1279 2 P0A ILy EHt C A A A s BAA A BazG5z BbB891 BbB891 A A C default/
70 1264 2 P0A DA17I EHt C A A A X BAA A BbB86T BbB85f BbB85f A A C depmod.d/
202 3447 2 P0A BFVS EHo E A A A 1 BAA A Ba+vUZ Ba+vUZ BbB9X9 A A C dhcp/
10 1268 2 P0A 6be EHt C A A A G BAA A BbB86p BazbmK BbB85f A A C dracut.conf.d/
61 1945 2 P0A CBStG EHo H A A A CF BAA A BazZR8 BbB85y BbB85y A A C firewalld/
47 1677 2 P0A CAfA9 EHt C A A A G BAA A BZgfW+ BZgfW+ BbB842 A A C gcrypt/
106 3452 2 P0A DBSa8 EHt C A A A G BAA A BYHgOf BYHgOf BbB85v A A C gnupg/
170 1709 2 P0A BASuH EHt E A A A o BAA A BTlhZM BbB849 BbB849 A A C groff/
250 1173 2 P0A CAKAT EHA C A A A C2 BAA A BbB892 BbB86S BbB86S A A C grub.d/
174 1684 2 P0A SAS EHt D A A A U BAA A Ba8vw+ Ba8vw+ BbB9YG A A C gss/
43 1721 2 P0A DAObA EHt C A A A Cf BAA A BazcKB BbB85E BbB85E A A C iproute2/
128 3500 2 P0A DBi+O EHt D A A A Y BAA A BbB86C BbB86C BbB86C A A C kernel/
254 1675 2 P0A CAfAw EHt C A A A G BAA A Ba8vw+ Ba8vw+ BbB9YG A A C krb5.conf.d/
195 10811 111 P0A CAeXE EHt C A A A Ck BAA A BbKjdw BbJ9aM BbJ9aM A A C ld.so.conf.d/
172 1226 2 P0A CAfA+ EHt C A A A j BAA A BZg34Z BbB843 BbB843 A A C libnl/
232 11444 138 P0A DAnhS EHt C A A A Bk BAA A BbM3Hi BbNLOz BbNLOz A A C logrotate.d/
131 1404 2 P0A DBSjo EHt G A A A Bk BAA A BbB87A BbB85z BbB85z A A C lvm/
57 10807 111 P0A 6cc EHt C A A A BR BAA A BbMLpP BbJ9aM BbJ9aM A A C modprobe.d/
115 1292 2 P0A 6eK EHt C A A A G BAA A BbB87B BazbsQ BbB85h A A C modules-load.d/
539 1753 2 P0A BAo2a EHt C A A A f BAA A BZhL1I BbB85Z BbB85Z A A C my.cnf.d/
42 1747 2 P0A CBM68 EHt D A A A k BAA A Ba/ABV BbB9X8 BbB9X8 A A C openldap/
5 1482 2 P0A BADLY EHt C A A A G BAA A BazZZL BazZZL BbB84r A A C opt/
98 1261 2 P0A SC/ EHt C A A A BAA BAA I BazX9d BbB9zP BbB9zP A A C pam.d/
163 1635 2 P0A BALKP EHt D A A A V BAA A BZhQUN BbB84y BbB84y A A C pkcs11/
198 1542 2 P0A CAKIu EHt K A A A B0 BAA A BazZZL BbB85y BbB85y A A C pki/
74 3451 2 P0A BImx EHt C A A A c BAA A Ba0Khn BbB85u BbB85u A A C plymouth/
94 1546 2 P0A DACnD EHt F A A A 0 BAA A BazZZL BbB84r BbB84r A A C pm/
177 1461 2 P0A CBNcL EHt F A A A BI BAA A BazVZ5 BbB85k BbB85k A A C polkit-1/
63 1631 2 P0A R+F EHt C A A A G BAA A BbB85Y BTloOK BbB84w A A C popt.d/
479 3492 2 P0A DBcGU EHt C A A A Ca BAA A BbB8/S BbB854 BbB855 A A C postfix/
636 1470 2 P0A BA7yu EHt D A A A B7 BAA A BazZih BbB85k BbB85k A A C ppp/
92 1275 2 P0A BAA9U EHt C A A A BO BAA A Ba+3OX BbB9X6 BbB9X6 A A C prelink.conf.d/
136 1444 2 P0A DACm/ EHt C A A A EY BAA A BbB9wW BbB9a/ BbB9a/ A A C profile.d/
516 1711 2 P0A CAg/e EHt C A A A j BAA A BazbsB BbB84/ BbB84/ A A C python/
441 3495 2 P0A DBi9r EHt D A A A y BAA A BZhCM/ BbB86B BbB86B A A C qemu-ga/
152 1223 2 P0A DAASf EHt K A A A B/ BAA A BZhHqO BbB85h BbB85h A A C rc.d/
226 1640 2 P0A R/l EHt C A A A s BAA A BbB9p2 BbB9a3 BbB9a3 A A C rpm/
109 1288 2 P0A BAo6t EHt C A A A Z BAA A BbB9YN Ba/BWx BbB9YH A A C rsyslog.d/
235 1726 2 P0A CAyML EHt C A A A X BAA A BazZih BazZih BbB85k A A C rwtab.d/
113 1648 2 P0A BALKY EHt C A A A Y BAA A BazY0n BbB854 BbB854 A A C sasl2/
25 1703 2 P0A BALT6 EHt G A A A BAA BAA I BazX9d BbB847 BbB847 A A C security/
21 3442 2 P0A CBM79 EHt F A A A BR BAA A Ba8xHa Ba8xHa BbB9X9 A A C selinux/
134 1178 2 P0A CAKIC EHt C A A A + BAA A BbB896 BazZZL BbB84r A A C skel/
99 1763 2 P0A BFVI EHt C A A A Dh BAA A BazY1J BbB8/P BbB8/P A A C ssh/
173 1637 2 P0A CAfAH EHt C A A A T BAA A Ba+7UQ BbB9YH BbB9YH A A C ssl/
215 1632 2 P0A DBG27 EHt C A A A G BAA A BazZih BazZih BbB85k A A C statetab.d/
6 3506 2 P0A Be+V EHo C A A A G BAA A BazY9P BazY9P BbB86D A A C sudoers.d/
13 10809 111 P0A DACnE EHt G A A A BAA BAA I BbKjdw BbJ9aS BbJ9aS A A C sysconfig/
53 1381 2 P0A BAo62 EHt C A A A c BAA A BbB87B BbB85k BbB85k A A C sysctl.d/
176 1351 2 P0A CBM/Z EHt E A A A CX BAA A BazbsQ BbB85h BbB85h A A C systemd/
190 1174 2 P0A Bx EHt C A A A G BAA A BZsHHM BZsHHM BbB84j A A C terminfo/
220 1383 2 P0A BAo63 EHt C A A A G BAA A BbB85j BazbsQ BbB85h A A C tmpfiles.d/
635 3459 2 P0A BIrs EHt D A A A Bt BAA A BbB8/S BbB85x BbB85x A A C tuned/
213 1388 2 P0A CBNAA EHt D A A A 2 BAA A BazbsR BbB8/O BbB8/O A A C udev/
143 3449 2 P0A BA927 EHt C A A A h BAA A BazZwI BbB85r BbB85r A A C wpa_supplicant/
182 1617 2 P0A J84 EHt E A A A m BAA A BazZZL BbB85h BbB85h A A C xdg/
119 1618 2 P0A CAKIw EHt C A A A G BAA A BazZZL BazZZL BbB84r A A C xinetd.d/
130 10814 111 P0A BALKk EHt C A A A D4 BAA A BbKQb2 BbKQbX BbKQbX A A C yum.repos.d/
32 1663 2 P0A CAfAM EHt G A A A Bk BAA A BbB8+0 BbB85w BbB85w A A C yum/
*

*.bvfs_lsdirs jobid=2,111,112,122,130,138 path=/etc/ limit=12 offset=0
123 11500 138 P0A BAABB EHt BM A A A CAA BAA Y BbNJKO BbNLO2 BbNLO2 A A C .
809 0 0 A A A A A A A A A A A A A A ..
112 1426 2 P0A DBG22 EHt H A A A CG BAA A Ba+/we BbB9X7 BbB9X7 A A C NetworkManager/
96 1478 2 P0A BADLX EHt F A A A 5 BAA A BazZZL BbB85h BbB85h A A C X11/
231 1192 2 P0A BAA8i EHt C A A A Ds BAA A BbB9YK BbB9X7 BbB9X7 A A C alternatives/
239 3476 2 P0A DBcGD EHo D A A A r BAA A BazZQQ BbB853 BbB853 A A C audisp/
66 3482 2 P0A BBLZn EHo D A A A BT BAA A BazZQQ BbB8/P BbB8/P A A C audit/
*

*.bvfs_lsdirs jobid=2,111,112,122,130,138 path=/etc/ limit=3 offset=0
123 11500 138 P0A BAABB EHt BM A A A CAA BAA Y BbNJKO BbNLO2 BbNLO2 A A C .
*

*.bvfs_lsdirs jobid=2,111,112,122,130,138 path=/etc/ limit=5
123 11500 138 P0A BAABB EHt BM A A A CAA BAA Y BbNJKO BbNLO2 BbNLO2 A A C .
*

Additional Informationbareos-dir (10): bvfs.c:642-0 ls_dirs(123)
bareos-dir (100): sql_query.c:96-0 called: void B_DB::fill_query_va_list(POOL_MEM&, B_DB_QUERY_ENUM_CLASS::SQL_QUERY_ENUM, __va_list_tag*) with query name bvfs_ls_special_dirs_3 (73)
bareos-dir (100): sql_query.c:102-0 called: void B_DB::fill_query_va_list(POOL_MEM&, B_DB_QUERY_ENUM_CLASS::SQL_QUERY_ENUM, __va_list_tag*) query is now SELECT 'D', SpecialDir.PathId, SpecialDir.Path, JobId, LStat, FileId FROM ( SELECT 123 AS PathId, '.' AS Path UNION SELECT PPathId AS PathId, '..' AS Path FROM PathHierarchy WHERE PathId = 123 ) AS SpecialDir LEFT JOIN ( SELECT PathId, JobId, LStat, FileId FROM File WHERE File.Name = '' AND File.JobId IN (2,111,112,122,130,138) ) AS DirAttribute ON (SpecialDir.PathId = DirAttribute.PathId)
bareos-dir (100): sql_query.c:96-0 called: void B_DB::fill_query_va_list(POOL_MEM&, B_DB_QUERY_ENUM_CLASS::SQL_QUERY_ENUM, __va_list_tag*) with query name bvfs_ls_sub_dirs_5 (74)
bareos-dir (100): sql_query.c:102-0 called: void B_DB::fill_query_va_list(POOL_MEM&, B_DB_QUERY_ENUM_CLASS::SQL_QUERY_ENUM, __va_list_tag*) query is now SELECT 'D', PathId, Path, JobId, LStat, FileId FROM ( SELECT Path1.PathId AS PathId, Path1.Path AS Path, lower(Path1.Path) AS lpath, listfile1.JobId AS JobId, listfile1.LStat AS LStat, listfile1.FileId AS FileId FROM ( SELECT listpath1.PathId AS PathId FROM ( SELECT DISTINCT PathHierarchy1.PathId AS PathId FROM PathHierarchy AS PathHierarchy1 INNER JOIN Path AS Path2 ON (PathHierarchy1.PathId = Path2.PathId) INNER JOIN PathVisibility AS PathVisibility1 ON (PathHierarchy1.PathId = PathVisibility1.PathId) WHERE PathHierarchy1.PPathId = 123 AND PathVisibility1.JobId IN (2,111,112,122,130,138) ) AS listpath1 LEFT JOIN ( SELECT PVD1.PathId AS PathId FROM ( SELECT PV1.PathId AS PathId, MAX(JobId) AS MaxJobId FROM PathVisibility AS PV1 WHERE JobId IN (2,111,112,122,130,138) GROUP BY PathId ) AS PVD1 INNER JOIN File AS F2 ON (F2.PathId = PVD1.PathId AND F2.JobId = PVD1.MaxJobId AND F2.FileIndex = 0 AND F2.Name = '') ) AS listpath2 ON (listpath1.PathId = listpath2.PathId) WHERE listpath2.PathId IS NULL ) AS listpath3 INNER JOIN Path AS Path1 ON (listpath3.PathId = Path1.PathId) LEFT JOIN ( SELECT File1.PathId AS PathId, File1.JobId AS JobId, File1.LStat AS LStat, File1.FileId AS FileId FROM File AS File1 WHERE File1.Name = '' AND File1.JobId IN (2,111,112,122,130,138) ) AS listfile1 ON (listpath3.PathId = listfile1.PathId) ) AS A
bareos-dir (100): sql_query.c:96-0 called: void B_DB::fill_query_va_list(POOL_MEM&, B_DB_QUERY_ENUM_CLASS::SQL_QUERY_ENUM, __va_list_tag*) with query name bvfs_lsdirs_4 (63)
bareos-dir (100): sql_query.c:102-0 called: void B_DB::fill_query_va_list(POOL_MEM&, B_DB_QUERY_ENUM_CLASS::SQL_QUERY_ENUM, __va_list_tag*) query is now SELECT 'D', SpecialDir.PathId, SpecialDir.Path, JobId, LStat, FileId FROM ( SELECT 123 AS PathId, '.' AS Path UNION SELECT PPathId AS PathId, '..' AS Path FROM PathHierarchy WHERE PathId = 123 ) AS SpecialDir LEFT JOIN ( SELECT PathId, JobId, LStat, FileId FROM File WHERE File.Name = '' AND File.JobId IN (2,111,112,122,130,138) ) AS DirAttribute ON (SpecialDir.PathId = DirAttribute.PathId) UNION SELECT 'D', PathId, Path, JobId, LStat, FileId FROM ( SELECT Path1.PathId AS PathId, Path1.Path AS Path, lower(Path1.Path) AS lpath, listfile1.JobId AS JobId, listfile1.LStat AS LStat, listfile1.FileId AS FileId FROM ( SELECT listpath1.PathId AS PathId FROM ( SELECT DISTINCT PathHierarchy1.PathId AS PathId FROM PathHierarchy AS PathHierarchy1 INNER JOIN Path AS Path2 ON (PathHierarchy1.PathId = Path2.PathId) INNER JOIN PathVisibility AS PathVisibility1 ON (PathHierarchy1.PathId = PathVisibility1.PathId) WHERE PathHierarchy1.PPathId = 123 AND PathVisibility1.JobId IN (2,111,112,122,130,138) ) AS listpath1 LEFT JOIN ( SELECT PVD1.PathId AS PathId FROM ( SELECT PV1.PathId AS PathId, MAX(JobId) AS MaxJobId FROM PathVisibility AS PV1 WHERE JobId IN (2,111,112,122,130,138) GROUP BY PathId ) AS PVD1 INNER JOIN File AS F2 ON (F2.PathId = PVD1.PathId AND F2.JobId = PVD1.MaxJobId AND F2.FileIndex = 0 AND F2.Name = '') ) AS listpath2 ON (listpath1.PathId = listpath2.PathId) WHERE listpath2.PathId IS NULL ) AS listpath3 INNER JOIN Path AS Path1 ON (listpath3.PathId = Path1.PathId) LEFT JOIN ( SELECT File1.PathId AS PathId, File1.JobId AS JobId, File1.LStat AS LStat, File1.FileId AS FileId FROM File AS File1 WHERE File1.Name = '' AND File1.JobId IN (2,111,112,122,130,138) ) AS listfile1 ON (listpath3.PathId = listfile1.PathId) ) AS A ORDER BY Path ASC,JobId DESC LIMIT 5 OFFSET 0
bareos-dir (15): bvfs.c:371-0 q=SELECT 'D', SpecialDir.PathId, SpecialDir.Path, JobId, LStat, FileId FROM ( SELECT 123 AS PathId, '.' AS Path UNION SELECT PPathId AS PathId, '..' AS Path FROM PathHierarchy WHERE PathId = 123 ) AS SpecialDir LEFT JOIN ( SELECT PathId, JobId, LStat, FileId FROM File WHERE File.Name = '' AND File.JobId IN (2,111,112,122,130,138) ) AS DirAttribute ON (SpecialDir.PathId = DirAttribute.PathId) UNION SELECT 'D', PathId, Path, JobId, LStat, FileId FROM ( SELECT Path1.PathId AS PathId, Path1.Path AS Path, lower(Path1.Path) AS lpath, listfile1.JobId AS JobId, listfile1.LStat AS LStat, listfile1.FileId AS FileId FROM ( SELECT listpath1.PathId AS PathId FROM ( SELECT DISTINCT PathHierarchy1.PathId AS PathId FROM PathHierarchy AS PathHierarchy1 INNER JOIN Path AS Path2 ON (PathHierarchy1.PathId = Path2.PathId) INNER JOIN PathVisibility AS PathVisibility1 ON (PathHierarchy1.PathId = PathVisibility1.PathId) WHERE PathHierarchy1.PPathId = 123 AND PathVisibility1.JobId IN (2,111,112,122,130,138) ) AS listpath1 LEFT JOIN ( SELECT PVD1.PathId AS PathId FROM ( SELECT PV1.PathId AS PathId, MAX(JobId) AS MaxJobId FROM PathVisibility AS PV1 WHERE JobId IN (2,111,112,122,130,138) GROUP BY PathId ) AS PVD1 INNER JOIN File AS F2 ON (F2.PathId = PVD1.PathId AND F2.JobId = PVD1.MaxJobId AND F2.FileIndex = 0 AND F2.Name = '') ) AS listpath2 ON (listpath1.PathId = listpath2.PathId) WHERE listpath2.PathId IS NULL ) AS listpath3 INNER JOIN Path AS Path1 ON (listpath3.PathId = Path1.PathId) LEFT JOIN ( SELECT File1.PathId AS PathId, File1.JobId AS JobId, File1.LStat AS LStat, File1.FileId AS FileId FROM File AS File1 WHERE File1.Name = '' AND File1.JobId IN (2,111,112,122,130,138) ) AS listfile1 ON (listpath3.PathId = listfile1.PathId) ) AS A ORDER BY Path ASC,JobId DESC LIMIT 5 OFFSET 0
bareos-dir (100): sql_query.c:140-0 called: bool B_DB::sql_query(const char*, int (*)(void*, int, char**), void*) with query SELECT 'D', SpecialDir.PathId, SpecialDir.Path, JobId, LStat, FileId FROM ( SELECT 123 AS PathId, '.' AS Path UNION SELECT PPathId AS PathId, '..' AS Path FROM PathHierarchy WHERE PathId = 123 ) AS SpecialDir LEFT JOIN ( SELECT PathId, JobId, LStat, FileId FROM File WHERE File.Name = '' AND File.JobId IN (2,111,112,122,130,138) ) AS DirAttribute ON (SpecialDir.PathId = DirAttribute.PathId) UNION SELECT 'D', PathId, Path, JobId, LStat, FileId FROM ( SELECT Path1.PathId AS PathId, Path1.Path AS Path, lower(Path1.Path) AS lpath, listfile1.JobId AS JobId, listfile1.LStat AS LStat, listfile1.FileId AS FileId FROM ( SELECT listpath1.PathId AS PathId FROM ( SELECT DISTINCT PathHierarchy1.PathId AS PathId FROM PathHierarchy AS PathHierarchy1 INNER JOIN Path AS Path2 ON (PathHierarchy1.PathId = Path2.PathId) INNER JOIN PathVisibility AS PathVisibility1 ON (PathHierarchy1.PathId = PathVisibility1.PathId) WHERE PathHierarchy1.PPathId = 123 AND PathVisibility1.JobId IN (2,111,112,122,130,138) ) AS listpath1 LEFT JOIN ( SELECT PVD1.PathId AS PathId FROM ( SELECT PV1.PathId AS PathId, MAX(JobId) AS MaxJobId FROM PathVisibility AS PV1 WHERE JobId IN (2,111,112,122,130,138) GROUP BY PathId ) AS PVD1 INNER JOIN File AS F2 ON (F2.PathId = PVD1.PathId AND F2.JobId = PVD1.MaxJobId AND F2.FileIndex = 0 AND F2.Name = '') ) AS listpath2 ON (listpath1.PathId = listpath2.PathId) WHERE listpath2.PathId IS NULL ) AS listpath3 INNER JOIN Path AS Path1 ON (listpath3.PathId = Path1.PathId) LEFT JOIN ( SELECT File1.PathId AS PathId, File1.JobId AS JobId, File1.LStat AS LStat, File1.FileId AS FileId FROM File AS File1 WHERE File1.Name = '' AND File1.JobId IN (2,111,112,122,130,138) ) AS listfile1 ON (listpath3.PathId = listfile1.PathId) ) AS A ORDER BY Path ASC,JobId DESC LIMIT 5 OFFSET 0
TagsNo tags attached.
bareos-master: impact
bareos-master: action
bareos-18.2: impact
bareos-18.2: action
bareos-17.2: impact
bareos-17.2: action
bareos-16.2: impact
bareos-16.2: action
bareos-15.2: impact
bareos-15.2: action
bareos-14.2: impact
bareos-14.2: action
bareos-13.2: impact
bareos-13.2: action
bareos-12.4: impact
bareos-12.4: action

Activities

arogge

arogge

2019-07-11 17:22

developer   ~0003444

Fix committed to bareos master branch with changesetid 11581.

Related Changesets

bareos: master a9a0bdd9

2019-07-09 16:31:56

arogge

Ported: N/A

Details Diff
cats: Fix .bvfs_lsdirs when using limit and offset

Fixes 0000975: .bvfs_lsdirs limit offset command parameters do not work properly

The .bvfs_lsdirs command did not return the correct amount of entries
when it was used with multiple jobids together with limit and offset.
The problem was that the SQL query returned multiple rows with the same
path and Bvfs::_handle_path() removed the duplicates. Also, no matter
what offset was given, the result did always start with the . and ..
entries.

This is fixed now when using the PostgreSQL DB for Catalog by a modified
SQL query that integrates the formerly separate SQL query for the . and
.. entries with the query for the normal directory entries and the new
query no longer contains duplicates.

This version will not work with a MySQL Catalog DB because MySQL/MariaDB
lacks the DISTINCT ON feature.

Original Author: Stephan Duehr <stephan.duehr@bareos.com>
Affected Issues
0000975
mod - core/src/cats/bvfs.cc Diff File
add - core/src/cats/dml/0074_bvfs_ls_special_dirs_3.postgresql Diff File
mod - core/src/cats/dml/0075_bvfs_ls_sub_dirs_5 Diff File
add - core/src/cats/dml/0075_bvfs_ls_sub_dirs_5.postgresql Diff File
mod - core/src/cats/mysql_queries.inc Diff File
mod - core/src/cats/postgresql_queries.inc Diff File
mod - core/src/cats/sqlite_queries.inc Diff File

bareos: master 613316e0

2019-07-11 17:13:56

arogge


Committer: GitHub

Ported: N/A

Details Diff
Merge pull request 0000216 from bareos/dev/arogge/master/fix-975

Fix 0000975: .bvfs_lsdirs limit offset command parameters do not work properly
Affected Issues
0000975
mod - core/src/cats/bvfs.cc Diff File
add - core/src/cats/dml/0074_bvfs_ls_special_dirs_3.postgresql Diff File
mod - core/src/cats/dml/0075_bvfs_ls_sub_dirs_5 Diff File
add - core/src/cats/dml/0075_bvfs_ls_sub_dirs_5.postgresql Diff File
mod - core/src/cats/dml/create_queryfiles.sh Diff File
mod - core/src/cats/mysql_queries.inc Diff File
mod - core/src/cats/postgresql_queries.inc Diff File
mod - core/src/cats/sqlite_queries.inc Diff File

Issue History

Date Modified Username Field Change
2018-06-28 15:44 frank New Issue
2018-06-28 15:53 frank Status new => confirmed
2018-07-12 09:45 stephand Assigned To => stephand
2018-07-12 09:45 stephand Status confirmed => assigned
2019-07-11 17:22 arogge Changeset attached => bareos master 613316e0
2019-07-11 17:22 arogge Changeset attached => bareos master a9a0bdd9
2019-07-11 17:22 arogge Note Added: 0003444
2019-07-11 17:22 arogge Assigned To stephand => arogge
2019-07-11 17:22 arogge Status assigned => resolved
2019-07-11 17:22 arogge Resolution open => fixed