SQLite (64-bit) 歷史版本列表 Page2

更新時間：2023-08-25
更新細節：

What's new in this version:

New features:
- Added Expression to CREATE INDEX
- Added cascade option while creating an extension
- Added ‘Ignore Grants’ option in the schema diff tool
- Added ‘Ignore Tablespace’ option in the schema diff tool
- Added support for ALTER INDEX column statistics
- Added unlogged option while creating a sequence
- Added all like options while creating a table
- Added support for SYSTEM, CONCURRENTLY and TABLESPACE options in REINDEX
- Added WAL option to EXPLAIN ANALYZE command
- Added new/missing options to the VACUUM command
- Added SKIP_LOCKED and BUFFER_USAGE_LIMIT option to Analyze command
- Add support for TRUNCATE trigger in foreign table
- Ensure that Schema Diff comparison results should be displayed in the sorted order

Housekeeping:
- Generate software bill of materials as part of the package builds
- Added support for PostgreSQL and EPAS 16 to ensure it works without any errors

Fixed:
- Fix incorrect redirection URL after authentication by removing fixed value set to SCRIPT_NAME environment variable in pgAdmin4.wsgi file
- Allow changing the POOL_SIZE and MAX_OVERFLOW config values of the pgAdmin config DB connection pool
- Fix an issue where query tool on shared server is throwing error if the pgAdmin config DB is external
- Fix the query tool issue where raise Notice from func/proc or code blocks are no longer displayed live
- Fix the issue where query tool window turns blank if the user tries to generate a graph on the result
- Fix an issue where changing MFA_SUPPORTED_METHODS breaks the MFA validation
- Fix an issue where pgAdmin 7.5 fails to render table SQL with extension loaded index method
- Fix an issue where cycle syntax was not added in SQL when creating new sequence from UI
- Fix an issue where the SET directive is excluded from the function header in the schema diff tool
- Fix a query tool error ‘pgAdminThread’ object has no attribute ‘native_id’
- Ensure keyboard shortcut for query execution is disabled when query execution is in progress

更新時間：2023-07-27
更新細節：

What's new in this version:

New features:
- Added support to detach partitions using concurrently and finalize
- Added all supported index storage parameters while creating an index
- Added new/missing parameters to pg_dumpall (Backup Server)
- Added new/missing parameters to pg_dump (Backup Objects)
- Added new/missing parameters to pg_restore

Housekeeping:
- Remove Bootstrap and jQuery from authentication pages and rewrite them in ReactJS
- Enable cluster deployment with gp3 volume for AWS & BigAnimal cloud providers
- Clarify the LICENSE file to indicate that it is the PostgreSQL Licence
- Remove unsupported PostgreSQL versions from the container

Fixed:
- Fix an issue where queries can’t complete execution
- Fixed an issue where Import Export not working when using pgpassfile
- Fix an issue where queries longer than 1 minute get stuck - Container 7
- Fix an issue where queries get stuck with auto-completion enabled
- Fixed Query Tool/ PSQL tool tab title not getting updated on database rename
- Ensure user gets proper error if incorrect credentials are entered while authenticating AWS
- Fix an issue where the edit server fails in desktop mode if the server password is not stored
- Ensure that Backup, Restore, and Maintenance should work properly when pgpass file is used
- Fix the query tool auto-complete issue on the server reconnection
- Fix the query tool restore connection issue
- Fix the reconnecton issue if the PostgreSQL server is restarted from the backend
- Fix the connection and stability issues since v7, possibly related to background schema changes
- Fixed an issue where the query tool is unable to execute a query on Postgres 10 and below versions
- Fix the lost connection error in v7.4
- Fixed an issue where pgAdmin failed to setup role with hyphens in name
- Fixed an issue where filters are not working and query history shows empty queries
- Fix an issue where adding a sub-folder inside a folder is not working as expected in File Manager
- Fix an error ‘list’ object has no attribute ‘strip’ while attempting to populate auto-complete manually the first time
- Fixed an issue where ERD Tool can’t load the saved pgerd file from Shared Storage
- Fix an issue where inserting more than 10 rows does not work correctly in View Data; only parts end up in the table.

更新時間：2023-06-29
更新細節：

What's new in this version:

