Skip to content

feat: add smallserial metadata#899

Merged
davecramer merged 1 commit intopgjdbc:masterfrom
jorsol:smallserial-metadata
Sep 30, 2020
Merged

feat: add smallserial metadata#899
davecramer merged 1 commit intopgjdbc:masterfrom
jorsol:smallserial-metadata

Conversation

@jorsol
Copy link
Copy Markdown
Member

@jorsol jorsol commented Aug 2, 2017

Add smallserial metadata info.

@codecov-io
Copy link
Copy Markdown

codecov-io commented Aug 2, 2017

Codecov Report

Merging #899 into master will increase coverage by <.01%.
The diff coverage is 60%.

@@             Coverage Diff              @@
##             master     #899      +/-   ##
============================================
+ Coverage     68.67%   68.67%   +<.01%     
- Complexity     3891     3893       +2     
============================================
  Files           179      179              
  Lines         16391    16401      +10     
  Branches       2669     2673       +4     
============================================
+ Hits          11256    11263       +7     
  Misses         3887     3887              
- Partials       1248     1251       +3

@davecramer
Copy link
Copy Markdown
Member

I'm curious does anyone actually use smallserial ? We've never had a request for this.

@jorsol
Copy link
Copy Markdown
Member Author

jorsol commented Aug 2, 2017

I use it 😝, this is essentially metadata which most people don't use, its added for completeness.

@vlsi
Copy link
Copy Markdown
Member

vlsi commented Aug 3, 2017

I wonder if we should delay this till 42.2.0 due to "new feature" nature of the PR.

@jorsol
Copy link
Copy Markdown
Member Author

jorsol commented Aug 3, 2017

It's not such a big feature, but it's fine to delay this till 42.2.0, it's not especially important as noted by Dave.

@jorsol
Copy link
Copy Markdown
Member Author

jorsol commented Sep 22, 2017

Should I add a check of the version of Postgres? smallserial was introduced in Pg9.2 so a check in Pg9.1 for a smallint column which has a sequence can be potentially reported as smallserial.

@vlsi
Copy link
Copy Markdown
Member

vlsi commented Sep 25, 2017

+1

@jorsol jorsol force-pushed the smallserial-metadata branch from 1325c4c to 46d13c1 Compare September 25, 2017 15:46
@jorsol
Copy link
Copy Markdown
Member Author

jorsol commented Sep 25, 2017

Ready the check for ServerVersion.v9_2

@jorsol jorsol force-pushed the smallserial-metadata branch from 46d13c1 to d6842ad Compare October 9, 2017 14:53
@jorsol
Copy link
Copy Markdown
Member Author

jorsol commented Oct 9, 2017

This feature is ready for 42.2.0, comments are welcome.

@jorsol jorsol force-pushed the smallserial-metadata branch from d6842ad to 2db1ef8 Compare December 21, 2017 17:42
@jorsol
Copy link
Copy Markdown
Member Author

jorsol commented Dec 21, 2017

Rebased and ready for 42.2.0

@jorsol jorsol force-pushed the smallserial-metadata branch 3 times, most recently from 2c28cb4 to 7cdfe43 Compare January 23, 2018 04:16
@jorsol
Copy link
Copy Markdown
Member Author

jorsol commented Jan 23, 2018

Should this be included in 42.2.1?

@vlsi vlsi modified the milestones: 42.2.1, 42.2.2 Jan 24, 2018
@vlsi vlsi modified the milestones: 42.2.2, 42.3.0 Mar 10, 2018
@jorsol jorsol force-pushed the smallserial-metadata branch from 7cdfe43 to 779636c Compare May 30, 2018 01:41
@jorsol jorsol force-pushed the smallserial-metadata branch from 779636c to 9882612 Compare December 5, 2018 12:43
@vlsi vlsi force-pushed the master branch 2 times, most recently from c25d807 to adcb194 Compare March 7, 2020 20:41
@jorsol jorsol force-pushed the smallserial-metadata branch 2 times, most recently from c1e7cb3 to dd044ce Compare September 29, 2020 14:14
@jorsol
Copy link
Copy Markdown
Member Author

jorsol commented Sep 29, 2020

Resurrecting this for completeness with #1899

smallserial was introduced in PG 9.2+ so return smallserial only of those versions.

PostgreSQL 9.2 adds a SMALLSERIAL data type, this reports the correct metadata information when a column is a smallserial (int2 with sequence), similar to how a serial or bigserial data types are reported.
@jorsol jorsol force-pushed the smallserial-metadata branch from dd044ce to dec8db1 Compare September 29, 2020 14:56
@codecov-commenter
Copy link
Copy Markdown

