Print Thread
Partitioned table by range with interval
#62720 10/19/21 08:10 AM
Joined: Oct 2021
Posts: 1
Russia
A
Member
OP Offline
Member
A
Joined: Oct 2021
Posts: 1
Russia
Hi!
The script of the partitioned table by range with interval is being built incorrectly. The interval parameter is not taken into account.

Re: Partitioned table by range with interval
Alexander1 #62723 10/19/21 09:12 AM
Joined: Aug 1999
Posts: 22,200
Member
Offline
Member
Joined: Aug 1999
Posts: 22,200
This is indeed on the list of enhancement requests.


Marco Kalter
Allround Automations
Re: Partitioned table by range with interval
Alexander1 #63928 05/13/22 04:34 AM
Joined: Aug 2003
Posts: 45
Pasadena, CA
Member
Offline
Member
Joined: Aug 2003
Posts: 45
Pasadena, CA
This has been an issue for at least 3 releases and is still not fixed. it's a significant issue because viewing a table and then switching to the SQL generates the cleanest DDL (better than DBMS_METADATA). However, the partitioning clause has to be written by hand. This also affects comparisons between schemas/databases because you get tons of false positives when the number of partitions is different, even when the DDL is the same.

Frankly, I would prefer this fix over any superficial updates to the icons, or the addition of a dark theme.


Thanks,
Ara

Moderated by  support 

Link Copied to Clipboard
Powered by UBB.threads™ PHP Forum Software 7.7.4
(Release build 20200307)
Responsive Width:

PHP: 7.1.33 Page Time: 0.054s Queries: 16 (0.019s) Memory: 2.5005 MB (Peak: 3.0380 MB) Data Comp: Off Server Time: 2024-04-19 11:38:54 UTC
Valid HTML 5 and Valid CSS