New features:
- Added support to drop databases using the ‘WITH (FORCE)’ option
- Add “[ NULLS [ NOT ] DISTINCT ]” option while creating an Index
- Added ‘OR REPLACE’ clause while creating trigger
- Added security_invoker option while creating a view

Housekeeping:
Fixed:
- Fix an issue where object explorer tree crashes occasionally
- Ensure that query tool shortcuts are working properly
- Add Password exec command and Expiration time to server export JSON and also allow them to import
- When opening pgAdmin the layout should be auto reset if it is corrupted. Reset layout menu should work if layout is corrupted while using pgAdmin
- Fix an issue where loading more rows indicator will not disappear if connection is lost
- Fix an encoding error when connecting through Pgbouncer
- Fix an issue where explain plan details is showing HTML escaped characters
- Fixed an issue where queries with temporary tables in the same transaction is not working
- Fixed an issue where preview images for themes were not loading
- Fix raise notice from func/proc or code blocks are no longer displayed live
- Fix an issue where PSQL is not working if the database name have quotes or double quotes
- Fix an issue where all the menus are enabled when pgAdmin is opened and no object is selected in the object explorer

更新時間：2023-05-17
更新細節：

更新時間：2023-05-17
更新細節：

What's new in this version:

- Add the FTS5 secure-delete command. This option causes all forensic traces to be removed from the FTS5 inverted index when content is deleted
- Enhance the JSON SQL functions to support JSON5 extensions
- The SQLITE_CONFIG_LOG and SQLITE_CONFIG_PCACHE_HDRSZ calls to sqlite3_config() are now allowed to occur after sqlite3_initialize()
- New sqlite3_db_config() options: SQLITE_DBCONFIG_STMT_SCANSTATUS and SQLITE_DBCONFIG_REVERSE_SCANORDER
- Query planner improvements
- Enable the "count-of-view" optimization by default
- Avoid computing unused columns in subqueries
- Improvements to the push-down optimization
- Enhancements to the CLI
- Add the --unsafe-testing command-line option. Without this option, some dot-commands (ex: ".testctrl") are now disabled because those commands that are intended for testing only and can cause malfunctions misused
- Allow commands ".log on" and ".log off", even in --safe mode
- "--" as a command-line argument means all subsequent arguments that start with "-" are interpreted as normal non-option argument
- Magic parameters ":inf" and ":nan" bind to floating point literals Infinity and NaN, respectively
- The --utf8 command-line option omits all translation to or from MBCS on the Windows console for interactive sessions, and sets the console code page for UTF-8 I/O during such sessions. The --utf8 option is a no-op on all other platforms
- Add the ability for application-defined SQL functions to have the same name as join keywords: CROSS, FULL, INNER, LEFT, NATURAL, OUTER, or RIGHT
- Enhancements to PRAGMA integrity_check
- Detect and raise an error when a NaN value is stored in a NOT NULL column
- Improved error message output identifies the root page of a b-tree when an error is found within a b-tree
- Allow the session extension to be configured to capture changes from tables that lack an explicit ROWID
- Added the subsecond modifier to the date and time functions
- Negative values passed into sqlite3_sleep() are henceforth interpreted as 0
- The maximum recursion depth for JSON arrays and objects is lowered from 2000 to 1000
- Extended the built-in printf() function so the comma option now works with floating-point conversions in addition to integer conversions
- Miscellaneous bug fixes and performance optimizations

更新時間：2023-05-17
更新細節：

What's new in this version:

- Block themes parsing shortcodes in user generated data; thanks to Liam Gladdy of WP Engine for reporting this issue
- A CSRF issue updating attachment thumbnails; reported by John Blackbourn of the WordPress security team
- A flaw allowing XSS via open embed auto discovery; reported independently by Jakub Żoczek of Securitum and during a third party security audit
- Bypassing of KSES sanitization in block attributes for low privileged users; discovered during a third party security audit.
- A path traversal issue via translation files; reported independently by Ramuel Gall and during a third party security audit.

更新時間：2023-03-30
更新細節：

What's new in this version:

Meet the reimagined Site Editor:
- Ready for you to dive in and explore: 6.2 is your invitation to discover what the next generation of WordPress—and block themes—can do
- Now out of beta, the Site Editor has an updated interface, giving you a new way to interact with your entire site. Explore full previews of your templates and template parts, then jump in and get to editing your site from wherever you choose.

