upstream/icingadb
1
0
Fork 0
mirror of https://github.com/Icinga/icingadb.git synced 2026-05-28 04:35:54 -04:00
Code Issues Projects Releases Packages Wiki Activity Actions 1
icingadb/cmd/icingadb-migrate/embed
History
Alvar Penning f94a65f459
icingadb-migrate: Explicit AS in SELECT 
By introducing an explicit "AS" to set output names in the SELECT column
list, there are no issues with reserved names. Unfortunately, this
happened on PostgreSQL in the older version 13 with the reserved name
"name". Adding "AS" mitigates this issue.

Furthermore, I have put each column name in its own line for the SELECT
queries to ease the readability of the query itself and of future diffs.

Fixes #884.
2025-03-05 14:02:01 +01:00
..
comment_query.sql icingadb-migrate: Explicit AS in SELECT 2025-03-05 14:02:01 +01:00
downtime_query.sql icingadb-migrate: Explicit AS in SELECT 2025-03-05 14:02:01 +01:00
event_time_cache_schema.sql cmd/: rename ido2icingadb/ to icingadb-migrate/ 2022-10-26 11:18:52 +02:00
flapping_query.sql icingadb-migrate: Explicit AS in SELECT 2025-03-05 14:02:01 +01:00
ido_migration_progress_schema.sql cmd/: rename ido2icingadb/ to icingadb-migrate/ 2022-10-26 11:18:52 +02:00
notification_query.sql icingadb-migrate: Explicit AS in SELECT 2025-03-05 14:02:01 +01:00
previous_hard_state_cache_schema.sql cmd/: rename ido2icingadb/ to icingadb-migrate/ 2022-10-26 11:18:52 +02:00
state_query.sql icingadb-migrate: Explicit AS in SELECT 2025-03-05 14:02:01 +01:00