Changelog

0.8.0 (2022-09-25)

Features

enable SSL connections (#358) (c856ce2)
JSONB support (#328) (0ec6c7c)
make guess types configurable (#347) (87415dd)
support OAuth2 token authentication (#360) (0cedf15)

Bug Fixes

cancel requests were ignored (#356) (2b5add0)

Documentation

document max 50 parameters limit (#355) (7e2fc78)

0.7.0 (2022-09-10)

Features

add COPY settings to session state (#338) (31a2faf)
add ddl_transaction_mode and replace_pg_catalog_tables settings (#334) (aed2b4d)
allow setting the server version number in startup msg (#336) (808217e)
auto-convert explicit DDL transactions to batches (#292) (612fc44)
execute INFORMATION_SCHEMA in single-use transaction (#276) (fa7fe13)
ignore named primary keys with correct name (#286) (6d90366)
manage session state (#305) (9e4d391)
PREPARE statement support (#332) (980e764)
replace pg_catalog tables with common table expressions (#331) (4b01399)
select current_schema (#273) (b80069d)
set default PG version reported by PGAdapter to 14.1 (#303) (4dcceb1)
support (ignore) show and set search_path (#288) (93d8c14)
support pg_settings table as CTE (#307) (a5e5634)

Bug Fixes

( and ) are allowed at the end of keywords (#312) (f3ebfb5)
allow 'T' in timestamp values in COPY operations (#319) (a239328)
backslash is not a valid quote escape (#317) (dc32af4)
catch unknown types in RowDescription (#343) (6562014)
correctly detect end of unquoted identifier (#301) (e31fd02)
hint for large copy operations missed 'spanner.' namespace (#304) (a5e8afc)
remove Spanner error prefixes (#306) (819a653)
translate queries for all table types in JDBC metadata (#295) (4cb43e6)
use a longer timeout for Commit for COPY (#308) (0f4dea7)
use main thread for CopyDataReceiver (#345) (687c952)

Performance Improvements

treat 'flush and sync' as 'sync' (#285) (7fc5d51)

Dependencies

bump google-cloud-spanner from 6.27.0 to 6.28.0 (#324) (029da7e)

Documentation

document all command line arguments (#296) (e4b32e2)
document COPY TO STDOUT (#297) (3dbb19f)
document psycopg2 usage (#344) (4144c2d)
Liquibase samples and tests (#291) (d471056)

0.6.1 (2022-07-13)

Bug Fixes

prepared statement could return error 'This ResultSet is closed' (#279) (3383738), closes #278

0.6.0 (2022-07-11)

Features

COPY my_table FROM STDIN BINARY (#261) (7155783)
COPY my_table TO STDOUT (#269) (393b520)
COPY my_table TO STDOUT BINARY (#271) (d8c4c77)
support \l meta command (#215) (b9d0363)
support COPY statement in a batch of sql statements (#217) (d39cec8)
support IF [NOT] EXISTS for DDL statements (#224) (703a25d)

Bug Fixes

copy could return wrong error message (#252) (6ad4aa2)
COPY null values caused NullPointerException (#254) (cd34476)
order parameters by index and not textual value (#239) (d472639)
parse table names with schema prefix (#232) (cbdf28d)
respect result format code from Bind msg (#238) (708fa42)
skip bytes in an invalid stream defensively (#241) (1c60253)

Documentation

add authentication faq entry (#244) (d5cc7e3)
add connection tips for pgx (#234) (1ac2a70)
add connection tips for pgx (#234) (684a068)
document JDBC connection tips and performance considerations (#233) (5a09690)
move COPY documentation to separate file (#246) (54251aa)
update readme to reflect latest version (#229) (ea998bf)

0.5.1 (2022-06-22)

Bug Fixes

correctly skip nested block comments (#219) (c9903da)
unix domain sockets failed for msg size > 8Kb on MacOS (#188) (bc778ec)

Dependencies

bump junixsockets to 2.5.0 (#186) (58d09cb)
enable dependabot (#187) (1bf14c8)
remove custom Maven plugin versions (#214) (1392a7a)

Documentation

add documentation for connection options (#212) (837fe31)
mark drivers as having experimental support (#189) (5ab7caa)
update README to reflect recent updates (#190) (d0c52bf)

0.5.0 (2022-06-13)

Features

add support for describe statement (#125) (52452d7)
add support for extended query protocol batching (#168) (30607f0)
automatically detect client that is connected (#169) (f11f459)
enable authentication (#174) (2e34c84)
handle implicit transactions and errors in batches (#127) (23702ee)
support unix domain sockets (#150) (cec7d43)

Bug Fixes

clear statement tag before auto rollback (#147) (994976f), closes #146
error handling for extended query protocol (#149) (6696531)
handle errors if domain socket file is invalid (#164) (4a6d865)
lower case single statement commands were not recognized (#148) (f069eaf)
print version number at startup (#142) (9f4d230)
send comments to the backend to support hints (#170) (f329578)
split statement did not correctly parse escaped quotes (#152) (cfbec96)
terminate connection for invalid messages (#154) (6ed6266)
use assembly instead of fat jar (#145) (dd8d3d1)

Dependencies

bump Spanner to 6.24 (#155) (836271e)
bump Spanner to 6.25 (#161) (d66e0e6)
bump Spanner to 6.25.5 (#172) (c986a25)

Documentation

add FAQ and DDL options documentation (#171) (e3016d1)

0.4.2 (2022-05-03)

Dependencies

bump PostgreSQL JDBC to 42.3.4 (#138) (9b67670)
bump Spanner to 6.23.3 (#137) (180b25c)

0.4.1 (2022-05-02)

Bug Fixes

update documentation to reflect \c support (#132) (10798df)

0.4.0 (2022-04-29)

Features

all statement batching (#108) (1d88311)
support connecting to different databases (#121) (2bc0355)
support fetching rows in multiple steps (#122) (d5b76ca)
support more JDBC parameter types (#118) (21a7bd0)
support pgx in extended mode (#82) (1fbb35d)

Bug Fixes

allow QueryMessage with empty query string (#113) (2a3f2eb)
invalid metadata command (#124) (4d2d37d)
remember parameter types of parsed statement (#114) (8f0d477)
return EmptyQueryResponse for empty statements (#126) (77e7421)

Documentation

add Maven coordinates to README (#111) (3629b54)
udpate pom description (#112) (f7d05b2)

0.3.0 (2022-04-07)

Features

add support for DATE data type (#88) (56e2015)

Performance Improvements

reduce parsing of sql string (#79) (4c24ef9)
skip analyzeQuery for queries (#80) (98e430a)

Documentation

update README with instructions for running (#97) (bab6106)

0.2.1 (2022-03-31)

Bug Fixes

handle null values in arrays (#87) (b469d7f)

Performance Improvements

reduce logger overhead (#78) (8ba1004)

0.2.0 (2022-03-30)

Features

User agent header addition (#46) (9e891de)

Bug Fixes

docker build command in GitHub Actions config (#90) (ec210ca)
handle connection failures better by returning an error response (#67) (c0bad6f)

Performance Improvements

reduce flushing the output stream (#77) (4871bc5)

0.1.0 (2022-03-18)

Features

Add Copy command parsing in QueryMessage and basic psql e2e test (#43) (184c00e)
Add support for multiple CopyData messages (#40) (24eeedc)
add support incoming binary values (#27) (2ef7563)
COPY supports large files and streaming input from PostgreSQL (#52) (b773999)
enable native JDBC connections (#28) (ceba433)
support JDBC metadata queries (#58) (021e131)
trigger release (#63) (62af37d)

Bug Fixes

add newly added view to expected result (4ca4411)
add support for arrays in ResultSets (#36) (90bd661)
CI integration tests ignored environment variable values (#31) (c37d2e4)
command should determine result type (#29) (1a39338)
remove all GSQL headers (#60) (755592a)
return correct transaction status (69c4017)
Statements with no results would return an error (#57) (398afbe), closes #56
support null parameters (#35) (4fde6c3)
Update Copy parser to handle ',' separated option list (#49) (7c6530f)

Dependencies

bump Spanner client lib to 6.21 (#54) (020471b)
upgrade jdbc to 2.5.6-pg-SNAPSHOT (f3f0f87)
upgrade jdbc to 2.5.7-pg-SNAPSHOT (0f61776)