Diff of the two buildlogs: -- --- b1/build.log 2025-09-15 19:35:29.213437517 +0000 +++ b2/build.log 2025-09-15 19:37:57.237621504 +0000 @@ -1,6 +1,6 @@ I: pbuilder: network access will be disabled during build -I: Current time: Mon Sep 15 07:33:44 -12 2025 -I: pbuilder-time-stamp: 1757964824 +I: Current time: Mon Oct 19 15:58:31 +14 2026 +I: pbuilder-time-stamp: 1792375111 I: Building the build Environment I: extracting base tarball [/var/cache/pbuilder/forky-reproducible-base.tgz] I: copying local configuration @@ -22,52 +22,84 @@ dpkg-source: info: unpacking golang-gopkg-gorp.v1_1.7.2-2.debian.tar.xz I: Not using root during the build. I: Installing the build-deps -I: user script /srv/workspace/pbuilder/3864389/tmp/hooks/D02_print_environment starting +I: user script /srv/workspace/pbuilder/3197581/tmp/hooks/D01_modify_environment starting +debug: Running on infom02-amd64. +I: Changing host+domainname to test build reproducibility +I: Adding a custom variable just for the fun of it... +I: Changing /bin/sh to bash +'/bin/sh' -> '/bin/bash' +lrwxrwxrwx 1 root root 9 Oct 19 01:58 /bin/sh -> /bin/bash +I: Setting pbuilder2's login shell to /bin/bash +I: Setting pbuilder2's GECOS to second user,second room,second work-phone,second home-phone,second other +I: user script /srv/workspace/pbuilder/3197581/tmp/hooks/D01_modify_environment finished +I: user script /srv/workspace/pbuilder/3197581/tmp/hooks/D02_print_environment starting I: set - BUILDDIR='/build/reproducible-path' - BUILDUSERGECOS='first user,first room,first work-phone,first home-phone,first other' - BUILDUSERNAME='pbuilder1' - BUILD_ARCH='amd64' - DEBIAN_FRONTEND='noninteractive' - DEB_BUILD_OPTIONS='buildinfo=+all reproducible=+all parallel=12 ' - DISTRIBUTION='forky' - HOME='/root' - HOST_ARCH='amd64' + BASH=/bin/sh + BASHOPTS=checkwinsize:cmdhist:complete_fullquote:extquote:force_fignore:globasciiranges:globskipdots:hostcomplete:interactive_comments:patsub_replacement:progcomp:promptvars:sourcepath + BASH_ALIASES=() + BASH_ARGC=() + BASH_ARGV=() + BASH_CMDS=() + BASH_LINENO=([0]="12" [1]="0") + BASH_LOADABLES_PATH=/usr/local/lib/bash:/usr/lib/bash:/opt/local/lib/bash:/usr/pkg/lib/bash:/opt/pkg/lib/bash:. + BASH_SOURCE=([0]="/tmp/hooks/D02_print_environment" [1]="/tmp/hooks/D02_print_environment") + BASH_VERSINFO=([0]="5" [1]="3" [2]="3" [3]="1" [4]="release" [5]="x86_64-pc-linux-gnu") + BASH_VERSION='5.3.3(1)-release' + BUILDDIR=/build/reproducible-path + BUILDUSERGECOS='second user,second room,second work-phone,second home-phone,second other' + BUILDUSERNAME=pbuilder2 + BUILD_ARCH=amd64 + DEBIAN_FRONTEND=noninteractive + DEB_BUILD_OPTIONS='buildinfo=+all reproducible=+all parallel=16 ' + DIRSTACK=() + DISTRIBUTION=forky + EUID=0 + FUNCNAME=([0]="Echo" [1]="main") + GROUPS=() + HOME=/root + HOSTNAME=i-capture-the-hostname + HOSTTYPE=x86_64 + HOST_ARCH=amd64 IFS=' ' - INVOCATION_ID='99121527b33b4d2ca37bb5e58ea4b907' - LANG='C' - LANGUAGE='en_US:en' - LC_ALL='C' - MAIL='/var/mail/root' - OPTIND='1' - PATH='/usr/sbin:/usr/bin:/sbin:/bin:/usr/games' - PBCURRENTCOMMANDLINEOPERATION='build' - PBUILDER_OPERATION='build' - PBUILDER_PKGDATADIR='/usr/share/pbuilder' - PBUILDER_PKGLIBDIR='/usr/lib/pbuilder' - PBUILDER_SYSCONFDIR='/etc' - PPID='3864389' - PS1='# ' - PS2='> ' + INVOCATION_ID=9df9ffe02d1446aba718b031463ab3e2 + LANG=C + LANGUAGE=et_EE:et + LC_ALL=C + MACHTYPE=x86_64-pc-linux-gnu + MAIL=/var/mail/root + OPTERR=1 + OPTIND=1 + OSTYPE=linux-gnu + PATH=/usr/sbin:/usr/bin:/sbin:/bin:/usr/games:/i/capture/the/path + PBCURRENTCOMMANDLINEOPERATION=build + PBUILDER_OPERATION=build + PBUILDER_PKGDATADIR=/usr/share/pbuilder + PBUILDER_PKGLIBDIR=/usr/lib/pbuilder + PBUILDER_SYSCONFDIR=/etc + PIPESTATUS=([0]="0") + POSIXLY_CORRECT=y + PPID=3197581 PS4='+ ' - PWD='/' - SHELL='/bin/bash' - SHLVL='2' - SUDO_COMMAND='/usr/bin/timeout -k 18.1h 18h /usr/bin/ionice -c 3 /usr/bin/nice /usr/sbin/pbuilder --build --configfile /srv/reproducible-results/rbuild-debian/r-b-build.O0XDxR8U/pbuilderrc_ASPM --distribution forky --hookdir /etc/pbuilder/first-build-hooks --debbuildopts -b --basetgz /var/cache/pbuilder/forky-reproducible-base.tgz --buildresult /srv/reproducible-results/rbuild-debian/r-b-build.O0XDxR8U/b1 --logfile b1/build.log golang-gopkg-gorp.v1_1.7.2-2.dsc' - SUDO_GID='109' - SUDO_HOME='/var/lib/jenkins' - SUDO_UID='104' - SUDO_USER='jenkins' - TERM='unknown' - TZ='/usr/share/zoneinfo/Etc/GMT+12' - USER='root' - _='/usr/bin/systemd-run' + PWD=/ + SHELL=/bin/bash + SHELLOPTS=braceexpand:errexit:hashall:interactive-comments:posix + SHLVL=3 + SUDO_COMMAND='/usr/bin/timeout -k 24.1h 24h /usr/bin/ionice -c 3 /usr/bin/nice -n 11 /usr/bin/unshare --uts -- /usr/sbin/pbuilder --build --configfile /srv/reproducible-results/rbuild-debian/r-b-build.O0XDxR8U/pbuilderrc_Erpz --distribution forky --hookdir /etc/pbuilder/rebuild-hooks --debbuildopts -b --basetgz /var/cache/pbuilder/forky-reproducible-base.tgz --buildresult /srv/reproducible-results/rbuild-debian/r-b-build.O0XDxR8U/b2 --logfile b2/build.log golang-gopkg-gorp.v1_1.7.2-2.dsc' + SUDO_GID=109 + SUDO_HOME=/var/lib/jenkins + SUDO_UID=104 + SUDO_USER=jenkins + TERM=unknown + TZ=/usr/share/zoneinfo/Etc/GMT-14 + UID=0 + USER=root + _='I: set' I: uname -a - Linux infom01-amd64 6.12.43+deb13-cloud-amd64 #1 SMP PREEMPT_DYNAMIC Debian 6.12.43-1 (2025-08-27) x86_64 GNU/Linux + Linux i-capture-the-hostname 6.12.43+deb13-amd64 #1 SMP PREEMPT_DYNAMIC Debian 6.12.43-1 (2025-08-27) x86_64 GNU/Linux I: ls -l /bin - lrwxrwxrwx 1 root root 7 Aug 10 12:30 /bin -> usr/bin -I: user script /srv/workspace/pbuilder/3864389/tmp/hooks/D02_print_environment finished + lrwxrwxrwx 1 root root 7 Aug 10 2025 /bin -> usr/bin +I: user script /srv/workspace/pbuilder/3197581/tmp/hooks/D02_print_environment finished -> Attempting to satisfy build-dependencies -> Creating pbuilder-satisfydepends-dummy package Package: pbuilder-satisfydepends-dummy @@ -175,7 +207,7 @@ Get: 58 http://deb.debian.org/debian forky/main amd64 libsqlite3-dev amd64 3.46.1-8 [1172 kB] Get: 59 http://deb.debian.org/debian forky/main amd64 golang-github-mattn-go-sqlite3-dev amd64 1.14.32~ds1-1 [82.5 kB] Get: 60 http://deb.debian.org/debian forky/main amd64 golang-github-ziutek-mymysql-dev all 1.5.4+git20170206.23.0582bcf-2 [46.8 kB] -Fetched 70.3 MB in 2s (46.6 MB/s) +Fetched 70.3 MB in 2s (35.7 MB/s) Preconfiguring packages ... Selecting previously unselected package sensible-utils. (Reading database ... (Reading database ... 5% (Reading database ... 10% (Reading database ... 15% (Reading database ... 20% (Reading database ... 25% (Reading database ... 30% (Reading database ... 35% (Reading database ... 40% (Reading database ... 45% (Reading database ... 50% (Reading database ... 55% (Reading database ... 60% (Reading database ... 65% (Reading database ... 70% (Reading database ... 75% (Reading database ... 80% (Reading database ... 85% (Reading database ... 90% (Reading database ... 95% (Reading database ... 100% (Reading database ... 19917 files and directories currently installed.) @@ -430,7 +462,11 @@ Building tag database... -> Finished parsing the build-deps I: Building the package -I: Running cd /build/reproducible-path/golang-gopkg-gorp.v1-1.7.2/ && env PATH="/usr/sbin:/usr/bin:/sbin:/bin:/usr/games" HOME="/nonexistent/first-build" dpkg-buildpackage -us -uc -b && env PATH="/usr/sbin:/usr/bin:/sbin:/bin:/usr/games" HOME="/nonexistent/first-build" dpkg-genchanges -S > ../golang-gopkg-gorp.v1_1.7.2-2_source.changes +I: user script /srv/workspace/pbuilder/3197581/tmp/hooks/A99_set_merged_usr starting +Not re-configuring usrmerge for forky +I: user script /srv/workspace/pbuilder/3197581/tmp/hooks/A99_set_merged_usr finished +hostname: Name or service not known +I: Running cd /build/reproducible-path/golang-gopkg-gorp.v1-1.7.2/ && env PATH="/usr/sbin:/usr/bin:/sbin:/bin:/usr/games:/i/capture/the/path" HOME="/nonexistent/second-build" dpkg-buildpackage -us -uc -b && env PATH="/usr/sbin:/usr/bin:/sbin:/bin:/usr/games:/i/capture/the/path" HOME="/nonexistent/second-build" dpkg-genchanges -S > ../golang-gopkg-gorp.v1_1.7.2-2_source.changes dpkg-buildpackage: info: source package golang-gopkg-gorp.v1 dpkg-buildpackage: info: source version 1.7.2-2 dpkg-buildpackage: info: source distribution unstable @@ -448,34 +484,34 @@ dh_autoreconf -O--builddirectory=_build -O--buildsystem=golang dh_auto_configure -O--builddirectory=_build -O--buildsystem=golang dh_auto_build -O--builddirectory=_build -O--buildsystem=golang - cd _build && go install -trimpath -v -p 12 gopkg.in/gorp.v1 + cd _build && go install -trimpath -v -p 16 gopkg.in/gorp.v1 internal/byteorder -internal/godebugs -internal/runtime/syscall -internal/msan internal/goarch -internal/unsafeheader +internal/godebugs internal/asan internal/profilerecord -internal/coverage/rtcov +internal/msan internal/cpu -internal/goos -internal/goexperiment -internal/runtime/atomic -sync/atomic math/bits +sync/atomic unicode -unicode/utf8 -internal/itoa -internal/chacha8rand +internal/coverage/rtcov internal/runtime/math internal/abi -internal/runtime/sys +internal/chacha8rand +internal/runtime/syscall +internal/unsafeheader +internal/runtime/atomic +internal/goexperiment +internal/goos +unicode/utf8 +internal/itoa cmp log/internal +internal/runtime/sys internal/bytealg -internal/runtime/exithook math +internal/runtime/exithook internal/stringslite internal/race internal/sync @@ -486,19 +522,19 @@ sync maps slices -errors -sort internal/bisect internal/testlog -io +errors +sort internal/oserror path +io math/rand/v2 strconv syscall internal/godebug -bytes strings +bytes reflect regexp/syntax internal/syscall/execenv @@ -517,1285 +553,1285 @@ database/sql gopkg.in/gorp.v1 dh_auto_test -O--builddirectory=_build -O--buildsystem=golang - cd _build && go test -vet=off -v -p 12 gopkg.in/gorp.v1 + cd _build && go test -vet=off -v -p 16 gopkg.in/gorp.v1 === RUN TestCreateTablesIfNotExists -2025/09/15 19:35:17 Warning: Automatic mapping of Version struct members to version columns (see optimistic locking) will be deprecated in next version (V2) See: https://github.com/go-gorp/gorp/pull/214 -gorptest: 19:35:17.108407 drop table if exists "invoice_test"; [] -gorptest: 19:35:17.108844 drop table if exists "invoice_tag_test"; [] -gorptest: 19:35:17.108869 drop table if exists "alias_trans_field_test"; [] -gorptest: 19:35:17.108886 drop table if exists "invoice_override_test"; [] -gorptest: 19:35:17.108902 drop table if exists "person_test"; [] -gorptest: 19:35:17.108919 drop table if exists "ignored_column_test"; [] -gorptest: 19:35:17.108935 drop table if exists "id_created_test"; [] -gorptest: 19:35:17.108950 drop table if exists "type_conv_test"; [] -gorptest: 19:35:17.108965 drop table if exists "embedded_struct_test"; [] -gorptest: 19:35:17.108981 drop table if exists "embedded_struct_before_autoincr_test"; [] -gorptest: 19:35:17.108997 drop table if exists "embedded_autoincr_test"; [] -gorptest: 19:35:17.109012 drop table if exists "time_test"; [] -gorptest: 19:35:17.109033 create table "invoice_test" ("Id" integer not null primary key autoincrement, "Created" integer, "Updated" integer, "Memo" varchar(255), "PersonId" integer, "IsPaid" integer) ; [] -gorptest: 19:35:17.123495 create table "invoice_tag_test" ("myid" integer not null primary key autoincrement, "myCreated" integer, "date_updated" integer, "Memo" varchar(255), "person_id" integer, "is_Paid" integer) ; [] -gorptest: 19:35:17.132977 create table "alias_trans_field_test" ("id" integer not null primary key autoincrement, "bar" varchar(255)) ; [] -gorptest: 19:35:17.140273 create table "invoice_override_test" ("Id" varchar(255) not null primary key, "Created" integer, "Updated" integer, "Memo" varchar(255), "PersonId" integer, "IsPaid" integer) ; [] -gorptest: 19:35:17.147816 create table "person_test" ("Id" integer not null primary key autoincrement, "Created" integer, "Updated" integer, "FName" varchar(255), "LName" varchar(255), "Version" integer) ; [] -gorptest: 19:35:17.155704 create table "ignored_column_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] -gorptest: 19:35:17.164884 create table "id_created_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] -gorptest: 19:35:17.172596 create table "type_conv_test" ("Id" integer not null primary key autoincrement, "PersonJSON" varchar(255), "Name" varchar(255)) ; [] -gorptest: 19:35:17.180538 create table "embedded_struct_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255)) ; [] -gorptest: 19:35:17.188979 create table "embedded_struct_before_autoincr_test" ("FirstName" varchar(255), "LastName" varchar(255), "Id" integer not null primary key autoincrement) ; [] -gorptest: 19:35:17.196289 create table "embedded_autoincr_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255), "MiddleName" varchar(255)) ; [] -gorptest: 19:35:17.203707 create table "time_test" ("Id" integer not null primary key autoincrement, "Time" datetime) ; [] -gorptest: 19:35:17.211084 create table if not exists "invoice_test" ("Id" integer not null primary key autoincrement, "Created" integer, "Updated" integer, "Memo" varchar(255), "PersonId" integer, "IsPaid" integer) ; [] -gorptest: 19:35:17.211141 create table if not exists "invoice_tag_test" ("myid" integer not null primary key autoincrement, "myCreated" integer, "date_updated" integer, "Memo" varchar(255), "person_id" integer, "is_Paid" integer) ; [] -gorptest: 19:35:17.211163 create table if not exists "alias_trans_field_test" ("id" integer not null primary key autoincrement, "bar" varchar(255)) ; [] -gorptest: 19:35:17.211185 create table if not exists "invoice_override_test" ("Id" varchar(255) not null primary key, "Created" integer, "Updated" integer, "Memo" varchar(255), "PersonId" integer, "IsPaid" integer) ; [] -gorptest: 19:35:17.211203 create table if not exists "person_test" ("Id" integer not null primary key autoincrement, "Created" integer, "Updated" integer, "FName" varchar(255), "LName" varchar(255), "Version" integer) ; [] -gorptest: 19:35:17.211223 create table if not exists "ignored_column_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] -gorptest: 19:35:17.211239 create table if not exists "id_created_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] -gorptest: 19:35:17.211257 create table if not exists "type_conv_test" ("Id" integer not null primary key autoincrement, "PersonJSON" varchar(255), "Name" varchar(255)) ; [] -gorptest: 19:35:17.211274 create table if not exists "embedded_struct_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255)) ; [] -gorptest: 19:35:17.211294 create table if not exists "embedded_struct_before_autoincr_test" ("FirstName" varchar(255), "LastName" varchar(255), "Id" integer not null primary key autoincrement) ; [] -gorptest: 19:35:17.211312 create table if not exists "embedded_autoincr_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255), "MiddleName" varchar(255)) ; [] -gorptest: 19:35:17.211329 create table if not exists "time_test" ("Id" integer not null primary key autoincrement, "Time" datetime) ; [] -gorptest: 19:35:17.211344 create table if not exists "id_created_test" ("Id" integer not null primary key autoincrement, "Created" integer, "External" integer) ; [] -gorptest: 19:35:17.211364 drop table if exists "invoice_test"; [] -gorptest: 19:35:17.245305 drop table if exists "invoice_tag_test"; [] -gorptest: 19:35:17.254082 drop table if exists "alias_trans_field_test"; [] -gorptest: 19:35:17.263973 drop table if exists "invoice_override_test"; [] -gorptest: 19:35:17.274111 drop table if exists "person_test"; [] -gorptest: 19:35:17.284362 drop table if exists "ignored_column_test"; [] -gorptest: 19:35:17.293793 drop table if exists "id_created_test"; [] -gorptest: 19:35:17.304461 drop table if exists "type_conv_test"; [] -gorptest: 19:35:17.313549 drop table if exists "embedded_struct_test"; [] -gorptest: 19:35:17.324134 drop table if exists "embedded_struct_before_autoincr_test"; [] -gorptest: 19:35:17.334188 drop table if exists "embedded_autoincr_test"; [] -gorptest: 19:35:17.344226 drop table if exists "time_test"; [] -gorptest: 19:35:17.354137 drop table if exists "id_created_test"; [] ---- PASS: TestCreateTablesIfNotExists (0.25s) +2026/10/19 02:00:44 Warning: Automatic mapping of Version struct members to version columns (see optimistic locking) will be deprecated in next version (V2) See: https://github.com/go-gorp/gorp/pull/214 +gorptest: 02:00:44.095616 drop table if exists "invoice_test"; [] +gorptest: 02:00:44.096183 drop table if exists "invoice_tag_test"; [] +gorptest: 02:00:44.096227 drop table if exists "alias_trans_field_test"; [] +gorptest: 02:00:44.096245 drop table if exists "invoice_override_test"; [] +gorptest: 02:00:44.096262 drop table if exists "person_test"; [] +gorptest: 02:00:44.096286 drop table if exists "ignored_column_test"; [] +gorptest: 02:00:44.096302 drop table if exists "id_created_test"; [] +gorptest: 02:00:44.096324 drop table if exists "type_conv_test"; [] +gorptest: 02:00:44.096344 drop table if exists "embedded_struct_test"; [] +gorptest: 02:00:44.096365 drop table if exists "embedded_struct_before_autoincr_test"; [] +gorptest: 02:00:44.096386 drop table if exists "embedded_autoincr_test"; [] +gorptest: 02:00:44.096402 drop table if exists "time_test"; [] +gorptest: 02:00:44.096441 create table "invoice_test" ("Id" integer not null primary key autoincrement, "Created" integer, "Updated" integer, "Memo" varchar(255), "PersonId" integer, "IsPaid" integer) ; [] +gorptest: 02:00:44.107969 create table "invoice_tag_test" ("myid" integer not null primary key autoincrement, "myCreated" integer, "date_updated" integer, "Memo" varchar(255), "person_id" integer, "is_Paid" integer) ; [] +gorptest: 02:00:44.115911 create table "alias_trans_field_test" ("id" integer not null primary key autoincrement, "bar" varchar(255)) ; [] +gorptest: 02:00:44.125418 create table "invoice_override_test" ("Id" varchar(255) not null primary key, "Created" integer, "Updated" integer, "Memo" varchar(255), "PersonId" integer, "IsPaid" integer) ; [] +gorptest: 02:00:44.133809 create table "person_test" ("Id" integer not null primary key autoincrement, "Created" integer, "Updated" integer, "FName" varchar(255), "LName" varchar(255), "Version" integer) ; [] +gorptest: 02:00:44.141575 create table "ignored_column_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] +gorptest: 02:00:44.149032 create table "id_created_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] +gorptest: 02:00:44.157128 create table "type_conv_test" ("Id" integer not null primary key autoincrement, "PersonJSON" varchar(255), "Name" varchar(255)) ; [] +gorptest: 02:00:44.164724 create table "embedded_struct_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255)) ; [] +gorptest: 02:00:44.172607 create table "embedded_struct_before_autoincr_test" ("FirstName" varchar(255), "LastName" varchar(255), "Id" integer not null primary key autoincrement) ; [] +gorptest: 02:00:44.182131 create table "embedded_autoincr_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255), "MiddleName" varchar(255)) ; [] +gorptest: 02:00:44.189937 create table "time_test" ("Id" integer not null primary key autoincrement, "Time" datetime) ; [] +gorptest: 02:00:44.197133 create table if not exists "invoice_test" ("Id" integer not null primary key autoincrement, "Created" integer, "Updated" integer, "Memo" varchar(255), "PersonId" integer, "IsPaid" integer) ; [] +gorptest: 02:00:44.197213 create table if not exists "invoice_tag_test" ("myid" integer not null primary key autoincrement, "myCreated" integer, "date_updated" integer, "Memo" varchar(255), "person_id" integer, "is_Paid" integer) ; [] +gorptest: 02:00:44.197256 create table if not exists "alias_trans_field_test" ("id" integer not null primary key autoincrement, "bar" varchar(255)) ; [] +gorptest: 02:00:44.197295 create table if not exists "invoice_override_test" ("Id" varchar(255) not null primary key, "Created" integer, "Updated" integer, "Memo" varchar(255), "PersonId" integer, "IsPaid" integer) ; [] +gorptest: 02:00:44.197342 create table if not exists "person_test" ("Id" integer not null primary key autoincrement, "Created" integer, "Updated" integer, "FName" varchar(255), "LName" varchar(255), "Version" integer) ; [] +gorptest: 02:00:44.197369 create table if not exists "ignored_column_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] +gorptest: 02:00:44.197391 create table if not exists "id_created_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] +gorptest: 02:00:44.197419 create table if not exists "type_conv_test" ("Id" integer not null primary key autoincrement, "PersonJSON" varchar(255), "Name" varchar(255)) ; [] +gorptest: 02:00:44.197439 create table if not exists "embedded_struct_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255)) ; [] +gorptest: 02:00:44.197466 create table if not exists "embedded_struct_before_autoincr_test" ("FirstName" varchar(255), "LastName" varchar(255), "Id" integer not null primary key autoincrement) ; [] +gorptest: 02:00:44.197488 create table if not exists "embedded_autoincr_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255), "MiddleName" varchar(255)) ; [] +gorptest: 02:00:44.197515 create table if not exists "time_test" ("Id" integer not null primary key autoincrement, "Time" datetime) ; [] +gorptest: 02:00:44.197535 create table if not exists "id_created_test" ("Id" integer not null primary key autoincrement, "Created" integer, "External" integer) ; [] +gorptest: 02:00:44.197561 drop table if exists "invoice_test"; [] +gorptest: 02:00:44.203030 drop table if exists "invoice_tag_test"; [] +gorptest: 02:00:44.208574 drop table if exists "alias_trans_field_test"; [] +gorptest: 02:00:44.213716 drop table if exists "invoice_override_test"; [] +gorptest: 02:00:44.219244 drop table if exists "person_test"; [] +gorptest: 02:00:44.224336 drop table if exists "ignored_column_test"; [] +gorptest: 02:00:44.229741 drop table if exists "id_created_test"; [] +gorptest: 02:00:44.236713 drop table if exists "type_conv_test"; [] +gorptest: 02:00:44.242740 drop table if exists "embedded_struct_test"; [] +gorptest: 02:00:44.252566 drop table if exists "embedded_struct_before_autoincr_test"; [] +gorptest: 02:00:44.263056 drop table if exists "embedded_autoincr_test"; [] +gorptest: 02:00:44.272656 drop table if exists "time_test"; [] +gorptest: 02:00:44.283057 drop table if exists "id_created_test"; [] +--- PASS: TestCreateTablesIfNotExists (0.19s) === RUN TestTruncateTables -2025/09/15 19:35:17 Warning: Automatic mapping of Version struct members to version columns (see optimistic locking) will be deprecated in next version (V2) See: https://github.com/go-gorp/gorp/pull/214 -gorptest: 19:35:17.354392 drop table if exists "invoice_test"; [] -gorptest: 19:35:17.354562 drop table if exists "invoice_tag_test"; [] -gorptest: 19:35:17.354584 drop table if exists "alias_trans_field_test"; [] -gorptest: 19:35:17.354598 drop table if exists "invoice_override_test"; [] -gorptest: 19:35:17.354615 drop table if exists "person_test"; [] -gorptest: 19:35:17.354629 drop table if exists "ignored_column_test"; [] -gorptest: 19:35:17.354643 drop table if exists "id_created_test"; [] -gorptest: 19:35:17.354657 drop table if exists "type_conv_test"; [] -gorptest: 19:35:17.354672 drop table if exists "embedded_struct_test"; [] -gorptest: 19:35:17.354686 drop table if exists "embedded_struct_before_autoincr_test"; [] -gorptest: 19:35:17.354703 drop table if exists "embedded_autoincr_test"; [] -gorptest: 19:35:17.354717 drop table if exists "time_test"; [] -gorptest: 19:35:17.354740 create table "invoice_test" ("Id" integer not null primary key autoincrement, "Created" integer, "Updated" integer, "Memo" varchar(255), "PersonId" integer, "IsPaid" integer) ; [] -gorptest: 19:35:17.363960 create table "invoice_tag_test" ("myid" integer not null primary key autoincrement, "myCreated" integer, "date_updated" integer, "Memo" varchar(255), "person_id" integer, "is_Paid" integer) ; [] -gorptest: 19:35:17.374475 create table "alias_trans_field_test" ("id" integer not null primary key autoincrement, "bar" varchar(255)) ; [] -gorptest: 19:35:17.383807 create table "invoice_override_test" ("Id" varchar(255) not null primary key, "Created" integer, "Updated" integer, "Memo" varchar(255), "PersonId" integer, "IsPaid" integer) ; [] -gorptest: 19:35:17.396550 create table "person_test" ("Id" integer not null primary key autoincrement, "Created" integer, "Updated" integer, "FName" varchar(255), "LName" varchar(255), "Version" integer) ; [] -gorptest: 19:35:17.406078 create table "ignored_column_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] -gorptest: 19:35:17.415714 create table "id_created_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] -gorptest: 19:35:17.426507 create table "type_conv_test" ("Id" integer not null primary key autoincrement, "PersonJSON" varchar(255), "Name" varchar(255)) ; [] -gorptest: 19:35:17.436145 create table "embedded_struct_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255)) ; [] -gorptest: 19:35:17.446643 create table "embedded_struct_before_autoincr_test" ("FirstName" varchar(255), "LastName" varchar(255), "Id" integer not null primary key autoincrement) ; [] -gorptest: 19:35:17.456068 create table "embedded_autoincr_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255), "MiddleName" varchar(255)) ; [] -gorptest: 19:35:17.466255 create table "time_test" ("Id" integer not null primary key autoincrement, "Time" datetime) ; [] -gorptest: 19:35:17.473703 create table if not exists "invoice_test" ("Id" integer not null primary key autoincrement, "Created" integer, "Updated" integer, "Memo" varchar(255), "PersonId" integer, "IsPaid" integer) ; [] -gorptest: 19:35:17.473755 create table if not exists "invoice_tag_test" ("myid" integer not null primary key autoincrement, "myCreated" integer, "date_updated" integer, "Memo" varchar(255), "person_id" integer, "is_Paid" integer) ; [] -gorptest: 19:35:17.473775 create table if not exists "alias_trans_field_test" ("id" integer not null primary key autoincrement, "bar" varchar(255)) ; [] -gorptest: 19:35:17.473797 create table if not exists "invoice_override_test" ("Id" varchar(255) not null primary key, "Created" integer, "Updated" integer, "Memo" varchar(255), "PersonId" integer, "IsPaid" integer) ; [] -gorptest: 19:35:17.473824 create table if not exists "person_test" ("Id" integer not null primary key autoincrement, "Created" integer, "Updated" integer, "FName" varchar(255), "LName" varchar(255), "Version" integer) ; [] -gorptest: 19:35:17.473843 create table if not exists "ignored_column_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] -gorptest: 19:35:17.473860 create table if not exists "id_created_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] -gorptest: 19:35:17.473876 create table if not exists "type_conv_test" ("Id" integer not null primary key autoincrement, "PersonJSON" varchar(255), "Name" varchar(255)) ; [] -gorptest: 19:35:17.473896 create table if not exists "embedded_struct_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255)) ; [] -gorptest: 19:35:17.473927 create table if not exists "embedded_struct_before_autoincr_test" ("FirstName" varchar(255), "LastName" varchar(255), "Id" integer not null primary key autoincrement) ; [] -gorptest: 19:35:17.473947 create table if not exists "embedded_autoincr_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255), "MiddleName" varchar(255)) ; [] -gorptest: 19:35:17.473963 create table if not exists "time_test" ("Id" integer not null primary key autoincrement, "Time" datetime) ; [] -gorptest: 19:35:17.473979 create table if not exists "id_created_test" ("Id" integer not null primary key autoincrement, "Created" integer, "External" integer) ; [] -gorptest: 19:35:17.474016 insert into "person_test" ("Id","Created","Updated","FName","LName","Version") values (null,?,?,?,?,?); [1:1757964917474004376 2:1757964917474004376 3:"Bob" 4:"Smith" 5:1] -gorptest: 19:35:17.486056 insert into "invoice_test" ("Id","Created","Updated","Memo","PersonId","IsPaid") values (null,?,?,?,?,?); [1:0 2:1 3:"my invoice" 4:0 5:true] -gorptest: 19:35:17.498509 delete from "invoice_test"; [] -gorptest: 19:35:17.509326 delete from "invoice_tag_test"; [] -gorptest: 19:35:17.518304 delete from "alias_trans_field_test"; [] -gorptest: 19:35:17.528117 delete from "invoice_override_test"; [] -gorptest: 19:35:17.540097 delete from "person_test"; [] -gorptest: 19:35:17.549978 delete from "ignored_column_test"; [] -gorptest: 19:35:17.560183 delete from "id_created_test"; [] -gorptest: 19:35:17.569744 delete from "type_conv_test"; [] -gorptest: 19:35:17.579994 delete from "embedded_struct_test"; [] -gorptest: 19:35:17.589946 delete from "embedded_struct_before_autoincr_test"; [] -gorptest: 19:35:17.600378 delete from "embedded_autoincr_test"; [] -gorptest: 19:35:17.610378 delete from "time_test"; [] -gorptest: 19:35:17.618354 delete from "id_created_test"; [] -gorptest: 19:35:17.628139 SELECT * FROM person_test [] -gorptest: 19:35:17.628270 SELECT * FROM invoice_test [] -gorptest: 19:35:17.628309 drop table if exists "invoice_test"; [] -gorptest: 19:35:17.640482 drop table if exists "invoice_tag_test"; [] -gorptest: 19:35:17.651684 drop table if exists "alias_trans_field_test"; [] -gorptest: 19:35:17.663964 drop table if exists "invoice_override_test"; [] -gorptest: 19:35:17.677867 drop table if exists "person_test"; [] -gorptest: 19:35:17.691985 drop table if exists "ignored_column_test"; [] -gorptest: 19:35:17.704488 drop table if exists "id_created_test"; [] -gorptest: 19:35:17.716395 drop table if exists "type_conv_test"; [] -gorptest: 19:35:17.728357 drop table if exists "embedded_struct_test"; [] -gorptest: 19:35:17.740371 drop table if exists "embedded_struct_before_autoincr_test"; [] -gorptest: 19:35:17.752464 drop table if exists "embedded_autoincr_test"; [] -gorptest: 19:35:17.764303 drop table if exists "time_test"; [] -gorptest: 19:35:17.774330 drop table if exists "id_created_test"; [] +2026/10/19 02:00:44 Warning: Automatic mapping of Version struct members to version columns (see optimistic locking) will be deprecated in next version (V2) See: https://github.com/go-gorp/gorp/pull/214 +gorptest: 02:00:44.283407 drop table if exists "invoice_test"; [] +gorptest: 02:00:44.283686 drop table if exists "invoice_tag_test"; [] +gorptest: 02:00:44.283722 drop table if exists "alias_trans_field_test"; [] +gorptest: 02:00:44.283744 drop table if exists "invoice_override_test"; [] +gorptest: 02:00:44.283762 drop table if exists "person_test"; [] +gorptest: 02:00:44.283783 drop table if exists "ignored_column_test"; [] +gorptest: 02:00:44.283812 drop table if exists "id_created_test"; [] +gorptest: 02:00:44.283831 drop table if exists "type_conv_test"; [] +gorptest: 02:00:44.283850 drop table if exists "embedded_struct_test"; [] +gorptest: 02:00:44.283875 drop table if exists "embedded_struct_before_autoincr_test"; [] +gorptest: 02:00:44.283894 drop table if exists "embedded_autoincr_test"; [] +gorptest: 02:00:44.283922 drop table if exists "time_test"; [] +gorptest: 02:00:44.283948 create table "invoice_test" ("Id" integer not null primary key autoincrement, "Created" integer, "Updated" integer, "Memo" varchar(255), "PersonId" integer, "IsPaid" integer) ; [] +gorptest: 02:00:44.292403 create table "invoice_tag_test" ("myid" integer not null primary key autoincrement, "myCreated" integer, "date_updated" integer, "Memo" varchar(255), "person_id" integer, "is_Paid" integer) ; [] +gorptest: 02:00:44.302869 create table "alias_trans_field_test" ("id" integer not null primary key autoincrement, "bar" varchar(255)) ; [] +gorptest: 02:00:44.312768 create table "invoice_override_test" ("Id" varchar(255) not null primary key, "Created" integer, "Updated" integer, "Memo" varchar(255), "PersonId" integer, "IsPaid" integer) ; [] +gorptest: 02:00:44.324707 create table "person_test" ("Id" integer not null primary key autoincrement, "Created" integer, "Updated" integer, "FName" varchar(255), "LName" varchar(255), "Version" integer) ; [] +gorptest: 02:00:44.334554 create table "ignored_column_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] +gorptest: 02:00:44.344242 create table "id_created_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] +gorptest: 02:00:44.354487 create table "type_conv_test" ("Id" integer not null primary key autoincrement, "PersonJSON" varchar(255), "Name" varchar(255)) ; [] +gorptest: 02:00:44.364835 create table "embedded_struct_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255)) ; [] +gorptest: 02:00:44.375067 create table "embedded_struct_before_autoincr_test" ("FirstName" varchar(255), "LastName" varchar(255), "Id" integer not null primary key autoincrement) ; [] +gorptest: 02:00:44.384969 create table "embedded_autoincr_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255), "MiddleName" varchar(255)) ; [] +gorptest: 02:00:44.394090 create table "time_test" ("Id" integer not null primary key autoincrement, "Time" datetime) ; [] +gorptest: 02:00:44.402906 create table if not exists "invoice_test" ("Id" integer not null primary key autoincrement, "Created" integer, "Updated" integer, "Memo" varchar(255), "PersonId" integer, "IsPaid" integer) ; [] +gorptest: 02:00:44.403006 create table if not exists "invoice_tag_test" ("myid" integer not null primary key autoincrement, "myCreated" integer, "date_updated" integer, "Memo" varchar(255), "person_id" integer, "is_Paid" integer) ; [] +gorptest: 02:00:44.403058 create table if not exists "alias_trans_field_test" ("id" integer not null primary key autoincrement, "bar" varchar(255)) ; [] +gorptest: 02:00:44.403091 create table if not exists "invoice_override_test" ("Id" varchar(255) not null primary key, "Created" integer, "Updated" integer, "Memo" varchar(255), "PersonId" integer, "IsPaid" integer) ; [] +gorptest: 02:00:44.403133 create table if not exists "person_test" ("Id" integer not null primary key autoincrement, "Created" integer, "Updated" integer, "FName" varchar(255), "LName" varchar(255), "Version" integer) ; [] +gorptest: 02:00:44.403164 create table if not exists "ignored_column_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] +gorptest: 02:00:44.403198 create table if not exists "id_created_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] +gorptest: 02:00:44.403226 create table if not exists "type_conv_test" ("Id" integer not null primary key autoincrement, "PersonJSON" varchar(255), "Name" varchar(255)) ; [] +gorptest: 02:00:44.403254 create table if not exists "embedded_struct_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255)) ; [] +gorptest: 02:00:44.403338 create table if not exists "embedded_struct_before_autoincr_test" ("FirstName" varchar(255), "LastName" varchar(255), "Id" integer not null primary key autoincrement) ; [] +gorptest: 02:00:44.403407 create table if not exists "embedded_autoincr_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255), "MiddleName" varchar(255)) ; [] +gorptest: 02:00:44.403460 create table if not exists "time_test" ("Id" integer not null primary key autoincrement, "Time" datetime) ; [] +gorptest: 02:00:44.403513 create table if not exists "id_created_test" ("Id" integer not null primary key autoincrement, "Created" integer, "External" integer) ; [] +gorptest: 02:00:44.403589 insert into "person_test" ("Id","Created","Updated","FName","LName","Version") values (null,?,?,?,?,?); [1:1792375244403571662 2:1792375244403571662 3:"Bob" 4:"Smith" 5:1] +gorptest: 02:00:44.414726 insert into "invoice_test" ("Id","Created","Updated","Memo","PersonId","IsPaid") values (null,?,?,?,?,?); [1:0 2:1 3:"my invoice" 4:0 5:true] +gorptest: 02:00:44.426591 delete from "invoice_test"; [] +gorptest: 02:00:44.436486 delete from "invoice_tag_test"; [] +gorptest: 02:00:44.446763 delete from "alias_trans_field_test"; [] +gorptest: 02:00:44.456903 delete from "invoice_override_test"; [] +gorptest: 02:00:44.468146 delete from "person_test"; [] +gorptest: 02:00:44.478163 delete from "ignored_column_test"; [] +gorptest: 02:00:44.488191 delete from "id_created_test"; [] +gorptest: 02:00:44.499006 delete from "type_conv_test"; [] +gorptest: 02:00:44.508476 delete from "embedded_struct_test"; [] +gorptest: 02:00:44.524864 delete from "embedded_struct_before_autoincr_test"; [] +gorptest: 02:00:44.531009 delete from "embedded_autoincr_test"; [] +gorptest: 02:00:44.538236 delete from "time_test"; [] +gorptest: 02:00:44.546837 delete from "id_created_test"; [] +gorptest: 02:00:44.556971 SELECT * FROM person_test [] +gorptest: 02:00:44.557237 SELECT * FROM invoice_test [] +gorptest: 02:00:44.557313 drop table if exists "invoice_test"; [] +gorptest: 02:00:44.568102 drop table if exists "invoice_tag_test"; [] +gorptest: 02:00:44.581142 drop table if exists "alias_trans_field_test"; [] +gorptest: 02:00:44.594502 drop table if exists "invoice_override_test"; [] +gorptest: 02:00:44.606518 drop table if exists "person_test"; [] +gorptest: 02:00:44.620244 drop table if exists "ignored_column_test"; [] +gorptest: 02:00:44.632686 drop table if exists "id_created_test"; [] +gorptest: 02:00:44.644815 drop table if exists "type_conv_test"; [] +gorptest: 02:00:44.656266 drop table if exists "embedded_struct_test"; [] +gorptest: 02:00:44.668189 drop table if exists "embedded_struct_before_autoincr_test"; [] +gorptest: 02:00:44.680856 drop table if exists "embedded_autoincr_test"; [] +gorptest: 02:00:44.692143 drop table if exists "time_test"; [] +gorptest: 02:00:44.702261 drop table if exists "id_created_test"; [] --- PASS: TestTruncateTables (0.42s) === RUN TestCustomDateType -gorptest: 19:35:17.774492 create table "WithCustomDate" ("Id" integer not null primary key autoincrement, "Added" datetime) ; [] -gorptest: 19:35:17.784575 insert into "WithCustomDate" ("Id","Added") values (null,?); [1:2025-09-15 19:35:17 +0000 UTC] -gorptest: 19:35:17.792213 select "Id","Added" from "WithCustomDate" where "Id"=?; [1:1] -gorptest: 19:35:17.792298 drop table if exists "WithCustomDate"; [] +gorptest: 02:00:44.702504 create table "WithCustomDate" ("Id" integer not null primary key autoincrement, "Added" datetime) ; [] +gorptest: 02:00:44.712045 insert into "WithCustomDate" ("Id","Added") values (null,?); [1:2026-10-19 02:00:44 +0000 UTC] +gorptest: 02:00:44.720722 select "Id","Added" from "WithCustomDate" where "Id"=?; [1:1] +gorptest: 02:00:44.720825 drop table if exists "WithCustomDate"; [] --- PASS: TestCustomDateType (0.03s) === RUN TestUIntPrimaryKey -gorptest: 19:35:17.802330 create table if not exists "PersonUInt64" ("Id" integer not null primary key autoincrement, "Name" varchar(255)) ; [] -gorptest: 19:35:17.811813 create table if not exists "PersonUInt32" ("Id" integer not null primary key autoincrement, "Name" varchar(255)) ; [] -gorptest: 19:35:17.823507 create table if not exists "PersonUInt16" ("Id" integer not null primary key autoincrement, "Name" varchar(255)) ; [] -gorptest: 19:35:17.835717 insert into "PersonUInt64" ("Id","Name") values (null,?); [1:"name1"] -gorptest: 19:35:17.844603 insert into "PersonUInt32" ("Id","Name") values (null,?); [1:"name2"] -gorptest: 19:35:17.856209 insert into "PersonUInt16" ("Id","Name") values (null,?); [1:"name3"] -gorptest: 19:35:17.868457 drop table if exists "PersonUInt64"; [] -gorptest: 19:35:17.878045 drop table if exists "PersonUInt32"; [] -gorptest: 19:35:17.900014 drop table if exists "PersonUInt16"; [] +gorptest: 02:00:44.730997 create table if not exists "PersonUInt64" ("Id" integer not null primary key autoincrement, "Name" varchar(255)) ; [] +gorptest: 02:00:44.740382 create table if not exists "PersonUInt32" ("Id" integer not null primary key autoincrement, "Name" varchar(255)) ; [] +gorptest: 02:00:44.752424 create table if not exists "PersonUInt16" ("Id" integer not null primary key autoincrement, "Name" varchar(255)) ; [] +gorptest: 02:00:44.764359 insert into "PersonUInt64" ("Id","Name") values (null,?); [1:"name1"] +gorptest: 02:00:44.784560 insert into "PersonUInt32" ("Id","Name") values (null,?); [1:"name2"] +gorptest: 02:00:44.790266 insert into "PersonUInt16" ("Id","Name") values (null,?); [1:"name3"] +gorptest: 02:00:44.796353 drop table if exists "PersonUInt64"; [] +gorptest: 02:00:44.806331 drop table if exists "PersonUInt32"; [] +gorptest: 02:00:44.820934 drop table if exists "PersonUInt16"; [] --- PASS: TestUIntPrimaryKey (0.10s) === RUN TestSetUniqueTogether -gorptest: 19:35:17.906822 create table if not exists "UniqueColumns" ("FirstName" varchar(255), "LastName" varchar(255), "City" varchar(255), "ZipCode" integer, unique ("FirstName", "LastName"), unique ("City", "ZipCode")) ; [] -gorptest: 19:35:17.919803 insert into "UniqueColumns" ("FirstName","LastName","City","ZipCode") values (?,?,?,?); [1:"Steve" 2:"Jobs" 3:"Cupertino" 4:95014] -gorptest: 19:35:17.932507 insert into "UniqueColumns" ("FirstName","LastName","City","ZipCode") values (?,?,?,?); [1:"Steve" 2:"Jobs" 3:"Sunnyvale" 4:94085] -gorptest: 19:35:17.932662 insert into "UniqueColumns" ("FirstName","LastName","City","ZipCode") values (?,?,?,?); [1:"Steve" 2:"Wozniak" 3:"Cupertino" 4:95014] -gorptest: 19:35:17.932716 insert into "UniqueColumns" ("FirstName","LastName","City","ZipCode") values (?,?,?,?); [1:"Steve" 2:"Wozniak" 3:"Sunnyvale" 4:94085] -gorptest: 19:35:17.943669 drop table if exists "UniqueColumns"; [] +gorptest: 02:00:44.834753 create table if not exists "UniqueColumns" ("FirstName" varchar(255), "LastName" varchar(255), "City" varchar(255), "ZipCode" integer, unique ("FirstName", "LastName"), unique ("City", "ZipCode")) ; [] +gorptest: 02:00:44.848568 insert into "UniqueColumns" ("FirstName","LastName","City","ZipCode") values (?,?,?,?); [1:"Steve" 2:"Jobs" 3:"Cupertino" 4:95014] +gorptest: 02:00:44.860952 insert into "UniqueColumns" ("FirstName","LastName","City","ZipCode") values (?,?,?,?); [1:"Steve" 2:"Jobs" 3:"Sunnyvale" 4:94085] +gorptest: 02:00:44.861143 insert into "UniqueColumns" ("FirstName","LastName","City","ZipCode") values (?,?,?,?); [1:"Steve" 2:"Wozniak" 3:"Cupertino" 4:95014] +gorptest: 02:00:44.861236 insert into "UniqueColumns" ("FirstName","LastName","City","ZipCode") values (?,?,?,?); [1:"Steve" 2:"Wozniak" 3:"Sunnyvale" 4:94085] +gorptest: 02:00:44.872478 drop table if exists "UniqueColumns"; [] --- PASS: TestSetUniqueTogether (0.05s) === RUN TestPersistentUser -gorptest: 19:35:17.958931 drop table if exists PersistentUser [] -gorptest: 19:35:17.959223 create table if not exists "PersistentUser" ("mykey" integer not null primary key, "Id" varchar(255), "PassedTraining" integer) ; [] -gorptest: 19:35:17.968331 insert into "PersistentUser" ("mykey","Id","PassedTraining") values (?,?,?); [1:43 2:"33r" 3:false] -gorptest: 19:35:17.975869 select "mykey","Id","PassedTraining" from "PersistentUser" where "mykey"=?; [1:43] -gorptest: 19:35:17.975964 select * from PersistentUser [] -gorptest: 19:35:17.976031 select * from PersistentUser [] -gorptest: 19:35:17.976083 select * from PersistentUser [] -gorptest: 19:35:17.976123 select Id from PersistentUser [] -gorptest: 19:35:17.976161 select mykey from PersistentUser [] -gorptest: 19:35:17.976194 select PassedTraining from PersistentUser [] -gorptest: 19:35:17.976229 select Id from PersistentUser [] -gorptest: 19:35:17.976262 drop table if exists "PersistentUser"; [] +gorptest: 02:00:44.886453 drop table if exists PersistentUser [] +gorptest: 02:00:44.886696 create table if not exists "PersistentUser" ("mykey" integer not null primary key, "Id" varchar(255), "PassedTraining" integer) ; [] +gorptest: 02:00:44.896131 insert into "PersistentUser" ("mykey","Id","PassedTraining") values (?,?,?); [1:43 2:"33r" 3:false] +gorptest: 02:00:44.904804 select "mykey","Id","PassedTraining" from "PersistentUser" where "mykey"=?; [1:43] +gorptest: 02:00:44.904917 select * from PersistentUser [] +gorptest: 02:00:44.904995 select * from PersistentUser [] +gorptest: 02:00:44.905100 select * from PersistentUser [] +gorptest: 02:00:44.905171 select Id from PersistentUser [] +gorptest: 02:00:44.905238 select mykey from PersistentUser [] +gorptest: 02:00:44.905280 select PassedTraining from PersistentUser [] +gorptest: 02:00:44.905314 select Id from PersistentUser [] +gorptest: 02:00:44.905363 drop table if exists "PersistentUser"; [] --- PASS: TestPersistentUser (0.03s) === RUN TestNamedQueryMap -gorptest: 19:35:17.986329 drop table if exists PersistentUser [] -gorptest: 19:35:17.986573 create table if not exists "PersistentUser" ("mykey" integer not null primary key, "Id" varchar(255), "PassedTraining" integer) ; [] -gorptest: 19:35:17.997614 insert into "PersistentUser" ("mykey","Id","PassedTraining") values (?,?,?); [1:43 2:"33r" 3:false] -gorptest: 19:35:18.007465 insert into "PersistentUser" ("mykey","Id","PassedTraining") values (?,?,?); [1:500 2:"abc" 3:false] -gorptest: 19:35:18.013590 select * from PersistentUser where mykey = ? [1:43] -gorptest: 19:35:18.013710 select * from PersistentUser where mykey = ? [1:43] -gorptest: 19:35:18.013778 +gorptest: 02:00:44.914532 drop table if exists PersistentUser [] +gorptest: 02:00:44.914729 create table if not exists "PersistentUser" ("mykey" integer not null primary key, "Id" varchar(255), "PassedTraining" integer) ; [] +gorptest: 02:00:44.924416 insert into "PersistentUser" ("mykey","Id","PassedTraining") values (?,?,?); [1:43 2:"33r" 3:false] +gorptest: 02:00:44.933241 insert into "PersistentUser" ("mykey","Id","PassedTraining") values (?,?,?); [1:500 2:"abc" 3:false] +gorptest: 02:00:44.942019 select * from PersistentUser where mykey = ? [1:43] +gorptest: 02:00:44.942126 select * from PersistentUser where mykey = ? [1:43] +gorptest: 02:00:44.942216 select * from PersistentUser where mykey = ? and PassedTraining = ? and Id = ? [1:43 2:false 3:"33r"] -gorptest: 19:35:18.013848 +gorptest: 02:00:44.942304 select * from PersistentUser where mykey = ? and Id != 'abc:def' [1:43] -gorptest: 19:35:18.013905 drop table if exists "PersistentUser"; [] +gorptest: 02:00:44.942368 drop table if exists "PersistentUser"; [] --- PASS: TestNamedQueryMap (0.04s) === RUN TestNamedQueryStruct -gorptest: 19:35:18.022003 drop table if exists PersistentUser [] -gorptest: 19:35:18.022211 create table if not exists "PersistentUser" ("mykey" integer not null primary key, "Id" varchar(255), "PassedTraining" integer) ; [] -gorptest: 19:35:18.031736 insert into "PersistentUser" ("mykey","Id","PassedTraining") values (?,?,?); [1:43 2:"33r" 3:false] -gorptest: 19:35:18.040444 insert into "PersistentUser" ("mykey","Id","PassedTraining") values (?,?,?); [1:500 2:"abc" 3:false] -gorptest: 19:35:18.049515 +gorptest: 02:00:44.951138 drop table if exists PersistentUser [] +gorptest: 02:00:44.951398 create table if not exists "PersistentUser" ("mykey" integer not null primary key, "Id" varchar(255), "PassedTraining" integer) ; [] +gorptest: 02:00:44.960911 insert into "PersistentUser" ("mykey","Id","PassedTraining") values (?,?,?); [1:43 2:"33r" 3:false] +gorptest: 02:00:44.968314 insert into "PersistentUser" ("mykey","Id","PassedTraining") values (?,?,?); [1:500 2:"abc" 3:false] +gorptest: 02:00:44.976893 select * from PersistentUser where mykey = ? and PassedTraining = ? and Id = ? [1:43 2:false 3:"33r"] -gorptest: 19:35:18.049636 drop table if exists "PersistentUser"; [] +gorptest: 02:00:44.977013 drop table if exists "PersistentUser"; [] --- PASS: TestNamedQueryStruct (0.04s) === RUN TestReturnsNonNilSlice -2025/09/15 19:35:18 Warning: Automatic mapping of Version struct members to version columns (see optimistic locking) will be deprecated in next version (V2) See: https://github.com/go-gorp/gorp/pull/214 -gorptest: 19:35:18.057788 drop table if exists "invoice_test"; [] -gorptest: 19:35:18.057961 drop table if exists "invoice_tag_test"; [] -gorptest: 19:35:18.057991 drop table if exists "alias_trans_field_test"; [] -gorptest: 19:35:18.058011 drop table if exists "invoice_override_test"; [] -gorptest: 19:35:18.058031 drop table if exists "person_test"; [] -gorptest: 19:35:18.058054 drop table if exists "ignored_column_test"; [] -gorptest: 19:35:18.058074 drop table if exists "id_created_test"; [] -gorptest: 19:35:18.058097 drop table if exists "type_conv_test"; [] -gorptest: 19:35:18.058116 drop table if exists "embedded_struct_test"; [] -gorptest: 19:35:18.058138 drop table if exists "embedded_struct_before_autoincr_test"; [] -gorptest: 19:35:18.058156 drop table if exists "embedded_autoincr_test"; [] -gorptest: 19:35:18.058179 drop table if exists "time_test"; [] -gorptest: 19:35:18.058204 create table "invoice_test" ("Id" integer not null primary key autoincrement, "Created" integer, "Updated" integer, "Memo" varchar(255), "PersonId" integer, "IsPaid" integer) ; [] -gorptest: 19:35:18.068492 create table "invoice_tag_test" ("myid" integer not null primary key autoincrement, "myCreated" integer, "date_updated" integer, "Memo" varchar(255), "person_id" integer, "is_Paid" integer) ; [] -gorptest: 19:35:18.080319 create table "alias_trans_field_test" ("id" integer not null primary key autoincrement, "bar" varchar(255)) ; [] -gorptest: 19:35:18.092255 create table "invoice_override_test" ("Id" varchar(255) not null primary key, "Created" integer, "Updated" integer, "Memo" varchar(255), "PersonId" integer, "IsPaid" integer) ; [] -gorptest: 19:35:18.106171 create table "person_test" ("Id" integer not null primary key autoincrement, "Created" integer, "Updated" integer, "FName" varchar(255), "LName" varchar(255), "Version" integer) ; [] -gorptest: 19:35:18.118184 create table "ignored_column_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] -gorptest: 19:35:18.129976 create table "id_created_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] -gorptest: 19:35:18.141534 create table "type_conv_test" ("Id" integer not null primary key autoincrement, "PersonJSON" varchar(255), "Name" varchar(255)) ; [] -gorptest: 19:35:18.154056 create table "embedded_struct_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255)) ; [] -gorptest: 19:35:18.165880 create table "embedded_struct_before_autoincr_test" ("FirstName" varchar(255), "LastName" varchar(255), "Id" integer not null primary key autoincrement) ; [] -gorptest: 19:35:18.178035 create table "embedded_autoincr_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255), "MiddleName" varchar(255)) ; [] -gorptest: 19:35:18.190748 create table "time_test" ("Id" integer not null primary key autoincrement, "Time" datetime) ; [] -gorptest: 19:35:18.200396 select * from invoice_test where id=99999 [] -gorptest: 19:35:18.200529 select * from invoice_test where id=99999 [] -gorptest: 19:35:18.200589 drop table if exists "invoice_test"; [] -gorptest: 19:35:18.208137 drop table if exists "invoice_tag_test"; [] -gorptest: 19:35:18.218246 drop table if exists "alias_trans_field_test"; [] -gorptest: 19:35:18.228270 drop table if exists "invoice_override_test"; [] -gorptest: 19:35:18.239792 drop table if exists "person_test"; [] -gorptest: 19:35:18.249660 drop table if exists "ignored_column_test"; [] -gorptest: 19:35:18.260588 drop table if exists "id_created_test"; [] -gorptest: 19:35:18.269876 drop table if exists "type_conv_test"; [] -gorptest: 19:35:18.279977 drop table if exists "embedded_struct_test"; [] -gorptest: 19:35:18.289890 drop table if exists "embedded_struct_before_autoincr_test"; [] -gorptest: 19:35:18.299477 drop table if exists "embedded_autoincr_test"; [] -gorptest: 19:35:18.310416 drop table if exists "time_test"; [] -gorptest: 19:35:18.320478 drop table if exists "id_created_test"; [] ---- PASS: TestReturnsNonNilSlice (0.26s) +2026/10/19 02:00:44 Warning: Automatic mapping of Version struct members to version columns (see optimistic locking) will be deprecated in next version (V2) See: https://github.com/go-gorp/gorp/pull/214 +gorptest: 02:00:44.986874 drop table if exists "invoice_test"; [] +gorptest: 02:00:44.987066 drop table if exists "invoice_tag_test"; [] +gorptest: 02:00:44.987109 drop table if exists "alias_trans_field_test"; [] +gorptest: 02:00:44.987141 drop table if exists "invoice_override_test"; [] +gorptest: 02:00:44.987176 drop table if exists "person_test"; [] +gorptest: 02:00:44.987203 drop table if exists "ignored_column_test"; [] +gorptest: 02:00:44.987226 drop table if exists "id_created_test"; [] +gorptest: 02:00:44.987247 drop table if exists "type_conv_test"; [] +gorptest: 02:00:44.987264 drop table if exists "embedded_struct_test"; [] +gorptest: 02:00:44.987298 drop table if exists "embedded_struct_before_autoincr_test"; [] +gorptest: 02:00:44.987326 drop table if exists "embedded_autoincr_test"; [] +gorptest: 02:00:44.987350 drop table if exists "time_test"; [] +gorptest: 02:00:44.987378 create table "invoice_test" ("Id" integer not null primary key autoincrement, "Created" integer, "Updated" integer, "Memo" varchar(255), "PersonId" integer, "IsPaid" integer) ; [] +gorptest: 02:00:44.996998 create table "invoice_tag_test" ("myid" integer not null primary key autoincrement, "myCreated" integer, "date_updated" integer, "Memo" varchar(255), "person_id" integer, "is_Paid" integer) ; [] +gorptest: 02:00:45.008244 create table "alias_trans_field_test" ("id" integer not null primary key autoincrement, "bar" varchar(255)) ; [] +gorptest: 02:00:45.020816 create table "invoice_override_test" ("Id" varchar(255) not null primary key, "Created" integer, "Updated" integer, "Memo" varchar(255), "PersonId" integer, "IsPaid" integer) ; [] +gorptest: 02:00:45.034709 create table "person_test" ("Id" integer not null primary key autoincrement, "Created" integer, "Updated" integer, "FName" varchar(255), "LName" varchar(255), "Version" integer) ; [] +gorptest: 02:00:45.046757 create table "ignored_column_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] +gorptest: 02:00:45.058807 create table "id_created_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] +gorptest: 02:00:45.070908 create table "type_conv_test" ("Id" integer not null primary key autoincrement, "PersonJSON" varchar(255), "Name" varchar(255)) ; [] +gorptest: 02:00:45.082125 create table "embedded_struct_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255)) ; [] +gorptest: 02:00:45.094739 create table "embedded_struct_before_autoincr_test" ("FirstName" varchar(255), "LastName" varchar(255), "Id" integer not null primary key autoincrement) ; [] +gorptest: 02:00:45.106390 create table "embedded_autoincr_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255), "MiddleName" varchar(255)) ; [] +gorptest: 02:00:45.118190 create table "time_test" ("Id" integer not null primary key autoincrement, "Time" datetime) ; [] +gorptest: 02:00:45.137599 select * from invoice_test where id=99999 [] +gorptest: 02:00:45.137815 select * from invoice_test where id=99999 [] +gorptest: 02:00:45.137903 drop table if exists "invoice_test"; [] +gorptest: 02:00:45.143942 drop table if exists "invoice_tag_test"; [] +gorptest: 02:00:45.150184 drop table if exists "alias_trans_field_test"; [] +gorptest: 02:00:45.156136 drop table if exists "invoice_override_test"; [] +gorptest: 02:00:45.168531 drop table if exists "person_test"; [] +gorptest: 02:00:45.178733 drop table if exists "ignored_column_test"; [] +gorptest: 02:00:45.188237 drop table if exists "id_created_test"; [] +gorptest: 02:00:45.198696 drop table if exists "type_conv_test"; [] +gorptest: 02:00:45.208702 drop table if exists "embedded_struct_test"; [] +gorptest: 02:00:45.218031 drop table if exists "embedded_struct_before_autoincr_test"; [] +gorptest: 02:00:45.228350 drop table if exists "embedded_autoincr_test"; [] +gorptest: 02:00:45.264999 drop table if exists "time_test"; [] +gorptest: 02:00:45.274331 drop table if exists "id_created_test"; [] +--- PASS: TestReturnsNonNilSlice (0.29s) === RUN TestOverrideVersionCol -gorptest: 19:35:18.320699 create table "InvoicePersonView" ("InvoiceId" integer not null, "PersonId" integer not null, "Memo" varchar(255), "FName" varchar(255), "LegacyVersion" integer, primary key ("InvoiceId", "PersonId")) ; [] -gorptest: 19:35:18.331880 update "InvoicePersonView" set "InvoiceId"=?, "PersonId"=?, "Memo"=?, "FName"=?, "LegacyVersion"=? where "InvoiceId"=? and "PersonId"=? and "LegacyVersion"=?; [1:1 2:2 3:"memo" 4:"fname" 5:1 6:1 7:2 8:1] -gorptest: 19:35:18.331982 drop table if exists "InvoicePersonView"; [] +gorptest: 02:00:45.274595 create table "InvoicePersonView" ("InvoiceId" integer not null, "PersonId" integer not null, "Memo" varchar(255), "FName" varchar(255), "LegacyVersion" integer, primary key ("InvoiceId", "PersonId")) ; [] +gorptest: 02:00:45.286628 update "InvoicePersonView" set "InvoiceId"=?, "PersonId"=?, "Memo"=?, "FName"=?, "LegacyVersion"=? where "InvoiceId"=? and "PersonId"=? and "LegacyVersion"=?; [1:1 2:2 3:"memo" 4:"fname" 5:1 6:1 7:2 8:1] +gorptest: 02:00:45.286756 drop table if exists "InvoicePersonView"; [] --- PASS: TestOverrideVersionCol (0.02s) === RUN TestOptimisticLocking -2025/09/15 19:35:18 Warning: Automatic mapping of Version struct members to version columns (see optimistic locking) will be deprecated in next version (V2) See: https://github.com/go-gorp/gorp/pull/214 -gorptest: 19:35:18.343955 drop table if exists "invoice_test"; [] -gorptest: 19:35:18.344367 drop table if exists "invoice_tag_test"; [] -gorptest: 19:35:18.344391 drop table if exists "alias_trans_field_test"; [] -gorptest: 19:35:18.344406 drop table if exists "invoice_override_test"; [] -gorptest: 19:35:18.344421 drop table if exists "person_test"; [] -gorptest: 19:35:18.344435 drop table if exists "ignored_column_test"; [] -gorptest: 19:35:18.344452 drop table if exists "id_created_test"; [] -gorptest: 19:35:18.344466 drop table if exists "type_conv_test"; [] -gorptest: 19:35:18.344481 drop table if exists "embedded_struct_test"; [] -gorptest: 19:35:18.344499 drop table if exists "embedded_struct_before_autoincr_test"; [] -gorptest: 19:35:18.344513 drop table if exists "embedded_autoincr_test"; [] -gorptest: 19:35:18.344527 drop table if exists "time_test"; [] -gorptest: 19:35:18.344549 create table "invoice_test" ("Id" integer not null primary key autoincrement, "Created" integer, "Updated" integer, "Memo" varchar(255), "PersonId" integer, "IsPaid" integer) ; [] -gorptest: 19:35:18.353844 create table "invoice_tag_test" ("myid" integer not null primary key autoincrement, "myCreated" integer, "date_updated" integer, "Memo" varchar(255), "person_id" integer, "is_Paid" integer) ; [] -gorptest: 19:35:18.364098 create table "alias_trans_field_test" ("id" integer not null primary key autoincrement, "bar" varchar(255)) ; [] -gorptest: 19:35:18.373696 create table "invoice_override_test" ("Id" varchar(255) not null primary key, "Created" integer, "Updated" integer, "Memo" varchar(255), "PersonId" integer, "IsPaid" integer) ; [] -gorptest: 19:35:18.386057 create table "person_test" ("Id" integer not null primary key autoincrement, "Created" integer, "Updated" integer, "FName" varchar(255), "LName" varchar(255), "Version" integer) ; [] -gorptest: 19:35:18.396340 create table "ignored_column_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] -gorptest: 19:35:18.406053 create table "id_created_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] -gorptest: 19:35:18.415983 create table "type_conv_test" ("Id" integer not null primary key autoincrement, "PersonJSON" varchar(255), "Name" varchar(255)) ; [] -gorptest: 19:35:18.426063 create table "embedded_struct_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255)) ; [] -gorptest: 19:35:18.435804 create table "embedded_struct_before_autoincr_test" ("FirstName" varchar(255), "LastName" varchar(255), "Id" integer not null primary key autoincrement) ; [] -gorptest: 19:35:18.446179 create table "embedded_autoincr_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255), "MiddleName" varchar(255)) ; [] -gorptest: 19:35:18.455898 create table "time_test" ("Id" integer not null primary key autoincrement, "Time" datetime) ; [] -gorptest: 19:35:18.464878 insert into "person_test" ("Id","Created","Updated","FName","LName","Version") values (null,?,?,?,?,?); [1:1757964918464860086 2:1757964918464860086 3:"Bob" 4:"Smith" 5:1] -gorptest: 19:35:18.475965 select "Id","Created","Updated","FName","LName","Version" from "person_test" where "Id"=?; [1:1] -gorptest: 19:35:18.476111 update "person_test" set "Created"=?, "Updated"=?, "FName"=?, "LName"=?, "Version"=? where "Id"=? and "Version"=?; [1:1757964918464860086 2:1757964918464860086 3:"preupdate" 4:"Edwards" 5:2 6:1 7:1] -gorptest: 19:35:18.486001 update "person_test" set "Created"=?, "Updated"=?, "FName"=?, "LName"=?, "Version"=? where "Id"=? and "Version"=?; [1:1757964918464860086 2:1757964918464860086 3:"preupdate" 4:"Howard" 5:2 6:1 7:1] -gorptest: 19:35:18.486092 select "Id","Created","Updated","FName","LName","Version" from "person_test" where "Id"=?; [1:1] -gorptest: 19:35:18.486145 delete from "person_test" where "Id"=? and "Version"=?; [1:1 2:1] -gorptest: 19:35:18.486176 select "Id","Created","Updated","FName","LName","Version" from "person_test" where "Id"=?; [1:1] -gorptest: 19:35:18.486206 drop table if exists "invoice_test"; [] -gorptest: 19:35:18.496042 drop table if exists "invoice_tag_test"; [] -gorptest: 19:35:18.508636 drop table if exists "alias_trans_field_test"; [] -gorptest: 19:35:18.520426 drop table if exists "invoice_override_test"; [] -gorptest: 19:35:18.534415 drop table if exists "person_test"; [] -gorptest: 19:35:18.547886 drop table if exists "ignored_column_test"; [] -gorptest: 19:35:18.560233 drop table if exists "id_created_test"; [] -gorptest: 19:35:18.572334 drop table if exists "type_conv_test"; [] -gorptest: 19:35:18.583981 drop table if exists "embedded_struct_test"; [] -gorptest: 19:35:18.595609 drop table if exists "embedded_struct_before_autoincr_test"; [] -gorptest: 19:35:18.607685 drop table if exists "embedded_autoincr_test"; [] -gorptest: 19:35:18.620553 drop table if exists "time_test"; [] -gorptest: 19:35:18.629658 drop table if exists "id_created_test"; [] +2026/10/19 02:00:45 Warning: Automatic mapping of Version struct members to version columns (see optimistic locking) will be deprecated in next version (V2) See: https://github.com/go-gorp/gorp/pull/214 +gorptest: 02:00:45.298947 drop table if exists "invoice_test"; [] +gorptest: 02:00:45.299201 drop table if exists "invoice_tag_test"; [] +gorptest: 02:00:45.299237 drop table if exists "alias_trans_field_test"; [] +gorptest: 02:00:45.299258 drop table if exists "invoice_override_test"; [] +gorptest: 02:00:45.299301 drop table if exists "person_test"; [] +gorptest: 02:00:45.299348 drop table if exists "ignored_column_test"; [] +gorptest: 02:00:45.299402 drop table if exists "id_created_test"; [] +gorptest: 02:00:45.299451 drop table if exists "type_conv_test"; [] +gorptest: 02:00:45.299490 drop table if exists "embedded_struct_test"; [] +gorptest: 02:00:45.299528 drop table if exists "embedded_struct_before_autoincr_test"; [] +gorptest: 02:00:45.299567 drop table if exists "embedded_autoincr_test"; [] +gorptest: 02:00:45.299606 drop table if exists "time_test"; [] +gorptest: 02:00:45.299651 create table "invoice_test" ("Id" integer not null primary key autoincrement, "Created" integer, "Updated" integer, "Memo" varchar(255), "PersonId" integer, "IsPaid" integer) ; [] +gorptest: 02:00:45.308237 create table "invoice_tag_test" ("myid" integer not null primary key autoincrement, "myCreated" integer, "date_updated" integer, "Memo" varchar(255), "person_id" integer, "is_Paid" integer) ; [] +gorptest: 02:00:45.319148 create table "alias_trans_field_test" ("id" integer not null primary key autoincrement, "bar" varchar(255)) ; [] +gorptest: 02:00:45.328597 create table "invoice_override_test" ("Id" varchar(255) not null primary key, "Created" integer, "Updated" integer, "Memo" varchar(255), "PersonId" integer, "IsPaid" integer) ; [] +gorptest: 02:00:45.339970 create table "person_test" ("Id" integer not null primary key autoincrement, "Created" integer, "Updated" integer, "FName" varchar(255), "LName" varchar(255), "Version" integer) ; [] +gorptest: 02:00:45.350834 create table "ignored_column_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] +gorptest: 02:00:45.360179 create table "id_created_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] +gorptest: 02:00:45.371040 create table "type_conv_test" ("Id" integer not null primary key autoincrement, "PersonJSON" varchar(255), "Name" varchar(255)) ; [] +gorptest: 02:00:45.380044 create table "embedded_struct_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255)) ; [] +gorptest: 02:00:45.390207 create table "embedded_struct_before_autoincr_test" ("FirstName" varchar(255), "LastName" varchar(255), "Id" integer not null primary key autoincrement) ; [] +gorptest: 02:00:45.400626 create table "embedded_autoincr_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255), "MiddleName" varchar(255)) ; [] +gorptest: 02:00:45.410226 create table "time_test" ("Id" integer not null primary key autoincrement, "Time" datetime) ; [] +gorptest: 02:00:45.418672 insert into "person_test" ("Id","Created","Updated","FName","LName","Version") values (null,?,?,?,?,?); [1:1792375245418654111 2:1792375245418654111 3:"Bob" 4:"Smith" 5:1] +gorptest: 02:00:45.430166 select "Id","Created","Updated","FName","LName","Version" from "person_test" where "Id"=?; [1:1] +gorptest: 02:00:45.430290 update "person_test" set "Created"=?, "Updated"=?, "FName"=?, "LName"=?, "Version"=? where "Id"=? and "Version"=?; [1:1792375245418654111 2:1792375245418654111 3:"preupdate" 4:"Edwards" 5:2 6:1 7:1] +gorptest: 02:00:45.440408 update "person_test" set "Created"=?, "Updated"=?, "FName"=?, "LName"=?, "Version"=? where "Id"=? and "Version"=?; [1:1792375245418654111 2:1792375245418654111 3:"preupdate" 4:"Howard" 5:2 6:1 7:1] +gorptest: 02:00:45.440514 select "Id","Created","Updated","FName","LName","Version" from "person_test" where "Id"=?; [1:1] +gorptest: 02:00:45.440625 delete from "person_test" where "Id"=? and "Version"=?; [1:1 2:1] +gorptest: 02:00:45.440704 select "Id","Created","Updated","FName","LName","Version" from "person_test" where "Id"=?; [1:1] +gorptest: 02:00:45.440781 drop table if exists "invoice_test"; [] +gorptest: 02:00:45.450265 drop table if exists "invoice_tag_test"; [] +gorptest: 02:00:45.462368 drop table if exists "alias_trans_field_test"; [] +gorptest: 02:00:45.474977 drop table if exists "invoice_override_test"; [] +gorptest: 02:00:45.488267 drop table if exists "person_test"; [] +gorptest: 02:00:45.505512 drop table if exists "ignored_column_test"; [] +gorptest: 02:00:45.514219 drop table if exists "id_created_test"; [] +gorptest: 02:00:45.525997 drop table if exists "type_conv_test"; [] +gorptest: 02:00:45.538825 drop table if exists "embedded_struct_test"; [] +gorptest: 02:00:45.551401 drop table if exists "embedded_struct_before_autoincr_test"; [] +gorptest: 02:00:45.567907 drop table if exists "embedded_autoincr_test"; [] +gorptest: 02:00:45.574765 drop table if exists "time_test"; [] +gorptest: 02:00:45.584425 drop table if exists "id_created_test"; [] --- PASS: TestOptimisticLocking (0.29s) === RUN TestDoubleAddTable --- PASS: TestDoubleAddTable (0.00s) === RUN TestNullValues -gorptest: 19:35:18.629847 create table "TableWithNull" ("Id" integer not null primary key, "Str" varchar(255), "Int64" integer, "Float64" real, "Bool" integer, "Bytes" blob) ; [] -gorptest: 19:35:18.640297 insert into TableWithNull values (10, null, null, null, null, null) [] -gorptest: 19:35:18.648223 select "Id","Str","Int64","Float64","Bool","Bytes" from "TableWithNull" where "Id"=?; [1:10] -gorptest: 19:35:18.648355 update "TableWithNull" set "Id"=?, "Str"=?, "Int64"=?, "Float64"=?, "Bool"=?, "Bytes"=? where "Id"=?; [1:10 2:"hi" 3:999 4:53.33 5:true 6:[1 30 31 33] 7:10] -gorptest: 19:35:18.655913 select "Id","Str","Int64","Float64","Bool","Bytes" from "TableWithNull" where "Id"=?; [1:10] -gorptest: 19:35:18.655984 drop table if exists "TableWithNull"; [] +gorptest: 02:00:45.584811 create table "TableWithNull" ("Id" integer not null primary key, "Str" varchar(255), "Int64" integer, "Float64" real, "Bool" integer, "Bytes" blob) ; [] +gorptest: 02:00:45.595082 insert into TableWithNull values (10, null, null, null, null, null) [] +gorptest: 02:00:45.602488 select "Id","Str","Int64","Float64","Bool","Bytes" from "TableWithNull" where "Id"=?; [1:10] +gorptest: 02:00:45.602667 update "TableWithNull" set "Id"=?, "Str"=?, "Int64"=?, "Float64"=?, "Bool"=?, "Bytes"=? where "Id"=?; [1:10 2:"hi" 3:999 4:53.33 5:true 6:[1 30 31 33] 7:10] +gorptest: 02:00:45.610706 select "Id","Str","Int64","Float64","Bool","Bytes" from "TableWithNull" where "Id"=?; [1:10] +gorptest: 02:00:45.610806 drop table if exists "TableWithNull"; [] --- PASS: TestNullValues (0.04s) === RUN TestColumnProps -gorptest: 19:35:18.666500 create table "Invoice" ("Id" integer not null primary key autoincrement, "date_created" integer, "Memo" varchar(10), "PersonId" integer unique, "IsPaid" integer) ; [] -gorptest: 19:35:18.677874 insert into "Invoice" ("Id","date_created","Memo","PersonId","IsPaid") values (null,?,?,?,?); [1:0 2:"my invoice" 3:0 4:true] -gorptest: 19:35:18.687984 select "Id","date_created","Memo","PersonId","IsPaid" from "Invoice" where "Id"=?; [1:1] -gorptest: 19:35:18.688095 insert into "Invoice" ("Id","date_created","Memo","PersonId","IsPaid") values (null,?,?,?,?); [1:0 2:"this memo is too long" 3:0 4:true] -gorptest: 19:35:18.688148 insert into "Invoice" ("Id","date_created","Memo","PersonId","IsPaid") values (null,?,?,?,?); [1:0 2:"my invoice2" 3:0 4:false] -gorptest: 19:35:18.688179 drop table if exists "Invoice"; [] +gorptest: 02:00:45.620471 create table "Invoice" ("Id" integer not null primary key autoincrement, "date_created" integer, "Memo" varchar(10), "PersonId" integer unique, "IsPaid" integer) ; [] +gorptest: 02:00:45.632909 insert into "Invoice" ("Id","date_created","Memo","PersonId","IsPaid") values (null,?,?,?,?); [1:0 2:"my invoice" 3:0 4:true] +gorptest: 02:00:45.642808 select "Id","date_created","Memo","PersonId","IsPaid" from "Invoice" where "Id"=?; [1:1] +gorptest: 02:00:45.642939 insert into "Invoice" ("Id","date_created","Memo","PersonId","IsPaid") values (null,?,?,?,?); [1:0 2:"this memo is too long" 3:0 4:true] +gorptest: 02:00:45.643032 insert into "Invoice" ("Id","date_created","Memo","PersonId","IsPaid") values (null,?,?,?,?); [1:0 2:"my invoice2" 3:0 4:false] +gorptest: 02:00:45.643107 drop table if exists "Invoice"; [] --- PASS: TestColumnProps (0.03s) === RUN TestRawSelect -2025/09/15 19:35:18 Warning: Automatic mapping of Version struct members to version columns (see optimistic locking) will be deprecated in next version (V2) See: https://github.com/go-gorp/gorp/pull/214 -gorptest: 19:35:18.700417 drop table if exists "invoice_test"; [] -gorptest: 19:35:18.700634 drop table if exists "invoice_tag_test"; [] -gorptest: 19:35:18.700656 drop table if exists "alias_trans_field_test"; [] -gorptest: 19:35:18.700671 drop table if exists "invoice_override_test"; [] -gorptest: 19:35:18.700684 drop table if exists "person_test"; [] -gorptest: 19:35:18.700701 drop table if exists "ignored_column_test"; [] -gorptest: 19:35:18.700734 drop table if exists "id_created_test"; [] -gorptest: 19:35:18.700751 drop table if exists "type_conv_test"; [] -gorptest: 19:35:18.700764 drop table if exists "embedded_struct_test"; [] -gorptest: 19:35:18.700779 drop table if exists "embedded_struct_before_autoincr_test"; [] -gorptest: 19:35:18.700792 drop table if exists "embedded_autoincr_test"; [] -gorptest: 19:35:18.700808 drop table if exists "time_test"; [] -gorptest: 19:35:18.700848 create table "invoice_test" ("Id" integer not null primary key autoincrement, "Created" integer, "Updated" integer, "Memo" varchar(255), "PersonId" integer, "IsPaid" integer) ; [] -gorptest: 19:35:18.709943 create table "invoice_tag_test" ("myid" integer not null primary key autoincrement, "myCreated" integer, "date_updated" integer, "Memo" varchar(255), "person_id" integer, "is_Paid" integer) ; [] -gorptest: 19:35:18.721794 create table "alias_trans_field_test" ("id" integer not null primary key autoincrement, "bar" varchar(255)) ; [] -gorptest: 19:35:18.733798 create table "invoice_override_test" ("Id" varchar(255) not null primary key, "Created" integer, "Updated" integer, "Memo" varchar(255), "PersonId" integer, "IsPaid" integer) ; [] -gorptest: 19:35:18.748406 create table "person_test" ("Id" integer not null primary key autoincrement, "Created" integer, "Updated" integer, "FName" varchar(255), "LName" varchar(255), "Version" integer) ; [] -gorptest: 19:35:18.760585 create table "ignored_column_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] -gorptest: 19:35:18.772233 create table "id_created_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] -gorptest: 19:35:18.784363 create table "type_conv_test" ("Id" integer not null primary key autoincrement, "PersonJSON" varchar(255), "Name" varchar(255)) ; [] -gorptest: 19:35:18.795843 create table "embedded_struct_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255)) ; [] -gorptest: 19:35:18.808120 create table "embedded_struct_before_autoincr_test" ("FirstName" varchar(255), "LastName" varchar(255), "Id" integer not null primary key autoincrement) ; [] -gorptest: 19:35:18.820582 create table "embedded_autoincr_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255), "MiddleName" varchar(255)) ; [] -gorptest: 19:35:18.831767 create table "time_test" ("Id" integer not null primary key autoincrement, "Time" datetime) ; [] -gorptest: 19:35:18.841490 insert into "person_test" ("Id","Created","Updated","FName","LName","Version") values (null,?,?,?,?,?); [1:1757964918841475428 2:1757964918841475428 3:"bob" 4:"smith" 5:1] -gorptest: 19:35:18.854621 insert into "invoice_test" ("Id","Created","Updated","Memo","PersonId","IsPaid") values (null,?,?,?,?,?); [1:0 2:0 3:"xmas order" 4:1 5:true] -gorptest: 19:35:18.862091 select i.Id InvoiceId, p.Id PersonId, i.Memo, p.FName from invoice_test i, person_test p where i.PersonId = p.Id [] -gorptest: 19:35:18.862234 drop table if exists "invoice_test"; [] -gorptest: 19:35:18.870238 drop table if exists "invoice_tag_test"; [] -gorptest: 19:35:18.880214 drop table if exists "alias_trans_field_test"; [] -gorptest: 19:35:18.890590 drop table if exists "invoice_override_test"; [] -gorptest: 19:35:18.902233 drop table if exists "person_test"; [] -gorptest: 19:35:18.911866 drop table if exists "ignored_column_test"; [] -gorptest: 19:35:18.922475 drop table if exists "id_created_test"; [] -gorptest: 19:35:18.932370 drop table if exists "type_conv_test"; [] -gorptest: 19:35:18.942467 drop table if exists "embedded_struct_test"; [] -gorptest: 19:35:18.951679 drop table if exists "embedded_struct_before_autoincr_test"; [] -gorptest: 19:35:18.962130 drop table if exists "embedded_autoincr_test"; [] -gorptest: 19:35:18.972506 drop table if exists "time_test"; [] -gorptest: 19:35:18.981886 drop table if exists "id_created_test"; [] ---- PASS: TestRawSelect (0.28s) +2026/10/19 02:00:45 Warning: Automatic mapping of Version struct members to version columns (see optimistic locking) will be deprecated in next version (V2) See: https://github.com/go-gorp/gorp/pull/214 +gorptest: 02:00:45.654806 drop table if exists "invoice_test"; [] +gorptest: 02:00:45.654996 drop table if exists "invoice_tag_test"; [] +gorptest: 02:00:45.655044 drop table if exists "alias_trans_field_test"; [] +gorptest: 02:00:45.655065 drop table if exists "invoice_override_test"; [] +gorptest: 02:00:45.655090 drop table if exists "person_test"; [] +gorptest: 02:00:45.655113 drop table if exists "ignored_column_test"; [] +gorptest: 02:00:45.655137 drop table if exists "id_created_test"; [] +gorptest: 02:00:45.655160 drop table if exists "type_conv_test"; [] +gorptest: 02:00:45.655182 drop table if exists "embedded_struct_test"; [] +gorptest: 02:00:45.655204 drop table if exists "embedded_struct_before_autoincr_test"; [] +gorptest: 02:00:45.655228 drop table if exists "embedded_autoincr_test"; [] +gorptest: 02:00:45.655246 drop table if exists "time_test"; [] +gorptest: 02:00:45.655273 create table "invoice_test" ("Id" integer not null primary key autoincrement, "Created" integer, "Updated" integer, "Memo" varchar(255), "PersonId" integer, "IsPaid" integer) ; [] +gorptest: 02:00:45.664655 create table "invoice_tag_test" ("myid" integer not null primary key autoincrement, "myCreated" integer, "date_updated" integer, "Memo" varchar(255), "person_id" integer, "is_Paid" integer) ; [] +gorptest: 02:00:45.676545 create table "alias_trans_field_test" ("id" integer not null primary key autoincrement, "bar" varchar(255)) ; [] +gorptest: 02:00:45.688483 create table "invoice_override_test" ("Id" varchar(255) not null primary key, "Created" integer, "Updated" integer, "Memo" varchar(255), "PersonId" integer, "IsPaid" integer) ; [] +gorptest: 02:00:45.702853 create table "person_test" ("Id" integer not null primary key autoincrement, "Created" integer, "Updated" integer, "FName" varchar(255), "LName" varchar(255), "Version" integer) ; [] +gorptest: 02:00:45.714905 create table "ignored_column_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] +gorptest: 02:00:45.727067 create table "id_created_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] +gorptest: 02:00:45.738134 create table "type_conv_test" ("Id" integer not null primary key autoincrement, "PersonJSON" varchar(255), "Name" varchar(255)) ; [] +gorptest: 02:00:45.750159 create table "embedded_struct_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255)) ; [] +gorptest: 02:00:45.762395 create table "embedded_struct_before_autoincr_test" ("FirstName" varchar(255), "LastName" varchar(255), "Id" integer not null primary key autoincrement) ; [] +gorptest: 02:00:45.774838 create table "embedded_autoincr_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255), "MiddleName" varchar(255)) ; [] +gorptest: 02:00:45.786895 create table "time_test" ("Id" integer not null primary key autoincrement, "Time" datetime) ; [] +gorptest: 02:00:45.797158 insert into "person_test" ("Id","Created","Updated","FName","LName","Version") values (null,?,?,?,?,?); [1:1792375245797032080 2:1792375245797032080 3:"bob" 4:"smith" 5:1] +gorptest: 02:00:45.809154 insert into "invoice_test" ("Id","Created","Updated","Memo","PersonId","IsPaid") values (null,?,?,?,?,?); [1:0 2:0 3:"xmas order" 4:1 5:true] +gorptest: 02:00:45.817446 select i.Id InvoiceId, p.Id PersonId, i.Memo, p.FName from invoice_test i, person_test p where i.PersonId = p.Id [] +gorptest: 02:00:45.817559 drop table if exists "invoice_test"; [] +gorptest: 02:00:45.825486 drop table if exists "invoice_tag_test"; [] +gorptest: 02:00:45.834945 drop table if exists "alias_trans_field_test"; [] +gorptest: 02:00:45.844617 drop table if exists "invoice_override_test"; [] +gorptest: 02:00:45.855948 drop table if exists "person_test"; [] +gorptest: 02:00:45.866630 drop table if exists "ignored_column_test"; [] +gorptest: 02:00:45.877154 drop table if exists "id_created_test"; [] +gorptest: 02:00:45.886840 drop table if exists "type_conv_test"; [] +gorptest: 02:00:45.896971 drop table if exists "embedded_struct_test"; [] +gorptest: 02:00:45.906231 drop table if exists "embedded_struct_before_autoincr_test"; [] +gorptest: 02:00:45.916104 drop table if exists "embedded_autoincr_test"; [] +gorptest: 02:00:45.926255 drop table if exists "time_test"; [] +gorptest: 02:00:45.942606 drop table if exists "id_created_test"; [] +--- PASS: TestRawSelect (0.29s) === RUN TestHooks -2025/09/15 19:35:18 Warning: Automatic mapping of Version struct members to version columns (see optimistic locking) will be deprecated in next version (V2) See: https://github.com/go-gorp/gorp/pull/214 -gorptest: 19:35:18.982100 drop table if exists "invoice_test"; [] -gorptest: 19:35:18.982266 drop table if exists "invoice_tag_test"; [] -gorptest: 19:35:18.982288 drop table if exists "alias_trans_field_test"; [] -gorptest: 19:35:18.982302 drop table if exists "invoice_override_test"; [] -gorptest: 19:35:18.982315 drop table if exists "person_test"; [] -gorptest: 19:35:18.982332 drop table if exists "ignored_column_test"; [] -gorptest: 19:35:18.982345 drop table if exists "id_created_test"; [] -gorptest: 19:35:18.982361 drop table if exists "type_conv_test"; [] -gorptest: 19:35:18.982374 drop table if exists "embedded_struct_test"; [] -gorptest: 19:35:18.982390 drop table if exists "embedded_struct_before_autoincr_test"; [] -gorptest: 19:35:18.982404 drop table if exists "embedded_autoincr_test"; [] -gorptest: 19:35:18.982417 drop table if exists "time_test"; [] -gorptest: 19:35:18.982440 create table "invoice_test" ("Id" integer not null primary key autoincrement, "Created" integer, "Updated" integer, "Memo" varchar(255), "PersonId" integer, "IsPaid" integer) ; [] -gorptest: 19:35:18.992488 create table "invoice_tag_test" ("myid" integer not null primary key autoincrement, "myCreated" integer, "date_updated" integer, "Memo" varchar(255), "person_id" integer, "is_Paid" integer) ; [] -gorptest: 19:35:19.002456 create table "alias_trans_field_test" ("id" integer not null primary key autoincrement, "bar" varchar(255)) ; [] -gorptest: 19:35:19.011801 create table "invoice_override_test" ("Id" varchar(255) not null primary key, "Created" integer, "Updated" integer, "Memo" varchar(255), "PersonId" integer, "IsPaid" integer) ; [] -gorptest: 19:35:19.023788 create table "person_test" ("Id" integer not null primary key autoincrement, "Created" integer, "Updated" integer, "FName" varchar(255), "LName" varchar(255), "Version" integer) ; [] -gorptest: 19:35:19.033951 create table "ignored_column_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] -gorptest: 19:35:19.044195 create table "id_created_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] -gorptest: 19:35:19.053915 create table "type_conv_test" ("Id" integer not null primary key autoincrement, "PersonJSON" varchar(255), "Name" varchar(255)) ; [] -gorptest: 19:35:19.063958 create table "embedded_struct_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255)) ; [] -gorptest: 19:35:19.074543 create table "embedded_struct_before_autoincr_test" ("FirstName" varchar(255), "LastName" varchar(255), "Id" integer not null primary key autoincrement) ; [] -gorptest: 19:35:19.083849 create table "embedded_autoincr_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255), "MiddleName" varchar(255)) ; [] -gorptest: 19:35:19.093562 create table "time_test" ("Id" integer not null primary key autoincrement, "Time" datetime) ; [] -gorptest: 19:35:19.101683 insert into "person_test" ("Id","Created","Updated","FName","LName","Version") values (null,?,?,?,?,?); [1:1757964919101642688 2:1757964919101642688 3:"bob" 4:"smith" 5:1] -gorptest: 19:35:19.114321 select "Id","Created","Updated","FName","LName","Version" from "person_test" where "Id"=?; [1:1] -gorptest: 19:35:19.114416 update "person_test" set "Created"=?, "Updated"=?, "FName"=?, "LName"=?, "Version"=? where "Id"=? and "Version"=?; [1:1757964919101642688 2:1757964919101642688 3:"preupdate" 4:"postget" 5:2 6:1 7:1] -gorptest: 19:35:19.124534 select * from person_test where id = ? [1:1] -gorptest: 19:35:19.124637 delete from "person_test" where "Id"=? and "Version"=?; [1:1 2:2] -gorptest: 19:35:19.134412 drop table if exists "invoice_test"; [] -gorptest: 19:35:19.144282 drop table if exists "invoice_tag_test"; [] -gorptest: 19:35:19.155987 drop table if exists "alias_trans_field_test"; [] -gorptest: 19:35:19.167729 drop table if exists "invoice_override_test"; [] -gorptest: 19:35:19.182588 drop table if exists "person_test"; [] -gorptest: 19:35:19.196273 drop table if exists "ignored_column_test"; [] -gorptest: 19:35:19.208543 drop table if exists "id_created_test"; [] -gorptest: 19:35:19.219832 drop table if exists "type_conv_test"; [] -gorptest: 19:35:19.232484 drop table if exists "embedded_struct_test"; [] -gorptest: 19:35:19.244540 drop table if exists "embedded_struct_before_autoincr_test"; [] -gorptest: 19:35:19.256240 drop table if exists "embedded_autoincr_test"; [] -gorptest: 19:35:19.268073 drop table if exists "time_test"; [] -gorptest: 19:35:19.277454 drop table if exists "id_created_test"; [] ---- PASS: TestHooks (0.30s) +2026/10/19 02:00:45 Warning: Automatic mapping of Version struct members to version columns (see optimistic locking) will be deprecated in next version (V2) See: https://github.com/go-gorp/gorp/pull/214 +gorptest: 02:00:45.942822 drop table if exists "invoice_test"; [] +gorptest: 02:00:45.943007 drop table if exists "invoice_tag_test"; [] +gorptest: 02:00:45.943054 drop table if exists "alias_trans_field_test"; [] +gorptest: 02:00:45.943077 drop table if exists "invoice_override_test"; [] +gorptest: 02:00:45.943101 drop table if exists "person_test"; [] +gorptest: 02:00:45.943124 drop table if exists "ignored_column_test"; [] +gorptest: 02:00:45.943141 drop table if exists "id_created_test"; [] +gorptest: 02:00:45.943162 drop table if exists "type_conv_test"; [] +gorptest: 02:00:45.943179 drop table if exists "embedded_struct_test"; [] +gorptest: 02:00:45.943200 drop table if exists "embedded_struct_before_autoincr_test"; [] +gorptest: 02:00:45.943224 drop table if exists "embedded_autoincr_test"; [] +gorptest: 02:00:45.943244 drop table if exists "time_test"; [] +gorptest: 02:00:45.943276 create table "invoice_test" ("Id" integer not null primary key autoincrement, "Created" integer, "Updated" integer, "Memo" varchar(255), "PersonId" integer, "IsPaid" integer) ; [] +gorptest: 02:00:45.948738 create table "invoice_tag_test" ("myid" integer not null primary key autoincrement, "myCreated" integer, "date_updated" integer, "Memo" varchar(255), "person_id" integer, "is_Paid" integer) ; [] +gorptest: 02:00:45.959012 create table "alias_trans_field_test" ("id" integer not null primary key autoincrement, "bar" varchar(255)) ; [] +gorptest: 02:00:45.971753 create table "invoice_override_test" ("Id" varchar(255) not null primary key, "Created" integer, "Updated" integer, "Memo" varchar(255), "PersonId" integer, "IsPaid" integer) ; [] +gorptest: 02:00:45.979020 create table "person_test" ("Id" integer not null primary key autoincrement, "Created" integer, "Updated" integer, "FName" varchar(255), "LName" varchar(255), "Version" integer) ; [] +gorptest: 02:00:45.988889 create table "ignored_column_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] +gorptest: 02:00:45.998304 create table "id_created_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] +gorptest: 02:00:46.009418 create table "type_conv_test" ("Id" integer not null primary key autoincrement, "PersonJSON" varchar(255), "Name" varchar(255)) ; [] +gorptest: 02:00:46.018936 create table "embedded_struct_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255)) ; [] +gorptest: 02:00:46.028738 create table "embedded_struct_before_autoincr_test" ("FirstName" varchar(255), "LastName" varchar(255), "Id" integer not null primary key autoincrement) ; [] +gorptest: 02:00:46.038878 create table "embedded_autoincr_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255), "MiddleName" varchar(255)) ; [] +gorptest: 02:00:46.048618 create table "time_test" ("Id" integer not null primary key autoincrement, "Time" datetime) ; [] +gorptest: 02:00:46.056638 insert into "person_test" ("Id","Created","Updated","FName","LName","Version") values (null,?,?,?,?,?); [1:1792375246056624585 2:1792375246056624585 3:"bob" 4:"smith" 5:1] +gorptest: 02:00:46.071665 select "Id","Created","Updated","FName","LName","Version" from "person_test" where "Id"=?; [1:1] +gorptest: 02:00:46.071818 update "person_test" set "Created"=?, "Updated"=?, "FName"=?, "LName"=?, "Version"=? where "Id"=? and "Version"=?; [1:1792375246056624585 2:1792375246056624585 3:"preupdate" 4:"postget" 5:2 6:1 7:1] +gorptest: 02:00:46.078461 select * from person_test where id = ? [1:1] +gorptest: 02:00:46.078629 delete from "person_test" where "Id"=? and "Version"=?; [1:1 2:2] +gorptest: 02:00:46.088718 drop table if exists "invoice_test"; [] +gorptest: 02:00:46.098790 drop table if exists "invoice_tag_test"; [] +gorptest: 02:00:46.111041 drop table if exists "alias_trans_field_test"; [] +gorptest: 02:00:46.122868 drop table if exists "invoice_override_test"; [] +gorptest: 02:00:46.136793 drop table if exists "person_test"; [] +gorptest: 02:00:46.150103 drop table if exists "ignored_column_test"; [] +gorptest: 02:00:46.162251 drop table if exists "id_created_test"; [] +gorptest: 02:00:46.174924 drop table if exists "type_conv_test"; [] +gorptest: 02:00:46.186345 drop table if exists "embedded_struct_test"; [] +gorptest: 02:00:46.198698 drop table if exists "embedded_struct_before_autoincr_test"; [] +gorptest: 02:00:46.210594 drop table if exists "embedded_autoincr_test"; [] +gorptest: 02:00:46.222580 drop table if exists "time_test"; [] +gorptest: 02:00:46.232605 drop table if exists "id_created_test"; [] +--- PASS: TestHooks (0.29s) === RUN TestTransaction -2025/09/15 19:35:19 Warning: Automatic mapping of Version struct members to version columns (see optimistic locking) will be deprecated in next version (V2) See: https://github.com/go-gorp/gorp/pull/214 -gorptest: 19:35:19.277715 drop table if exists "invoice_test"; [] -gorptest: 19:35:19.278120 drop table if exists "invoice_tag_test"; [] -gorptest: 19:35:19.278143 drop table if exists "alias_trans_field_test"; [] -gorptest: 19:35:19.278157 drop table if exists "invoice_override_test"; [] -gorptest: 19:35:19.278174 drop table if exists "person_test"; [] -gorptest: 19:35:19.278200 drop table if exists "ignored_column_test"; [] -gorptest: 19:35:19.278214 drop table if exists "id_created_test"; [] -gorptest: 19:35:19.278232 drop table if exists "type_conv_test"; [] -gorptest: 19:35:19.278246 drop table if exists "embedded_struct_test"; [] -gorptest: 19:35:19.278265 drop table if exists "embedded_struct_before_autoincr_test"; [] -gorptest: 19:35:19.278279 drop table if exists "embedded_autoincr_test"; [] -gorptest: 19:35:19.278294 drop table if exists "time_test"; [] -gorptest: 19:35:19.278315 create table "invoice_test" ("Id" integer not null primary key autoincrement, "Created" integer, "Updated" integer, "Memo" varchar(255), "PersonId" integer, "IsPaid" integer) ; [] -gorptest: 19:35:19.287679 create table "invoice_tag_test" ("myid" integer not null primary key autoincrement, "myCreated" integer, "date_updated" integer, "Memo" varchar(255), "person_id" integer, "is_Paid" integer) ; [] -gorptest: 19:35:19.299593 create table "alias_trans_field_test" ("id" integer not null primary key autoincrement, "bar" varchar(255)) ; [] -gorptest: 19:35:19.311899 create table "invoice_override_test" ("Id" varchar(255) not null primary key, "Created" integer, "Updated" integer, "Memo" varchar(255), "PersonId" integer, "IsPaid" integer) ; [] -gorptest: 19:35:19.325828 create table "person_test" ("Id" integer not null primary key autoincrement, "Created" integer, "Updated" integer, "FName" varchar(255), "LName" varchar(255), "Version" integer) ; [] -gorptest: 19:35:19.338204 create table "ignored_column_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] -gorptest: 19:35:19.350236 create table "id_created_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] -gorptest: 19:35:19.362576 create table "type_conv_test" ("Id" integer not null primary key autoincrement, "PersonJSON" varchar(255), "Name" varchar(255)) ; [] -gorptest: 19:35:19.373817 create table "embedded_struct_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255)) ; [] -gorptest: 19:35:19.386600 create table "embedded_struct_before_autoincr_test" ("FirstName" varchar(255), "LastName" varchar(255), "Id" integer not null primary key autoincrement) ; [] -gorptest: 19:35:19.397613 create table "embedded_autoincr_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255), "MiddleName" varchar(255)) ; [] -gorptest: 19:35:19.410772 create table "time_test" ("Id" integer not null primary key autoincrement, "Time" datetime) ; [] -gorptest: 19:35:19.420327 begin; [] -gorptest: 19:35:19.420373 insert into "invoice_test" ("Id","Created","Updated","Memo","PersonId","IsPaid") values (null,?,?,?,?,?); [1:100 2:200 3:"t1" 4:0 5:true] -gorptest: 19:35:19.420484 insert into "invoice_test" ("Id","Created","Updated","Memo","PersonId","IsPaid") values (null,?,?,?,?,?); [1:100 2:200 3:"t2" 4:0 5:false] -gorptest: 19:35:19.420510 commit; [] -gorptest: 19:35:19.428531 select "Id","Created","Updated","Memo","PersonId","IsPaid" from "invoice_test" where "Id"=?; [1:1] -gorptest: 19:35:19.428605 select "Id","Created","Updated","Memo","PersonId","IsPaid" from "invoice_test" where "Id"=?; [1:2] -gorptest: 19:35:19.428641 drop table if exists "invoice_test"; [] -gorptest: 19:35:19.436276 drop table if exists "invoice_tag_test"; [] -gorptest: 19:35:19.446073 drop table if exists "alias_trans_field_test"; [] -gorptest: 19:35:19.456279 drop table if exists "invoice_override_test"; [] -gorptest: 19:35:19.468282 drop table if exists "person_test"; [] -gorptest: 19:35:19.477970 drop table if exists "ignored_column_test"; [] -gorptest: 19:35:19.488204 drop table if exists "id_created_test"; [] -gorptest: 19:35:19.498206 drop table if exists "type_conv_test"; [] -gorptest: 19:35:19.508219 drop table if exists "embedded_struct_test"; [] -gorptest: 19:35:19.518352 drop table if exists "embedded_struct_before_autoincr_test"; [] -gorptest: 19:35:19.528671 drop table if exists "embedded_autoincr_test"; [] -gorptest: 19:35:19.537700 drop table if exists "time_test"; [] -gorptest: 19:35:19.547458 drop table if exists "id_created_test"; [] +2026/10/19 02:00:46 Warning: Automatic mapping of Version struct members to version columns (see optimistic locking) will be deprecated in next version (V2) See: https://github.com/go-gorp/gorp/pull/214 +gorptest: 02:00:46.232962 drop table if exists "invoice_test"; [] +gorptest: 02:00:46.233322 drop table if exists "invoice_tag_test"; [] +gorptest: 02:00:46.233370 drop table if exists "alias_trans_field_test"; [] +gorptest: 02:00:46.233389 drop table if exists "invoice_override_test"; [] +gorptest: 02:00:46.233406 drop table if exists "person_test"; [] +gorptest: 02:00:46.233438 drop table if exists "ignored_column_test"; [] +gorptest: 02:00:46.233463 drop table if exists "id_created_test"; [] +gorptest: 02:00:46.233484 drop table if exists "type_conv_test"; [] +gorptest: 02:00:46.233505 drop table if exists "embedded_struct_test"; [] +gorptest: 02:00:46.233528 drop table if exists "embedded_struct_before_autoincr_test"; [] +gorptest: 02:00:46.233549 drop table if exists "embedded_autoincr_test"; [] +gorptest: 02:00:46.233569 drop table if exists "time_test"; [] +gorptest: 02:00:46.233598 create table "invoice_test" ("Id" integer not null primary key autoincrement, "Created" integer, "Updated" integer, "Memo" varchar(255), "PersonId" integer, "IsPaid" integer) ; [] +gorptest: 02:00:46.242632 create table "invoice_tag_test" ("myid" integer not null primary key autoincrement, "myCreated" integer, "date_updated" integer, "Memo" varchar(255), "person_id" integer, "is_Paid" integer) ; [] +gorptest: 02:00:46.255310 create table "alias_trans_field_test" ("id" integer not null primary key autoincrement, "bar" varchar(255)) ; [] +gorptest: 02:00:46.266317 create table "invoice_override_test" ("Id" varchar(255) not null primary key, "Created" integer, "Updated" integer, "Memo" varchar(255), "PersonId" integer, "IsPaid" integer) ; [] +gorptest: 02:00:46.280508 create table "person_test" ("Id" integer not null primary key autoincrement, "Created" integer, "Updated" integer, "FName" varchar(255), "LName" varchar(255), "Version" integer) ; [] +gorptest: 02:00:46.292639 create table "ignored_column_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] +gorptest: 02:00:46.304993 create table "id_created_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] +gorptest: 02:00:46.316934 create table "type_conv_test" ("Id" integer not null primary key autoincrement, "PersonJSON" varchar(255), "Name" varchar(255)) ; [] +gorptest: 02:00:46.328372 create table "embedded_struct_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255)) ; [] +gorptest: 02:00:46.340553 create table "embedded_struct_before_autoincr_test" ("FirstName" varchar(255), "LastName" varchar(255), "Id" integer not null primary key autoincrement) ; [] +gorptest: 02:00:46.352480 create table "embedded_autoincr_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255), "MiddleName" varchar(255)) ; [] +gorptest: 02:00:46.364860 create table "time_test" ("Id" integer not null primary key autoincrement, "Time" datetime) ; [] +gorptest: 02:00:46.374924 begin; [] +gorptest: 02:00:46.375091 insert into "invoice_test" ("Id","Created","Updated","Memo","PersonId","IsPaid") values (null,?,?,?,?,?); [1:100 2:200 3:"t1" 4:0 5:true] +gorptest: 02:00:46.375347 insert into "invoice_test" ("Id","Created","Updated","Memo","PersonId","IsPaid") values (null,?,?,?,?,?); [1:100 2:200 3:"t2" 4:0 5:false] +gorptest: 02:00:46.375419 commit; [] +gorptest: 02:00:46.382853 select "Id","Created","Updated","Memo","PersonId","IsPaid" from "invoice_test" where "Id"=?; [1:1] +gorptest: 02:00:46.382976 select "Id","Created","Updated","Memo","PersonId","IsPaid" from "invoice_test" where "Id"=?; [1:2] +gorptest: 02:00:46.383057 drop table if exists "invoice_test"; [] +gorptest: 02:00:46.392499 drop table if exists "invoice_tag_test"; [] +gorptest: 02:00:46.400680 drop table if exists "alias_trans_field_test"; [] +gorptest: 02:00:46.410489 drop table if exists "invoice_override_test"; [] +gorptest: 02:00:46.422200 drop table if exists "person_test"; [] +gorptest: 02:00:46.432318 drop table if exists "ignored_column_test"; [] +gorptest: 02:00:46.442702 drop table if exists "id_created_test"; [] +gorptest: 02:00:46.452957 drop table if exists "type_conv_test"; [] +gorptest: 02:00:46.462516 drop table if exists "embedded_struct_test"; [] +gorptest: 02:00:46.472508 drop table if exists "embedded_struct_before_autoincr_test"; [] +gorptest: 02:00:46.482096 drop table if exists "embedded_autoincr_test"; [] +gorptest: 02:00:46.492222 drop table if exists "time_test"; [] +gorptest: 02:00:46.502419 drop table if exists "id_created_test"; [] --- PASS: TestTransaction (0.27s) === RUN TestSavepoint -2025/09/15 19:35:19 Warning: Automatic mapping of Version struct members to version columns (see optimistic locking) will be deprecated in next version (V2) See: https://github.com/go-gorp/gorp/pull/214 -gorptest: 19:35:19.547705 drop table if exists "invoice_test"; [] -gorptest: 19:35:19.547887 drop table if exists "invoice_tag_test"; [] -gorptest: 19:35:19.547910 drop table if exists "alias_trans_field_test"; [] -gorptest: 19:35:19.547924 drop table if exists "invoice_override_test"; [] -gorptest: 19:35:19.547942 drop table if exists "person_test"; [] -gorptest: 19:35:19.547956 drop table if exists "ignored_column_test"; [] -gorptest: 19:35:19.547970 drop table if exists "id_created_test"; [] -gorptest: 19:35:19.547984 drop table if exists "type_conv_test"; [] -gorptest: 19:35:19.548002 drop table if exists "embedded_struct_test"; [] -gorptest: 19:35:19.548017 drop table if exists "embedded_struct_before_autoincr_test"; [] -gorptest: 19:35:19.548034 drop table if exists "embedded_autoincr_test"; [] -gorptest: 19:35:19.548048 drop table if exists "time_test"; [] -gorptest: 19:35:19.548068 create table "invoice_test" ("Id" integer not null primary key autoincrement, "Created" integer, "Updated" integer, "Memo" varchar(255), "PersonId" integer, "IsPaid" integer) ; [] -gorptest: 19:35:19.557722 create table "invoice_tag_test" ("myid" integer not null primary key autoincrement, "myCreated" integer, "date_updated" integer, "Memo" varchar(255), "person_id" integer, "is_Paid" integer) ; [] -gorptest: 19:35:19.568390 create table "alias_trans_field_test" ("id" integer not null primary key autoincrement, "bar" varchar(255)) ; [] -gorptest: 19:35:19.578195 create table "invoice_override_test" ("Id" varchar(255) not null primary key, "Created" integer, "Updated" integer, "Memo" varchar(255), "PersonId" integer, "IsPaid" integer) ; [] -gorptest: 19:35:19.590007 create table "person_test" ("Id" integer not null primary key autoincrement, "Created" integer, "Updated" integer, "FName" varchar(255), "LName" varchar(255), "Version" integer) ; [] -gorptest: 19:35:19.599682 create table "ignored_column_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] -gorptest: 19:35:19.609856 create table "id_created_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] -gorptest: 19:35:19.620027 create table "type_conv_test" ("Id" integer not null primary key autoincrement, "PersonJSON" varchar(255), "Name" varchar(255)) ; [] -gorptest: 19:35:19.630058 create table "embedded_struct_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255)) ; [] -gorptest: 19:35:19.639972 create table "embedded_struct_before_autoincr_test" ("FirstName" varchar(255), "LastName" varchar(255), "Id" integer not null primary key autoincrement) ; [] -gorptest: 19:35:19.649932 create table "embedded_autoincr_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255), "MiddleName" varchar(255)) ; [] -gorptest: 19:35:19.660376 create table "time_test" ("Id" integer not null primary key autoincrement, "Time" datetime) ; [] -gorptest: 19:35:19.668084 begin; [] -gorptest: 19:35:19.668136 insert into "invoice_test" ("Id","Created","Updated","Memo","PersonId","IsPaid") values (null,?,?,?,?,?); [1:100 2:200 3:"unpaid" 4:0 5:false] -gorptest: 19:35:19.668245 select memo from invoice_test [] -gorptest: 19:35:19.668289 savepoint "foo" [1:] -gorptest: 19:35:19.668298 select memo from invoice_test [] -gorptest: 19:35:19.668319 update "invoice_test" set "Created"=?, "Updated"=?, "Memo"=?, "PersonId"=?, "IsPaid"=? where "Id"=?; [1:100 2:200 3:"paid" 4:0 5:false 6:1] -gorptest: 19:35:19.668342 select memo from invoice_test [] -gorptest: 19:35:19.668354 rollback to savepoint "foo" [1:] -gorptest: 19:35:19.668365 select memo from invoice_test [] -gorptest: 19:35:19.668373 rollback; [] -gorptest: 19:35:19.668431 drop table if exists "invoice_test"; [] -gorptest: 19:35:19.678721 drop table if exists "invoice_tag_test"; [] -gorptest: 19:35:19.690270 drop table if exists "alias_trans_field_test"; [] -gorptest: 19:35:19.702571 drop table if exists "invoice_override_test"; [] -gorptest: 19:35:19.717466 drop table if exists "person_test"; [] -gorptest: 19:35:19.728188 drop table if exists "ignored_column_test"; [] -gorptest: 19:35:19.740156 drop table if exists "id_created_test"; [] -gorptest: 19:35:19.752079 drop table if exists "type_conv_test"; [] -gorptest: 19:35:19.763976 drop table if exists "embedded_struct_test"; [] -gorptest: 19:35:19.776152 drop table if exists "embedded_struct_before_autoincr_test"; [] -gorptest: 19:35:19.788072 drop table if exists "embedded_autoincr_test"; [] -gorptest: 19:35:19.800253 drop table if exists "time_test"; [] -gorptest: 19:35:19.810741 drop table if exists "id_created_test"; [] ---- PASS: TestSavepoint (0.26s) +2026/10/19 02:00:46 Warning: Automatic mapping of Version struct members to version columns (see optimistic locking) will be deprecated in next version (V2) See: https://github.com/go-gorp/gorp/pull/214 +gorptest: 02:00:46.502808 drop table if exists "invoice_test"; [] +gorptest: 02:00:46.503061 drop table if exists "invoice_tag_test"; [] +gorptest: 02:00:46.503096 drop table if exists "alias_trans_field_test"; [] +gorptest: 02:00:46.503115 drop table if exists "invoice_override_test"; [] +gorptest: 02:00:46.503144 drop table if exists "person_test"; [] +gorptest: 02:00:46.503168 drop table if exists "ignored_column_test"; [] +gorptest: 02:00:46.503212 drop table if exists "id_created_test"; [] +gorptest: 02:00:46.503274 drop table if exists "type_conv_test"; [] +gorptest: 02:00:46.503315 drop table if exists "embedded_struct_test"; [] +gorptest: 02:00:46.503345 drop table if exists "embedded_struct_before_autoincr_test"; [] +gorptest: 02:00:46.503376 drop table if exists "embedded_autoincr_test"; [] +gorptest: 02:00:46.503401 drop table if exists "time_test"; [] +gorptest: 02:00:46.503441 create table "invoice_test" ("Id" integer not null primary key autoincrement, "Created" integer, "Updated" integer, "Memo" varchar(255), "PersonId" integer, "IsPaid" integer) ; [] +gorptest: 02:00:46.512192 create table "invoice_tag_test" ("myid" integer not null primary key autoincrement, "myCreated" integer, "date_updated" integer, "Memo" varchar(255), "person_id" integer, "is_Paid" integer) ; [] +gorptest: 02:00:46.522434 create table "alias_trans_field_test" ("id" integer not null primary key autoincrement, "bar" varchar(255)) ; [] +gorptest: 02:00:46.532627 create table "invoice_override_test" ("Id" varchar(255) not null primary key, "Created" integer, "Updated" integer, "Memo" varchar(255), "PersonId" integer, "IsPaid" integer) ; [] +gorptest: 02:00:46.545162 create table "person_test" ("Id" integer not null primary key autoincrement, "Created" integer, "Updated" integer, "FName" varchar(255), "LName" varchar(255), "Version" integer) ; [] +gorptest: 02:00:46.554855 create table "ignored_column_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] +gorptest: 02:00:46.564803 create table "id_created_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] +gorptest: 02:00:46.574416 create table "type_conv_test" ("Id" integer not null primary key autoincrement, "PersonJSON" varchar(255), "Name" varchar(255)) ; [] +gorptest: 02:00:46.584902 create table "embedded_struct_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255)) ; [] +gorptest: 02:00:46.594140 create table "embedded_struct_before_autoincr_test" ("FirstName" varchar(255), "LastName" varchar(255), "Id" integer not null primary key autoincrement) ; [] +gorptest: 02:00:46.604752 create table "embedded_autoincr_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255), "MiddleName" varchar(255)) ; [] +gorptest: 02:00:46.614622 create table "time_test" ("Id" integer not null primary key autoincrement, "Time" datetime) ; [] +gorptest: 02:00:46.622903 begin; [] +gorptest: 02:00:46.622973 insert into "invoice_test" ("Id","Created","Updated","Memo","PersonId","IsPaid") values (null,?,?,?,?,?); [1:100 2:200 3:"unpaid" 4:0 5:false] +gorptest: 02:00:46.623161 select memo from invoice_test [] +gorptest: 02:00:46.623231 savepoint "foo" [1:] +gorptest: 02:00:46.623256 select memo from invoice_test [] +gorptest: 02:00:46.623311 update "invoice_test" set "Created"=?, "Updated"=?, "Memo"=?, "PersonId"=?, "IsPaid"=? where "Id"=?; [1:100 2:200 3:"paid" 4:0 5:false 6:1] +gorptest: 02:00:46.623351 select memo from invoice_test [] +gorptest: 02:00:46.623382 rollback to savepoint "foo" [1:] +gorptest: 02:00:46.623405 select memo from invoice_test [] +gorptest: 02:00:46.623443 rollback; [] +gorptest: 02:00:46.623545 drop table if exists "invoice_test"; [] +gorptest: 02:00:46.632304 drop table if exists "invoice_tag_test"; [] +gorptest: 02:00:46.644582 drop table if exists "alias_trans_field_test"; [] +gorptest: 02:00:46.657241 drop table if exists "invoice_override_test"; [] +gorptest: 02:00:46.671107 drop table if exists "person_test"; [] +gorptest: 02:00:46.682523 drop table if exists "ignored_column_test"; [] +gorptest: 02:00:46.694657 drop table if exists "id_created_test"; [] +gorptest: 02:00:46.706328 drop table if exists "type_conv_test"; [] +gorptest: 02:00:46.718853 drop table if exists "embedded_struct_test"; [] +gorptest: 02:00:46.730934 drop table if exists "embedded_struct_before_autoincr_test"; [] +gorptest: 02:00:46.764572 drop table if exists "embedded_autoincr_test"; [] +gorptest: 02:00:46.770237 drop table if exists "time_test"; [] +gorptest: 02:00:46.775175 drop table if exists "id_created_test"; [] +--- PASS: TestSavepoint (0.27s) === RUN TestMultiple -2025/09/15 19:35:19 Warning: Automatic mapping of Version struct members to version columns (see optimistic locking) will be deprecated in next version (V2) See: https://github.com/go-gorp/gorp/pull/214 -gorptest: 19:35:19.810940 drop table if exists "invoice_test"; [] -gorptest: 19:35:19.811129 drop table if exists "invoice_tag_test"; [] -gorptest: 19:35:19.811153 drop table if exists "alias_trans_field_test"; [] -gorptest: 19:35:19.811167 drop table if exists "invoice_override_test"; [] -gorptest: 19:35:19.811181 drop table if exists "person_test"; [] -gorptest: 19:35:19.811195 drop table if exists "ignored_column_test"; [] -gorptest: 19:35:19.811210 drop table if exists "id_created_test"; [] -gorptest: 19:35:19.811224 drop table if exists "type_conv_test"; [] -gorptest: 19:35:19.811241 drop table if exists "embedded_struct_test"; [] -gorptest: 19:35:19.811255 drop table if exists "embedded_struct_before_autoincr_test"; [] -gorptest: 19:35:19.811278 drop table if exists "embedded_autoincr_test"; [] -gorptest: 19:35:19.811292 drop table if exists "time_test"; [] -gorptest: 19:35:19.811316 create table "invoice_test" ("Id" integer not null primary key autoincrement, "Created" integer, "Updated" integer, "Memo" varchar(255), "PersonId" integer, "IsPaid" integer) ; [] -gorptest: 19:35:19.819554 create table "invoice_tag_test" ("myid" integer not null primary key autoincrement, "myCreated" integer, "date_updated" integer, "Memo" varchar(255), "person_id" integer, "is_Paid" integer) ; [] -gorptest: 19:35:19.832380 create table "alias_trans_field_test" ("id" integer not null primary key autoincrement, "bar" varchar(255)) ; [] -gorptest: 19:35:19.843822 create table "invoice_override_test" ("Id" varchar(255) not null primary key, "Created" integer, "Updated" integer, "Memo" varchar(255), "PersonId" integer, "IsPaid" integer) ; [] -gorptest: 19:35:19.858631 create table "person_test" ("Id" integer not null primary key autoincrement, "Created" integer, "Updated" integer, "FName" varchar(255), "LName" varchar(255), "Version" integer) ; [] -gorptest: 19:35:19.870139 create table "ignored_column_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] -gorptest: 19:35:19.882001 create table "id_created_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] -gorptest: 19:35:19.894058 create table "type_conv_test" ("Id" integer not null primary key autoincrement, "PersonJSON" varchar(255), "Name" varchar(255)) ; [] -gorptest: 19:35:19.906201 create table "embedded_struct_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255)) ; [] -gorptest: 19:35:19.917968 create table "embedded_struct_before_autoincr_test" ("FirstName" varchar(255), "LastName" varchar(255), "Id" integer not null primary key autoincrement) ; [] -gorptest: 19:35:19.929869 create table "embedded_autoincr_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255), "MiddleName" varchar(255)) ; [] -gorptest: 19:35:19.942143 create table "time_test" ("Id" integer not null primary key autoincrement, "Time" datetime) ; [] -gorptest: 19:35:19.951834 insert into "invoice_test" ("Id","Created","Updated","Memo","PersonId","IsPaid") values (null,?,?,?,?,?); [1:100 2:200 3:"a" 4:0 5:false] -gorptest: 19:35:19.960005 insert into "invoice_test" ("Id","Created","Updated","Memo","PersonId","IsPaid") values (null,?,?,?,?,?); [1:100 2:200 3:"b" 4:0 5:true] -gorptest: 19:35:19.968696 update "invoice_test" set "Created"=?, "Updated"=?, "Memo"=?, "PersonId"=?, "IsPaid"=? where "Id"=?; [1:100 2:200 3:"c" 4:0 5:false 6:1] -gorptest: 19:35:19.976429 update "invoice_test" set "Created"=?, "Updated"=?, "Memo"=?, "PersonId"=?, "IsPaid"=? where "Id"=?; [1:100 2:200 3:"d" 4:0 5:true 6:2] -gorptest: 19:35:19.984441 delete from "invoice_test" where "Id"=?; [1:1] -gorptest: 19:35:19.992100 delete from "invoice_test" where "Id"=?; [1:2] -gorptest: 19:35:20.000211 drop table if exists "invoice_test"; [] -gorptest: 19:35:20.008292 drop table if exists "invoice_tag_test"; [] -gorptest: 19:35:20.018432 drop table if exists "alias_trans_field_test"; [] -gorptest: 19:35:20.027714 drop table if exists "invoice_override_test"; [] -gorptest: 19:35:20.039877 drop table if exists "person_test"; [] -gorptest: 19:35:20.050376 drop table if exists "ignored_column_test"; [] -gorptest: 19:35:20.060601 drop table if exists "id_created_test"; [] -gorptest: 19:35:20.069736 drop table if exists "type_conv_test"; [] -gorptest: 19:35:20.079468 drop table if exists "embedded_struct_test"; [] -gorptest: 19:35:20.090130 drop table if exists "embedded_struct_before_autoincr_test"; [] -gorptest: 19:35:20.100200 drop table if exists "embedded_autoincr_test"; [] -gorptest: 19:35:20.109576 drop table if exists "time_test"; [] -gorptest: 19:35:20.119956 drop table if exists "id_created_test"; [] ---- PASS: TestMultiple (0.31s) +2026/10/19 02:00:46 Warning: Automatic mapping of Version struct members to version columns (see optimistic locking) will be deprecated in next version (V2) See: https://github.com/go-gorp/gorp/pull/214 +gorptest: 02:00:46.775476 drop table if exists "invoice_test"; [] +gorptest: 02:00:46.775712 drop table if exists "invoice_tag_test"; [] +gorptest: 02:00:46.775746 drop table if exists "alias_trans_field_test"; [] +gorptest: 02:00:46.775765 drop table if exists "invoice_override_test"; [] +gorptest: 02:00:46.775788 drop table if exists "person_test"; [] +gorptest: 02:00:46.775812 drop table if exists "ignored_column_test"; [] +gorptest: 02:00:46.775828 drop table if exists "id_created_test"; [] +gorptest: 02:00:46.775850 drop table if exists "type_conv_test"; [] +gorptest: 02:00:46.775867 drop table if exists "embedded_struct_test"; [] +gorptest: 02:00:46.775889 drop table if exists "embedded_struct_before_autoincr_test"; [] +gorptest: 02:00:46.775906 drop table if exists "embedded_autoincr_test"; [] +gorptest: 02:00:46.775929 drop table if exists "time_test"; [] +gorptest: 02:00:46.775953 create table "invoice_test" ("Id" integer not null primary key autoincrement, "Created" integer, "Updated" integer, "Memo" varchar(255), "PersonId" integer, "IsPaid" integer) ; [] +gorptest: 02:00:46.781458 create table "invoice_tag_test" ("myid" integer not null primary key autoincrement, "myCreated" integer, "date_updated" integer, "Memo" varchar(255), "person_id" integer, "is_Paid" integer) ; [] +gorptest: 02:00:46.786681 create table "alias_trans_field_test" ("id" integer not null primary key autoincrement, "bar" varchar(255)) ; [] +gorptest: 02:00:46.807645 create table "invoice_override_test" ("Id" varchar(255) not null primary key, "Created" integer, "Updated" integer, "Memo" varchar(255), "PersonId" integer, "IsPaid" integer) ; [] +gorptest: 02:00:46.813381 create table "person_test" ("Id" integer not null primary key autoincrement, "Created" integer, "Updated" integer, "FName" varchar(255), "LName" varchar(255), "Version" integer) ; [] +gorptest: 02:00:46.824268 create table "ignored_column_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] +gorptest: 02:00:46.845016 create table "id_created_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] +gorptest: 02:00:46.851356 create table "type_conv_test" ("Id" integer not null primary key autoincrement, "PersonJSON" varchar(255), "Name" varchar(255)) ; [] +gorptest: 02:00:46.860672 create table "embedded_struct_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255)) ; [] +gorptest: 02:00:46.872980 create table "embedded_struct_before_autoincr_test" ("FirstName" varchar(255), "LastName" varchar(255), "Id" integer not null primary key autoincrement) ; [] +gorptest: 02:00:46.884863 create table "embedded_autoincr_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255), "MiddleName" varchar(255)) ; [] +gorptest: 02:00:46.896852 create table "time_test" ("Id" integer not null primary key autoincrement, "Time" datetime) ; [] +gorptest: 02:00:46.906623 insert into "invoice_test" ("Id","Created","Updated","Memo","PersonId","IsPaid") values (null,?,?,?,?,?); [1:100 2:200 3:"a" 4:0 5:false] +gorptest: 02:00:46.915102 insert into "invoice_test" ("Id","Created","Updated","Memo","PersonId","IsPaid") values (null,?,?,?,?,?); [1:100 2:200 3:"b" 4:0 5:true] +gorptest: 02:00:46.922968 update "invoice_test" set "Created"=?, "Updated"=?, "Memo"=?, "PersonId"=?, "IsPaid"=? where "Id"=?; [1:100 2:200 3:"c" 4:0 5:false 6:1] +gorptest: 02:00:46.930451 update "invoice_test" set "Created"=?, "Updated"=?, "Memo"=?, "PersonId"=?, "IsPaid"=? where "Id"=?; [1:100 2:200 3:"d" 4:0 5:true 6:2] +gorptest: 02:00:46.938335 delete from "invoice_test" where "Id"=?; [1:1] +gorptest: 02:00:46.946399 delete from "invoice_test" where "Id"=?; [1:2] +gorptest: 02:00:46.954470 drop table if exists "invoice_test"; [] +gorptest: 02:00:46.963328 drop table if exists "invoice_tag_test"; [] +gorptest: 02:00:46.972314 drop table if exists "alias_trans_field_test"; [] +gorptest: 02:00:46.982784 drop table if exists "invoice_override_test"; [] +gorptest: 02:00:46.994714 drop table if exists "person_test"; [] +gorptest: 02:00:47.004918 drop table if exists "ignored_column_test"; [] +gorptest: 02:00:47.015202 drop table if exists "id_created_test"; [] +gorptest: 02:00:47.024826 drop table if exists "type_conv_test"; [] +gorptest: 02:00:47.035022 drop table if exists "embedded_struct_test"; [] +gorptest: 02:00:47.044608 drop table if exists "embedded_struct_before_autoincr_test"; [] +gorptest: 02:00:47.054273 drop table if exists "embedded_autoincr_test"; [] +gorptest: 02:00:47.065572 drop table if exists "time_test"; [] +gorptest: 02:00:47.074470 drop table if exists "id_created_test"; [] +--- PASS: TestMultiple (0.30s) === RUN TestCrud -2025/09/15 19:35:20 Warning: Automatic mapping of Version struct members to version columns (see optimistic locking) will be deprecated in next version (V2) See: https://github.com/go-gorp/gorp/pull/214 -gorptest: 19:35:20.120139 drop table if exists "invoice_test"; [] -gorptest: 19:35:20.120318 drop table if exists "invoice_tag_test"; [] -gorptest: 19:35:20.120341 drop table if exists "alias_trans_field_test"; [] -gorptest: 19:35:20.120355 drop table if exists "invoice_override_test"; [] -gorptest: 19:35:20.120369 drop table if exists "person_test"; [] -gorptest: 19:35:20.120387 drop table if exists "ignored_column_test"; [] -gorptest: 19:35:20.120400 drop table if exists "id_created_test"; [] -gorptest: 19:35:20.120415 drop table if exists "type_conv_test"; [] -gorptest: 19:35:20.120429 drop table if exists "embedded_struct_test"; [] -gorptest: 19:35:20.120446 drop table if exists "embedded_struct_before_autoincr_test"; [] -gorptest: 19:35:20.120460 drop table if exists "embedded_autoincr_test"; [] -gorptest: 19:35:20.120474 drop table if exists "time_test"; [] -gorptest: 19:35:20.120493 create table "invoice_test" ("Id" integer not null primary key autoincrement, "Created" integer, "Updated" integer, "Memo" varchar(255), "PersonId" integer, "IsPaid" integer) ; [] -gorptest: 19:35:20.129597 create table "invoice_tag_test" ("myid" integer not null primary key autoincrement, "myCreated" integer, "date_updated" integer, "Memo" varchar(255), "person_id" integer, "is_Paid" integer) ; [] -gorptest: 19:35:20.140757 create table "alias_trans_field_test" ("id" integer not null primary key autoincrement, "bar" varchar(255)) ; [] -gorptest: 19:35:20.149904 create table "invoice_override_test" ("Id" varchar(255) not null primary key, "Created" integer, "Updated" integer, "Memo" varchar(255), "PersonId" integer, "IsPaid" integer) ; [] -gorptest: 19:35:20.162181 create table "person_test" ("Id" integer not null primary key autoincrement, "Created" integer, "Updated" integer, "FName" varchar(255), "LName" varchar(255), "Version" integer) ; [] -gorptest: 19:35:20.172370 create table "ignored_column_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] -gorptest: 19:35:20.181581 create table "id_created_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] -gorptest: 19:35:20.192169 create table "type_conv_test" ("Id" integer not null primary key autoincrement, "PersonJSON" varchar(255), "Name" varchar(255)) ; [] -gorptest: 19:35:20.201882 create table "embedded_struct_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255)) ; [] -gorptest: 19:35:20.212496 create table "embedded_struct_before_autoincr_test" ("FirstName" varchar(255), "LastName" varchar(255), "Id" integer not null primary key autoincrement) ; [] -gorptest: 19:35:20.222102 create table "embedded_autoincr_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255), "MiddleName" varchar(255)) ; [] -gorptest: 19:35:20.231786 create table "time_test" ("Id" integer not null primary key autoincrement, "Time" datetime) ; [] -gorptest: 19:35:20.239751 delete from invoice_test [] -gorptest: 19:35:20.249978 insert into "invoice_test" ("Id","Created","Updated","Memo","PersonId","IsPaid") values (null,?,?,?,?,?); [1:100 2:200 3:"first order" 4:0 5:true] -gorptest: 19:35:20.262290 select "Id","Created","Updated","Memo","PersonId","IsPaid" from "invoice_test" where "Id"=?; [1:1] -gorptest: 19:35:20.262387 update "invoice_test" set "Created"=?, "Updated"=?, "Memo"=?, "PersonId"=?, "IsPaid"=? where "Id"=?; [1:7275070221239908431 2:7162929569793184166 3:"random 8897294196570667563" 4:0 5:true 6:1] -gorptest: 19:35:20.272302 select "Id","Created","Updated","Memo","PersonId","IsPaid" from "invoice_test" where "Id"=?; [1:1] -gorptest: 19:35:20.272371 select * from invoice_test [] -gorptest: 19:35:20.272426 delete from "invoice_test" where "Id"=?; [1:1] -gorptest: 19:35:20.282373 select "Id","Created","Updated","Memo","PersonId","IsPaid" from "invoice_test" where "Id"=?; [1:1] -gorptest: 19:35:20.282437 delete from invoice_tag_test [] -gorptest: 19:35:20.291747 insert into "invoice_tag_test" ("myid","myCreated","date_updated","Memo","person_id","is_Paid") values (null,?,?,?,?,?); [1:300 2:400 3:"some order" 4:33 5:false] -gorptest: 19:35:20.304078 select "myid","myCreated","date_updated","Memo","person_id","is_Paid" from "invoice_tag_test" where "myid"=?; [1:1] -gorptest: 19:35:20.304182 update "invoice_tag_test" set "myCreated"=?, "date_updated"=?, "Memo"=?, "person_id"=?, "is_Paid"=? where "myid"=?; [1:6681476145745115450 2:1854094703687711348 3:"random 2901902113142161798" 4:33 5:false 6:1] -gorptest: 19:35:20.314150 select "myid","myCreated","date_updated","Memo","person_id","is_Paid" from "invoice_tag_test" where "myid"=?; [1:1] -gorptest: 19:35:20.314220 select * from invoice_tag_test [] -gorptest: 19:35:20.314294 delete from "invoice_tag_test" where "myid"=?; [1:1] -gorptest: 19:35:20.324264 select "myid","myCreated","date_updated","Memo","person_id","is_Paid" from "invoice_tag_test" where "myid"=?; [1:1] -gorptest: 19:35:20.324340 delete from alias_trans_field_test [] -gorptest: 19:35:20.333641 insert into "alias_trans_field_test" ("id","bar") values (null,?); [1:"some bar"] -gorptest: 19:35:20.346132 select "id","bar" from "alias_trans_field_test" where "id"=?; [1:1] -gorptest: 19:35:20.346204 update "alias_trans_field_test" set "bar"=? where "id"=?; [1:"random 7154892241919074323" 2:1] -gorptest: 19:35:20.355492 select "id","bar" from "alias_trans_field_test" where "id"=?; [1:1] -gorptest: 19:35:20.355572 select * from alias_trans_field_test [] -gorptest: 19:35:20.355620 delete from "alias_trans_field_test" where "id"=?; [1:1] -gorptest: 19:35:20.366431 select "id","bar" from "alias_trans_field_test" where "id"=?; [1:1] -gorptest: 19:35:20.366496 drop table if exists "invoice_test"; [] -gorptest: 19:35:20.378803 drop table if exists "invoice_tag_test"; [] -gorptest: 19:35:20.392365 drop table if exists "alias_trans_field_test"; [] -gorptest: 19:35:20.405701 drop table if exists "invoice_override_test"; [] -gorptest: 19:35:20.420341 drop table if exists "person_test"; [] -gorptest: 19:35:20.431493 drop table if exists "ignored_column_test"; [] -gorptest: 19:35:20.443941 drop table if exists "id_created_test"; [] -gorptest: 19:35:20.457646 drop table if exists "type_conv_test"; [] -gorptest: 19:35:20.468134 drop table if exists "embedded_struct_test"; [] -gorptest: 19:35:20.479806 drop table if exists "embedded_struct_before_autoincr_test"; [] -gorptest: 19:35:20.492015 drop table if exists "embedded_autoincr_test"; [] -gorptest: 19:35:20.504212 drop table if exists "time_test"; [] -gorptest: 19:35:20.514280 drop table if exists "id_created_test"; [] +2026/10/19 02:00:47 Warning: Automatic mapping of Version struct members to version columns (see optimistic locking) will be deprecated in next version (V2) See: https://github.com/go-gorp/gorp/pull/214 +gorptest: 02:00:47.074774 drop table if exists "invoice_test"; [] +gorptest: 02:00:47.075015 drop table if exists "invoice_tag_test"; [] +gorptest: 02:00:47.075053 drop table if exists "alias_trans_field_test"; [] +gorptest: 02:00:47.075073 drop table if exists "invoice_override_test"; [] +gorptest: 02:00:47.075099 drop table if exists "person_test"; [] +gorptest: 02:00:47.075118 drop table if exists "ignored_column_test"; [] +gorptest: 02:00:47.075137 drop table if exists "id_created_test"; [] +gorptest: 02:00:47.075155 drop table if exists "type_conv_test"; [] +gorptest: 02:00:47.075179 drop table if exists "embedded_struct_test"; [] +gorptest: 02:00:47.075196 drop table if exists "embedded_struct_before_autoincr_test"; [] +gorptest: 02:00:47.075219 drop table if exists "embedded_autoincr_test"; [] +gorptest: 02:00:47.075247 drop table if exists "time_test"; [] +gorptest: 02:00:47.075292 create table "invoice_test" ("Id" integer not null primary key autoincrement, "Created" integer, "Updated" integer, "Memo" varchar(255), "PersonId" integer, "IsPaid" integer) ; [] +gorptest: 02:00:47.084473 create table "invoice_tag_test" ("myid" integer not null primary key autoincrement, "myCreated" integer, "date_updated" integer, "Memo" varchar(255), "person_id" integer, "is_Paid" integer) ; [] +gorptest: 02:00:47.094432 create table "alias_trans_field_test" ("id" integer not null primary key autoincrement, "bar" varchar(255)) ; [] +gorptest: 02:00:47.104766 create table "invoice_override_test" ("Id" varchar(255) not null primary key, "Created" integer, "Updated" integer, "Memo" varchar(255), "PersonId" integer, "IsPaid" integer) ; [] +gorptest: 02:00:47.116505 create table "person_test" ("Id" integer not null primary key autoincrement, "Created" integer, "Updated" integer, "FName" varchar(255), "LName" varchar(255), "Version" integer) ; [] +gorptest: 02:00:47.126784 create table "ignored_column_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] +gorptest: 02:00:47.136193 create table "id_created_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] +gorptest: 02:00:47.147036 create table "type_conv_test" ("Id" integer not null primary key autoincrement, "PersonJSON" varchar(255), "Name" varchar(255)) ; [] +gorptest: 02:00:47.156913 create table "embedded_struct_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255)) ; [] +gorptest: 02:00:47.166460 create table "embedded_struct_before_autoincr_test" ("FirstName" varchar(255), "LastName" varchar(255), "Id" integer not null primary key autoincrement) ; [] +gorptest: 02:00:47.176054 create table "embedded_autoincr_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255), "MiddleName" varchar(255)) ; [] +gorptest: 02:00:47.186603 create table "time_test" ("Id" integer not null primary key autoincrement, "Time" datetime) ; [] +gorptest: 02:00:47.194993 delete from invoice_test [] +gorptest: 02:00:47.204264 insert into "invoice_test" ("Id","Created","Updated","Memo","PersonId","IsPaid") values (null,?,?,?,?,?); [1:100 2:200 3:"first order" 4:0 5:true] +gorptest: 02:00:47.218888 select "Id","Created","Updated","Memo","PersonId","IsPaid" from "invoice_test" where "Id"=?; [1:1] +gorptest: 02:00:47.219035 update "invoice_test" set "Created"=?, "Updated"=?, "Memo"=?, "PersonId"=?, "IsPaid"=? where "Id"=?; [1:1485937070396702700 2:5356959716454216335 3:"random 678882847027218722" 4:0 5:true 6:1] +gorptest: 02:00:47.226303 select "Id","Created","Updated","Memo","PersonId","IsPaid" from "invoice_test" where "Id"=?; [1:1] +gorptest: 02:00:47.226410 select * from invoice_test [] +gorptest: 02:00:47.226502 delete from "invoice_test" where "Id"=?; [1:1] +gorptest: 02:00:47.235978 select "Id","Created","Updated","Memo","PersonId","IsPaid" from "invoice_test" where "Id"=?; [1:1] +gorptest: 02:00:47.236108 delete from invoice_tag_test [] +gorptest: 02:00:47.246560 insert into "invoice_tag_test" ("myid","myCreated","date_updated","Memo","person_id","is_Paid") values (null,?,?,?,?,?); [1:300 2:400 3:"some order" 4:33 5:false] +gorptest: 02:00:47.258459 select "myid","myCreated","date_updated","Memo","person_id","is_Paid" from "invoice_tag_test" where "myid"=?; [1:1] +gorptest: 02:00:47.258645 update "invoice_tag_test" set "myCreated"=?, "date_updated"=?, "Memo"=?, "person_id"=?, "is_Paid"=? where "myid"=?; [1:8846369087758611877 2:7886928481579696199 3:"random 2934302236481500551" 4:33 5:false 6:1] +gorptest: 02:00:47.268934 select "myid","myCreated","date_updated","Memo","person_id","is_Paid" from "invoice_tag_test" where "myid"=?; [1:1] +gorptest: 02:00:47.269103 select * from invoice_tag_test [] +gorptest: 02:00:47.269222 delete from "invoice_tag_test" where "myid"=?; [1:1] +gorptest: 02:00:47.279041 select "myid","myCreated","date_updated","Memo","person_id","is_Paid" from "invoice_tag_test" where "myid"=?; [1:1] +gorptest: 02:00:47.279137 delete from alias_trans_field_test [] +gorptest: 02:00:47.288716 insert into "alias_trans_field_test" ("id","bar") values (null,?); [1:"some bar"] +gorptest: 02:00:47.300179 select "id","bar" from "alias_trans_field_test" where "id"=?; [1:1] +gorptest: 02:00:47.300284 update "alias_trans_field_test" set "bar"=? where "id"=?; [1:"random 6451844755141373506" 2:1] +gorptest: 02:00:47.310898 select "id","bar" from "alias_trans_field_test" where "id"=?; [1:1] +gorptest: 02:00:47.311060 select * from alias_trans_field_test [] +gorptest: 02:00:47.311206 delete from "alias_trans_field_test" where "id"=?; [1:1] +gorptest: 02:00:47.323100 select "id","bar" from "alias_trans_field_test" where "id"=?; [1:1] +gorptest: 02:00:47.323180 drop table if exists "invoice_test"; [] +gorptest: 02:00:47.332722 drop table if exists "invoice_tag_test"; [] +gorptest: 02:00:47.347076 drop table if exists "alias_trans_field_test"; [] +gorptest: 02:00:47.361753 drop table if exists "invoice_override_test"; [] +gorptest: 02:00:47.374630 drop table if exists "person_test"; [] +gorptest: 02:00:47.386605 drop table if exists "ignored_column_test"; [] +gorptest: 02:00:47.398428 drop table if exists "id_created_test"; [] +gorptest: 02:00:47.409997 drop table if exists "type_conv_test"; [] +gorptest: 02:00:47.424049 drop table if exists "embedded_struct_test"; [] +gorptest: 02:00:47.435136 drop table if exists "embedded_struct_before_autoincr_test"; [] +gorptest: 02:00:47.452069 drop table if exists "embedded_autoincr_test"; [] +gorptest: 02:00:47.459636 drop table if exists "time_test"; [] +gorptest: 02:00:47.468054 drop table if exists "id_created_test"; [] --- PASS: TestCrud (0.39s) === RUN TestWithIgnoredColumn -2025/09/15 19:35:20 Warning: Automatic mapping of Version struct members to version columns (see optimistic locking) will be deprecated in next version (V2) See: https://github.com/go-gorp/gorp/pull/214 -gorptest: 19:35:20.514496 drop table if exists "invoice_test"; [] -gorptest: 19:35:20.514670 drop table if exists "invoice_tag_test"; [] -gorptest: 19:35:20.514694 drop table if exists "alias_trans_field_test"; [] -gorptest: 19:35:20.514709 drop table if exists "invoice_override_test"; [] -gorptest: 19:35:20.514727 drop table if exists "person_test"; [] -gorptest: 19:35:20.514741 drop table if exists "ignored_column_test"; [] -gorptest: 19:35:20.514758 drop table if exists "id_created_test"; [] -gorptest: 19:35:20.514772 drop table if exists "type_conv_test"; [] -gorptest: 19:35:20.514786 drop table if exists "embedded_struct_test"; [] -gorptest: 19:35:20.514807 drop table if exists "embedded_struct_before_autoincr_test"; [] -gorptest: 19:35:20.514824 drop table if exists "embedded_autoincr_test"; [] -gorptest: 19:35:20.514838 drop table if exists "time_test"; [] -gorptest: 19:35:20.514859 create table "invoice_test" ("Id" integer not null primary key autoincrement, "Created" integer, "Updated" integer, "Memo" varchar(255), "PersonId" integer, "IsPaid" integer) ; [] -gorptest: 19:35:20.523856 create table "invoice_tag_test" ("myid" integer not null primary key autoincrement, "myCreated" integer, "date_updated" integer, "Memo" varchar(255), "person_id" integer, "is_Paid" integer) ; [] -gorptest: 19:35:20.536300 create table "alias_trans_field_test" ("id" integer not null primary key autoincrement, "bar" varchar(255)) ; [] -gorptest: 19:35:20.548341 create table "invoice_override_test" ("Id" varchar(255) not null primary key, "Created" integer, "Updated" integer, "Memo" varchar(255), "PersonId" integer, "IsPaid" integer) ; [] -gorptest: 19:35:20.562330 create table "person_test" ("Id" integer not null primary key autoincrement, "Created" integer, "Updated" integer, "FName" varchar(255), "LName" varchar(255), "Version" integer) ; [] -gorptest: 19:35:20.573777 create table "ignored_column_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] -gorptest: 19:35:20.586165 create table "id_created_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] -gorptest: 19:35:20.598086 create table "type_conv_test" ("Id" integer not null primary key autoincrement, "PersonJSON" varchar(255), "Name" varchar(255)) ; [] -gorptest: 19:35:20.609803 create table "embedded_struct_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255)) ; [] -gorptest: 19:35:20.621727 create table "embedded_struct_before_autoincr_test" ("FirstName" varchar(255), "LastName" varchar(255), "Id" integer not null primary key autoincrement) ; [] -gorptest: 19:35:20.633814 create table "embedded_autoincr_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255), "MiddleName" varchar(255)) ; [] -gorptest: 19:35:20.645678 create table "time_test" ("Id" integer not null primary key autoincrement, "Time" datetime) ; [] -gorptest: 19:35:20.655646 insert into "ignored_column_test" ("Id","Created") values (null,?); [1:1] -gorptest: 19:35:20.667633 select "Id","Created" from "ignored_column_test" where "Id"=?; [1:1] -gorptest: 19:35:20.667716 delete from "ignored_column_test" where "Id"=?; [1:1] -gorptest: 19:35:20.678360 select "Id","Created" from "ignored_column_test" where "Id"=?; [1:1] -gorptest: 19:35:20.678416 drop table if exists "invoice_test"; [] -gorptest: 19:35:20.686274 drop table if exists "invoice_tag_test"; [] -gorptest: 19:35:20.695718 drop table if exists "alias_trans_field_test"; [] -gorptest: 19:35:20.706137 drop table if exists "invoice_override_test"; [] -gorptest: 19:35:20.718027 drop table if exists "person_test"; [] -gorptest: 19:35:20.728086 drop table if exists "ignored_column_test"; [] -gorptest: 19:35:20.738006 drop table if exists "id_created_test"; [] -gorptest: 19:35:20.748497 drop table if exists "type_conv_test"; [] -gorptest: 19:35:20.758331 drop table if exists "embedded_struct_test"; [] -gorptest: 19:35:20.768277 drop table if exists "embedded_struct_before_autoincr_test"; [] -gorptest: 19:35:20.778993 drop table if exists "embedded_autoincr_test"; [] -gorptest: 19:35:20.788364 drop table if exists "time_test"; [] -gorptest: 19:35:20.798380 drop table if exists "id_created_test"; [] ---- PASS: TestWithIgnoredColumn (0.28s) +2026/10/19 02:00:47 Warning: Automatic mapping of Version struct members to version columns (see optimistic locking) will be deprecated in next version (V2) See: https://github.com/go-gorp/gorp/pull/214 +gorptest: 02:00:47.468387 drop table if exists "invoice_test"; [] +gorptest: 02:00:47.468685 drop table if exists "invoice_tag_test"; [] +gorptest: 02:00:47.468775 drop table if exists "alias_trans_field_test"; [] +gorptest: 02:00:47.468816 drop table if exists "invoice_override_test"; [] +gorptest: 02:00:47.468838 drop table if exists "person_test"; [] +gorptest: 02:00:47.468865 drop table if exists "ignored_column_test"; [] +gorptest: 02:00:47.468887 drop table if exists "id_created_test"; [] +gorptest: 02:00:47.468912 drop table if exists "type_conv_test"; [] +gorptest: 02:00:47.468937 drop table if exists "embedded_struct_test"; [] +gorptest: 02:00:47.468957 drop table if exists "embedded_struct_before_autoincr_test"; [] +gorptest: 02:00:47.468976 drop table if exists "embedded_autoincr_test"; [] +gorptest: 02:00:47.469005 drop table if exists "time_test"; [] +gorptest: 02:00:47.469036 create table "invoice_test" ("Id" integer not null primary key autoincrement, "Created" integer, "Updated" integer, "Memo" varchar(255), "PersonId" integer, "IsPaid" integer) ; [] +gorptest: 02:00:47.478499 create table "invoice_tag_test" ("myid" integer not null primary key autoincrement, "myCreated" integer, "date_updated" integer, "Memo" varchar(255), "person_id" integer, "is_Paid" integer) ; [] +gorptest: 02:00:47.493420 create table "alias_trans_field_test" ("id" integer not null primary key autoincrement, "bar" varchar(255)) ; [] +gorptest: 02:00:47.502953 create table "invoice_override_test" ("Id" varchar(255) not null primary key, "Created" integer, "Updated" integer, "Memo" varchar(255), "PersonId" integer, "IsPaid" integer) ; [] +gorptest: 02:00:47.516382 create table "person_test" ("Id" integer not null primary key autoincrement, "Created" integer, "Updated" integer, "FName" varchar(255), "LName" varchar(255), "Version" integer) ; [] +gorptest: 02:00:47.528540 create table "ignored_column_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] +gorptest: 02:00:47.541249 create table "id_created_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] +gorptest: 02:00:47.555966 create table "type_conv_test" ("Id" integer not null primary key autoincrement, "PersonJSON" varchar(255), "Name" varchar(255)) ; [] +gorptest: 02:00:47.564751 create table "embedded_struct_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255)) ; [] +gorptest: 02:00:47.577202 create table "embedded_struct_before_autoincr_test" ("FirstName" varchar(255), "LastName" varchar(255), "Id" integer not null primary key autoincrement) ; [] +gorptest: 02:00:47.588917 create table "embedded_autoincr_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255), "MiddleName" varchar(255)) ; [] +gorptest: 02:00:47.600914 create table "time_test" ("Id" integer not null primary key autoincrement, "Time" datetime) ; [] +gorptest: 02:00:47.610242 insert into "ignored_column_test" ("Id","Created") values (null,?); [1:1] +gorptest: 02:00:47.623002 select "Id","Created" from "ignored_column_test" where "Id"=?; [1:1] +gorptest: 02:00:47.623136 delete from "ignored_column_test" where "Id"=?; [1:1] +gorptest: 02:00:47.632718 select "Id","Created" from "ignored_column_test" where "Id"=?; [1:1] +gorptest: 02:00:47.632823 drop table if exists "invoice_test"; [] +gorptest: 02:00:47.640655 drop table if exists "invoice_tag_test"; [] +gorptest: 02:00:47.650823 drop table if exists "alias_trans_field_test"; [] +gorptest: 02:00:47.660948 drop table if exists "invoice_override_test"; [] +gorptest: 02:00:47.673130 drop table if exists "person_test"; [] +gorptest: 02:00:47.682240 drop table if exists "ignored_column_test"; [] +gorptest: 02:00:47.692671 drop table if exists "id_created_test"; [] +gorptest: 02:00:47.702520 drop table if exists "type_conv_test"; [] +gorptest: 02:00:47.712417 drop table if exists "embedded_struct_test"; [] +gorptest: 02:00:47.722373 drop table if exists "embedded_struct_before_autoincr_test"; [] +gorptest: 02:00:47.732106 drop table if exists "embedded_autoincr_test"; [] +gorptest: 02:00:47.742867 drop table if exists "time_test"; [] +gorptest: 02:00:47.754222 drop table if exists "id_created_test"; [] +--- PASS: TestWithIgnoredColumn (0.29s) === RUN TestTypeConversionExample -2025/09/15 19:35:20 Warning: Automatic mapping of Version struct members to version columns (see optimistic locking) will be deprecated in next version (V2) See: https://github.com/go-gorp/gorp/pull/214 -gorptest: 19:35:20.798587 drop table if exists "invoice_test"; [] -gorptest: 19:35:20.798762 drop table if exists "invoice_tag_test"; [] -gorptest: 19:35:20.798785 drop table if exists "alias_trans_field_test"; [] -gorptest: 19:35:20.798799 drop table if exists "invoice_override_test"; [] -gorptest: 19:35:20.798817 drop table if exists "person_test"; [] -gorptest: 19:35:20.798831 drop table if exists "ignored_column_test"; [] -gorptest: 19:35:20.798845 drop table if exists "id_created_test"; [] -gorptest: 19:35:20.798862 drop table if exists "type_conv_test"; [] -gorptest: 19:35:20.798875 drop table if exists "embedded_struct_test"; [] -gorptest: 19:35:20.798893 drop table if exists "embedded_struct_before_autoincr_test"; [] -gorptest: 19:35:20.798907 drop table if exists "embedded_autoincr_test"; [] -gorptest: 19:35:20.798921 drop table if exists "time_test"; [] -gorptest: 19:35:20.798941 create table "invoice_test" ("Id" integer not null primary key autoincrement, "Created" integer, "Updated" integer, "Memo" varchar(255), "PersonId" integer, "IsPaid" integer) ; [] -gorptest: 19:35:20.807692 create table "invoice_tag_test" ("myid" integer not null primary key autoincrement, "myCreated" integer, "date_updated" integer, "Memo" varchar(255), "person_id" integer, "is_Paid" integer) ; [] -gorptest: 19:35:20.818130 create table "alias_trans_field_test" ("id" integer not null primary key autoincrement, "bar" varchar(255)) ; [] -gorptest: 19:35:20.827407 create table "invoice_override_test" ("Id" varchar(255) not null primary key, "Created" integer, "Updated" integer, "Memo" varchar(255), "PersonId" integer, "IsPaid" integer) ; [] -gorptest: 19:35:20.840582 create table "person_test" ("Id" integer not null primary key autoincrement, "Created" integer, "Updated" integer, "FName" varchar(255), "LName" varchar(255), "Version" integer) ; [] -gorptest: 19:35:20.850092 create table "ignored_column_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] -gorptest: 19:35:20.859701 create table "id_created_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] -gorptest: 19:35:20.869631 create table "type_conv_test" ("Id" integer not null primary key autoincrement, "PersonJSON" varchar(255), "Name" varchar(255)) ; [] -gorptest: 19:35:20.879612 create table "embedded_struct_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255)) ; [] -gorptest: 19:35:20.889477 create table "embedded_struct_before_autoincr_test" ("FirstName" varchar(255), "LastName" varchar(255), "Id" integer not null primary key autoincrement) ; [] -gorptest: 19:35:20.900511 create table "embedded_autoincr_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255), "MiddleName" varchar(255)) ; [] -gorptest: 19:35:20.910206 create table "time_test" ("Id" integer not null primary key autoincrement, "Time" datetime) ; [] -gorptest: 19:35:20.917911 insert into "type_conv_test" ("Id","PersonJSON","Name") values (null,?,?); [1:"{\"Id\":0,\"Created\":0,\"Updated\":0,\"FName\":\"Bob\",\"LName\":\"Smith\",\"Version\":0}" 2:"hi"] -gorptest: 19:35:20.929927 select "Id","PersonJSON","Name" from "type_conv_test" where "Id"=?; [1:1] -gorptest: 19:35:20.930036 update "type_conv_test" set "PersonJSON"=?, "Name"=? where "Id"=?; [1:"{\"Id\":0,\"Created\":0,\"Updated\":0,\"FName\":\"Jane\",\"LName\":\"Doe\",\"Version\":0}" 2:"hi2" 3:1] -gorptest: 19:35:20.939984 select "Id","PersonJSON","Name" from "type_conv_test" where "Id"=?; [1:1] -gorptest: 19:35:20.940071 delete from "type_conv_test" where "Id"=?; [1:1] -gorptest: 19:35:20.949819 drop table if exists "invoice_test"; [] -gorptest: 19:35:20.959481 drop table if exists "invoice_tag_test"; [] -gorptest: 19:35:20.972360 drop table if exists "alias_trans_field_test"; [] -gorptest: 19:35:20.984066 drop table if exists "invoice_override_test"; [] -gorptest: 19:35:20.998203 drop table if exists "person_test"; [] -gorptest: 19:35:21.010507 drop table if exists "ignored_column_test"; [] -gorptest: 19:35:21.022358 drop table if exists "id_created_test"; [] -gorptest: 19:35:21.034324 drop table if exists "type_conv_test"; [] -gorptest: 19:35:21.048083 drop table if exists "embedded_struct_test"; [] -gorptest: 19:35:21.062028 drop table if exists "embedded_struct_before_autoincr_test"; [] -gorptest: 19:35:21.072158 drop table if exists "embedded_autoincr_test"; [] -gorptest: 19:35:21.084339 drop table if exists "time_test"; [] -gorptest: 19:35:21.093968 drop table if exists "id_created_test"; [] +2026/10/19 02:00:47 Warning: Automatic mapping of Version struct members to version columns (see optimistic locking) will be deprecated in next version (V2) See: https://github.com/go-gorp/gorp/pull/214 +gorptest: 02:00:47.754587 drop table if exists "invoice_test"; [] +gorptest: 02:00:47.754805 drop table if exists "invoice_tag_test"; [] +gorptest: 02:00:47.754840 drop table if exists "alias_trans_field_test"; [] +gorptest: 02:00:47.754858 drop table if exists "invoice_override_test"; [] +gorptest: 02:00:47.754888 drop table if exists "person_test"; [] +gorptest: 02:00:47.754912 drop table if exists "ignored_column_test"; [] +gorptest: 02:00:47.754946 drop table if exists "id_created_test"; [] +gorptest: 02:00:47.754963 drop table if exists "type_conv_test"; [] +gorptest: 02:00:47.754985 drop table if exists "embedded_struct_test"; [] +gorptest: 02:00:47.755006 drop table if exists "embedded_struct_before_autoincr_test"; [] +gorptest: 02:00:47.755023 drop table if exists "embedded_autoincr_test"; [] +gorptest: 02:00:47.755055 drop table if exists "time_test"; [] +gorptest: 02:00:47.755083 create table "invoice_test" ("Id" integer not null primary key autoincrement, "Created" integer, "Updated" integer, "Memo" varchar(255), "PersonId" integer, "IsPaid" integer) ; [] +gorptest: 02:00:47.763105 create table "invoice_tag_test" ("myid" integer not null primary key autoincrement, "myCreated" integer, "date_updated" integer, "Memo" varchar(255), "person_id" integer, "is_Paid" integer) ; [] +gorptest: 02:00:47.773667 create table "alias_trans_field_test" ("id" integer not null primary key autoincrement, "bar" varchar(255)) ; [] +gorptest: 02:00:47.782347 create table "invoice_override_test" ("Id" varchar(255) not null primary key, "Created" integer, "Updated" integer, "Memo" varchar(255), "PersonId" integer, "IsPaid" integer) ; [] +gorptest: 02:00:47.794624 create table "person_test" ("Id" integer not null primary key autoincrement, "Created" integer, "Updated" integer, "FName" varchar(255), "LName" varchar(255), "Version" integer) ; [] +gorptest: 02:00:47.807406 create table "ignored_column_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] +gorptest: 02:00:47.814788 create table "id_created_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] +gorptest: 02:00:47.824082 create table "type_conv_test" ("Id" integer not null primary key autoincrement, "PersonJSON" varchar(255), "Name" varchar(255)) ; [] +gorptest: 02:00:47.834853 create table "embedded_struct_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255)) ; [] +gorptest: 02:00:47.844522 create table "embedded_struct_before_autoincr_test" ("FirstName" varchar(255), "LastName" varchar(255), "Id" integer not null primary key autoincrement) ; [] +gorptest: 02:00:47.854609 create table "embedded_autoincr_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255), "MiddleName" varchar(255)) ; [] +gorptest: 02:00:47.864236 create table "time_test" ("Id" integer not null primary key autoincrement, "Time" datetime) ; [] +gorptest: 02:00:47.872749 insert into "type_conv_test" ("Id","PersonJSON","Name") values (null,?,?); [1:"{\"Id\":0,\"Created\":0,\"Updated\":0,\"FName\":\"Bob\",\"LName\":\"Smith\",\"Version\":0}" 2:"hi"] +gorptest: 02:00:47.884951 select "Id","PersonJSON","Name" from "type_conv_test" where "Id"=?; [1:1] +gorptest: 02:00:47.885171 update "type_conv_test" set "PersonJSON"=?, "Name"=? where "Id"=?; [1:"{\"Id\":0,\"Created\":0,\"Updated\":0,\"FName\":\"Jane\",\"LName\":\"Doe\",\"Version\":0}" 2:"hi2" 3:1] +gorptest: 02:00:47.894929 select "Id","PersonJSON","Name" from "type_conv_test" where "Id"=?; [1:1] +gorptest: 02:00:47.895053 delete from "type_conv_test" where "Id"=?; [1:1] +gorptest: 02:00:47.904380 drop table if exists "invoice_test"; [] +gorptest: 02:00:47.914969 drop table if exists "invoice_tag_test"; [] +gorptest: 02:00:47.927099 drop table if exists "alias_trans_field_test"; [] +gorptest: 02:00:47.938759 drop table if exists "invoice_override_test"; [] +gorptest: 02:00:47.952963 drop table if exists "person_test"; [] +gorptest: 02:00:47.965222 drop table if exists "ignored_column_test"; [] +gorptest: 02:00:47.976867 drop table if exists "id_created_test"; [] +gorptest: 02:00:47.989231 drop table if exists "type_conv_test"; [] +gorptest: 02:00:48.002617 drop table if exists "embedded_struct_test"; [] +gorptest: 02:00:48.015380 drop table if exists "embedded_struct_before_autoincr_test"; [] +gorptest: 02:00:48.027036 drop table if exists "embedded_autoincr_test"; [] +gorptest: 02:00:48.038677 drop table if exists "time_test"; [] +gorptest: 02:00:48.052869 drop table if exists "id_created_test"; [] --- PASS: TestTypeConversionExample (0.30s) === RUN TestWithEmbeddedStruct -2025/09/15 19:35:21 Warning: Automatic mapping of Version struct members to version columns (see optimistic locking) will be deprecated in next version (V2) See: https://github.com/go-gorp/gorp/pull/214 -gorptest: 19:35:21.094152 drop table if exists "invoice_test"; [] -gorptest: 19:35:21.094319 drop table if exists "invoice_tag_test"; [] -gorptest: 19:35:21.094340 drop table if exists "alias_trans_field_test"; [] -gorptest: 19:35:21.094355 drop table if exists "invoice_override_test"; [] -gorptest: 19:35:21.094370 drop table if exists "person_test"; [] -gorptest: 19:35:21.094383 drop table if exists "ignored_column_test"; [] -gorptest: 19:35:21.094401 drop table if exists "id_created_test"; [] -gorptest: 19:35:21.094414 drop table if exists "type_conv_test"; [] -gorptest: 19:35:21.094429 drop table if exists "embedded_struct_test"; [] -gorptest: 19:35:21.094443 drop table if exists "embedded_struct_before_autoincr_test"; [] -gorptest: 19:35:21.094457 drop table if exists "embedded_autoincr_test"; [] -gorptest: 19:35:21.094472 drop table if exists "time_test"; [] -gorptest: 19:35:21.094494 create table "invoice_test" ("Id" integer not null primary key autoincrement, "Created" integer, "Updated" integer, "Memo" varchar(255), "PersonId" integer, "IsPaid" integer) ; [] -gorptest: 19:35:21.104345 create table "invoice_tag_test" ("myid" integer not null primary key autoincrement, "myCreated" integer, "date_updated" integer, "Memo" varchar(255), "person_id" integer, "is_Paid" integer) ; [] -gorptest: 19:35:21.116287 create table "alias_trans_field_test" ("id" integer not null primary key autoincrement, "bar" varchar(255)) ; [] -gorptest: 19:35:21.127785 create table "invoice_override_test" ("Id" varchar(255) not null primary key, "Created" integer, "Updated" integer, "Memo" varchar(255), "PersonId" integer, "IsPaid" integer) ; [] -gorptest: 19:35:21.141879 create table "person_test" ("Id" integer not null primary key autoincrement, "Created" integer, "Updated" integer, "FName" varchar(255), "LName" varchar(255), "Version" integer) ; [] -gorptest: 19:35:21.154347 create table "ignored_column_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] -gorptest: 19:35:21.165520 create table "id_created_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] -gorptest: 19:35:21.177625 create table "type_conv_test" ("Id" integer not null primary key autoincrement, "PersonJSON" varchar(255), "Name" varchar(255)) ; [] -gorptest: 19:35:21.189773 create table "embedded_struct_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255)) ; [] -gorptest: 19:35:21.201539 create table "embedded_struct_before_autoincr_test" ("FirstName" varchar(255), "LastName" varchar(255), "Id" integer not null primary key autoincrement) ; [] -gorptest: 19:35:21.214469 create table "embedded_autoincr_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255), "MiddleName" varchar(255)) ; [] -gorptest: 19:35:21.225623 create table "time_test" ("Id" integer not null primary key autoincrement, "Time" datetime) ; [] -gorptest: 19:35:21.236613 insert into "embedded_struct_test" ("Id","FirstName","LastName") values (null,?,?); [1:"Alice" 2:"Smith"] -gorptest: 19:35:21.248370 select "Id","FirstName","LastName" from "embedded_struct_test" where "Id"=?; [1:1] -gorptest: 19:35:21.248456 update "embedded_struct_test" set "FirstName"=?, "LastName"=? where "Id"=?; [1:"Bob" 2:"Smith" 3:1] -gorptest: 19:35:21.258135 select "Id","FirstName","LastName" from "embedded_struct_test" where "Id"=?; [1:1] -gorptest: 19:35:21.258200 select * from embedded_struct_test [] -gorptest: 19:35:21.258243 drop table if exists "invoice_test"; [] -gorptest: 19:35:21.266685 drop table if exists "invoice_tag_test"; [] -gorptest: 19:35:21.276187 drop table if exists "alias_trans_field_test"; [] -gorptest: 19:35:21.285478 drop table if exists "invoice_override_test"; [] -gorptest: 19:35:21.298138 drop table if exists "person_test"; [] -gorptest: 19:35:21.307562 drop table if exists "ignored_column_test"; [] -gorptest: 19:35:21.317857 drop table if exists "id_created_test"; [] -gorptest: 19:35:21.327965 drop table if exists "type_conv_test"; [] -gorptest: 19:35:21.338423 drop table if exists "embedded_struct_test"; [] -gorptest: 19:35:21.347884 drop table if exists "embedded_struct_before_autoincr_test"; [] -gorptest: 19:35:21.358115 drop table if exists "embedded_autoincr_test"; [] -gorptest: 19:35:21.368366 drop table if exists "time_test"; [] -gorptest: 19:35:21.378376 drop table if exists "id_created_test"; [] ---- PASS: TestWithEmbeddedStruct (0.28s) +2026/10/19 02:00:48 Warning: Automatic mapping of Version struct members to version columns (see optimistic locking) will be deprecated in next version (V2) See: https://github.com/go-gorp/gorp/pull/214 +gorptest: 02:00:48.053357 drop table if exists "invoice_test"; [] +gorptest: 02:00:48.053683 drop table if exists "invoice_tag_test"; [] +gorptest: 02:00:48.053718 drop table if exists "alias_trans_field_test"; [] +gorptest: 02:00:48.053736 drop table if exists "invoice_override_test"; [] +gorptest: 02:00:48.053753 drop table if exists "person_test"; [] +gorptest: 02:00:48.053772 drop table if exists "ignored_column_test"; [] +gorptest: 02:00:48.053801 drop table if exists "id_created_test"; [] +gorptest: 02:00:48.053832 drop table if exists "type_conv_test"; [] +gorptest: 02:00:48.053849 drop table if exists "embedded_struct_test"; [] +gorptest: 02:00:48.053867 drop table if exists "embedded_struct_before_autoincr_test"; [] +gorptest: 02:00:48.053883 drop table if exists "embedded_autoincr_test"; [] +gorptest: 02:00:48.053900 drop table if exists "time_test"; [] +gorptest: 02:00:48.053925 create table "invoice_test" ("Id" integer not null primary key autoincrement, "Created" integer, "Updated" integer, "Memo" varchar(255), "PersonId" integer, "IsPaid" integer) ; [] +gorptest: 02:00:48.062527 create table "invoice_tag_test" ("myid" integer not null primary key autoincrement, "myCreated" integer, "date_updated" integer, "Memo" varchar(255), "person_id" integer, "is_Paid" integer) ; [] +gorptest: 02:00:48.080273 create table "alias_trans_field_test" ("id" integer not null primary key autoincrement, "bar" varchar(255)) ; [] +gorptest: 02:00:48.094467 create table "invoice_override_test" ("Id" varchar(255) not null primary key, "Created" integer, "Updated" integer, "Memo" varchar(255), "PersonId" integer, "IsPaid" integer) ; [] +gorptest: 02:00:48.112207 create table "person_test" ("Id" integer not null primary key autoincrement, "Created" integer, "Updated" integer, "FName" varchar(255), "LName" varchar(255), "Version" integer) ; [] +gorptest: 02:00:48.129163 create table "ignored_column_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] +gorptest: 02:00:48.144154 create table "id_created_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] +gorptest: 02:00:48.160477 create table "type_conv_test" ("Id" integer not null primary key autoincrement, "PersonJSON" varchar(255), "Name" varchar(255)) ; [] +gorptest: 02:00:48.172223 create table "embedded_struct_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255)) ; [] +gorptest: 02:00:48.185120 create table "embedded_struct_before_autoincr_test" ("FirstName" varchar(255), "LastName" varchar(255), "Id" integer not null primary key autoincrement) ; [] +gorptest: 02:00:48.200273 create table "embedded_autoincr_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255), "MiddleName" varchar(255)) ; [] +gorptest: 02:00:48.213825 create table "time_test" ("Id" integer not null primary key autoincrement, "Time" datetime) ; [] +gorptest: 02:00:48.222527 insert into "embedded_struct_test" ("Id","FirstName","LastName") values (null,?,?); [1:"Alice" 2:"Smith"] +gorptest: 02:00:48.235272 select "Id","FirstName","LastName" from "embedded_struct_test" where "Id"=?; [1:1] +gorptest: 02:00:48.235436 update "embedded_struct_test" set "FirstName"=?, "LastName"=? where "Id"=?; [1:"Bob" 2:"Smith" 3:1] +gorptest: 02:00:48.244228 select "Id","FirstName","LastName" from "embedded_struct_test" where "Id"=?; [1:1] +gorptest: 02:00:48.244331 select * from embedded_struct_test [] +gorptest: 02:00:48.244441 drop table if exists "invoice_test"; [] +gorptest: 02:00:48.256365 drop table if exists "invoice_tag_test"; [] +gorptest: 02:00:48.273944 drop table if exists "alias_trans_field_test"; [] +gorptest: 02:00:48.284192 drop table if exists "invoice_override_test"; [] +gorptest: 02:00:48.300725 drop table if exists "person_test"; [] +gorptest: 02:00:48.315167 drop table if exists "ignored_column_test"; [] +gorptest: 02:00:48.329156 drop table if exists "id_created_test"; [] +gorptest: 02:00:48.339481 drop table if exists "type_conv_test"; [] +gorptest: 02:00:48.352256 drop table if exists "embedded_struct_test"; [] +gorptest: 02:00:48.364258 drop table if exists "embedded_struct_before_autoincr_test"; [] +gorptest: 02:00:48.375991 drop table if exists "embedded_autoincr_test"; [] +gorptest: 02:00:48.384671 drop table if exists "time_test"; [] +gorptest: 02:00:48.394642 drop table if exists "id_created_test"; [] +--- PASS: TestWithEmbeddedStruct (0.34s) === RUN TestWithEmbeddedStructBeforeAutoincr -2025/09/15 19:35:21 Warning: Automatic mapping of Version struct members to version columns (see optimistic locking) will be deprecated in next version (V2) See: https://github.com/go-gorp/gorp/pull/214 -gorptest: 19:35:21.378610 drop table if exists "invoice_test"; [] -gorptest: 19:35:21.378778 drop table if exists "invoice_tag_test"; [] -gorptest: 19:35:21.378800 drop table if exists "alias_trans_field_test"; [] -gorptest: 19:35:21.378814 drop table if exists "invoice_override_test"; [] -gorptest: 19:35:21.378829 drop table if exists "person_test"; [] -gorptest: 19:35:21.378846 drop table if exists "ignored_column_test"; [] -gorptest: 19:35:21.378859 drop table if exists "id_created_test"; [] -gorptest: 19:35:21.378877 drop table if exists "type_conv_test"; [] -gorptest: 19:35:21.378890 drop table if exists "embedded_struct_test"; [] -gorptest: 19:35:21.378907 drop table if exists "embedded_struct_before_autoincr_test"; [] -gorptest: 19:35:21.378920 drop table if exists "embedded_autoincr_test"; [] -gorptest: 19:35:21.378935 drop table if exists "time_test"; [] -gorptest: 19:35:21.378976 create table "invoice_test" ("Id" integer not null primary key autoincrement, "Created" integer, "Updated" integer, "Memo" varchar(255), "PersonId" integer, "IsPaid" integer) ; [] -gorptest: 19:35:21.387632 create table "invoice_tag_test" ("myid" integer not null primary key autoincrement, "myCreated" integer, "date_updated" integer, "Memo" varchar(255), "person_id" integer, "is_Paid" integer) ; [] -gorptest: 19:35:21.398926 create table "alias_trans_field_test" ("id" integer not null primary key autoincrement, "bar" varchar(255)) ; [] -gorptest: 19:35:21.407724 create table "invoice_override_test" ("Id" varchar(255) not null primary key, "Created" integer, "Updated" integer, "Memo" varchar(255), "PersonId" integer, "IsPaid" integer) ; [] -gorptest: 19:35:21.420212 create table "person_test" ("Id" integer not null primary key autoincrement, "Created" integer, "Updated" integer, "FName" varchar(255), "LName" varchar(255), "Version" integer) ; [] -gorptest: 19:35:21.430049 create table "ignored_column_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] -gorptest: 19:35:21.439634 create table "id_created_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] -gorptest: 19:35:21.449502 create table "type_conv_test" ("Id" integer not null primary key autoincrement, "PersonJSON" varchar(255), "Name" varchar(255)) ; [] -gorptest: 19:35:21.460164 create table "embedded_struct_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255)) ; [] -gorptest: 19:35:21.470329 create table "embedded_struct_before_autoincr_test" ("FirstName" varchar(255), "LastName" varchar(255), "Id" integer not null primary key autoincrement) ; [] -gorptest: 19:35:21.480273 create table "embedded_autoincr_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255), "MiddleName" varchar(255)) ; [] -gorptest: 19:35:21.489468 create table "time_test" ("Id" integer not null primary key autoincrement, "Time" datetime) ; [] -gorptest: 19:35:21.497991 insert into "embedded_struct_before_autoincr_test" ("FirstName","LastName","Id") values (?,?,null); [1:"Alice" 2:"Smith"] -gorptest: 19:35:21.510319 drop table if exists "invoice_test"; [] -gorptest: 19:35:21.519699 drop table if exists "invoice_tag_test"; [] -gorptest: 19:35:21.532532 drop table if exists "alias_trans_field_test"; [] -gorptest: 19:35:21.544340 drop table if exists "invoice_override_test"; [] -gorptest: 19:35:21.558292 drop table if exists "person_test"; [] -gorptest: 19:35:21.570109 drop table if exists "ignored_column_test"; [] -gorptest: 19:35:21.581767 drop table if exists "id_created_test"; [] -gorptest: 19:35:21.593741 drop table if exists "type_conv_test"; [] -gorptest: 19:35:21.606287 drop table if exists "embedded_struct_test"; [] -gorptest: 19:35:21.617873 drop table if exists "embedded_struct_before_autoincr_test"; [] -gorptest: 19:35:21.632374 drop table if exists "embedded_autoincr_test"; [] -gorptest: 19:35:21.644175 drop table if exists "time_test"; [] -gorptest: 19:35:21.653979 drop table if exists "id_created_test"; [] ---- PASS: TestWithEmbeddedStructBeforeAutoincr (0.28s) +2026/10/19 02:00:48 Warning: Automatic mapping of Version struct members to version columns (see optimistic locking) will be deprecated in next version (V2) See: https://github.com/go-gorp/gorp/pull/214 +gorptest: 02:00:48.394953 drop table if exists "invoice_test"; [] +gorptest: 02:00:48.395284 drop table if exists "invoice_tag_test"; [] +gorptest: 02:00:48.395329 drop table if exists "alias_trans_field_test"; [] +gorptest: 02:00:48.395354 drop table if exists "invoice_override_test"; [] +gorptest: 02:00:48.395376 drop table if exists "person_test"; [] +gorptest: 02:00:48.395406 drop table if exists "ignored_column_test"; [] +gorptest: 02:00:48.395426 drop table if exists "id_created_test"; [] +gorptest: 02:00:48.395457 drop table if exists "type_conv_test"; [] +gorptest: 02:00:48.395478 drop table if exists "embedded_struct_test"; [] +gorptest: 02:00:48.395499 drop table if exists "embedded_struct_before_autoincr_test"; [] +gorptest: 02:00:48.395522 drop table if exists "embedded_autoincr_test"; [] +gorptest: 02:00:48.395543 drop table if exists "time_test"; [] +gorptest: 02:00:48.395579 create table "invoice_test" ("Id" integer not null primary key autoincrement, "Created" integer, "Updated" integer, "Memo" varchar(255), "PersonId" integer, "IsPaid" integer) ; [] +gorptest: 02:00:48.404165 create table "invoice_tag_test" ("myid" integer not null primary key autoincrement, "myCreated" integer, "date_updated" integer, "Memo" varchar(255), "person_id" integer, "is_Paid" integer) ; [] +gorptest: 02:00:48.420605 create table "alias_trans_field_test" ("id" integer not null primary key autoincrement, "bar" varchar(255)) ; [] +gorptest: 02:00:48.430123 create table "invoice_override_test" ("Id" varchar(255) not null primary key, "Created" integer, "Updated" integer, "Memo" varchar(255), "PersonId" integer, "IsPaid" integer) ; [] +gorptest: 02:00:48.447866 create table "person_test" ("Id" integer not null primary key autoincrement, "Created" integer, "Updated" integer, "FName" varchar(255), "LName" varchar(255), "Version" integer) ; [] +gorptest: 02:00:48.453921 create table "ignored_column_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] +gorptest: 02:00:48.462363 create table "id_created_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] +gorptest: 02:00:48.472451 create table "type_conv_test" ("Id" integer not null primary key autoincrement, "PersonJSON" varchar(255), "Name" varchar(255)) ; [] +gorptest: 02:00:48.482103 create table "embedded_struct_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255)) ; [] +gorptest: 02:00:48.492056 create table "embedded_struct_before_autoincr_test" ("FirstName" varchar(255), "LastName" varchar(255), "Id" integer not null primary key autoincrement) ; [] +gorptest: 02:00:48.502322 create table "embedded_autoincr_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255), "MiddleName" varchar(255)) ; [] +gorptest: 02:00:48.516299 create table "time_test" ("Id" integer not null primary key autoincrement, "Time" datetime) ; [] +gorptest: 02:00:48.524494 insert into "embedded_struct_before_autoincr_test" ("FirstName","LastName","Id") values (?,?,null); [1:"Alice" 2:"Smith"] +gorptest: 02:00:48.537175 drop table if exists "invoice_test"; [] +gorptest: 02:00:48.546839 drop table if exists "invoice_tag_test"; [] +gorptest: 02:00:48.559072 drop table if exists "alias_trans_field_test"; [] +gorptest: 02:00:48.571167 drop table if exists "invoice_override_test"; [] +gorptest: 02:00:48.584632 drop table if exists "person_test"; [] +gorptest: 02:00:48.597023 drop table if exists "ignored_column_test"; [] +gorptest: 02:00:48.608473 drop table if exists "id_created_test"; [] +gorptest: 02:00:48.620581 drop table if exists "type_conv_test"; [] +gorptest: 02:00:48.632556 drop table if exists "embedded_struct_test"; [] +gorptest: 02:00:48.644250 drop table if exists "embedded_struct_before_autoincr_test"; [] +gorptest: 02:00:48.658807 drop table if exists "embedded_autoincr_test"; [] +gorptest: 02:00:48.670042 drop table if exists "time_test"; [] +gorptest: 02:00:48.681573 drop table if exists "id_created_test"; [] +--- PASS: TestWithEmbeddedStructBeforeAutoincr (0.29s) === RUN TestWithEmbeddedAutoincr -2025/09/15 19:35:21 Warning: Automatic mapping of Version struct members to version columns (see optimistic locking) will be deprecated in next version (V2) See: https://github.com/go-gorp/gorp/pull/214 -gorptest: 19:35:21.654189 drop table if exists "invoice_test"; [] -gorptest: 19:35:21.654352 drop table if exists "invoice_tag_test"; [] -gorptest: 19:35:21.654375 drop table if exists "alias_trans_field_test"; [] -gorptest: 19:35:21.654389 drop table if exists "invoice_override_test"; [] -gorptest: 19:35:21.654406 drop table if exists "person_test"; [] -gorptest: 19:35:21.654420 drop table if exists "ignored_column_test"; [] -gorptest: 19:35:21.654434 drop table if exists "id_created_test"; [] -gorptest: 19:35:21.654448 drop table if exists "type_conv_test"; [] -gorptest: 19:35:21.654465 drop table if exists "embedded_struct_test"; [] -gorptest: 19:35:21.654478 drop table if exists "embedded_struct_before_autoincr_test"; [] -gorptest: 19:35:21.654495 drop table if exists "embedded_autoincr_test"; [] -gorptest: 19:35:21.654509 drop table if exists "time_test"; [] -gorptest: 19:35:21.654528 create table "invoice_test" ("Id" integer not null primary key autoincrement, "Created" integer, "Updated" integer, "Memo" varchar(255), "PersonId" integer, "IsPaid" integer) ; [] -gorptest: 19:35:21.664172 create table "invoice_tag_test" ("myid" integer not null primary key autoincrement, "myCreated" integer, "date_updated" integer, "Memo" varchar(255), "person_id" integer, "is_Paid" integer) ; [] -gorptest: 19:35:21.675768 create table "alias_trans_field_test" ("id" integer not null primary key autoincrement, "bar" varchar(255)) ; [] -gorptest: 19:35:21.688491 create table "invoice_override_test" ("Id" varchar(255) not null primary key, "Created" integer, "Updated" integer, "Memo" varchar(255), "PersonId" integer, "IsPaid" integer) ; [] -gorptest: 19:35:21.702221 create table "person_test" ("Id" integer not null primary key autoincrement, "Created" integer, "Updated" integer, "FName" varchar(255), "LName" varchar(255), "Version" integer) ; [] -gorptest: 19:35:21.713727 create table "ignored_column_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] -gorptest: 19:35:21.726323 create table "id_created_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] -gorptest: 19:35:21.738347 create table "type_conv_test" ("Id" integer not null primary key autoincrement, "PersonJSON" varchar(255), "Name" varchar(255)) ; [] -gorptest: 19:35:21.750211 create table "embedded_struct_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255)) ; [] -gorptest: 19:35:21.761834 create table "embedded_struct_before_autoincr_test" ("FirstName" varchar(255), "LastName" varchar(255), "Id" integer not null primary key autoincrement) ; [] -gorptest: 19:35:21.773673 create table "embedded_autoincr_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255), "MiddleName" varchar(255)) ; [] -gorptest: 19:35:21.786935 create table "time_test" ("Id" integer not null primary key autoincrement, "Time" datetime) ; [] -gorptest: 19:35:21.796543 insert into "embedded_autoincr_test" ("Id","FirstName","LastName","MiddleName") values (null,?,?,?); [1:"Alice" 2:"Smith" 3:"Rose"] -gorptest: 19:35:21.807823 drop table if exists "invoice_test"; [] -gorptest: 19:35:21.816511 drop table if exists "invoice_tag_test"; [] -gorptest: 19:35:21.825908 drop table if exists "alias_trans_field_test"; [] -gorptest: 19:35:21.836490 drop table if exists "invoice_override_test"; [] -gorptest: 19:35:21.848783 drop table if exists "person_test"; [] -gorptest: 19:35:21.858510 drop table if exists "ignored_column_test"; [] -gorptest: 19:35:21.868153 drop table if exists "id_created_test"; [] -gorptest: 19:35:21.877860 drop table if exists "type_conv_test"; [] -gorptest: 19:35:21.888253 drop table if exists "embedded_struct_test"; [] -gorptest: 19:35:21.898265 drop table if exists "embedded_struct_before_autoincr_test"; [] -gorptest: 19:35:21.908239 drop table if exists "embedded_autoincr_test"; [] -gorptest: 19:35:21.917833 drop table if exists "time_test"; [] -gorptest: 19:35:21.928021 drop table if exists "id_created_test"; [] ---- PASS: TestWithEmbeddedAutoincr (0.27s) +2026/10/19 02:00:48 Warning: Automatic mapping of Version struct members to version columns (see optimistic locking) will be deprecated in next version (V2) See: https://github.com/go-gorp/gorp/pull/214 +gorptest: 02:00:48.681963 drop table if exists "invoice_test"; [] +gorptest: 02:00:48.682296 drop table if exists "invoice_tag_test"; [] +gorptest: 02:00:48.682343 drop table if exists "alias_trans_field_test"; [] +gorptest: 02:00:48.682367 drop table if exists "invoice_override_test"; [] +gorptest: 02:00:48.682396 drop table if exists "person_test"; [] +gorptest: 02:00:48.682417 drop table if exists "ignored_column_test"; [] +gorptest: 02:00:48.682439 drop table if exists "id_created_test"; [] +gorptest: 02:00:48.682459 drop table if exists "type_conv_test"; [] +gorptest: 02:00:48.682486 drop table if exists "embedded_struct_test"; [] +gorptest: 02:00:48.682506 drop table if exists "embedded_struct_before_autoincr_test"; [] +gorptest: 02:00:48.682533 drop table if exists "embedded_autoincr_test"; [] +gorptest: 02:00:48.682554 drop table if exists "time_test"; [] +gorptest: 02:00:48.682583 create table "invoice_test" ("Id" integer not null primary key autoincrement, "Created" integer, "Updated" integer, "Memo" varchar(255), "PersonId" integer, "IsPaid" integer) ; [] +gorptest: 02:00:48.690876 create table "invoice_tag_test" ("myid" integer not null primary key autoincrement, "myCreated" integer, "date_updated" integer, "Memo" varchar(255), "person_id" integer, "is_Paid" integer) ; [] +gorptest: 02:00:48.702896 create table "alias_trans_field_test" ("id" integer not null primary key autoincrement, "bar" varchar(255)) ; [] +gorptest: 02:00:48.714981 create table "invoice_override_test" ("Id" varchar(255) not null primary key, "Created" integer, "Updated" integer, "Memo" varchar(255), "PersonId" integer, "IsPaid" integer) ; [] +gorptest: 02:00:48.728634 create table "person_test" ("Id" integer not null primary key autoincrement, "Created" integer, "Updated" integer, "FName" varchar(255), "LName" varchar(255), "Version" integer) ; [] +gorptest: 02:00:48.740871 create table "ignored_column_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] +gorptest: 02:00:48.752928 create table "id_created_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] +gorptest: 02:00:48.764143 create table "type_conv_test" ("Id" integer not null primary key autoincrement, "PersonJSON" varchar(255), "Name" varchar(255)) ; [] +gorptest: 02:00:48.776223 create table "embedded_struct_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255)) ; [] +gorptest: 02:00:48.788533 create table "embedded_struct_before_autoincr_test" ("FirstName" varchar(255), "LastName" varchar(255), "Id" integer not null primary key autoincrement) ; [] +gorptest: 02:00:48.801042 create table "embedded_autoincr_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255), "MiddleName" varchar(255)) ; [] +gorptest: 02:00:48.812695 create table "time_test" ("Id" integer not null primary key autoincrement, "Time" datetime) ; [] +gorptest: 02:00:48.841182 insert into "embedded_autoincr_test" ("Id","FirstName","LastName","MiddleName") values (null,?,?,?); [1:"Alice" 2:"Smith" 3:"Rose"] +gorptest: 02:00:48.852761 drop table if exists "invoice_test"; [] +gorptest: 02:00:48.861169 drop table if exists "invoice_tag_test"; [] +gorptest: 02:00:48.871003 drop table if exists "alias_trans_field_test"; [] +gorptest: 02:00:48.881122 drop table if exists "invoice_override_test"; [] +gorptest: 02:00:48.892648 drop table if exists "person_test"; [] +gorptest: 02:00:48.902829 drop table if exists "ignored_column_test"; [] +gorptest: 02:00:48.912312 drop table if exists "id_created_test"; [] +gorptest: 02:00:48.923119 drop table if exists "type_conv_test"; [] +gorptest: 02:00:48.932790 drop table if exists "embedded_struct_test"; [] +gorptest: 02:00:48.942243 drop table if exists "embedded_struct_before_autoincr_test"; [] +gorptest: 02:00:48.952805 drop table if exists "embedded_autoincr_test"; [] +gorptest: 02:00:48.962816 drop table if exists "time_test"; [] +gorptest: 02:00:48.972733 drop table if exists "id_created_test"; [] +--- PASS: TestWithEmbeddedAutoincr (0.29s) === RUN TestSelectVal -gorptest: 19:35:21.928218 create table "TableWithNull" ("Id" integer not null primary key, "Str" varchar(255), "Int64" integer, "Float64" real, "Bool" integer, "Bytes" blob) ; [] -gorptest: 19:35:21.937893 insert into "TableWithNull" ("Id","Str","Int64","Float64","Bool","Bytes") values (?,?,?,?,?,?); [1:0 2:"abc" 3:78 4:32.2 5:true 6:[104 105]] -gorptest: 19:35:21.948113 select Int64 from TableWithNull where Str='abc' [] -gorptest: 19:35:21.948199 select count(*) from TableWithNull [] -gorptest: 19:35:21.948254 select count(*) from TableWithNull where Str=? [1:"asdfasdf"] -gorptest: 19:35:21.948286 select Int64 from TableWithNull where Str='notfound' [] -gorptest: 19:35:21.948313 select Int64 from TableWithNull where Str='abc' [] -gorptest: 19:35:21.948337 select Float64 from TableWithNull where Str='abc' [] -gorptest: 19:35:21.948356 select min(Float64) from TableWithNull [] -gorptest: 19:35:21.948382 select count(*) from TableWithNull where Str=? [1:"asdfasdf"] -gorptest: 19:35:21.948408 select Float64 from TableWithNull where Str='notfound' [] -gorptest: 19:35:21.948427 select Float64 from TableWithNull where Str='abc' [] -gorptest: 19:35:21.948450 select Str from TableWithNull where Int64=? [1:78] -gorptest: 19:35:21.948470 select Str from TableWithNull where Str='asdfasdf' [] -gorptest: 19:35:21.948491 select Str from TableWithNull where Int64=? [1:78] -gorptest: 19:35:21.948510 select Str from TableWithNull where Str='asdfasdf' [] -gorptest: 19:35:21.948544 select Int64 from TableWithNull where Str=? [1:"abc"] -gorptest: 19:35:21.948570 select Str from TableWithNull where Int64=? [1:78] -gorptest: 19:35:21.948592 drop table if exists "TableWithNull"; [] +gorptest: 02:00:48.973021 create table "TableWithNull" ("Id" integer not null primary key, "Str" varchar(255), "Int64" integer, "Float64" real, "Bool" integer, "Bytes" blob) ; [] +gorptest: 02:00:48.982586 insert into "TableWithNull" ("Id","Str","Int64","Float64","Bool","Bytes") values (?,?,?,?,?,?); [1:0 2:"abc" 3:78 4:32.2 5:true 6:[104 105]] +gorptest: 02:00:48.992255 select Int64 from TableWithNull where Str='abc' [] +gorptest: 02:00:48.992370 select count(*) from TableWithNull [] +gorptest: 02:00:48.992449 select count(*) from TableWithNull where Str=? [1:"asdfasdf"] +gorptest: 02:00:48.992529 select Int64 from TableWithNull where Str='notfound' [] +gorptest: 02:00:48.992620 select Int64 from TableWithNull where Str='abc' [] +gorptest: 02:00:48.992669 select Float64 from TableWithNull where Str='abc' [] +gorptest: 02:00:48.992766 select min(Float64) from TableWithNull [] +gorptest: 02:00:48.992862 select count(*) from TableWithNull where Str=? [1:"asdfasdf"] +gorptest: 02:00:48.992986 select Float64 from TableWithNull where Str='notfound' [] +gorptest: 02:00:48.993140 select Float64 from TableWithNull where Str='abc' [] +gorptest: 02:00:48.993196 select Str from TableWithNull where Int64=? [1:78] +gorptest: 02:00:48.993246 select Str from TableWithNull where Str='asdfasdf' [] +gorptest: 02:00:48.993289 select Str from TableWithNull where Int64=? [1:78] +gorptest: 02:00:48.993333 select Str from TableWithNull where Str='asdfasdf' [] +gorptest: 02:00:48.993474 select Int64 from TableWithNull where Str=? [1:"abc"] +gorptest: 02:00:48.993571 select Str from TableWithNull where Int64=? [1:78] +gorptest: 02:00:48.993703 drop table if exists "TableWithNull"; [] --- PASS: TestSelectVal (0.03s) === RUN TestVersionMultipleRows -2025/09/15 19:35:21 Warning: Automatic mapping of Version struct members to version columns (see optimistic locking) will be deprecated in next version (V2) See: https://github.com/go-gorp/gorp/pull/214 -gorptest: 19:35:21.957871 drop table if exists "invoice_test"; [] -gorptest: 19:35:21.958054 drop table if exists "invoice_tag_test"; [] -gorptest: 19:35:21.958077 drop table if exists "alias_trans_field_test"; [] -gorptest: 19:35:21.958091 drop table if exists "invoice_override_test"; [] -gorptest: 19:35:21.958105 drop table if exists "person_test"; [] -gorptest: 19:35:21.958120 drop table if exists "ignored_column_test"; [] -gorptest: 19:35:21.958134 drop table if exists "id_created_test"; [] -gorptest: 19:35:21.958151 drop table if exists "type_conv_test"; [] -gorptest: 19:35:21.958165 drop table if exists "embedded_struct_test"; [] -gorptest: 19:35:21.958182 drop table if exists "embedded_struct_before_autoincr_test"; [] -gorptest: 19:35:21.958196 drop table if exists "embedded_autoincr_test"; [] -gorptest: 19:35:21.958213 drop table if exists "time_test"; [] -gorptest: 19:35:21.958231 create table "invoice_test" ("Id" integer not null primary key autoincrement, "Created" integer, "Updated" integer, "Memo" varchar(255), "PersonId" integer, "IsPaid" integer) ; [] -gorptest: 19:35:21.970315 create table "invoice_tag_test" ("myid" integer not null primary key autoincrement, "myCreated" integer, "date_updated" integer, "Memo" varchar(255), "person_id" integer, "is_Paid" integer) ; [] -gorptest: 19:35:21.977888 create table "alias_trans_field_test" ("id" integer not null primary key autoincrement, "bar" varchar(255)) ; [] -gorptest: 19:35:21.988117 create table "invoice_override_test" ("Id" varchar(255) not null primary key, "Created" integer, "Updated" integer, "Memo" varchar(255), "PersonId" integer, "IsPaid" integer) ; [] -gorptest: 19:35:21.999886 create table "person_test" ("Id" integer not null primary key autoincrement, "Created" integer, "Updated" integer, "FName" varchar(255), "LName" varchar(255), "Version" integer) ; [] -gorptest: 19:35:22.009670 create table "ignored_column_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] -gorptest: 19:35:22.019741 create table "id_created_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] -gorptest: 19:35:22.030282 create table "type_conv_test" ("Id" integer not null primary key autoincrement, "PersonJSON" varchar(255), "Name" varchar(255)) ; [] -gorptest: 19:35:22.039898 create table "embedded_struct_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255)) ; [] -gorptest: 19:35:22.049902 create table "embedded_struct_before_autoincr_test" ("FirstName" varchar(255), "LastName" varchar(255), "Id" integer not null primary key autoincrement) ; [] -gorptest: 19:35:22.060537 create table "embedded_autoincr_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255), "MiddleName" varchar(255)) ; [] -gorptest: 19:35:22.070176 create table "time_test" ("Id" integer not null primary key autoincrement, "Time" datetime) ; [] -gorptest: 19:35:22.078052 insert into "person_test" ("Id","Created","Updated","FName","LName","Version") values (null,?,?,?,?,?); [1:1757964922078035120 2:1757964922078035120 3:"Bob" 4:"Smith" 5:1] -gorptest: 19:35:22.089711 insert into "person_test" ("Id","Created","Updated","FName","LName","Version") values (null,?,?,?,?,?); [1:1757964922089677198 2:1757964922089677198 3:"Jane" 4:"Smith" 5:1] -gorptest: 19:35:22.102478 insert into "person_test" ("Id","Created","Updated","FName","LName","Version") values (null,?,?,?,?,?); [1:1757964922102463955 2:1757964922102463955 3:"Mike" 4:"Smith" 5:1] -gorptest: 19:35:22.114226 drop table if exists "invoice_test"; [] -gorptest: 19:35:22.124217 drop table if exists "invoice_tag_test"; [] -gorptest: 19:35:22.136110 drop table if exists "alias_trans_field_test"; [] -gorptest: 19:35:22.148147 drop table if exists "invoice_override_test"; [] -gorptest: 19:35:22.161845 drop table if exists "person_test"; [] -gorptest: 19:35:22.176083 drop table if exists "ignored_column_test"; [] -gorptest: 19:35:22.188702 drop table if exists "id_created_test"; [] -gorptest: 19:35:22.199645 drop table if exists "type_conv_test"; [] -gorptest: 19:35:22.212239 drop table if exists "embedded_struct_test"; [] -gorptest: 19:35:22.224293 drop table if exists "embedded_struct_before_autoincr_test"; [] -gorptest: 19:35:22.236380 drop table if exists "embedded_autoincr_test"; [] -gorptest: 19:35:22.248125 drop table if exists "time_test"; [] -gorptest: 19:35:22.258302 drop table if exists "id_created_test"; [] +2026/10/19 02:00:49 Warning: Automatic mapping of Version struct members to version columns (see optimistic locking) will be deprecated in next version (V2) See: https://github.com/go-gorp/gorp/pull/214 +gorptest: 02:00:49.002982 drop table if exists "invoice_test"; [] +gorptest: 02:00:49.003306 drop table if exists "invoice_tag_test"; [] +gorptest: 02:00:49.003351 drop table if exists "alias_trans_field_test"; [] +gorptest: 02:00:49.003404 drop table if exists "invoice_override_test"; [] +gorptest: 02:00:49.003463 drop table if exists "person_test"; [] +gorptest: 02:00:49.003521 drop table if exists "ignored_column_test"; [] +gorptest: 02:00:49.003585 drop table if exists "id_created_test"; [] +gorptest: 02:00:49.003615 drop table if exists "type_conv_test"; [] +gorptest: 02:00:49.003645 drop table if exists "embedded_struct_test"; [] +gorptest: 02:00:49.003670 drop table if exists "embedded_struct_before_autoincr_test"; [] +gorptest: 02:00:49.003701 drop table if exists "embedded_autoincr_test"; [] +gorptest: 02:00:49.003721 drop table if exists "time_test"; [] +gorptest: 02:00:49.003755 create table "invoice_test" ("Id" integer not null primary key autoincrement, "Created" integer, "Updated" integer, "Memo" varchar(255), "PersonId" integer, "IsPaid" integer) ; [] +gorptest: 02:00:49.012985 create table "invoice_tag_test" ("myid" integer not null primary key autoincrement, "myCreated" integer, "date_updated" integer, "Memo" varchar(255), "person_id" integer, "is_Paid" integer) ; [] +gorptest: 02:00:49.022125 create table "alias_trans_field_test" ("id" integer not null primary key autoincrement, "bar" varchar(255)) ; [] +gorptest: 02:00:49.032770 create table "invoice_override_test" ("Id" varchar(255) not null primary key, "Created" integer, "Updated" integer, "Memo" varchar(255), "PersonId" integer, "IsPaid" integer) ; [] +gorptest: 02:00:49.044156 create table "person_test" ("Id" integer not null primary key autoincrement, "Created" integer, "Updated" integer, "FName" varchar(255), "LName" varchar(255), "Version" integer) ; [] +gorptest: 02:00:49.054848 create table "ignored_column_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] +gorptest: 02:00:49.064963 create table "id_created_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] +gorptest: 02:00:49.074648 create table "type_conv_test" ("Id" integer not null primary key autoincrement, "PersonJSON" varchar(255), "Name" varchar(255)) ; [] +gorptest: 02:00:49.084110 create table "embedded_struct_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255)) ; [] +gorptest: 02:00:49.094510 create table "embedded_struct_before_autoincr_test" ("FirstName" varchar(255), "LastName" varchar(255), "Id" integer not null primary key autoincrement) ; [] +gorptest: 02:00:49.104812 create table "embedded_autoincr_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255), "MiddleName" varchar(255)) ; [] +gorptest: 02:00:49.114476 create table "time_test" ("Id" integer not null primary key autoincrement, "Time" datetime) ; [] +gorptest: 02:00:49.122281 insert into "person_test" ("Id","Created","Updated","FName","LName","Version") values (null,?,?,?,?,?); [1:1792375249122262055 2:1792375249122262055 3:"Bob" 4:"Smith" 5:1] +gorptest: 02:00:49.134821 insert into "person_test" ("Id","Created","Updated","FName","LName","Version") values (null,?,?,?,?,?); [1:1792375249134761471 2:1792375249134761471 3:"Jane" 4:"Smith" 5:1] +gorptest: 02:00:49.146993 insert into "person_test" ("Id","Created","Updated","FName","LName","Version") values (null,?,?,?,?,?); [1:1792375249146980712 2:1792375249146980712 3:"Mike" 4:"Smith" 5:1] +gorptest: 02:00:49.158409 drop table if exists "invoice_test"; [] +gorptest: 02:00:49.169000 drop table if exists "invoice_tag_test"; [] +gorptest: 02:00:49.181974 drop table if exists "alias_trans_field_test"; [] +gorptest: 02:00:49.192179 drop table if exists "invoice_override_test"; [] +gorptest: 02:00:49.206957 drop table if exists "person_test"; [] +gorptest: 02:00:49.220014 drop table if exists "ignored_column_test"; [] +gorptest: 02:00:49.232063 drop table if exists "id_created_test"; [] +gorptest: 02:00:49.244163 drop table if exists "type_conv_test"; [] +gorptest: 02:00:49.257511 drop table if exists "embedded_struct_test"; [] +gorptest: 02:00:49.268887 drop table if exists "embedded_struct_before_autoincr_test"; [] +gorptest: 02:00:49.280073 drop table if exists "embedded_autoincr_test"; [] +gorptest: 02:00:49.293661 drop table if exists "time_test"; [] +gorptest: 02:00:49.302256 drop table if exists "id_created_test"; [] --- PASS: TestVersionMultipleRows (0.30s) === RUN TestWithStringPk -gorptest: 19:35:22.258511 create table string_pk_test (Id varchar(255), Name varchar(255)); [] -gorptest: 19:35:22.268473 insert into "string_pk_test" ("Id","Name") values (null,?); [1:"foo"] -gorptest: 19:35:22.276378 drop table if exists "string_pk_test"; [] +gorptest: 02:00:49.302540 create table string_pk_test (Id varchar(255), Name varchar(255)); [] +gorptest: 02:00:49.312911 insert into "string_pk_test" ("Id","Name") values (null,?); [1:"foo"] +gorptest: 02:00:49.325310 drop table if exists "string_pk_test"; [] --- PASS: TestWithStringPk (0.03s) === RUN TestSqlExecutorInterfaceSelects --- PASS: TestSqlExecutorInterfaceSelects (0.00s) === RUN TestWithTimeSelect -2025/09/15 19:35:22 Warning: Automatic mapping of Version struct members to version columns (see optimistic locking) will be deprecated in next version (V2) See: https://github.com/go-gorp/gorp/pull/214 -gorptest: 19:35:22.286394 drop table if exists "invoice_test"; [] -gorptest: 19:35:22.286575 drop table if exists "invoice_tag_test"; [] -gorptest: 19:35:22.286599 drop table if exists "alias_trans_field_test"; [] -gorptest: 19:35:22.286613 drop table if exists "invoice_override_test"; [] -gorptest: 19:35:22.286628 drop table if exists "person_test"; [] -gorptest: 19:35:22.286644 drop table if exists "ignored_column_test"; [] -gorptest: 19:35:22.286658 drop table if exists "id_created_test"; [] -gorptest: 19:35:22.286675 drop table if exists "type_conv_test"; [] -gorptest: 19:35:22.286688 drop table if exists "embedded_struct_test"; [] -gorptest: 19:35:22.286705 drop table if exists "embedded_struct_before_autoincr_test"; [] -gorptest: 19:35:22.286719 drop table if exists "embedded_autoincr_test"; [] -gorptest: 19:35:22.286736 drop table if exists "time_test"; [] -gorptest: 19:35:22.286754 create table "invoice_test" ("Id" integer not null primary key autoincrement, "Created" integer, "Updated" integer, "Memo" varchar(255), "PersonId" integer, "IsPaid" integer) ; [] -gorptest: 19:35:22.295687 create table "invoice_tag_test" ("myid" integer not null primary key autoincrement, "myCreated" integer, "date_updated" integer, "Memo" varchar(255), "person_id" integer, "is_Paid" integer) ; [] -gorptest: 19:35:22.308131 create table "alias_trans_field_test" ("id" integer not null primary key autoincrement, "bar" varchar(255)) ; [] -gorptest: 19:35:22.319967 create table "invoice_override_test" ("Id" varchar(255) not null primary key, "Created" integer, "Updated" integer, "Memo" varchar(255), "PersonId" integer, "IsPaid" integer) ; [] -gorptest: 19:35:22.333736 create table "person_test" ("Id" integer not null primary key autoincrement, "Created" integer, "Updated" integer, "FName" varchar(255), "LName" varchar(255), "Version" integer) ; [] -gorptest: 19:35:22.349873 create table "ignored_column_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] -gorptest: 19:35:22.358273 create table "id_created_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] -gorptest: 19:35:22.369954 create table "type_conv_test" ("Id" integer not null primary key autoincrement, "PersonJSON" varchar(255), "Name" varchar(255)) ; [] -gorptest: 19:35:22.381612 create table "embedded_struct_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255)) ; [] -gorptest: 19:35:22.394495 create table "embedded_struct_before_autoincr_test" ("FirstName" varchar(255), "LastName" varchar(255), "Id" integer not null primary key autoincrement) ; [] -gorptest: 19:35:22.406528 create table "embedded_autoincr_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255), "MiddleName" varchar(255)) ; [] -gorptest: 19:35:22.418426 create table "time_test" ("Id" integer not null primary key autoincrement, "Time" datetime) ; [] -gorptest: 19:35:22.427940 insert into "time_test" ("Id","Time") values (null,?); [1:2025-09-15 19:04:22.427901405 +0000 UTC] -gorptest: 19:35:22.439390 insert into "time_test" ("Id","Time") values (null,?); [1:2025-09-15 19:05:23.427901405 +0000 UTC] -gorptest: 19:35:22.465606 SELECT id FROM time_test WHERE Time < ? [1:2025-09-15 19:05:22.427901405 +0000 UTC] -gorptest: 19:35:22.465743 drop table if exists "invoice_test"; [] -gorptest: 19:35:22.471229 drop table if exists "invoice_tag_test"; [] -gorptest: 19:35:22.476729 drop table if exists "alias_trans_field_test"; [] -gorptest: 19:35:22.484396 drop table if exists "invoice_override_test"; [] -gorptest: 19:35:22.492242 drop table if exists "person_test"; [] -gorptest: 19:35:22.502072 drop table if exists "ignored_column_test"; [] -gorptest: 19:35:22.511718 drop table if exists "id_created_test"; [] -gorptest: 19:35:22.522269 drop table if exists "type_conv_test"; [] -gorptest: 19:35:22.531732 drop table if exists "embedded_struct_test"; [] -gorptest: 19:35:22.542213 drop table if exists "embedded_struct_before_autoincr_test"; [] -gorptest: 19:35:22.552025 drop table if exists "embedded_autoincr_test"; [] -gorptest: 19:35:22.561658 drop table if exists "time_test"; [] -gorptest: 19:35:22.572330 drop table if exists "id_created_test"; [] +2026/10/19 02:00:49 Warning: Automatic mapping of Version struct members to version columns (see optimistic locking) will be deprecated in next version (V2) See: https://github.com/go-gorp/gorp/pull/214 +gorptest: 02:00:49.331112 drop table if exists "invoice_test"; [] +gorptest: 02:00:49.331347 drop table if exists "invoice_tag_test"; [] +gorptest: 02:00:49.331390 drop table if exists "alias_trans_field_test"; [] +gorptest: 02:00:49.331419 drop table if exists "invoice_override_test"; [] +gorptest: 02:00:49.331449 drop table if exists "person_test"; [] +gorptest: 02:00:49.331475 drop table if exists "ignored_column_test"; [] +gorptest: 02:00:49.331501 drop table if exists "id_created_test"; [] +gorptest: 02:00:49.331527 drop table if exists "type_conv_test"; [] +gorptest: 02:00:49.331553 drop table if exists "embedded_struct_test"; [] +gorptest: 02:00:49.331578 drop table if exists "embedded_struct_before_autoincr_test"; [] +gorptest: 02:00:49.331604 drop table if exists "embedded_autoincr_test"; [] +gorptest: 02:00:49.331630 drop table if exists "time_test"; [] +gorptest: 02:00:49.331664 create table "invoice_test" ("Id" integer not null primary key autoincrement, "Created" integer, "Updated" integer, "Memo" varchar(255), "PersonId" integer, "IsPaid" integer) ; [] +gorptest: 02:00:49.340021 create table "invoice_tag_test" ("myid" integer not null primary key autoincrement, "myCreated" integer, "date_updated" integer, "Memo" varchar(255), "person_id" integer, "is_Paid" integer) ; [] +gorptest: 02:00:49.352836 create table "alias_trans_field_test" ("id" integer not null primary key autoincrement, "bar" varchar(255)) ; [] +gorptest: 02:00:49.364369 create table "invoice_override_test" ("Id" varchar(255) not null primary key, "Created" integer, "Updated" integer, "Memo" varchar(255), "PersonId" integer, "IsPaid" integer) ; [] +gorptest: 02:00:49.378500 create table "person_test" ("Id" integer not null primary key autoincrement, "Created" integer, "Updated" integer, "FName" varchar(255), "LName" varchar(255), "Version" integer) ; [] +gorptest: 02:00:49.390979 create table "ignored_column_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] +gorptest: 02:00:49.402669 create table "id_created_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] +gorptest: 02:00:49.414062 create table "type_conv_test" ("Id" integer not null primary key autoincrement, "PersonJSON" varchar(255), "Name" varchar(255)) ; [] +gorptest: 02:00:49.426518 create table "embedded_struct_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255)) ; [] +gorptest: 02:00:49.438534 create table "embedded_struct_before_autoincr_test" ("FirstName" varchar(255), "LastName" varchar(255), "Id" integer not null primary key autoincrement) ; [] +gorptest: 02:00:49.450722 create table "embedded_autoincr_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255), "MiddleName" varchar(255)) ; [] +gorptest: 02:00:49.462939 create table "time_test" ("Id" integer not null primary key autoincrement, "Time" datetime) ; [] +gorptest: 02:00:49.472550 insert into "time_test" ("Id","Time") values (null,?); [1:2026-10-19 01:29:49.472511151 +0000 UTC] +gorptest: 02:00:49.484841 insert into "time_test" ("Id","Time") values (null,?); [1:2026-10-19 01:30:50.472511151 +0000 UTC] +gorptest: 02:00:49.496772 SELECT id FROM time_test WHERE Time < ? [1:2026-10-19 01:30:49.472511151 +0000 UTC] +gorptest: 02:00:49.496936 drop table if exists "invoice_test"; [] +gorptest: 02:00:49.505198 drop table if exists "invoice_tag_test"; [] +gorptest: 02:00:49.514735 drop table if exists "alias_trans_field_test"; [] +gorptest: 02:00:49.524871 drop table if exists "invoice_override_test"; [] +gorptest: 02:00:49.537244 drop table if exists "person_test"; [] +gorptest: 02:00:49.546596 drop table if exists "ignored_column_test"; [] +gorptest: 02:00:49.556928 drop table if exists "id_created_test"; [] +gorptest: 02:00:49.566590 drop table if exists "type_conv_test"; [] +gorptest: 02:00:49.576973 drop table if exists "embedded_struct_test"; [] +gorptest: 02:00:49.586154 drop table if exists "embedded_struct_before_autoincr_test"; [] +gorptest: 02:00:49.596722 drop table if exists "embedded_autoincr_test"; [] +gorptest: 02:00:49.607134 drop table if exists "time_test"; [] +gorptest: 02:00:49.616421 drop table if exists "id_created_test"; [] --- PASS: TestWithTimeSelect (0.29s) === RUN TestInvoicePersonView -2025/09/15 19:35:22 Warning: Automatic mapping of Version struct members to version columns (see optimistic locking) will be deprecated in next version (V2) See: https://github.com/go-gorp/gorp/pull/214 -gorptest: 19:35:22.572573 drop table if exists "invoice_test"; [] -gorptest: 19:35:22.572772 drop table if exists "invoice_tag_test"; [] -gorptest: 19:35:22.572795 drop table if exists "alias_trans_field_test"; [] -gorptest: 19:35:22.572811 drop table if exists "invoice_override_test"; [] -gorptest: 19:35:22.572826 drop table if exists "person_test"; [] -gorptest: 19:35:22.572851 drop table if exists "ignored_column_test"; [] -gorptest: 19:35:22.572872 drop table if exists "id_created_test"; [] -gorptest: 19:35:22.572891 drop table if exists "type_conv_test"; [] -gorptest: 19:35:22.572914 drop table if exists "embedded_struct_test"; [] -gorptest: 19:35:22.572931 drop table if exists "embedded_struct_before_autoincr_test"; [] -gorptest: 19:35:22.572955 drop table if exists "embedded_autoincr_test"; [] -gorptest: 19:35:22.572975 drop table if exists "time_test"; [] -gorptest: 19:35:22.573009 create table "invoice_test" ("Id" integer not null primary key autoincrement, "Created" integer, "Updated" integer, "Memo" varchar(255), "PersonId" integer, "IsPaid" integer) ; [] -gorptest: 19:35:22.581909 create table "invoice_tag_test" ("myid" integer not null primary key autoincrement, "myCreated" integer, "date_updated" integer, "Memo" varchar(255), "person_id" integer, "is_Paid" integer) ; [] -gorptest: 19:35:22.591497 create table "alias_trans_field_test" ("id" integer not null primary key autoincrement, "bar" varchar(255)) ; [] -gorptest: 19:35:22.601688 create table "invoice_override_test" ("Id" varchar(255) not null primary key, "Created" integer, "Updated" integer, "Memo" varchar(255), "PersonId" integer, "IsPaid" integer) ; [] -gorptest: 19:35:22.614263 create table "person_test" ("Id" integer not null primary key autoincrement, "Created" integer, "Updated" integer, "FName" varchar(255), "LName" varchar(255), "Version" integer) ; [] -gorptest: 19:35:22.623836 create table "ignored_column_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] -gorptest: 19:35:22.639345 create table "id_created_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] -gorptest: 19:35:22.653747 create table "type_conv_test" ("Id" integer not null primary key autoincrement, "PersonJSON" varchar(255), "Name" varchar(255)) ; [] -gorptest: 19:35:22.659624 create table "embedded_struct_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255)) ; [] -gorptest: 19:35:22.665195 create table "embedded_struct_before_autoincr_test" ("FirstName" varchar(255), "LastName" varchar(255), "Id" integer not null primary key autoincrement) ; [] -gorptest: 19:35:22.674259 create table "embedded_autoincr_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255), "MiddleName" varchar(255)) ; [] -gorptest: 19:35:22.684302 create table "time_test" ("Id" integer not null primary key autoincrement, "Time" datetime) ; [] -gorptest: 19:35:22.691910 insert into "person_test" ("Id","Created","Updated","FName","LName","Version") values (null,?,?,?,?,?); [1:1757964922691884707 2:1757964922691884707 3:"bob" 4:"smith" 5:1] -gorptest: 19:35:22.703748 insert into "invoice_test" ("Id","Created","Updated","Memo","PersonId","IsPaid") values (null,?,?,?,?,?); [1:0 2:0 3:"xmas order" 4:1 5:false] -gorptest: 19:35:22.716050 select i.Id InvoiceId, p.Id PersonId, i.Memo, p.FName from invoice_test i, person_test p where i.PersonId = p.Id [] -gorptest: 19:35:22.716218 drop table if exists "invoice_test"; [] -gorptest: 19:35:22.727897 drop table if exists "invoice_tag_test"; [] -gorptest: 19:35:22.739680 drop table if exists "alias_trans_field_test"; [] -gorptest: 19:35:22.752266 drop table if exists "invoice_override_test"; [] -gorptest: 19:35:22.766283 drop table if exists "person_test"; [] -gorptest: 19:35:22.780199 drop table if exists "ignored_column_test"; [] -gorptest: 19:35:22.792249 drop table if exists "id_created_test"; [] -gorptest: 19:35:22.803842 drop table if exists "type_conv_test"; [] -gorptest: 19:35:22.815723 drop table if exists "embedded_struct_test"; [] -gorptest: 19:35:22.828178 drop table if exists "embedded_struct_before_autoincr_test"; [] -gorptest: 19:35:22.840235 drop table if exists "embedded_autoincr_test"; [] -gorptest: 19:35:22.851946 drop table if exists "time_test"; [] -gorptest: 19:35:22.861893 drop table if exists "id_created_test"; [] +2026/10/19 02:00:49 Warning: Automatic mapping of Version struct members to version columns (see optimistic locking) will be deprecated in next version (V2) See: https://github.com/go-gorp/gorp/pull/214 +gorptest: 02:00:49.616760 drop table if exists "invoice_test"; [] +gorptest: 02:00:49.617152 drop table if exists "invoice_tag_test"; [] +gorptest: 02:00:49.617228 drop table if exists "alias_trans_field_test"; [] +gorptest: 02:00:49.617271 drop table if exists "invoice_override_test"; [] +gorptest: 02:00:49.617303 drop table if exists "person_test"; [] +gorptest: 02:00:49.617331 drop table if exists "ignored_column_test"; [] +gorptest: 02:00:49.617352 drop table if exists "id_created_test"; [] +gorptest: 02:00:49.617382 drop table if exists "type_conv_test"; [] +gorptest: 02:00:49.617411 drop table if exists "embedded_struct_test"; [] +gorptest: 02:00:49.617440 drop table if exists "embedded_struct_before_autoincr_test"; [] +gorptest: 02:00:49.617468 drop table if exists "embedded_autoincr_test"; [] +gorptest: 02:00:49.617508 drop table if exists "time_test"; [] +gorptest: 02:00:49.617558 create table "invoice_test" ("Id" integer not null primary key autoincrement, "Created" integer, "Updated" integer, "Memo" varchar(255), "PersonId" integer, "IsPaid" integer) ; [] +gorptest: 02:00:49.626860 create table "invoice_tag_test" ("myid" integer not null primary key autoincrement, "myCreated" integer, "date_updated" integer, "Memo" varchar(255), "person_id" integer, "is_Paid" integer) ; [] +gorptest: 02:00:49.636991 create table "alias_trans_field_test" ("id" integer not null primary key autoincrement, "bar" varchar(255)) ; [] +gorptest: 02:00:49.646201 create table "invoice_override_test" ("Id" varchar(255) not null primary key, "Created" integer, "Updated" integer, "Memo" varchar(255), "PersonId" integer, "IsPaid" integer) ; [] +gorptest: 02:00:49.658670 create table "person_test" ("Id" integer not null primary key autoincrement, "Created" integer, "Updated" integer, "FName" varchar(255), "LName" varchar(255), "Version" integer) ; [] +gorptest: 02:00:49.668335 create table "ignored_column_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] +gorptest: 02:00:49.678808 create table "id_created_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] +gorptest: 02:00:49.688955 create table "type_conv_test" ("Id" integer not null primary key autoincrement, "PersonJSON" varchar(255), "Name" varchar(255)) ; [] +gorptest: 02:00:49.698410 create table "embedded_struct_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255)) ; [] +gorptest: 02:00:49.708744 create table "embedded_struct_before_autoincr_test" ("FirstName" varchar(255), "LastName" varchar(255), "Id" integer not null primary key autoincrement) ; [] +gorptest: 02:00:49.718734 create table "embedded_autoincr_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255), "MiddleName" varchar(255)) ; [] +gorptest: 02:00:49.728032 create table "time_test" ("Id" integer not null primary key autoincrement, "Time" datetime) ; [] +gorptest: 02:00:49.736538 insert into "person_test" ("Id","Created","Updated","FName","LName","Version") values (null,?,?,?,?,?); [1:1792375249736485664 2:1792375249736485664 3:"bob" 4:"smith" 5:1] +gorptest: 02:00:49.747940 insert into "invoice_test" ("Id","Created","Updated","Memo","PersonId","IsPaid") values (null,?,?,?,?,?); [1:0 2:0 3:"xmas order" 4:1 5:false] +gorptest: 02:00:49.760512 select i.Id InvoiceId, p.Id PersonId, i.Memo, p.FName from invoice_test i, person_test p where i.PersonId = p.Id [] +gorptest: 02:00:49.760684 drop table if exists "invoice_test"; [] +gorptest: 02:00:49.771925 drop table if exists "invoice_tag_test"; [] +gorptest: 02:00:49.784193 drop table if exists "alias_trans_field_test"; [] +gorptest: 02:00:49.796782 drop table if exists "invoice_override_test"; [] +gorptest: 02:00:49.810695 drop table if exists "person_test"; [] +gorptest: 02:00:49.824211 drop table if exists "ignored_column_test"; [] +gorptest: 02:00:49.836954 drop table if exists "id_created_test"; [] +gorptest: 02:00:49.848721 drop table if exists "type_conv_test"; [] +gorptest: 02:00:49.860988 drop table if exists "embedded_struct_test"; [] +gorptest: 02:00:49.872858 drop table if exists "embedded_struct_before_autoincr_test"; [] +gorptest: 02:00:49.884158 drop table if exists "embedded_autoincr_test"; [] +gorptest: 02:00:49.896386 drop table if exists "time_test"; [] +gorptest: 02:00:49.907165 drop table if exists "id_created_test"; [] --- PASS: TestInvoicePersonView (0.29s) === RUN TestQuoteTableNames -2025/09/15 19:35:22 Warning: Automatic mapping of Version struct members to version columns (see optimistic locking) will be deprecated in next version (V2) See: https://github.com/go-gorp/gorp/pull/214 -gorptest: 19:35:22.862152 drop table if exists "invoice_test"; [] -gorptest: 19:35:22.862390 drop table if exists "invoice_tag_test"; [] -gorptest: 19:35:22.862424 drop table if exists "alias_trans_field_test"; [] -gorptest: 19:35:22.862443 drop table if exists "invoice_override_test"; [] -gorptest: 19:35:22.862467 drop table if exists "person_test"; [] -gorptest: 19:35:22.862486 drop table if exists "ignored_column_test"; [] -gorptest: 19:35:22.862511 drop table if exists "id_created_test"; [] -gorptest: 19:35:22.862533 drop table if exists "type_conv_test"; [] -gorptest: 19:35:22.862553 drop table if exists "embedded_struct_test"; [] -gorptest: 19:35:22.862578 drop table if exists "embedded_struct_before_autoincr_test"; [] -gorptest: 19:35:22.862597 drop table if exists "embedded_autoincr_test"; [] -gorptest: 19:35:22.862621 drop table if exists "time_test"; [] -gorptest: 19:35:22.862648 create table "invoice_test" ("Id" integer not null primary key autoincrement, "Created" integer, "Updated" integer, "Memo" varchar(255), "PersonId" integer, "IsPaid" integer) ; [] -gorptest: 19:35:22.872232 create table "invoice_tag_test" ("myid" integer not null primary key autoincrement, "myCreated" integer, "date_updated" integer, "Memo" varchar(255), "person_id" integer, "is_Paid" integer) ; [] -gorptest: 19:35:22.884020 create table "alias_trans_field_test" ("id" integer not null primary key autoincrement, "bar" varchar(255)) ; [] -gorptest: 19:35:22.896555 create table "invoice_override_test" ("Id" varchar(255) not null primary key, "Created" integer, "Updated" integer, "Memo" varchar(255), "PersonId" integer, "IsPaid" integer) ; [] -gorptest: 19:35:22.910060 create table "person_test" ("Id" integer not null primary key autoincrement, "Created" integer, "Updated" integer, "FName" varchar(255), "LName" varchar(255), "Version" integer) ; [] -gorptest: 19:35:22.922556 create table "ignored_column_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] -gorptest: 19:35:22.933675 create table "id_created_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] -gorptest: 19:35:22.946360 create table "type_conv_test" ("Id" integer not null primary key autoincrement, "PersonJSON" varchar(255), "Name" varchar(255)) ; [] -gorptest: 19:35:22.958475 create table "embedded_struct_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255)) ; [] -gorptest: 19:35:22.969613 create table "embedded_struct_before_autoincr_test" ("FirstName" varchar(255), "LastName" varchar(255), "Id" integer not null primary key autoincrement) ; [] -gorptest: 19:35:22.981642 create table "embedded_autoincr_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255), "MiddleName" varchar(255)) ; [] -gorptest: 19:35:22.993796 create table "time_test" ("Id" integer not null primary key autoincrement, "Time" datetime) ; [] +2026/10/19 02:00:49 Warning: Automatic mapping of Version struct members to version columns (see optimistic locking) will be deprecated in next version (V2) See: https://github.com/go-gorp/gorp/pull/214 +gorptest: 02:00:49.907508 drop table if exists "invoice_test"; [] +gorptest: 02:00:49.907775 drop table if exists "invoice_tag_test"; [] +gorptest: 02:00:49.907819 drop table if exists "alias_trans_field_test"; [] +gorptest: 02:00:49.907841 drop table if exists "invoice_override_test"; [] +gorptest: 02:00:49.907863 drop table if exists "person_test"; [] +gorptest: 02:00:49.907892 drop table if exists "ignored_column_test"; [] +gorptest: 02:00:49.907915 drop table if exists "id_created_test"; [] +gorptest: 02:00:49.907935 drop table if exists "type_conv_test"; [] +gorptest: 02:00:49.907956 drop table if exists "embedded_struct_test"; [] +gorptest: 02:00:49.907983 drop table if exists "embedded_struct_before_autoincr_test"; [] +gorptest: 02:00:49.908018 drop table if exists "embedded_autoincr_test"; [] +gorptest: 02:00:49.908050 drop table if exists "time_test"; [] +gorptest: 02:00:49.908081 create table "invoice_test" ("Id" integer not null primary key autoincrement, "Created" integer, "Updated" integer, "Memo" varchar(255), "PersonId" integer, "IsPaid" integer) ; [] +gorptest: 02:00:49.915873 create table "invoice_tag_test" ("myid" integer not null primary key autoincrement, "myCreated" integer, "date_updated" integer, "Memo" varchar(255), "person_id" integer, "is_Paid" integer) ; [] +gorptest: 02:00:49.928413 create table "alias_trans_field_test" ("id" integer not null primary key autoincrement, "bar" varchar(255)) ; [] +gorptest: 02:00:49.940416 create table "invoice_override_test" ("Id" varchar(255) not null primary key, "Created" integer, "Updated" integer, "Memo" varchar(255), "PersonId" integer, "IsPaid" integer) ; [] +gorptest: 02:00:49.954747 create table "person_test" ("Id" integer not null primary key autoincrement, "Created" integer, "Updated" integer, "FName" varchar(255), "LName" varchar(255), "Version" integer) ; [] +gorptest: 02:00:49.976030 create table "ignored_column_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] +gorptest: 02:00:49.981725 create table "id_created_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] +gorptest: 02:00:49.990485 create table "type_conv_test" ("Id" integer not null primary key autoincrement, "PersonJSON" varchar(255), "Name" varchar(255)) ; [] +gorptest: 02:00:50.002287 create table "embedded_struct_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255)) ; [] +gorptest: 02:00:50.013879 create table "embedded_struct_before_autoincr_test" ("FirstName" varchar(255), "LastName" varchar(255), "Id" integer not null primary key autoincrement) ; [] +gorptest: 02:00:50.026897 create table "embedded_autoincr_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255), "MiddleName" varchar(255)) ; [] +gorptest: 02:00:50.038146 create table "time_test" ("Id" integer not null primary key autoincrement, "Time" datetime) ; [] --- PASS: TestQuoteTableNames (0.27s) === RUN TestSelectTooManyCols -2025/09/15 19:35:23 Warning: Automatic mapping of Version struct members to version columns (see optimistic locking) will be deprecated in next version (V2) See: https://github.com/go-gorp/gorp/pull/214 -gorptest: 19:35:23.135716 drop table if exists "invoice_test"; [] -gorptest: 19:35:23.135887 drop table if exists "invoice_tag_test"; [] -gorptest: 19:35:23.135911 drop table if exists "alias_trans_field_test"; [] -gorptest: 19:35:23.135925 drop table if exists "invoice_override_test"; [] -gorptest: 19:35:23.135938 drop table if exists "person_test"; [] -gorptest: 19:35:23.135956 drop table if exists "ignored_column_test"; [] -gorptest: 19:35:23.135969 drop table if exists "id_created_test"; [] -gorptest: 19:35:23.135985 drop table if exists "type_conv_test"; [] -gorptest: 19:35:23.136002 drop table if exists "embedded_struct_test"; [] -gorptest: 19:35:23.136016 drop table if exists "embedded_struct_before_autoincr_test"; [] -gorptest: 19:35:23.136030 drop table if exists "embedded_autoincr_test"; [] -gorptest: 19:35:23.136044 drop table if exists "time_test"; [] -gorptest: 19:35:23.136066 create table "invoice_test" ("Id" integer not null primary key autoincrement, "Created" integer, "Updated" integer, "Memo" varchar(255), "PersonId" integer, "IsPaid" integer) ; [] -gorptest: 19:35:23.146051 create table "invoice_tag_test" ("myid" integer not null primary key autoincrement, "myCreated" integer, "date_updated" integer, "Memo" varchar(255), "person_id" integer, "is_Paid" integer) ; [] -gorptest: 19:35:23.156139 create table "alias_trans_field_test" ("id" integer not null primary key autoincrement, "bar" varchar(255)) ; [] -gorptest: 19:35:23.166292 create table "invoice_override_test" ("Id" varchar(255) not null primary key, "Created" integer, "Updated" integer, "Memo" varchar(255), "PersonId" integer, "IsPaid" integer) ; [] -gorptest: 19:35:23.177583 create table "person_test" ("Id" integer not null primary key autoincrement, "Created" integer, "Updated" integer, "FName" varchar(255), "LName" varchar(255), "Version" integer) ; [] -gorptest: 19:35:23.188149 create table "ignored_column_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] -gorptest: 19:35:23.198791 create table "id_created_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] -gorptest: 19:35:23.208403 create table "type_conv_test" ("Id" integer not null primary key autoincrement, "PersonJSON" varchar(255), "Name" varchar(255)) ; [] -gorptest: 19:35:23.217572 create table "embedded_struct_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255)) ; [] -gorptest: 19:35:23.228553 create table "embedded_struct_before_autoincr_test" ("FirstName" varchar(255), "LastName" varchar(255), "Id" integer not null primary key autoincrement) ; [] -gorptest: 19:35:23.239606 create table "embedded_autoincr_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255), "MiddleName" varchar(255)) ; [] -gorptest: 19:35:23.247959 create table "time_test" ("Id" integer not null primary key autoincrement, "Time" datetime) ; [] -gorptest: 19:35:23.256705 insert into "person_test" ("Id","Created","Updated","FName","LName","Version") values (null,?,?,?,?,?); [1:1757964923256688620 2:1757964923256688620 3:"bob" 4:"smith" 5:1] -gorptest: 19:35:23.268386 insert into "person_test" ("Id","Created","Updated","FName","LName","Version") values (null,?,?,?,?,?); [1:1757964923268354795 2:1757964923268354795 3:"jane" 4:"doe" 5:1] -gorptest: 19:35:23.280308 select "Id","Created","Updated","FName","LName","Version" from "person_test" where "Id"=?; [1:1] -gorptest: 19:35:23.280435 select "Id","Created","Updated","FName","LName","Version" from "person_test" where "Id"=?; [1:2] -gorptest: 19:35:23.280501 select * from person_test where Id=? [1:1] -gorptest: 19:35:23.280566 select * from person_test order by fname asc [] -gorptest: 19:35:23.280657 drop table if exists "invoice_test"; [] -gorptest: 19:35:23.289944 drop table if exists "invoice_tag_test"; [] -gorptest: 19:35:23.302612 drop table if exists "alias_trans_field_test"; [] -gorptest: 19:35:23.314087 drop table if exists "invoice_override_test"; [] -gorptest: 19:35:23.328352 drop table if exists "person_test"; [] -gorptest: 19:35:23.342506 drop table if exists "ignored_column_test"; [] -gorptest: 19:35:23.353640 drop table if exists "id_created_test"; [] -gorptest: 19:35:23.366136 drop table if exists "type_conv_test"; [] -gorptest: 19:35:23.378117 drop table if exists "embedded_struct_test"; [] -gorptest: 19:35:23.390307 drop table if exists "embedded_struct_before_autoincr_test"; [] -gorptest: 19:35:23.402228 drop table if exists "embedded_autoincr_test"; [] -gorptest: 19:35:23.414304 drop table if exists "time_test"; [] -gorptest: 19:35:23.430997 drop table if exists "id_created_test"; [] ---- PASS: TestSelectTooManyCols (0.30s) +2026/10/19 02:00:50 Warning: Automatic mapping of Version struct members to version columns (see optimistic locking) will be deprecated in next version (V2) See: https://github.com/go-gorp/gorp/pull/214 +gorptest: 02:00:50.181699 drop table if exists "invoice_test"; [] +gorptest: 02:00:50.182037 drop table if exists "invoice_tag_test"; [] +gorptest: 02:00:50.182078 drop table if exists "alias_trans_field_test"; [] +gorptest: 02:00:50.182101 drop table if exists "invoice_override_test"; [] +gorptest: 02:00:50.182125 drop table if exists "person_test"; [] +gorptest: 02:00:50.182153 drop table if exists "ignored_column_test"; [] +gorptest: 02:00:50.182227 drop table if exists "id_created_test"; [] +gorptest: 02:00:50.182267 drop table if exists "type_conv_test"; [] +gorptest: 02:00:50.182290 drop table if exists "embedded_struct_test"; [] +gorptest: 02:00:50.182319 drop table if exists "embedded_struct_before_autoincr_test"; [] +gorptest: 02:00:50.182340 drop table if exists "embedded_autoincr_test"; [] +gorptest: 02:00:50.182363 drop table if exists "time_test"; [] +gorptest: 02:00:50.182398 create table "invoice_test" ("Id" integer not null primary key autoincrement, "Created" integer, "Updated" integer, "Memo" varchar(255), "PersonId" integer, "IsPaid" integer) ; [] +gorptest: 02:00:50.190032 create table "invoice_tag_test" ("myid" integer not null primary key autoincrement, "myCreated" integer, "date_updated" integer, "Memo" varchar(255), "person_id" integer, "is_Paid" integer) ; [] +gorptest: 02:00:50.200825 create table "alias_trans_field_test" ("id" integer not null primary key autoincrement, "bar" varchar(255)) ; [] +gorptest: 02:00:50.210992 create table "invoice_override_test" ("Id" varchar(255) not null primary key, "Created" integer, "Updated" integer, "Memo" varchar(255), "PersonId" integer, "IsPaid" integer) ; [] +gorptest: 02:00:50.222862 create table "person_test" ("Id" integer not null primary key autoincrement, "Created" integer, "Updated" integer, "FName" varchar(255), "LName" varchar(255), "Version" integer) ; [] +gorptest: 02:00:50.232547 create table "ignored_column_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] +gorptest: 02:00:50.243208 create table "id_created_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] +gorptest: 02:00:50.252803 create table "type_conv_test" ("Id" integer not null primary key autoincrement, "PersonJSON" varchar(255), "Name" varchar(255)) ; [] +gorptest: 02:00:50.262811 create table "embedded_struct_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255)) ; [] +gorptest: 02:00:50.272198 create table "embedded_struct_before_autoincr_test" ("FirstName" varchar(255), "LastName" varchar(255), "Id" integer not null primary key autoincrement) ; [] +gorptest: 02:00:50.282916 create table "embedded_autoincr_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255), "MiddleName" varchar(255)) ; [] +gorptest: 02:00:50.292769 create table "time_test" ("Id" integer not null primary key autoincrement, "Time" datetime) ; [] +gorptest: 02:00:50.300639 insert into "person_test" ("Id","Created","Updated","FName","LName","Version") values (null,?,?,?,?,?); [1:1792375250300620326 2:1792375250300620326 3:"bob" 4:"smith" 5:1] +gorptest: 02:00:50.312697 insert into "person_test" ("Id","Created","Updated","FName","LName","Version") values (null,?,?,?,?,?); [1:1792375250312683574 2:1792375250312683574 3:"jane" 4:"doe" 5:1] +gorptest: 02:00:50.324922 select "Id","Created","Updated","FName","LName","Version" from "person_test" where "Id"=?; [1:1] +gorptest: 02:00:50.325031 select "Id","Created","Updated","FName","LName","Version" from "person_test" where "Id"=?; [1:2] +gorptest: 02:00:50.325179 select * from person_test where Id=? [1:1] +gorptest: 02:00:50.325264 select * from person_test order by fname asc [] +gorptest: 02:00:50.325373 drop table if exists "invoice_test"; [] +gorptest: 02:00:50.334698 drop table if exists "invoice_tag_test"; [] +gorptest: 02:00:50.346644 drop table if exists "alias_trans_field_test"; [] +gorptest: 02:00:50.358494 drop table if exists "invoice_override_test"; [] +gorptest: 02:00:50.377016 drop table if exists "person_test"; [] +gorptest: 02:00:50.388199 drop table if exists "ignored_column_test"; [] +gorptest: 02:00:50.399506 drop table if exists "id_created_test"; [] +gorptest: 02:00:50.410683 drop table if exists "type_conv_test"; [] +gorptest: 02:00:50.422965 drop table if exists "embedded_struct_test"; [] +gorptest: 02:00:50.435210 drop table if exists "embedded_struct_before_autoincr_test"; [] +gorptest: 02:00:50.447033 drop table if exists "embedded_autoincr_test"; [] +gorptest: 02:00:50.459968 drop table if exists "time_test"; [] +gorptest: 02:00:50.468602 drop table if exists "id_created_test"; [] +--- PASS: TestSelectTooManyCols (0.29s) === RUN TestSelectSingleVal -2025/09/15 19:35:23 Warning: Automatic mapping of Version struct members to version columns (see optimistic locking) will be deprecated in next version (V2) See: https://github.com/go-gorp/gorp/pull/214 -gorptest: 19:35:23.431290 drop table if exists "invoice_test"; [] -gorptest: 19:35:23.431715 drop table if exists "invoice_tag_test"; [] -gorptest: 19:35:23.431739 drop table if exists "alias_trans_field_test"; [] -gorptest: 19:35:23.431753 drop table if exists "invoice_override_test"; [] -gorptest: 19:35:23.431767 drop table if exists "person_test"; [] -gorptest: 19:35:23.431785 drop table if exists "ignored_column_test"; [] -gorptest: 19:35:23.431799 drop table if exists "id_created_test"; [] -gorptest: 19:35:23.431816 drop table if exists "type_conv_test"; [] -gorptest: 19:35:23.431829 drop table if exists "embedded_struct_test"; [] -gorptest: 19:35:23.431844 drop table if exists "embedded_struct_before_autoincr_test"; [] -gorptest: 19:35:23.431858 drop table if exists "embedded_autoincr_test"; [] -gorptest: 19:35:23.431871 drop table if exists "time_test"; [] -gorptest: 19:35:23.431895 create table "invoice_test" ("Id" integer not null primary key autoincrement, "Created" integer, "Updated" integer, "Memo" varchar(255), "PersonId" integer, "IsPaid" integer) ; [] -gorptest: 19:35:23.438319 create table "invoice_tag_test" ("myid" integer not null primary key autoincrement, "myCreated" integer, "date_updated" integer, "Memo" varchar(255), "person_id" integer, "is_Paid" integer) ; [] -gorptest: 19:35:23.445971 create table "alias_trans_field_test" ("id" integer not null primary key autoincrement, "bar" varchar(255)) ; [] -gorptest: 19:35:23.458199 create table "invoice_override_test" ("Id" varchar(255) not null primary key, "Created" integer, "Updated" integer, "Memo" varchar(255), "PersonId" integer, "IsPaid" integer) ; [] -gorptest: 19:35:23.474993 create table "person_test" ("Id" integer not null primary key autoincrement, "Created" integer, "Updated" integer, "FName" varchar(255), "LName" varchar(255), "Version" integer) ; [] -gorptest: 19:35:23.484477 create table "ignored_column_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] -gorptest: 19:35:23.495922 create table "id_created_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] -gorptest: 19:35:23.508284 create table "type_conv_test" ("Id" integer not null primary key autoincrement, "PersonJSON" varchar(255), "Name" varchar(255)) ; [] -gorptest: 19:35:23.519871 create table "embedded_struct_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255)) ; [] -gorptest: 19:35:23.532357 create table "embedded_struct_before_autoincr_test" ("FirstName" varchar(255), "LastName" varchar(255), "Id" integer not null primary key autoincrement) ; [] -gorptest: 19:35:23.545211 create table "embedded_autoincr_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255), "MiddleName" varchar(255)) ; [] -gorptest: 19:35:23.556353 create table "time_test" ("Id" integer not null primary key autoincrement, "Time" datetime) ; [] -gorptest: 19:35:23.565996 insert into "person_test" ("Id","Created","Updated","FName","LName","Version") values (null,?,?,?,?,?); [1:1757964923565953483 2:1757964923565953483 3:"bob" 4:"smith" 5:1] -gorptest: 19:35:23.578182 select "Id","Created","Updated","FName","LName","Version" from "person_test" where "Id"=?; [1:1] -gorptest: 19:35:23.578286 select * from person_test where Id=? [1:1] -gorptest: 19:35:23.578342 select FName from person_test where Id=? [1:1] -gorptest: 19:35:23.578371 select * from person_test where Id=? [1:1] -gorptest: 19:35:23.578407 select * from person_test where 2<1 AND Id=? [1:1] -gorptest: 19:35:23.578445 select * from person_test where Id=? [1:-2222] -gorptest: 19:35:23.578481 insert into "person_test" ("Id","Created","Updated","FName","LName","Version") values (null,?,?,?,?,?); [1:1757964923578475058 2:1757964923578475058 3:"bob" 4:"smith" 5:1] -gorptest: 19:35:23.589617 select * from person_test where Fname='bob' [] -gorptest: 19:35:23.589707 select * from person_test where Id=-123 [] -gorptest: 19:35:23.589739 select * from person_test where Id=-123 [] -gorptest: 19:35:23.589763 select * from person_test where Id=-123 [] -gorptest: 19:35:23.589784 select * from person_test where Id=-123 [] -gorptest: 19:35:23.589808 drop table if exists "invoice_test"; [] -gorptest: 19:35:23.597687 drop table if exists "invoice_tag_test"; [] -gorptest: 19:35:23.607796 drop table if exists "alias_trans_field_test"; [] -gorptest: 19:35:23.618311 drop table if exists "invoice_override_test"; [] -gorptest: 19:35:23.630427 drop table if exists "person_test"; [] -gorptest: 19:35:23.640591 drop table if exists "ignored_column_test"; [] -gorptest: 19:35:23.649932 drop table if exists "id_created_test"; [] -gorptest: 19:35:23.659880 drop table if exists "type_conv_test"; [] -gorptest: 19:35:23.669986 drop table if exists "embedded_struct_test"; [] -gorptest: 19:35:23.680212 drop table if exists "embedded_struct_before_autoincr_test"; [] -gorptest: 19:35:23.690293 drop table if exists "embedded_autoincr_test"; [] -gorptest: 19:35:23.701408 drop table if exists "time_test"; [] -gorptest: 19:35:23.710188 drop table if exists "id_created_test"; [] ---- PASS: TestSelectSingleVal (0.28s) +2026/10/19 02:00:50 Warning: Automatic mapping of Version struct members to version columns (see optimistic locking) will be deprecated in next version (V2) See: https://github.com/go-gorp/gorp/pull/214 +gorptest: 02:00:50.468940 drop table if exists "invoice_test"; [] +gorptest: 02:00:50.469235 drop table if exists "invoice_tag_test"; [] +gorptest: 02:00:50.469266 drop table if exists "alias_trans_field_test"; [] +gorptest: 02:00:50.469284 drop table if exists "invoice_override_test"; [] +gorptest: 02:00:50.469300 drop table if exists "person_test"; [] +gorptest: 02:00:50.469316 drop table if exists "ignored_column_test"; [] +gorptest: 02:00:50.469332 drop table if exists "id_created_test"; [] +gorptest: 02:00:50.469348 drop table if exists "type_conv_test"; [] +gorptest: 02:00:50.469364 drop table if exists "embedded_struct_test"; [] +gorptest: 02:00:50.469389 drop table if exists "embedded_struct_before_autoincr_test"; [] +gorptest: 02:00:50.469432 drop table if exists "embedded_autoincr_test"; [] +gorptest: 02:00:50.469454 drop table if exists "time_test"; [] +gorptest: 02:00:50.469488 create table "invoice_test" ("Id" integer not null primary key autoincrement, "Created" integer, "Updated" integer, "Memo" varchar(255), "PersonId" integer, "IsPaid" integer) ; [] +gorptest: 02:00:50.479010 create table "invoice_tag_test" ("myid" integer not null primary key autoincrement, "myCreated" integer, "date_updated" integer, "Memo" varchar(255), "person_id" integer, "is_Paid" integer) ; [] +gorptest: 02:00:50.490205 create table "alias_trans_field_test" ("id" integer not null primary key autoincrement, "bar" varchar(255)) ; [] +gorptest: 02:00:50.502548 create table "invoice_override_test" ("Id" varchar(255) not null primary key, "Created" integer, "Updated" integer, "Memo" varchar(255), "PersonId" integer, "IsPaid" integer) ; [] +gorptest: 02:00:50.516182 create table "person_test" ("Id" integer not null primary key autoincrement, "Created" integer, "Updated" integer, "FName" varchar(255), "LName" varchar(255), "Version" integer) ; [] +gorptest: 02:00:50.528420 create table "ignored_column_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] +gorptest: 02:00:50.540519 create table "id_created_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] +gorptest: 02:00:50.552459 create table "type_conv_test" ("Id" integer not null primary key autoincrement, "PersonJSON" varchar(255), "Name" varchar(255)) ; [] +gorptest: 02:00:50.564355 create table "embedded_struct_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255)) ; [] +gorptest: 02:00:50.576598 create table "embedded_struct_before_autoincr_test" ("FirstName" varchar(255), "LastName" varchar(255), "Id" integer not null primary key autoincrement) ; [] +gorptest: 02:00:50.589024 create table "embedded_autoincr_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255), "MiddleName" varchar(255)) ; [] +gorptest: 02:00:50.600149 create table "time_test" ("Id" integer not null primary key autoincrement, "Time" datetime) ; [] +gorptest: 02:00:50.610841 insert into "person_test" ("Id","Created","Updated","FName","LName","Version") values (null,?,?,?,?,?); [1:1792375250610789723 2:1792375250610789723 3:"bob" 4:"smith" 5:1] +gorptest: 02:00:50.623434 select "Id","Created","Updated","FName","LName","Version" from "person_test" where "Id"=?; [1:1] +gorptest: 02:00:50.623646 select * from person_test where Id=? [1:1] +gorptest: 02:00:50.623771 select FName from person_test where Id=? [1:1] +gorptest: 02:00:50.623845 select * from person_test where Id=? [1:1] +gorptest: 02:00:50.623980 select * from person_test where 2<1 AND Id=? [1:1] +gorptest: 02:00:50.624095 select * from person_test where Id=? [1:-2222] +gorptest: 02:00:50.624182 insert into "person_test" ("Id","Created","Updated","FName","LName","Version") values (null,?,?,?,?,?); [1:1792375250624169320 2:1792375250624169320 3:"bob" 4:"smith" 5:1] +gorptest: 02:00:50.642782 select * from person_test where Fname='bob' [] +gorptest: 02:00:50.642945 select * from person_test where Id=-123 [] +gorptest: 02:00:50.643011 select * from person_test where Id=-123 [] +gorptest: 02:00:50.643061 select * from person_test where Id=-123 [] +gorptest: 02:00:50.643092 select * from person_test where Id=-123 [] +gorptest: 02:00:50.643130 drop table if exists "invoice_test"; [] +gorptest: 02:00:50.656133 drop table if exists "invoice_tag_test"; [] +gorptest: 02:00:50.662508 drop table if exists "alias_trans_field_test"; [] +gorptest: 02:00:50.668448 drop table if exists "invoice_override_test"; [] +gorptest: 02:00:50.675007 drop table if exists "person_test"; [] +gorptest: 02:00:50.684623 drop table if exists "ignored_column_test"; [] +gorptest: 02:00:50.694815 drop table if exists "id_created_test"; [] +gorptest: 02:00:50.704874 drop table if exists "type_conv_test"; [] +gorptest: 02:00:50.714278 drop table if exists "embedded_struct_test"; [] +gorptest: 02:00:50.725609 drop table if exists "embedded_struct_before_autoincr_test"; [] +gorptest: 02:00:50.734298 drop table if exists "embedded_autoincr_test"; [] +gorptest: 02:00:50.745274 drop table if exists "time_test"; [] +gorptest: 02:00:50.754373 drop table if exists "id_created_test"; [] +--- PASS: TestSelectSingleVal (0.29s) === RUN TestSelectAlias -2025/09/15 19:35:23 Warning: Automatic mapping of Version struct members to version columns (see optimistic locking) will be deprecated in next version (V2) See: https://github.com/go-gorp/gorp/pull/214 -gorptest: 19:35:23.710384 drop table if exists "invoice_test"; [] -gorptest: 19:35:23.710555 drop table if exists "invoice_tag_test"; [] -gorptest: 19:35:23.710580 drop table if exists "alias_trans_field_test"; [] -gorptest: 19:35:23.710593 drop table if exists "invoice_override_test"; [] -gorptest: 19:35:23.710608 drop table if exists "person_test"; [] -gorptest: 19:35:23.710625 drop table if exists "ignored_column_test"; [] -gorptest: 19:35:23.710638 drop table if exists "id_created_test"; [] -gorptest: 19:35:23.710655 drop table if exists "type_conv_test"; [] -gorptest: 19:35:23.710668 drop table if exists "embedded_struct_test"; [] -gorptest: 19:35:23.710685 drop table if exists "embedded_struct_before_autoincr_test"; [] -gorptest: 19:35:23.710699 drop table if exists "embedded_autoincr_test"; [] -gorptest: 19:35:23.710715 drop table if exists "time_test"; [] -gorptest: 19:35:23.710735 create table "invoice_test" ("Id" integer not null primary key autoincrement, "Created" integer, "Updated" integer, "Memo" varchar(255), "PersonId" integer, "IsPaid" integer) ; [] -gorptest: 19:35:23.720333 create table "invoice_tag_test" ("myid" integer not null primary key autoincrement, "myCreated" integer, "date_updated" integer, "Memo" varchar(255), "person_id" integer, "is_Paid" integer) ; [] -gorptest: 19:35:23.729843 create table "alias_trans_field_test" ("id" integer not null primary key autoincrement, "bar" varchar(255)) ; [] -gorptest: 19:35:23.739831 create table "invoice_override_test" ("Id" varchar(255) not null primary key, "Created" integer, "Updated" integer, "Memo" varchar(255), "PersonId" integer, "IsPaid" integer) ; [] -gorptest: 19:35:23.752012 create table "person_test" ("Id" integer not null primary key autoincrement, "Created" integer, "Updated" integer, "FName" varchar(255), "LName" varchar(255), "Version" integer) ; [] -gorptest: 19:35:23.761927 create table "ignored_column_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] -gorptest: 19:35:23.771902 create table "id_created_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] -gorptest: 19:35:23.782258 create table "type_conv_test" ("Id" integer not null primary key autoincrement, "PersonJSON" varchar(255), "Name" varchar(255)) ; [] -gorptest: 19:35:23.791832 create table "embedded_struct_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255)) ; [] -gorptest: 19:35:23.801789 create table "embedded_struct_before_autoincr_test" ("FirstName" varchar(255), "LastName" varchar(255), "Id" integer not null primary key autoincrement) ; [] -gorptest: 19:35:23.812973 create table "embedded_autoincr_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255), "MiddleName" varchar(255)) ; [] -gorptest: 19:35:23.821744 create table "time_test" ("Id" integer not null primary key autoincrement, "Time" datetime) ; [] -gorptest: 19:35:23.830328 insert into "id_created_test" ("Id","Created") values (null,?); [1:3] -gorptest: 19:35:23.842123 select * from id_created_test where Id=1 [] -gorptest: 19:35:23.842254 SELECT *, 1 AS external FROM id_created_test [] -gorptest: 19:35:23.842333 drop table if exists "invoice_test"; [] -gorptest: 19:35:23.852021 drop table if exists "invoice_tag_test"; [] -gorptest: 19:35:23.869977 drop table if exists "alias_trans_field_test"; [] -gorptest: 19:35:23.889489 drop table if exists "invoice_override_test"; [] -gorptest: 19:35:23.895839 drop table if exists "person_test"; [] -gorptest: 19:35:23.902348 drop table if exists "ignored_column_test"; [] -gorptest: 19:35:23.914144 drop table if exists "id_created_test"; [] -gorptest: 19:35:23.927962 drop table if exists "type_conv_test"; [] -gorptest: 19:35:23.939806 drop table if exists "embedded_struct_test"; [] -gorptest: 19:35:23.951792 drop table if exists "embedded_struct_before_autoincr_test"; [] -gorptest: 19:35:23.964340 drop table if exists "embedded_autoincr_test"; [] -gorptest: 19:35:23.976346 drop table if exists "time_test"; [] -gorptest: 19:35:23.986311 drop table if exists "id_created_test"; [] +2026/10/19 02:00:50 Warning: Automatic mapping of Version struct members to version columns (see optimistic locking) will be deprecated in next version (V2) See: https://github.com/go-gorp/gorp/pull/214 +gorptest: 02:00:50.754866 drop table if exists "invoice_test"; [] +gorptest: 02:00:50.755157 drop table if exists "invoice_tag_test"; [] +gorptest: 02:00:50.755200 drop table if exists "alias_trans_field_test"; [] +gorptest: 02:00:50.755222 drop table if exists "invoice_override_test"; [] +gorptest: 02:00:50.755242 drop table if exists "person_test"; [] +gorptest: 02:00:50.755263 drop table if exists "ignored_column_test"; [] +gorptest: 02:00:50.755282 drop table if exists "id_created_test"; [] +gorptest: 02:00:50.755302 drop table if exists "type_conv_test"; [] +gorptest: 02:00:50.755321 drop table if exists "embedded_struct_test"; [] +gorptest: 02:00:50.755350 drop table if exists "embedded_struct_before_autoincr_test"; [] +gorptest: 02:00:50.755369 drop table if exists "embedded_autoincr_test"; [] +gorptest: 02:00:50.755395 drop table if exists "time_test"; [] +gorptest: 02:00:50.755424 create table "invoice_test" ("Id" integer not null primary key autoincrement, "Created" integer, "Updated" integer, "Memo" varchar(255), "PersonId" integer, "IsPaid" integer) ; [] +gorptest: 02:00:50.765193 create table "invoice_tag_test" ("myid" integer not null primary key autoincrement, "myCreated" integer, "date_updated" integer, "Memo" varchar(255), "person_id" integer, "is_Paid" integer) ; [] +gorptest: 02:00:50.774605 create table "alias_trans_field_test" ("id" integer not null primary key autoincrement, "bar" varchar(255)) ; [] +gorptest: 02:00:50.784409 create table "invoice_override_test" ("Id" varchar(255) not null primary key, "Created" integer, "Updated" integer, "Memo" varchar(255), "PersonId" integer, "IsPaid" integer) ; [] +gorptest: 02:00:50.796207 create table "person_test" ("Id" integer not null primary key autoincrement, "Created" integer, "Updated" integer, "FName" varchar(255), "LName" varchar(255), "Version" integer) ; [] +gorptest: 02:00:50.806286 create table "ignored_column_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] +gorptest: 02:00:50.816692 create table "id_created_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] +gorptest: 02:00:50.827059 create table "type_conv_test" ("Id" integer not null primary key autoincrement, "PersonJSON" varchar(255), "Name" varchar(255)) ; [] +gorptest: 02:00:50.837144 create table "embedded_struct_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255)) ; [] +gorptest: 02:00:50.846821 create table "embedded_struct_before_autoincr_test" ("FirstName" varchar(255), "LastName" varchar(255), "Id" integer not null primary key autoincrement) ; [] +gorptest: 02:00:50.855951 create table "embedded_autoincr_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255), "MiddleName" varchar(255)) ; [] +gorptest: 02:00:50.866961 create table "time_test" ("Id" integer not null primary key autoincrement, "Time" datetime) ; [] +gorptest: 02:00:50.875367 insert into "id_created_test" ("Id","Created") values (null,?); [1:3] +gorptest: 02:00:50.886500 select * from id_created_test where Id=1 [] +gorptest: 02:00:50.886647 SELECT *, 1 AS external FROM id_created_test [] +gorptest: 02:00:50.886758 drop table if exists "invoice_test"; [] +gorptest: 02:00:50.896986 drop table if exists "invoice_tag_test"; [] +gorptest: 02:00:50.908181 drop table if exists "alias_trans_field_test"; [] +gorptest: 02:00:50.920823 drop table if exists "invoice_override_test"; [] +gorptest: 02:00:50.934756 drop table if exists "person_test"; [] +gorptest: 02:00:50.955348 drop table if exists "ignored_column_test"; [] +gorptest: 02:00:50.961509 drop table if exists "id_created_test"; [] +gorptest: 02:00:50.972980 drop table if exists "type_conv_test"; [] +gorptest: 02:00:50.984311 drop table if exists "embedded_struct_test"; [] +gorptest: 02:00:50.996783 drop table if exists "embedded_struct_before_autoincr_test"; [] +gorptest: 02:00:51.008336 drop table if exists "embedded_autoincr_test"; [] +gorptest: 02:00:51.021002 drop table if exists "time_test"; [] +gorptest: 02:00:51.030455 drop table if exists "id_created_test"; [] --- PASS: TestSelectAlias (0.28s) === RUN TestMysqlPanicIfDialectNotInitialized --- PASS: TestMysqlPanicIfDialectNotInitialized (0.00s) === RUN TestSingleColumnKeyDbReturnsZeroRowsUpdatedOnPKChange -2025/09/15 19:35:23 Warning: Automatic mapping of Version struct members to version columns (see optimistic locking) will be deprecated in next version (V2) See: https://github.com/go-gorp/gorp/pull/214 -gorptest: 19:35:23.986567 drop table if exists "invoice_test"; [] -gorptest: 19:35:23.986748 drop table if exists "invoice_tag_test"; [] -gorptest: 19:35:23.986770 drop table if exists "alias_trans_field_test"; [] -gorptest: 19:35:23.986784 drop table if exists "invoice_override_test"; [] -gorptest: 19:35:23.986798 drop table if exists "person_test"; [] -gorptest: 19:35:23.986815 drop table if exists "ignored_column_test"; [] -gorptest: 19:35:23.986828 drop table if exists "id_created_test"; [] -gorptest: 19:35:23.986843 drop table if exists "type_conv_test"; [] -gorptest: 19:35:23.986858 drop table if exists "embedded_struct_test"; [] -gorptest: 19:35:23.986871 drop table if exists "embedded_struct_before_autoincr_test"; [] -gorptest: 19:35:23.986886 drop table if exists "embedded_autoincr_test"; [] -gorptest: 19:35:23.986900 drop table if exists "time_test"; [] -gorptest: 19:35:23.986924 create table "invoice_test" ("Id" integer not null primary key autoincrement, "Created" integer, "Updated" integer, "Memo" varchar(255), "PersonId" integer, "IsPaid" integer) ; [] -gorptest: 19:35:23.996708 create table "invoice_tag_test" ("myid" integer not null primary key autoincrement, "myCreated" integer, "date_updated" integer, "Memo" varchar(255), "person_id" integer, "is_Paid" integer) ; [] -gorptest: 19:35:24.008372 create table "alias_trans_field_test" ("id" integer not null primary key autoincrement, "bar" varchar(255)) ; [] -gorptest: 19:35:24.020705 create table "invoice_override_test" ("Id" varchar(255) not null primary key, "Created" integer, "Updated" integer, "Memo" varchar(255), "PersonId" integer, "IsPaid" integer) ; [] -gorptest: 19:35:24.034401 create table "person_test" ("Id" integer not null primary key autoincrement, "Created" integer, "Updated" integer, "FName" varchar(255), "LName" varchar(255), "Version" integer) ; [] -gorptest: 19:35:24.046632 create table "ignored_column_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] -gorptest: 19:35:24.057898 create table "id_created_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] -gorptest: 19:35:24.070280 create table "type_conv_test" ("Id" integer not null primary key autoincrement, "PersonJSON" varchar(255), "Name" varchar(255)) ; [] -gorptest: 19:35:24.082423 create table "embedded_struct_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255)) ; [] -gorptest: 19:35:24.093684 create table "embedded_struct_before_autoincr_test" ("FirstName" varchar(255), "LastName" varchar(255), "Id" integer not null primary key autoincrement) ; [] -gorptest: 19:35:24.105889 create table "embedded_autoincr_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255), "MiddleName" varchar(255)) ; [] -gorptest: 19:35:24.118398 create table "time_test" ("Id" integer not null primary key autoincrement, "Time" datetime) ; [] -gorptest: 19:35:24.130121 drop table if exists "invoice_test"; [] -gorptest: 19:35:24.136024 drop table if exists "invoice_tag_test"; [] -gorptest: 19:35:24.146259 drop table if exists "alias_trans_field_test"; [] -gorptest: 19:35:24.155833 drop table if exists "invoice_override_test"; [] -gorptest: 19:35:24.168069 drop table if exists "person_test"; [] -gorptest: 19:35:24.178013 drop table if exists "ignored_column_test"; [] -gorptest: 19:35:24.188449 drop table if exists "id_created_test"; [] -gorptest: 19:35:24.198246 drop table if exists "type_conv_test"; [] -gorptest: 19:35:24.208293 drop table if exists "embedded_struct_test"; [] -gorptest: 19:35:24.218379 drop table if exists "embedded_struct_before_autoincr_test"; [] -gorptest: 19:35:24.228375 drop table if exists "embedded_autoincr_test"; [] -gorptest: 19:35:24.238240 drop table if exists "time_test"; [] -gorptest: 19:35:24.247591 drop table if exists "id_created_test"; [] -gorptest: 19:35:24.247639 drop table if exists "single_column_table"; [] -gorptest: 19:35:24.247668 create table if not exists "invoice_test" ("Id" integer not null primary key autoincrement, "Created" integer, "Updated" integer, "Memo" varchar(255), "PersonId" integer, "IsPaid" integer) ; [] -gorptest: 19:35:24.258347 create table if not exists "invoice_tag_test" ("myid" integer not null primary key autoincrement, "myCreated" integer, "date_updated" integer, "Memo" varchar(255), "person_id" integer, "is_Paid" integer) ; [] -gorptest: 19:35:24.268733 create table if not exists "alias_trans_field_test" ("id" integer not null primary key autoincrement, "bar" varchar(255)) ; [] -gorptest: 19:35:24.278107 create table if not exists "invoice_override_test" ("Id" varchar(255) not null primary key, "Created" integer, "Updated" integer, "Memo" varchar(255), "PersonId" integer, "IsPaid" integer) ; [] -gorptest: 19:35:24.289694 create table if not exists "person_test" ("Id" integer not null primary key autoincrement, "Created" integer, "Updated" integer, "FName" varchar(255), "LName" varchar(255), "Version" integer) ; [] -gorptest: 19:35:24.299612 create table if not exists "ignored_column_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] -gorptest: 19:35:24.309770 create table if not exists "id_created_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] -gorptest: 19:35:24.319934 create table if not exists "type_conv_test" ("Id" integer not null primary key autoincrement, "PersonJSON" varchar(255), "Name" varchar(255)) ; [] -gorptest: 19:35:24.329913 create table if not exists "embedded_struct_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255)) ; [] -gorptest: 19:35:24.339909 create table if not exists "embedded_struct_before_autoincr_test" ("FirstName" varchar(255), "LastName" varchar(255), "Id" integer not null primary key autoincrement) ; [] -gorptest: 19:35:24.350374 create table if not exists "embedded_autoincr_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255), "MiddleName" varchar(255)) ; [] -gorptest: 19:35:24.359642 create table if not exists "time_test" ("Id" integer not null primary key autoincrement, "Time" datetime) ; [] -gorptest: 19:35:24.367901 create table if not exists "id_created_test" ("Id" integer not null primary key autoincrement, "Created" integer, "External" integer) ; [] -gorptest: 19:35:24.367951 create table if not exists "single_column_table" ("SomeId" varchar(255) not null primary key) ; [] -gorptest: 19:35:24.381654 delete from "invoice_test"; [] -gorptest: 19:35:24.580210 delete from "invoice_tag_test"; [] -gorptest: 19:35:24.832708 delete from "alias_trans_field_test"; [] -gorptest: 19:35:24.841653 delete from "invoice_override_test"; [] -gorptest: 19:35:24.854458 delete from "person_test"; [] -gorptest: 19:35:24.864166 delete from "ignored_column_test"; [] -gorptest: 19:35:24.874231 delete from "id_created_test"; [] -gorptest: 19:35:24.884651 delete from "type_conv_test"; [] -gorptest: 19:35:24.893933 delete from "embedded_struct_test"; [] -gorptest: 19:35:25.036380 delete from "embedded_struct_before_autoincr_test"; [] -gorptest: 19:35:25.043657 delete from "embedded_autoincr_test"; [] -gorptest: 19:35:25.049716 delete from "time_test"; [] -gorptest: 19:35:25.055779 delete from "id_created_test"; [] -gorptest: 19:35:25.062577 delete from "single_column_table"; [] -gorptest: 19:35:25.068088 update "single_column_table" set "SomeId"=? where "SomeId"=?; [1:"A Unique Id String" 2:"A Unique Id String"] -gorptest: 19:35:25.068171 drop table if exists "invoice_test"; [] -gorptest: 19:35:25.073867 drop table if exists "invoice_tag_test"; [] -gorptest: 19:35:25.079447 drop table if exists "alias_trans_field_test"; [] -gorptest: 19:35:25.084707 drop table if exists "invoice_override_test"; [] -gorptest: 19:35:25.090491 drop table if exists "person_test"; [] -gorptest: 19:35:25.096596 drop table if exists "ignored_column_test"; [] -gorptest: 19:35:25.102400 drop table if exists "id_created_test"; [] -gorptest: 19:35:25.110313 drop table if exists "type_conv_test"; [] -gorptest: 19:35:25.121916 drop table if exists "embedded_struct_test"; [] -gorptest: 19:35:25.133523 drop table if exists "embedded_struct_before_autoincr_test"; [] -gorptest: 19:35:25.146206 drop table if exists "embedded_autoincr_test"; [] -gorptest: 19:35:25.158122 drop table if exists "time_test"; [] -gorptest: 19:35:25.167937 drop table if exists "id_created_test"; [] -gorptest: 19:35:25.168000 drop table if exists "single_column_table"; [] ---- PASS: TestSingleColumnKeyDbReturnsZeroRowsUpdatedOnPKChange (1.19s) +2026/10/19 02:00:51 Warning: Automatic mapping of Version struct members to version columns (see optimistic locking) will be deprecated in next version (V2) See: https://github.com/go-gorp/gorp/pull/214 +gorptest: 02:00:51.030855 drop table if exists "invoice_test"; [] +gorptest: 02:00:51.031102 drop table if exists "invoice_tag_test"; [] +gorptest: 02:00:51.031171 drop table if exists "alias_trans_field_test"; [] +gorptest: 02:00:51.031215 drop table if exists "invoice_override_test"; [] +gorptest: 02:00:51.031241 drop table if exists "person_test"; [] +gorptest: 02:00:51.031261 drop table if exists "ignored_column_test"; [] +gorptest: 02:00:51.031284 drop table if exists "id_created_test"; [] +gorptest: 02:00:51.031310 drop table if exists "type_conv_test"; [] +gorptest: 02:00:51.031331 drop table if exists "embedded_struct_test"; [] +gorptest: 02:00:51.031376 drop table if exists "embedded_struct_before_autoincr_test"; [] +gorptest: 02:00:51.031417 drop table if exists "embedded_autoincr_test"; [] +gorptest: 02:00:51.031438 drop table if exists "time_test"; [] +gorptest: 02:00:51.031469 create table "invoice_test" ("Id" integer not null primary key autoincrement, "Created" integer, "Updated" integer, "Memo" varchar(255), "PersonId" integer, "IsPaid" integer) ; [] +gorptest: 02:00:51.040681 create table "invoice_tag_test" ("myid" integer not null primary key autoincrement, "myCreated" integer, "date_updated" integer, "Memo" varchar(255), "person_id" integer, "is_Paid" integer) ; [] +gorptest: 02:00:51.052956 create table "alias_trans_field_test" ("id" integer not null primary key autoincrement, "bar" varchar(255)) ; [] +gorptest: 02:00:51.064035 create table "invoice_override_test" ("Id" varchar(255) not null primary key, "Created" integer, "Updated" integer, "Memo" varchar(255), "PersonId" integer, "IsPaid" integer) ; [] +gorptest: 02:00:51.078731 create table "person_test" ("Id" integer not null primary key autoincrement, "Created" integer, "Updated" integer, "FName" varchar(255), "LName" varchar(255), "Version" integer) ; [] +gorptest: 02:00:51.090347 create table "ignored_column_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] +gorptest: 02:00:51.103130 create table "id_created_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] +gorptest: 02:00:51.115014 create table "type_conv_test" ("Id" integer not null primary key autoincrement, "PersonJSON" varchar(255), "Name" varchar(255)) ; [] +gorptest: 02:00:51.127056 create table "embedded_struct_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255)) ; [] +gorptest: 02:00:51.138815 create table "embedded_struct_before_autoincr_test" ("FirstName" varchar(255), "LastName" varchar(255), "Id" integer not null primary key autoincrement) ; [] +gorptest: 02:00:51.151127 create table "embedded_autoincr_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255), "MiddleName" varchar(255)) ; [] +gorptest: 02:00:51.162578 create table "time_test" ("Id" integer not null primary key autoincrement, "Time" datetime) ; [] +gorptest: 02:00:51.172839 drop table if exists "invoice_test"; [] +gorptest: 02:00:51.180616 drop table if exists "invoice_tag_test"; [] +gorptest: 02:00:51.190459 drop table if exists "alias_trans_field_test"; [] +gorptest: 02:00:51.200541 drop table if exists "invoice_override_test"; [] +gorptest: 02:00:51.212015 drop table if exists "person_test"; [] +gorptest: 02:00:51.222716 drop table if exists "ignored_column_test"; [] +gorptest: 02:00:51.232782 drop table if exists "id_created_test"; [] +gorptest: 02:00:51.242973 drop table if exists "type_conv_test"; [] +gorptest: 02:00:51.252307 drop table if exists "embedded_struct_test"; [] +gorptest: 02:00:51.262070 drop table if exists "embedded_struct_before_autoincr_test"; [] +gorptest: 02:00:51.272708 drop table if exists "embedded_autoincr_test"; [] +gorptest: 02:00:51.282666 drop table if exists "time_test"; [] +gorptest: 02:00:51.292646 drop table if exists "id_created_test"; [] +gorptest: 02:00:51.292701 drop table if exists "single_column_table"; [] +gorptest: 02:00:51.292738 create table if not exists "invoice_test" ("Id" integer not null primary key autoincrement, "Created" integer, "Updated" integer, "Memo" varchar(255), "PersonId" integer, "IsPaid" integer) ; [] +gorptest: 02:00:51.302891 create table if not exists "invoice_tag_test" ("myid" integer not null primary key autoincrement, "myCreated" integer, "date_updated" integer, "Memo" varchar(255), "person_id" integer, "is_Paid" integer) ; [] +gorptest: 02:00:51.313162 create table if not exists "alias_trans_field_test" ("id" integer not null primary key autoincrement, "bar" varchar(255)) ; [] +gorptest: 02:00:51.322051 create table if not exists "invoice_override_test" ("Id" varchar(255) not null primary key, "Created" integer, "Updated" integer, "Memo" varchar(255), "PersonId" integer, "IsPaid" integer) ; [] +gorptest: 02:00:51.334663 create table if not exists "person_test" ("Id" integer not null primary key autoincrement, "Created" integer, "Updated" integer, "FName" varchar(255), "LName" varchar(255), "Version" integer) ; [] +gorptest: 02:00:51.345721 create table if not exists "ignored_column_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] +gorptest: 02:00:51.354574 create table if not exists "id_created_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] +gorptest: 02:00:51.364117 create table if not exists "type_conv_test" ("Id" integer not null primary key autoincrement, "PersonJSON" varchar(255), "Name" varchar(255)) ; [] +gorptest: 02:00:51.374558 create table if not exists "embedded_struct_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255)) ; [] +gorptest: 02:00:51.384133 create table if not exists "embedded_struct_before_autoincr_test" ("FirstName" varchar(255), "LastName" varchar(255), "Id" integer not null primary key autoincrement) ; [] +gorptest: 02:00:51.394991 create table if not exists "embedded_autoincr_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255), "MiddleName" varchar(255)) ; [] +gorptest: 02:00:51.404545 create table if not exists "time_test" ("Id" integer not null primary key autoincrement, "Time" datetime) ; [] +gorptest: 02:00:51.412219 create table if not exists "id_created_test" ("Id" integer not null primary key autoincrement, "Created" integer, "External" integer) ; [] +gorptest: 02:00:51.412290 create table if not exists "single_column_table" ("SomeId" varchar(255) not null primary key) ; [] +gorptest: 02:00:51.427191 delete from "invoice_test"; [] +gorptest: 02:00:51.436556 delete from "invoice_tag_test"; [] +gorptest: 02:00:51.446952 delete from "alias_trans_field_test"; [] +gorptest: 02:00:51.456964 delete from "invoice_override_test"; [] +gorptest: 02:00:51.469448 delete from "person_test"; [] +gorptest: 02:00:51.478905 delete from "ignored_column_test"; [] +gorptest: 02:00:51.488317 delete from "id_created_test"; [] +gorptest: 02:00:51.498729 delete from "type_conv_test"; [] +gorptest: 02:00:51.508683 delete from "embedded_struct_test"; [] +gorptest: 02:00:51.518212 delete from "embedded_struct_before_autoincr_test"; [] +gorptest: 02:00:51.528959 delete from "embedded_autoincr_test"; [] +gorptest: 02:00:51.539014 delete from "time_test"; [] +gorptest: 02:00:51.546766 delete from "id_created_test"; [] +gorptest: 02:00:51.556765 delete from "single_column_table"; [] +gorptest: 02:00:51.566096 update "single_column_table" set "SomeId"=? where "SomeId"=?; [1:"A Unique Id String" 2:"A Unique Id String"] +gorptest: 02:00:51.566214 drop table if exists "invoice_test"; [] +gorptest: 02:00:51.576555 drop table if exists "invoice_tag_test"; [] +gorptest: 02:00:51.588531 drop table if exists "alias_trans_field_test"; [] +gorptest: 02:00:51.600185 drop table if exists "invoice_override_test"; [] +gorptest: 02:00:51.614901 drop table if exists "person_test"; [] +gorptest: 02:00:51.627343 drop table if exists "ignored_column_test"; [] +gorptest: 02:00:51.639448 drop table if exists "id_created_test"; [] +gorptest: 02:00:51.651061 drop table if exists "type_conv_test"; [] +gorptest: 02:00:51.662944 drop table if exists "embedded_struct_test"; [] +gorptest: 02:00:51.674775 drop table if exists "embedded_struct_before_autoincr_test"; [] +gorptest: 02:00:51.687136 drop table if exists "embedded_autoincr_test"; [] +gorptest: 02:00:51.698883 drop table if exists "time_test"; [] +gorptest: 02:00:51.708433 drop table if exists "id_created_test"; [] +gorptest: 02:00:51.708491 drop table if exists "single_column_table"; [] +--- PASS: TestSingleColumnKeyDbReturnsZeroRowsUpdatedOnPKChange (0.69s) === RUN TestPrepare -2025/09/15 19:35:25 Warning: Automatic mapping of Version struct members to version columns (see optimistic locking) will be deprecated in next version (V2) See: https://github.com/go-gorp/gorp/pull/214 -gorptest: 19:35:25.179976 drop table if exists "invoice_test"; [] -gorptest: 19:35:25.180148 drop table if exists "invoice_tag_test"; [] -gorptest: 19:35:25.180171 drop table if exists "alias_trans_field_test"; [] -gorptest: 19:35:25.180185 drop table if exists "invoice_override_test"; [] -gorptest: 19:35:25.180199 drop table if exists "person_test"; [] -gorptest: 19:35:25.180215 drop table if exists "ignored_column_test"; [] -gorptest: 19:35:25.180230 drop table if exists "id_created_test"; [] -gorptest: 19:35:25.180247 drop table if exists "type_conv_test"; [] -gorptest: 19:35:25.180263 drop table if exists "embedded_struct_test"; [] -gorptest: 19:35:25.180280 drop table if exists "embedded_struct_before_autoincr_test"; [] -gorptest: 19:35:25.180294 drop table if exists "embedded_autoincr_test"; [] -gorptest: 19:35:25.180311 drop table if exists "time_test"; [] -gorptest: 19:35:25.180331 create table "invoice_test" ("Id" integer not null primary key autoincrement, "Created" integer, "Updated" integer, "Memo" varchar(255), "PersonId" integer, "IsPaid" integer) ; [] -gorptest: 19:35:25.190261 create table "invoice_tag_test" ("myid" integer not null primary key autoincrement, "myCreated" integer, "date_updated" integer, "Memo" varchar(255), "person_id" integer, "is_Paid" integer) ; [] -gorptest: 19:35:25.202099 create table "alias_trans_field_test" ("id" integer not null primary key autoincrement, "bar" varchar(255)) ; [] -gorptest: 19:35:25.214057 create table "invoice_override_test" ("Id" varchar(255) not null primary key, "Created" integer, "Updated" integer, "Memo" varchar(255), "PersonId" integer, "IsPaid" integer) ; [] -gorptest: 19:35:25.227868 create table "person_test" ("Id" integer not null primary key autoincrement, "Created" integer, "Updated" integer, "FName" varchar(255), "LName" varchar(255), "Version" integer) ; [] -gorptest: 19:35:25.239499 create table "ignored_column_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] -gorptest: 19:35:25.252111 create table "id_created_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] -gorptest: 19:35:25.264333 create table "type_conv_test" ("Id" integer not null primary key autoincrement, "PersonJSON" varchar(255), "Name" varchar(255)) ; [] -gorptest: 19:35:25.276407 create table "embedded_struct_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255)) ; [] -gorptest: 19:35:25.288168 create table "embedded_struct_before_autoincr_test" ("FirstName" varchar(255), "LastName" varchar(255), "Id" integer not null primary key autoincrement) ; [] -gorptest: 19:35:25.299643 create table "embedded_autoincr_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255), "MiddleName" varchar(255)) ; [] -gorptest: 19:35:25.312028 create table "time_test" ("Id" integer not null primary key autoincrement, "Time" datetime) ; [] -gorptest: 19:35:25.323567 insert into "invoice_test" ("Id","Created","Updated","Memo","PersonId","IsPaid") values (null,?,?,?,?,?); [1:100 2:200 3:"prepare-foo" 4:0 5:false] -gorptest: 19:35:25.332331 insert into "invoice_test" ("Id","Created","Updated","Memo","PersonId","IsPaid") values (null,?,?,?,?,?); [1:100 2:200 3:"prepare-bar" 4:0 5:false] -gorptest: 19:35:25.339919 UPDATE invoice_test SET Memo=? WHERE Id=? [1:] -gorptest: 19:35:25.348722 SELECT * from invoice_test WHERE Memo='prepare-baz' [] -gorptest: 19:35:25.348852 begin; [] -gorptest: 19:35:25.348876 UPDATE invoice_test SET IsPaid=? WHERE Id=? [1:] -gorptest: 19:35:25.348955 SELECT * from invoice_test WHERE IsPaid=? [1:true] -gorptest: 19:35:25.349230 SELECT * from invoice_test WHERE IsPaid=? [1:true] -gorptest: 19:35:25.349275 commit; [] -gorptest: 19:35:25.355516 SELECT * from invoice_test WHERE IsPaid=? [1:true] -gorptest: 19:35:25.355621 drop table if exists "invoice_test"; [] -gorptest: 19:35:25.366451 drop table if exists "invoice_tag_test"; [] -gorptest: 19:35:25.378567 drop table if exists "alias_trans_field_test"; [] -gorptest: 19:35:25.390222 drop table if exists "invoice_override_test"; [] -gorptest: 19:35:25.403632 drop table if exists "person_test"; [] -gorptest: 19:35:25.415683 drop table if exists "ignored_column_test"; [] -gorptest: 19:35:25.428319 drop table if exists "id_created_test"; [] -gorptest: 19:35:25.440156 drop table if exists "type_conv_test"; [] -gorptest: 19:35:25.451832 drop table if exists "embedded_struct_test"; [] -gorptest: 19:35:25.464089 drop table if exists "embedded_struct_before_autoincr_test"; [] -gorptest: 19:35:25.475577 drop table if exists "embedded_autoincr_test"; [] -gorptest: 19:35:25.488377 drop table if exists "time_test"; [] -gorptest: 19:35:25.500208 drop table if exists "id_created_test"; [] +2026/10/19 02:00:51 Warning: Automatic mapping of Version struct members to version columns (see optimistic locking) will be deprecated in next version (V2) See: https://github.com/go-gorp/gorp/pull/214 +gorptest: 02:00:51.720547 drop table if exists "invoice_test"; [] +gorptest: 02:00:51.720774 drop table if exists "invoice_tag_test"; [] +gorptest: 02:00:51.720811 drop table if exists "alias_trans_field_test"; [] +gorptest: 02:00:51.720829 drop table if exists "invoice_override_test"; [] +gorptest: 02:00:51.720847 drop table if exists "person_test"; [] +gorptest: 02:00:51.720866 drop table if exists "ignored_column_test"; [] +gorptest: 02:00:51.720882 drop table if exists "id_created_test"; [] +gorptest: 02:00:51.720905 drop table if exists "type_conv_test"; [] +gorptest: 02:00:51.720925 drop table if exists "embedded_struct_test"; [] +gorptest: 02:00:51.720942 drop table if exists "embedded_struct_before_autoincr_test"; [] +gorptest: 02:00:51.720963 drop table if exists "embedded_autoincr_test"; [] +gorptest: 02:00:51.720979 drop table if exists "time_test"; [] +gorptest: 02:00:51.721005 create table "invoice_test" ("Id" integer not null primary key autoincrement, "Created" integer, "Updated" integer, "Memo" varchar(255), "PersonId" integer, "IsPaid" integer) ; [] +gorptest: 02:00:51.730495 create table "invoice_tag_test" ("myid" integer not null primary key autoincrement, "myCreated" integer, "date_updated" integer, "Memo" varchar(255), "person_id" integer, "is_Paid" integer) ; [] +gorptest: 02:00:51.742900 create table "alias_trans_field_test" ("id" integer not null primary key autoincrement, "bar" varchar(255)) ; [] +gorptest: 02:00:51.754792 create table "invoice_override_test" ("Id" varchar(255) not null primary key, "Created" integer, "Updated" integer, "Memo" varchar(255), "PersonId" integer, "IsPaid" integer) ; [] +gorptest: 02:00:51.768437 create table "person_test" ("Id" integer not null primary key autoincrement, "Created" integer, "Updated" integer, "FName" varchar(255), "LName" varchar(255), "Version" integer) ; [] +gorptest: 02:00:51.780893 create table "ignored_column_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] +gorptest: 02:00:51.792342 create table "id_created_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] +gorptest: 02:00:51.804776 create table "type_conv_test" ("Id" integer not null primary key autoincrement, "PersonJSON" varchar(255), "Name" varchar(255)) ; [] +gorptest: 02:00:51.817043 create table "embedded_struct_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255)) ; [] +gorptest: 02:00:51.829204 create table "embedded_struct_before_autoincr_test" ("FirstName" varchar(255), "LastName" varchar(255), "Id" integer not null primary key autoincrement) ; [] +gorptest: 02:00:51.840973 create table "embedded_autoincr_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255), "MiddleName" varchar(255)) ; [] +gorptest: 02:00:51.852407 create table "time_test" ("Id" integer not null primary key autoincrement, "Time" datetime) ; [] +gorptest: 02:00:51.868571 insert into "invoice_test" ("Id","Created","Updated","Memo","PersonId","IsPaid") values (null,?,?,?,?,?); [1:100 2:200 3:"prepare-foo" 4:0 5:false] +gorptest: 02:00:51.874331 insert into "invoice_test" ("Id","Created","Updated","Memo","PersonId","IsPaid") values (null,?,?,?,?,?); [1:100 2:200 3:"prepare-bar" 4:0 5:false] +gorptest: 02:00:51.886184 UPDATE invoice_test SET Memo=? WHERE Id=? [1:] +gorptest: 02:00:51.891712 SELECT * from invoice_test WHERE Memo='prepare-baz' [] +gorptest: 02:00:51.891859 begin; [] +gorptest: 02:00:51.891900 UPDATE invoice_test SET IsPaid=? WHERE Id=? [1:] +gorptest: 02:00:51.892005 SELECT * from invoice_test WHERE IsPaid=? [1:true] +gorptest: 02:00:51.892335 SELECT * from invoice_test WHERE IsPaid=? [1:true] +gorptest: 02:00:51.892413 commit; [] +gorptest: 02:00:51.897620 SELECT * from invoice_test WHERE IsPaid=? [1:true] +gorptest: 02:00:51.897753 drop table if exists "invoice_test"; [] +gorptest: 02:00:51.907203 drop table if exists "invoice_tag_test"; [] +gorptest: 02:00:51.918482 drop table if exists "alias_trans_field_test"; [] +gorptest: 02:00:51.930383 drop table if exists "invoice_override_test"; [] +gorptest: 02:00:51.944728 drop table if exists "person_test"; [] +gorptest: 02:00:51.956616 drop table if exists "ignored_column_test"; [] +gorptest: 02:00:51.968457 drop table if exists "id_created_test"; [] +gorptest: 02:00:51.980932 drop table if exists "type_conv_test"; [] +gorptest: 02:00:51.992141 drop table if exists "embedded_struct_test"; [] +gorptest: 02:00:52.004957 drop table if exists "embedded_struct_before_autoincr_test"; [] +gorptest: 02:00:52.016840 drop table if exists "embedded_autoincr_test"; [] +gorptest: 02:00:52.028112 drop table if exists "time_test"; [] +gorptest: 02:00:52.040709 drop table if exists "id_created_test"; [] --- PASS: TestPrepare (0.32s) PASS -ok gopkg.in/gorp.v1 8.397s +ok gopkg.in/gorp.v1 7.952s create-stamp debian/debhelper-build-stamp dh_testroot -O--builddirectory=_build -O--buildsystem=golang dh_prep -O--builddirectory=_build -O--buildsystem=golang @@ -1823,12 +1859,14 @@ dpkg-buildpackage: info: binary-only upload (no source included) dpkg-genchanges: info: not including original source code in upload I: copying local configuration +I: user script /srv/workspace/pbuilder/3197581/tmp/hooks/B01_cleanup starting +I: user script /srv/workspace/pbuilder/3197581/tmp/hooks/B01_cleanup finished I: unmounting dev/ptmx filesystem I: unmounting dev/pts filesystem I: unmounting dev/shm filesystem I: unmounting proc filesystem I: unmounting sys filesystem I: cleaning the build env -I: removing directory /srv/workspace/pbuilder/3864389 and its subdirectories -I: Current time: Mon Sep 15 07:35:28 -12 2025 -I: pbuilder-time-stamp: 1757964928 +I: removing directory /srv/workspace/pbuilder/3197581 and its subdirectories +I: Current time: Mon Oct 19 16:00:56 +14 2026 +I: pbuilder-time-stamp: 1792375256