On Mon, Nov 09, 2009 at 08:59:38AM -0500, Jay Pipes wrote: > >>CREATE TABLE INFORMATION_SCHEMA.TRANSACTION_LOG_ENTRIES ( > >> ENTRY_OFFSET BIGINT NOT NULL > >>, ENTRY_TYPE VARCHAR NOT NULL > >>, ENTRY_LENGTH BIGINT NOT NULL > >>); > > > >ENTRY BLOB > > > >then can write more tests as plain sql :) > > Eh, kinda. There is an ENTRY_TYPE of "BLOB" coming shortly. I > didn't think that there didn't to be a separate view for the BLOBs > themselves since pretty much all the information one needs *about* > the BLOB is in the view above...
was thinking the blob of the serialised proto. could use this to write SQL that always checks we're generating the same stream. > >>CREATE TABLE INFORMATION_SCHEMA.TRANSACTION_LOG_TRANSACTIONS ( > >> ENTRY_OFFSET BIGINT NOT NULL > >>, TRANSACTION_ID BIGINT NOT NULL > >>, SERVER_ID INT NOT NULL > >>, START_TIMESTAMP BIGINT NOT NULL > >>, END_TIMESTAMP BIGINT NOT NULL > >>, NUM_STATEMENTS INT NOT NULL > >>); > > > >possible to get at all the entries for a txn? > > Yes, but via a UDF called PRINT_TRANSACTION_MESSAGE(). More on this > today... > > Cheers! > jay > -- Stewart Smith _______________________________________________ Mailing list: https://launchpad.net/~drizzle-discuss Post to : [email protected] Unsubscribe : https://launchpad.net/~drizzle-discuss More help : https://help.launchpad.net/ListHelp
