I would suspect that these are SQL queries which can be dynamic. But if the data never changes how is it that the query results are false when they were true at one point?
#Group2 sql query and api output (no issues with this group)
### Start Device Groups ###
SQL[SELECT * FROM device_groups ORDER BY name
SQL[SELECT 1 FROM information_schema.COLUMNS WHERE TABLE_NAME = 'ipv6_addresses' && COLUMN_NAME = 'device_id'
SQL[SELECT COLUMN_NAME FROM information_schema.COLUMNS WHERE TABLE_NAME = 'ipv6_addresses' && COLUMN_NAME LIKE "%\_id"
SQL[SELECT 1 FROM information_schema.COLUMNS WHERE TABLE_NAME = 'ipv6s' && COLUMN_NAME = 'device_id'
SQL[SELECT 1 FROM information_schema.COLUMNS WHERE TABLE_NAME = 'ipv6s' && COLUMN_NAME = 'device_id'
SQL[SELECT 1 FROM information_schema.COLUMNS WHERE TABLE_NAME = 'ports' && COLUMN_NAME = 'device_id'
SQL[SELECT DISTINCT(devices.device_id) FROM devices,ipv6_addresses,ports WHERE (( ipv6_addresses.port_id = ports.port_id && ports.device_id = devices.device_id )) && devices.device_id='1' AND (ipv6_addresses.ipv6_compressed REGEXP "2607:9
MySQL Error: You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near '"2607:9' at line 1 (SELECT DISTINCT(devices.device_id) FROM devices,ipv6_addresses,ports WHERE (( ipv6_addresses.port_id = ports.port_id && ports.device_id = devices.device_id )) && devices.device_id='1' AND (ipv6_addresses.ipv6_compressed REGEXP "2607:9)
SQL[SELECT `device_group_id` FROM `device_group_device` WHERE `device_id`='1'
Groups Added:
Groups Removed: 19
SQL[DELETE FROM `device_group_device` WHERE `device_id`='1' AND `device_group_id` IN (19)
### End Device Groups ###
### Start Device Groups ###
SQL[SELECT * FROM device_groups ORDER BY name
SQL[SELECT 1 FROM information_schema.COLUMNS WHERE TABLE_NAME = 'ipv6_addresses' && COLUMN_NAME = 'device_id'
SQL[SELECT COLUMN_NAME FROM information_schema.COLUMNS WHERE TABLE_NAME = 'ipv6_addresses' && COLUMN_NAME LIKE "%\_id"
SQL[SELECT 1 FROM information_schema.COLUMNS WHERE TABLE_NAME = 'ipv6s' && COLUMN_NAME = 'device_id'
SQL[SELECT 1 FROM information_schema.COLUMNS WHERE TABLE_NAME = 'ipv6s' && COLUMN_NAME = 'device_id'
SQL[SELECT 1 FROM information_schema.COLUMNS WHERE TABLE_NAME = 'ports' && COLUMN_NAME = 'device_id'
SQL[SELECT DISTINCT(devices.device_id) FROM devices,ipv6_addresses,ports WHERE (( ipv6_addresses.port_id = ports.port_id && ports.device_id = devices.device_id )) && devices.device_id='2' AND (ipv6_addresses.ipv6_compressed REGEXP "2607:9
MySQL Error: You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near '"2607:9' at line 1 (SELECT DISTINCT(devices.device_id) FROM devices,ipv6_addresses,ports WHERE (( ipv6_addresses.port_id = ports.port_id && ports.device_id = devices.device_id )) && devices.device_id='2' AND (ipv6_addresses.ipv6_compressed REGEXP "2607:9)
SQL[SELECT `device_group_id` FROM `device_group_device` WHERE `device_id`='2'
Groups Added:
Groups Removed:
### End Device Groups ###
Idk if normal but this line ipv6_addresses.ipv6_compressed REGEXP "2607:9 looks wrong. Should read ipv6_addresses.ipv6_compressed REGEXP "2607:xxxx:9 which is what the API outputs