Manage menus in more ways with the Navigation block:
- Add, remove, and reorder menu items faster—with a new sidebar experience that makes editing your site’s navigation easier.

Discover a smoother experience for the Block Inserter:
- A refreshed design gives you easier access to the content you need. Use the Media tab to quickly drag and drop content from your existing Media Library. Find patterns faster with a split view that lets you navigate categories and see previews all at once.

Find the controls you want when you need them:
- Your block settings sidebar is better organized with tabs for Settings and Styles. So the tools you need are easy to identify and access.

Build faster with headers and footers for block themes:
- Discover a new collection of header and footer patterns. Use them with any block theme as a quick, high-quality starting point for your site’s templates.

Explore Openverse media right from the Editor:
- Openverse’s library catalogs over 700 million+ free, openly licensed stock images and audio—and now it’s directly integrated into the WordPress experience through the Inserter.

Focus on writing with Distraction Free mode:
- For those times you want to be alone with your ideas. You can now hide all your panels and controls, leaving you free to bring your content to life.

Meet the new Style Book:
- Get a complete overview of how every block in your site’s library looks. All in one place, all at a glance, directly in the Site Editor.

Copy and paste styles:
- Perfect the design on one type of block, then copy and paste those styles to other blocks to get just the look you want

Custom CSS:
- Power up your site any way you wish with design tools and custom CSS for another level of control over your site’s look and feel for maximum creativity and artistry in your designs
- Other highlights in 6.2
- Sticky positioning: Choose to keep top-level group blocks fixed to the top of a page as visitors scroll
- Importing widgets: Options to import your favorite widgets from Classic themes to Block themes
- Local fonts in themes: Default WordPress themes offer better privacy with Google Fonts now included

更新時間：2023-03-29
更新細節：

What's new in this version:

Tweaks and bug fixes:
- If LANG parameter is set in setup, don’t show language dialog
- Trusted Domains: Allow trusting a domain regardless of HTTP basic auth credentials
- Allow playlists to be played from network
- Fix room name case sensitivity UI issue
- Remove redundant help button from dialogs
- macOS build: upgrade to Python 3.9 and PySide2 5.15.2
- Remove Encoding from .desktop files as it’s depreciated now and add Keywords entry to .desktop files.
- Console: Document setting offset in help
- Add deprecation notice for offset help
- Add Windows Store mpv.net path support
- Update PT-BR translation
- Fixed server argument max-username-length not working
- Fix disconnected monitor bug
- Print timestamp when pausing
- Add Windows Store mpv.net path support (issue #494 raised by @soredake and resolved by @Et0h)
- Correct persistence argument type
- Remove mpv fallback warning spam
- Fixed permanent rooms on Windows servers
- Fixes converting lines to array
- Made Hungarian chars usable from MPV: ő and ű
- Typo fixes
- Linux: Fix dark mode detection by moving to darkdetect v0.7.1
- macOS: bundle PySide6, create a universal2 app; and explicitly exclude tkinter
- Explicitly pass certifi as trustRoot for Twisted
- Don’t detect SMPlayer as mplayer2
- Fix localhost connection breaking mpv chat
- More verbose connection error messages
- Fix mpv quit message
- Log –debug as UTF-8 to fix charmap mapping
- Add/fix wildcard matching of trusted subdomains
- Restore server-side playlist on reconnect

更新時間：2023-03-22
更新細節：

What's new in this version:

Multiple fixes for reads past the end of memory buffers (NB: reads not writes) in the following circumstances:
- When processing a corrupt database file using the non-standard SQLITE_ENABLE_STAT4 compile-time option
- In the CLI when the sqlite3_error_offset() routine returns an out-of-range value (see change item 21 below)
- In the recovery extension
- In FTS3 when processing a corrupt database file
- Fix the sqlite3_error_offset() so that it does not return out-of-range values when reporting errors associated with generated columns
- Multiple fixes in the query query optimizer for problems that cause incorrect results for bizarre, fuzzer-generated queries
- Increase the size of the reference counter in the page cache object to 64 bits to ensure that the counter never overflows
- Fix a performance regression caused by a bug fix in patch release 3.41.1
- Fix a few incorrect assert() statements

更新時間：2023-03-22
更新細節：