SQLite 歷史版本列表
SQLite (32-bit)SQLite (64-bit)
更新時間：2022-07-22
更新細節：
What's new in this version:
- Fix a performance regression in the query planner associated with rearranging the order of FROM clause terms in the presences of a LEFT JOIN
- Apply fixes for CVE-2022-35737, Chromium bugs 1343348 and 1345947, forum post 3607259d3c, and other minor problems discovered by internal testing
更新時間：2022-07-14
更新細節：
What's new in this version:
Fixed:
- Fix an incorrect result from a query that uses a view that contains a compound SELECT in which only one arm contains a RIGHT JOIN and where the view is not the first FROM clause term of the query that contains the view. forum post 174afeae5734d42d
- Fix some harmless compiler warnings
- Fix a long-standing problem with ALTER TABLE RENAME that can only arise if the sqlite3_limit(SQLITE_LIMIT_SQL_LENGTH) is set to a very small value
- Fix a long-standing problem in FTS3 that can only arise when compiled with the SQLITE_ENABLE_FTS3_PARENTHESIS compile-time option
- Fix the build so that is works when the SQLITE_DEBUG and SQLITE_OMIT_WINDOWFUNC compile-time options are both provided at the same time
- Fix the initial-prefix optimization for the REGEXP extension so that it works correctly even if the prefix contains characters that require a 3-byte UTF8 encoding
- Enhance the sqlite_stmt virtual table so that it buffers all of its output
更新時間：2022-07-13
更新細節：
What's new in this version:
The following core tickets from Trac are fixed:
- Build/Test Tools: Pass GitHub Actions environment variables to the Docker container
- Fix block-templates theme support not present in /themes REST API endpoint
- About page: Replace video thumbnail image
- Resolve WP_Term_Query cache problem
- Fix caching issues in WP_Term_Query class
- Remove meetup from oembed allow list
- Register Comments Query Loop from metadata to enable title and description translation
- Themes: Revert the change of theme preview width on Add Themes screen
- Block Patterns: Update the value used for keywords
- Bundled Themes: Revert the Twenty Ten theme version to 3.6
The following block editor issues from GitHub are fixed:
- Lower the priority of the gallery gap css so it loads after the block layout css
- Add utility classnames back to blocks that have layout attributes specified
- Block Library: Fix JS Error in Avatar Block
- Media & Text: Remove font size declaration from template
- Comment Author and Date blocks: aligned editor markup with the frontend
- Handle no variation case in the block transform menu
- Fix/block meta icon prop errors
- Prevent opening the links in editor for Latest Posts
- Navigation block “Open on click”: Inherit font style and font weight
- Comments Block: fixed issue with custom font sizes and links color
- Reuse code of the editor placeholder across Post Comments and Post Comments Form
- Improve the logic for warnings for Post Comments Form placeholder
- Post Comments Form: Add button that enables commenting to warning
- Ensure only the main query is modified when resolving template for new posts
- Strip whitespaces in render_block_core_cover before injecting the featured image
- Post Template: Ensure layout classnames are not attached to inner li elements
- Pasting: Fix performance regression due to removeWindowsFragments
- Post Comments Form: Fix warning i18n
更新時間：2022-07-07
更新細節：
What's new in this version:
Fixed
- Fixed an issue where DataList bounds had part of the item text cut off vertically
Other Changes:
- Updated Chromium to 102.0.5005.148
更新時間：2022-07-07
更新細節：
What's new in this version:
Clip Time Remaining Panel:
- One of the most requested features on the forum is to show the clip time remaining much bigger in the interface. So we have created a dedicated panel for the clip time remaining where you can decide what playing clips to see the time of and you can show the current system time. You can make this panel very big and the text will scale along with it so that the entire FOH can read it from a distance ????. This is super handy for tightly scripted shows where everybody needs to get their timing right.
SMPTE Input Panel:
- The SMPTE inputs on the toolbar in Arena were a bit small and not very readable from a distance. We have now moved the SMPTE inputs from the toolbar to a panel so you can make it a big as you like, just like the clip time panel.
Slice Fader:
- You can now fade the opacity of each slice individually in the Slice Transform effect. Map the slice opacity to your MIDI controller or even animate it to the beat.
Slice Scaling:
- In the Slice Transform effect you can now also set a different scaling for each slice, so you're not limited to Fit, Fill, Stretch or Mask for all your slices anymore. There is also a new Inverted Mask mode to actually show the pixels outside a slice and not inside.
Multiple Wire Slice Inputs:
- You can now create multiple slice inputs for your Wire patches. This is nice for creating more complex Wire slice effects like applying different effects to groups of slices.
+ buttons on all parameters:
- Making small adjustments to any parameter is now much quicker because every parameter has - + buttons next to the slider. Handy!
Shift Click to Fold/Unfold All:
- Hold down Shift on your keyboard and then click on the fold arrow of an effect and it will fold (or unfold) all effects below it. This also works on the folding arrow for slices in the Slice Transform effect.
Auto Node Layout Improvements:
- The auto node layout feature that we introduced in beta in the previous version is now improved further and out of beta. This has become an essential tool for us to maintain our sanity in bigger patches.
Find Node:
- With the Find node you can find the position of the first or last occurrence of a substring in a string. Finding a needle in a haystack is actually very easy now.
更新時間：2022-07-01
更新細節：
What's new in this version:
Fixed:
- Fixed an issue where Windows Control Overlay buttons did not respect maximizable/minimizable/closable states of a BrowserWindow
- Fixed missing Sec-CH-UA headers and empty navigator.userAgentData
Other Changes:
- Security: backported fix for CVE-2022-2162
- Updated Chromium to 102.0.5005.134
更新時間：2022-06-26
更新細節：
What's new in this version:
- Add (long overdue) support for RIGHT and FULL OUTER JOIN
- Add new binary comparison operators IS NOT DISTINCT FROM and IS DISTINCT FROM that are equivalent to IS and IS NOT, respective, for compatibility with PostgreSQL and SQL standards
- Add a new return code (value "3") from the sqlite3_vtab_distinct() interface that indicates a query that has both DISTINCT and ORDER BY clauses
- Added the sqlite3_db_name() interface
- The unix os interface resolves all symbolic links in database filenames to create a canonical name for the database before the file is opened
- Defer materializing views until the materialization is actually needed, thus avoiding unnecessary work if the materialization turns out to never be used
- The HAVING clause of a SELECT statement is now allowed on any aggregate query, even queries that do not have a GROUP BY clause
- Many microoptimizations collectively reduce CPU cycles by about 2.3%
更新時間：2022-06-24
更新細節：
What's new in this version:
- Pioneer TCNet is dropped changing computer's networking settings, can crash
- Pioneer Clip overlap offset triggering not working perfectly
- Remove Localhost as Arena TCNet network interface on windows
- Wire crashes loading file with UTF-8 name
更新時間：2022-06-11
更新細節：
更新時間：2022-06-07
更新細節：
What's new in this version:
Pioneer DJ Sync:
- When using a Pioneer DJ mixer & players, you can automatically sync the audio played by the DJ to a video in Resolume Arena. Arena will keep an eye on what track is loaded in the player; when it sees a linked track, it will play the video for you. This way, your show will be totally automagically in sync. To use this integration you need the free Pioneer DJ Bridge app from the Pioneer DJ website.
Link parameters to CrossFader Position:
- When animating parameters you can now choose the Crossfader Phase as the driving force for your animation. Checkout this video to see it in action.
3 New Effects:
- There are now 3 new effects in Arena & Avenue. Slice Delay, WarpSpeed & SearchLight. These new effects are created, and thus, editable in Wire so feel free to improve them to your needs.
Auto-layout for Nodes (beta):
- Let's be honest, bigger wire patches often look like a big bowl of spaghetti meatballs. With wires criss-crossing all over the place, nodes all over the place it's a mess. But with the auto-layout you can now untangle that mess with the press of a button: CNTRL+L. It tries to minimise cord crossing and nodes overlapping cords as much as possible to maximise readability of the patch. You can apply the auto-layout to only a selection of nodes or of course on the entire patch. Programming this auto-layout was a lot of fun but also very finicky because adding a new rule to improve certain patches actually makes other patches look worse. This is why we're introducing this as a beta feature. Please try it out and let us know how you think it can be improved on your specific patches. If you do not like the result you just press undo and you're back to your bowl of spaghetti.
Avenue & Arena Fix List:
- DXV3 is missing in ARM After effects Export
- Double clicking a Composition in Finder, Resolume opens last composition on startup
- Option to disable open composition confirm dialog via the command line not working on macOS
- Crash moving Composition monitor out of main window with this ui layout
- Composition NDI Syphon and Spout output can get initialised with wrong resolution
- Preferences option to save snapshot images to different directory than the recordings
- Moving default transform in the effect list creates a copy of the transform
- Clip transport folding no working in the API Example
- Saving presets takes progressively longer with more presets
- Right clicking spout clip on mac causes crash
- Missing FFGL mixers should show a red Missing Mixer message in the layer blend selector
- Add API endpoints for selected layer, group, column and clip
- Some custom OSC shortcuts rewrite the address after you typed them
- Audio tracks can get 5 secs as duration when you drop them into empty clips slots, in a deck which was loaded
Wire Fix List:
- Double clicking on compiled Wire-patch does not copy it to patches-folder
- Crash pasting bunch of nodes with Delay after a bunch of nodes with Delay
- Pack in texture mode refuses float as last input, keeps showing red disconnecting wire
- Input order isn't stored in Copy (for sharing)
- Contextual menu with show in Finder no worky for compiled Wire patches from shared folder
- Merge in texture mode crops textures to patch size
- Add snapping to comment node
- Slice in node gets set to 5 instances on re-open
- Shift node should be in the collection tab instead of logic tab
- Gradient disconnects Bypass when changing Type
- Thumbnail Snapshot should work with Texture Out
- Float fields accept input with two dots
- Wire hangs on exit, with Slice in node, uses lots of memory
- Crash replacing Texture in node with Hub
- Gradient node doesn't have the precision you'd expect
- Color to Texture to Crop crashes Wire