-
Notifications
You must be signed in to change notification settings - Fork 0
/
gixsql-v1018-is-here.html
18 lines (17 loc) · 15.7 KB
/
gixsql-v1018-is-here.html
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
<!DOCTYPE html><html lang="en-us"><head><meta charset="utf-8"><meta http-equiv="X-UA-Compatible" content="IE=edge"><meta name="viewport" content="width=device-width,initial-scale=1"><title>GixSQL v1.0.18 is here - mridoni's development blog</title><meta name="description" content="This is a maintenance release for GixSQL, that fixes a few issues and adds some new features, notably two new database drivers (Oracle and SQLite). Check the documentation for generic and driver-specific usage notes. Please note: there have been several breaking changes both in the runtime libraries and in the preprocessing engine, so source code compiled with older versions MUST be preprocessed again and recompiled. Also, be sure you are using the updated runtime libraries (i.e libgixsql/libgixsql-*)."><meta name="generator" content="Publii Open-Source CMS for Static Site"><link rel="canonical" href="https://mridoni.github.io/gixsql-v1018-is-here.html"><link rel="alternate" type="application/atom+xml" href="https://mridoni.github.io/feed.xml"><link rel="alternate" type="application/json" href="https://mridoni.github.io/feed.json"><meta property="og:title" content="GixSQL v1.0.18 is here"><meta property="og:site_name" content="mridoni's development blog"><meta property="og:description" content="This is a maintenance release for GixSQL, that fixes a few issues and adds some new features, notably two new database drivers (Oracle and SQLite). Check the documentation for generic and driver-specific usage notes. Please note: there have been several breaking changes both in the runtime libraries and in the preprocessing engine, so source code compiled with older versions MUST be preprocessed again and recompiled. Also, be sure you are using the updated runtime libraries (i.e libgixsql/libgixsql-*)."><meta property="og:url" content="https://mridoni.github.io/gixsql-v1018-is-here.html"><meta property="og:type" content="article"><style>:root{--body-font:-apple-system,BlinkMacSystemFont,"Segoe UI",Roboto,Oxygen,Ubuntu,Cantarell,"Fira Sans","Droid Sans","Helvetica Neue",Arial,sans-serif,"Apple Color Emoji","Segoe UI Emoji","Segoe UI Symbol";--heading-font:-apple-system,BlinkMacSystemFont,"Segoe UI",Roboto,Oxygen,Ubuntu,Cantarell,"Fira Sans","Droid Sans","Helvetica Neue",Arial,sans-serif,"Apple Color Emoji","Segoe UI Emoji","Segoe UI Symbol";--logo-font:-apple-system,BlinkMacSystemFont,"Segoe UI",Roboto,Oxygen,Ubuntu,Cantarell,"Fira Sans","Droid Sans","Helvetica Neue",Arial,sans-serif,"Apple Color Emoji","Segoe UI Emoji","Segoe UI Symbol";--menu-font:-apple-system,BlinkMacSystemFont,"Segoe UI",Roboto,Oxygen,Ubuntu,Cantarell,"Fira Sans","Droid Sans","Helvetica Neue",Arial,sans-serif,"Apple Color Emoji","Segoe UI Emoji","Segoe UI Symbol"}</style><link rel="stylesheet" href="https://mridoni.github.io/assets/css/style.css?v=c65e4b699f773de4045874d9f49bbe9c"><script type="application/ld+json">{"@context":"http://schema.org","@type":"Article","mainEntityOfPage":{"@type":"WebPage","@id":"https://mridoni.github.io/gixsql-v1018-is-here.html"},"headline":"GixSQL v1.0.18 is here","datePublished":"2022-08-23T15:53","dateModified":"2022-08-23T15:53","description":"This is a maintenance release for GixSQL, that fixes a few issues and adds some new features, notably two new database drivers (Oracle and SQLite). Check the documentation for generic and driver-specific usage notes. Please note: there have been several breaking changes both in the runtime libraries and in the preprocessing engine, so source code compiled with older versions MUST be preprocessed again and recompiled. Also, be sure you are using the updated runtime libraries (i.e libgixsql/libgixsql-*).","author":{"@type":"Person","name":"Marco Ridoni","url":"https://mridoni.github.io/authors/marco-ridoni/"},"publisher":{"@type":"Organization","name":"Marco Ridoni"}}</script></head><body><div class="site-container"><header class="top" id="js-header"><a class="logo" href="https://mridoni.github.io/">mridoni's development blog</a></header><main><article class="post"><div class="hero"><header class="hero__content"><div class="wrapper"><div class="post__meta"><time datetime="2022-08-23T15:53">August 23, 2022</time></div><h1>GixSQL v1.0.18 is here</h1></div></header></div><div class="wrapper post__entry"><p>This is a maintenance release for GixSQL, that fixes a few issues and adds some new features, notably two new database drivers (Oracle and SQLite). Check the <a href="https://github.com/mridoni/gixsql/blob/main/README.md">documentation</a> for generic and driver-specific usage notes.</p><p><strong>Please note: there have been several breaking changes both in the runtime libraries and in the preprocessing engine, so source code compiled with older versions MUST be preprocessed again and recompiled. Also, be sure you are using the updated runtime libraries (i.e libgixsql/libgixsql-*).</strong></p><p>Binary packages available (as usual on the <a href="https://github.com/mridoni/gixsql/releases/tag/v1.0.18" target="_blank" rel="noopener noreferrer">release page</a> on GitHub):</p><ul><li>Windows x64 (MSVC + MinGW)</li><li>Windows x64 (MinGW only)</li><li>Windows x86 (MSVC + MinGW)</li><li>Windows x86 (MinGW only)</li><li>Windows x86 "portable"</li><li>Linux x64 (Ubuntu 20.04)</li></ul><p>There is also a autoconf-enabled source package, to make building on Linux and MinGW easier.</p><p>A summary of new features and fixes:</p><ul><li>Added new Oracle driver, based on ODPI</li><li>Added new SQLite driver</li><li>All the drivers have been updated and now implement the complete set of supported features</li><li>Solution for "PG: issue with prepared statements" (<a class="issue-link js-issue-link" data-error-text="Failed to load title" data-id="1322005045" data-permission-text="Title is private" data-url="https://github.com/mridoni/gixsql/issues/99" data-hovercard-type="issue" data-hovercard-url="/mridoni/gixsql/issues/99/hovercard" href="https://github.com/mridoni/gixsql/issues/99">#99</a>)</li><li>Solution for "PCursors cannot be re-opened after close" (<a class="issue-link js-issue-link" data-error-text="Failed to load title" data-id="1321910348" data-permission-text="Title is private" data-url="https://github.com/mridoni/gixsql/issues/98" data-hovercard-type="issue" data-hovercard-url="/mridoni/gixsql/issues/98/hovercard" href="https://github.com/mridoni/gixsql/issues/98">#98</a>)</li><li>Solution for "libgixpp: setStatus is called for errors without DBI parm passed - sets SQLERRM" (<a class="issue-link js-issue-link" data-error-text="Failed to load title" data-id="1317934850" data-permission-text="Title is private" data-url="https://github.com/mridoni/gixsql/issues/94" data-hovercard-type="issue" data-hovercard-url="/mridoni/gixsql/issues/94/hovercard" href="https://github.com/mridoni/gixsql/issues/94">#94</a>)</li><li>Solution for "error handling (especially for 07001)" (<a class="issue-link js-issue-link" data-error-text="Failed to load title" data-id="1314985996" data-permission-text="Title is private" data-url="https://github.com/mridoni/gixsql/issues/92" data-hovercard-type="issue" data-hovercard-url="/mridoni/gixsql/issues/92/hovercard" href="https://github.com/mridoni/gixsql/issues/92">#92</a>)</li><li>Solution for "show-stopper bug in pgsql_prepare" (<a class="issue-link js-issue-link" data-error-text="Failed to load title" data-id="1314568084" data-permission-text="Title is private" data-url="https://github.com/mridoni/gixsql/issues/91" data-hovercard-type="issue" data-hovercard-url="/mridoni/gixsql/issues/91/hovercard" href="https://github.com/mridoni/gixsql/issues/91">#91</a>)</li><li>Solution for "PREPARE does not work with VARLENGTH groups (ocesql compat)" (<a class="issue-link js-issue-link" data-error-text="Failed to load title" data-id="1289253715" data-permission-text="Title is private" data-url="https://github.com/mridoni/gixsql/issues/79" data-hovercard-type="issue" data-hovercard-url="/mridoni/gixsql/issues/79/hovercard" href="https://github.com/mridoni/gixsql/issues/79">#79</a>)</li><li>Partial solution for "PREPARE does not work with VARLENGTH groups (ocesql compat)" (<a class="issue-link js-issue-link" data-error-text="Failed to load title" data-id="1285584726" data-permission-text="Title is private" data-url="https://github.com/mridoni/gixsql/issues/68" data-hovercard-type="issue" data-hovercard-url="/mridoni/gixsql/issues/68/hovercard" href="https://github.com/mridoni/gixsql/issues/68">#68</a>)</li><li>Solution for "The PostgreSQL driver needs START TRANSACTION before using cursors" (<a class="issue-link js-issue-link" data-error-text="Failed to load title" data-id="1205386006" data-permission-text="Title is private" data-url="https://github.com/mridoni/gixsql/issues/14" data-hovercard-type="issue" data-hovercard-url="/mridoni/gixsql/issues/14/hovercard" href="https://github.com/mridoni/gixsql/issues/14">#14</a>)</li><li>Solution for "FR: support EXEC SQL VAR" (<a class="issue-link js-issue-link" data-error-text="Failed to load title" data-id="1205396026" data-permission-text="Title is private" data-url="https://github.com/mridoni/gixsql/issues/21" data-hovercard-type="issue" data-hovercard-url="/mridoni/gixsql/issues/21/hovercard" href="https://github.com/mridoni/gixsql/issues/21">#21</a>)</li><li>Fixed a bug in "problems with "codegen / logic issue for "GIXSQLCursorDeclareParams" (<a class="issue-link js-issue-link" data-error-text="Failed to load title" data-id="1295941001" data-permission-text="Title is private" data-url="https://github.com/mridoni/gixsql/issues/88" data-hovercard-type="issue" data-hovercard-url="/mridoni/gixsql/issues/88/hovercard" href="https://github.com/mridoni/gixsql/issues/88">#88</a>)</li><li>Solution for "FR: allow mapping of "NoRecCode"' (<a class="issue-link js-issue-link" data-error-text="Failed to load title" data-id="1317993838" data-permission-text="Title is private" data-url="https://github.com/mridoni/gixsql/issues/95" data-hovercard-type="issue" data-hovercard-url="/mridoni/gixsql/issues/95/hovercard" href="https://github.com/mridoni/gixsql/issues/95">#95</a>) - added --no-rec-code parameter to gixpp</li><li>Tokens in the parser have been labeled to improve diagnostics (pulled PR <a class="issue-link js-issue-link" data-error-text="Failed to load title" data-id="1321364767" data-permission-text="Title is private" data-url="https://github.com/mridoni/gixsql/issues/96" data-hovercard-type="pull_request" data-hovercard-url="/mridoni/gixsql/pull/96/hovercard" href="https://github.com/mridoni/gixsql/pull/96">#96</a> by <a class="user-mention notranslate" data-hovercard-type="user" data-hovercard-url="/users/GitMensch/hovercard" data-octo-click="hovercard-link-click" data-octo-dimensions="link_type:self" href="https://github.com/GitMensch">@GitMensch</a>)</li><li>Fixed COMP-3 handling in drivers other than PostgreSQL</li><li>Rewrote the test suite (still MSTest-based) to dynamically generate a matrix of test to be run on the various platforms/database drivers</li><li>Added options for parameter generation in gixpp (-a was removed)</li><li>Added new <code>GIXSQL_FIXUP_PARAMS</code> option for runtime, to automatically convert parameter format in prepared statements</li><li>"Native" cursors are now the default for the PostgreSQL driver</li><li>"Smart" cursor initialization is now the default for all cursors, including those declared in WORKING-STORAGE (<code>-L</code> was removed from gixpp), should fix <a class="issue-link js-issue-link" data-error-text="Failed to load title" data-id="1341569847" data-permission-text="Title is private" data-url="https://github.com/mridoni/gixsql/issues/101" data-hovercard-type="issue" data-hovercard-url="/mridoni/gixsql/issues/101/hovercard" href="https://github.com/mridoni/gixsql/issues/101">#101</a></li><li>Removed dynamic cursor emulation from the ODBC driver when using PostgreSQL</li></ul></div><footer class="wrapper post__footer"><p class="post__last-updated">This article was updated on August 23, 2022</p><div class="post__share"><a href="https://www.facebook.com/sharer/sharer.php?u=https%3A%2F%2Fmridoni.github.io%2Fgixsql-v1018-is-here.html" class="js-share facebook" rel="nofollow noopener noreferrer"><svg class="icon" aria-hidden="true" focusable="false"><use xlink:href="https://mridoni.github.io/assets/svg/svg-map.svg#facebook"/></svg> <span>Facebook</span> </a><a href="https://twitter.com/share?url=https%3A%2F%2Fmridoni.github.io%2Fgixsql-v1018-is-here.html&via=%40quasicomese&text=GixSQL%20v1.0.18%20is%20here" class="js-share twitter" rel="nofollow noopener noreferrer"><svg class="icon" aria-hidden="true" focusable="false"><use xlink:href="https://mridoni.github.io/assets/svg/svg-map.svg#twitter"/></svg> <span>Twitter</span> </a><a href="https://www.linkedin.com/sharing/share-offsite/?url=https%3A%2F%2Fmridoni.github.io%2Fgixsql-v1018-is-here.html" class="js-share linkedin" rel="nofollow noopener noreferrer"><svg class="icon" aria-hidden="true" focusable="false"><use xlink:href="https://mridoni.github.io/assets/svg/svg-map.svg#linkedin"/></svg> <span>LinkedIn</span></a></div></footer></article><nav class="post__nav"><div class="post__nav-inner"><div class="post__nav-prev"><svg width="1.041em" height="0.416em" aria-hidden="true"><use xlink:href="https://mridoni.github.io/assets/svg/svg-map.svg#arrow-prev"/></svg> <a href="https://mridoni.github.io/gixsql-1018dev2-isout.html" class="invert post__nav-link" rel="prev"><span>Previous</span> GixSQL 1.0.18dev2 isout</a></div><div class="post__nav-next"><a href="https://mridoni.github.io/gix-ide-v1018.html" class="invert post__nav-link" rel="next"><span>Next</span> Gix-IDE v1.0.18 </a><svg width="1.041em" height="0.416em" aria-hidden="true"><use xlink:href="https://mridoni.github.io/assets/svg/svg-map.svg#arrow-next"/></svg></div></div></nav><div class="post__related related"><div class="wrapper"><h2 class="h5 related__title">You should also read:</h2><article class="related__item"><div class="feed__meta"><time datetime="2022-04-15T10:21" class="feed__date">April 15, 2022</time></div><h3 class="h1"><a href="https://mridoni.github.io/gix-ide-and-gixsql-1013-are-available.html" class="invert">Gix-IDE and GixSQL 1.0.13 are available</a></h3></article><article class="related__item"><div class="feed__meta"><time datetime="2022-04-07T16:07" class="feed__date">April 7, 2022</time></div><h3 class="h1"><a href="https://mridoni.github.io/gixsql-and-gix-ide-v1012-are-available.html" class="invert">GixSQL and Gix-IDE v1.0.12 are available</a></h3></article><article class="related__item"><div class="feed__meta"><time datetime="2022-03-22T11:14" class="feed__date">March 22, 2022</time></div><h3 class="h1"><a href="https://mridoni.github.io/gix-ide-and-gixsql-1011-available-now.html" class="invert">Gix-IDE and GixSQL 1.0.11 available now</a></h3></article></div></div></main><footer class="footer"><div class="footer__copyright"><p>Powered by Publii</p></div><button class="footer__bttop js-footer__bttop" aria-label="Back to top"><svg><title>Back to top</title><use xlink:href="https://mridoni.github.io/assets/svg/svg-map.svg#toparrow"/></svg></button></footer></div><script>window.publiiThemeMenuConfig = {
mobileMenuMode: 'sidebar',
animationSpeed: 300,
submenuWidth: 'auto',
doubleClickTime: 500,
mobileMenuExpandableSubmenus: true,
relatedContainerForOverlayMenuSelector: '.top',
};</script><script defer="defer" src="https://mridoni.github.io/assets/js/scripts.min.js?v=48e9576b9741cf2a93ab25c5689c9f5d"></script><script>var images = document.querySelectorAll('img[loading]');
for (var i = 0; i < images.length; i++) {
if (images[i].complete) {
images[i].classList.add('is-loaded');
} else {
images[i].addEventListener('load', function () {
this.classList.add('is-loaded');
}, false);
}
}</script></body></html>