codecov-commenter commented Sep 29, 2020

Codecov Report

Merging #899 into master will increase coverage by 0.15%.
The diff coverage is 70.00%.

@@             Coverage Diff              @@
##             master     #899      +/-   ##
============================================
+ Coverage     69.02%   69.18%   +0.15%     
- Complexity     4198     4211      +13     
============================================
  Files           197      197              
  Lines         17998    18004       +6     
  Branches       2917     2919       +2     
============================================
+ Hits          12424    12456      +32     
+ Misses         4223     4202      -21     
+ Partials       1351     1346       -5     

@davecramer
Copy link
Copy Markdown
Member

ah, thanks good catch. I'll push shortly

@davecramer davecramer merged commit 2c02d4e into pgjdbc:master Sep 30, 2020
davecramer pushed a commit to davecramer/pgjdbc that referenced this pull request Oct 1, 2020
PostgreSQL 9.2 adds a SMALLSERIAL data type, this reports the correct metadata information when a column is a smallserial (int2 with sequence), similar to how a serial or bigserial data types are reported.
davecramer pushed a commit to davecramer/pgjdbc that referenced this pull request Oct 2, 2020
PostgreSQL 9.2 adds a SMALLSERIAL data type, this reports the correct metadata information when a column is a smallserial (int2 with sequence), similar to how a serial or bigserial data types are reported.
davecramer added a commit that referenced this pull request Oct 6, 2020
* fix: avoid removal type annotations on "this" so the source archive is buildable

"this" type annotations are Java 8+, so we no longer need to remove them.

* fix: PgTokenizer was ignoring last empty token (#1882)

* fix: PgTokenizer was ignoring last empty token fixes #1881

* fix: handle smallserial correctly fixes #1897 (#1899)

* feat: add smallserial metadata (#899)

PostgreSQL 9.2 adds a SMALLSERIAL data type, this reports the correct metadata information when a column is a smallserial (int2 with sequence), similar to how a serial or bigserial data types are reported.

* fix:remove osgi from karaf fixes Issue #1891 (#1902)

* Change default of gssEncMode to ALLOW. PostgreSQL can deal with PREFER but there are cloud providers that did not implement the protocol properly. Using PREFER seems to cause more problems than it solves

Co-authored-by: Vladimir Sitnikov <[email protected]>
Co-authored-by: Jorge Solorzano <[email protected]>
davecramer added a commit that referenced this pull request Oct 8, 2020
* fix: avoid removal type annotations on "this" so the source archive is buildable

"this" type annotations are Java 8+, so we no longer need to remove them.

* fix: PgTokenizer was ignoring last empty token (#1882)


* feat: add smallserial metadata (#899)

PostgreSQL 9.2 adds a SMALLSERIAL data type, this reports the correct metadata information when a column is a smallserial (int2 with sequence), similar to how a serial or bigserial data types are reported.

* fix:remove osgi from karaf fixes Issue #1891 (#1902)

* Change default of gssEncMode to ALLOW. PostgreSQL can deal with PREFER but there are cloud providers that did not implement the protocol properly

* update CHANGELOG and posts for 42.2.17

* fix up CHANGELOG

* Update README, gssEncMode for release

Co-authored-by: Vladimir Sitnikov <[email protected]>
Co-authored-by: Jorge Solorzano <[email protected]>
davecramer added a commit to davecramer/pgjdbc that referenced this pull request Nov 16, 2020
* fix: avoid removal type annotations on "this" so the source archive is buildable

"this" type annotations are Java 8+, so we no longer need to remove them.

* fix: PgTokenizer was ignoring last empty token (pgjdbc#1882)

* feat: add smallserial metadata (pgjdbc#899)

PostgreSQL 9.2 adds a SMALLSERIAL data type, this reports the correct metadata information when a column is a smallserial (int2 with sequence), similar to how a serial or bigserial data types are reported.

* fix:remove osgi from karaf fixes Issue pgjdbc#1891 (pgjdbc#1902)

* Change default of gssEncMode to ALLOW. PostgreSQL can deal with PREFER but there are cloud providers that did not implement the protocol properly

* update CHANGELOG and posts for 42.2.17

* fix up CHANGELOG

* Update README, gssEncMode for release

Co-authored-by: Vladimir Sitnikov <[email protected]>
Co-authored-by: Jorge Solorzano <[email protected]>
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment

Projects

None yet

Development

Successfully merging this pull request may close these issues.

5 participants