Unable to find certain versions for releases in the DB as shown on official website

[ronaldtse]

From @andrew2net .

In the DB there are two "0.2.1" versions with not nil 3guId for spec 02.08 and release Ph1 (Phase 1). For spec 02.08 and release Ph2 (Phase 2) there isn't any "0.2.1" version:

schedule.select { |sc| sc[:spec] == "02.08" && sc[:release] == "Ph1" && sc[:MAJOR_VERSION_NB] == '0' && sc[:TECHNICAL_VERSION_NB] == '2' && sc[:EDITORIAL_VERSION_NB] == '1' }.size
=> 2

schedule.select { |sc| sc[:spec] == "02.08" && sc[:release] == "Ph2" && sc[:MAJOR_VERSION_NB] == '0' && sc[:TECHNICAL_VERSION_NB] == '2' && sc[:EDITORIAL_VERSION_NB] == '1' }.size
=> 0

on the 3GPP portal one "0.2.1" version is displayed in "Phase 1" and one in "Phase 2" https://portal.3gpp.org/desktopmodules/Specifications/SpecificationDetails.aspx?specificationId=35

Originally posted by @andrew2net in https://github.com/relaton/relaton-3gpp/issues/1#issuecomment-991740310

[ronaldtse]

See original issue for latest investigation results. (reposted information below)

[ronaldtse]

From https://github.com/relaton/relaton-3gpp/issues/1#issuecomment-991844813

Some further insights from the screenshot:

• "ACHIEVED DATE" in the database is shown as "Upload date". This is evident from:
  • Phase 1 0.2.1 has an upload date of 1995-10-06, but Phase 2 0.2.1 upload date is empty
  • In the database, 3guId(639) has "ACHIEVED DATE" of "1995-10-06", and 3guId(5227) has a "ACHIEVED DATE" of NULL.
• We know 3guId(639) and 3guId(5227) in the database corresponds with the two 0.2.1 items in the screenshot, because:
  • When we look at the "Comment", 3guId(639) has the Comment of "SMG 571/95", which matches the "Comment" in the screenshot of Phase 1 0.2.1. 3guId(5227) has Comment of "SMG1 571/95" (extra "1").
  • 0.2.1 in Phase 1 has a URL but not the 0.2.1 Phase 2 entry. This is confirmed in the database, where 3guId(639) has URL but 3guId(5227) has no URL.

As @andrew2net mentioned, the magical thing is both records have a "release" value of Ph1. However in the screenshot these two entries split into "Phase 1" and "Phase 2"! How is that even possible?

I found two places that have "02.08" listed as Phase 1 and Phase 2:

1. In the "Specs_GSM+3G_release-info" table:

2. In the "temp-status" table:

Now downloading the latest 2021-12-05 DB to see if there are any changes...

[ronaldtse]

From https://github.com/relaton/relaton-3gpp/issues/1#issuecomment-991864990:

I am not sure if 3GPP has a different database, but in the 2001-04-25_schedule table we can see data from 2021-12-03, which is super recent. This would indicate that at least this table is likely authoritative. So I don't understand how they placed the same record in "Phase 1" vs "Phase 2" that way.

However, I just found this table: 2003-04-10_webexp04_release-and-version-details_table.

This data is correct! Yet the newest data for this table is only until 2013.

So it is very possible that there is another table (e.g. release-and-version-details_table) that contains the correct information, but it is not published.